power Bi Advanced training

Service Description

Total Duration: • 4 days training with 30% theory and 70% practice. Deliverables • Training materials in PDF. • Power BI Working Files (PBIX). • DAX scripts used during training. • Access to additional resources for further study. Training Objectives • Master advanced modeling and analysis concepts in Power BI. • Know how to create dynamic, interactive and optimized reports. • Be able to solve complex data analysis problems. • Integrate Power BI with professional tools and workflows to maximize its impact. Advanced Power BI Training Plan 1. Introduction and Objectives of the Training • Presentation of the training objectives. • Overview of Power BI advanced features. • Discussion of participants' expectations and objectives and context. 2. Connect and transform data • Connectors under Power BI • Data connection modes. • Power Query and the different transformations available. 3. Advanced Data Modeling • Complex relationships: o Many-to-many relationships. o Enabling and disabling relationships. • Data hierarchies: o Creation and use of hierarchies (time, geography, organization, etc.). o Drill-down and drill-through analysis. • Model optimization: o Best practices for structuring a data model. o Removed unnecessary columns and reduced model sizes. o Column Calculations vs Measures: When and How to Use Them. o Performance Analysis with the Performance Analyzer Tool o Performance Management for DirectQuery Connections 3. Advanced DAX (Data Analysis Expressions) Language • Complex measures: o Creating conditional measures with IF, SWITCH. o Using calculation functions like SUMX, AVERAGEX, CALCULATE, etc. • Time analysis: o Using time functions like DATEADD, TOTALYTD, SAMEPERIODLASTYEAR, PARALLELEPERIOD, etc. o Managing date columns for temporal analyses. • Advanced functions: o Variables in DAX: improved readability and performance. o Using ALL, REMOVEFILTERS, KEEPFILTERS functions to manipulate filter context. o Dynamic calculations with RANKX, TOPN, and ISINSCOPE 5. Advanced and Custom Visualizations • Creating advanced visuals: o Use built-in visuals like KPIs, distribution maps and combo charts. o Visual overlay and dynamic layout. • Customizing visuals: o Advanced configuration of filters and slicers. o Using custom themes for consistent reporting. • Interactive reports: o Creating action buttons for navigation and storytelling. o Using bookmarks for interactive scenarios. 6. Dataflows and Data Automation