IT0175 : Advanced Data Analysis & Reporting Using Power BI

 This practical and highly-interactive course includes various practical sessions and exercises. Theory learnt will be applied using the “Microsoft Power BI” application. 

 This course is designed to provide participants with a detailed and up-to-date overview of Advanced Data Analysis and Reporting Using Power BI. It covers the advanced Power BI architecture, advanced data connectivity and data transformation at scale (advanced power query); the advanced data modeling concepts, performance optimization in data models and data quality and governance foundations; the DAX evaluation context and advanced DAX functions; the advanced measures and KPIs, time-series and trend analysis; the whatif analysis and scenario modelling and proper debugging and optimizing DAX. 

 Further, the course will also discuss the advanced visual design principles and advanced built-in visuals; the use of custom visuals safely and the advanced interactivity, analytical dashboards design and visualization performance optimization; the Power BI service architecture, advanced security models and data refresh and automation; and the app creation and distribution, sharing strategies for large organizations, version control practices and managing user access and permissions.