The Power BI Intermediate Course is designed for professionals who want to enhance their skills in data modeling, transformation, and analysis using Power BI. This course covers essential concepts such as data normalization, Power Query transformations, DAX fundamentals, and visualization techniques to build interactive and insightful reports.
By the end of this course, participants will be able to :
- Understand the different Power BI products and when to use them.
- Connect Power BI to various data sources, including SharePoint, Excel, and SQL databases.
- Perform data transformations using Power Query Editor.
- Develop a well-structured data model with optimized relationships.
- Use DAX to create calculated columns and measures.
- Apply data visualization techniques to build meaningful reports.
- Implement basic row-level security and share reports online.
Module 1: Power BI
Module 2: The Business Intelligence Process
Module 3: Data Model & Transformation
Module 4: Get Data
Module 5: Power Query Editor
Module 6: Data Transformations
Module 7: Check the Data: Profiling
Module 8: Data Transformations
Module 9: Load Data
Module 10: Data Modelling
Module 11: Data Analysis Expressions
Module 12: The X Functions
Module 13: Quick Measures
Module 14: Time Intelligence Quick Measures
Module 15: Secure and Share Data
Module 16: Extended Content: More Visualisations
Module 17: Appendix: Database Normalisation
Microsoft Power BI - Intermediate
-
PRICE (2 Days) Physical
-
PRICE (2 Days) Online
Language
English, Malay