This training program is designed to equip participants with the knowledge and skills to effectively utilize Microsoft Power BI. Power BI is a powerful business intelligence tool that allows users to connect to various data sources, create data models, design interactive dashboards, and generate insightful reports. Through hands-on exercises and practical examples, participants will learn the end-to-end workflow of business intelligence, data modeling, data visualization, and leveraging Power BI services.
Upon successful completion of this course, participants will be able to:
- Understand the business intelligence workflow from end-to-end.
- Perform data modeling and create relationships in Power BI.
- Gain proficiency in using DAX (Data Analysis Expressions).
- Master data visualization techniques using different charts and visual elements.
- Publish BI report to Power BI service and share it with other users.
- Explore the features and capabilities of Power BI services.
Module 1: Introduction to Power BI
- What is Business Intelligence?
- Overview of Self-Service Business Intelligence (SSBI) Tools.
- Comparison between Traditional BI and Power BI.
- Introduction to Power BI elements.
- Power BI Installation.
- Power BI Workflow.
Module 2: Connecting with different Data Source Using Connectors in Power BI Desktop
- Understand the business intelligence workflow from end-to-end.
- Perform data modeling and create relationships in Power BI.
- Gain proficiency in using DAX (Data Analysis Expressions).
- Master data visualization techniques using different charts and visual elements.
- Publish BI report to Power BI service and share it with other users.
- Explore the features and capabilities of Power BI services.
Module 3: Data Exploration and Transformation Using Query Editor
- Data Transformation Techniques.
- Working with number-specific and data-specific tools.
- Adding index columns.
- Grouping Data.
- Merging and appending queries.
- Data Sources settings.
- Query refreshing and data category definition
- Query editing and Power BI best practices
- LAB – Connecting and Shaping Data with Power BI Desktop
Module 4: Data Modeling
- Introduction to database normalization
- Data (“Fact”) tables vs. “Snowflake” schemas
- Actives vs. Inactive relationships
- Connecting multiple data tables
- Filtering and cross filtering techniques
- Hiding fields from the Power BI review view
- LAB – Data Modeling
Module 5: DAX (Data Analysis Expressions)
- Essential concepts in DAX
- Importance of DAX in Power BI
- DAX syntax and data types
- Calculation types and DAX functions
- Working with measures and DAX Operators
- DAX tables and filtering
- DAX queries and parameter naming
- Introduction to data visualization
- LAB - DAX.
Module 6: Data Visualization
- Introduction to visual in Power BI
- Creating charts, matrices and tables
- Utilizing slicers for data filtering and customization using user filter, pre-defined filter and sync filters
- Visualizing data on maps
- Gauges and single number cards
- Modifying colors and format in charts and visual
- Adding shapes, text boxes, and images
- Page Layout and formatting
- Key performance indicators (KPI) visuals
- Using Bookmark
- Creating mobile reports
- Row Level security
Module 7: Power BI Services
- Publishing reports
- Creating workplaces
- Introduction to Power BI services
- Dashboard vs. Reports
- Sharing BI Reports
- Creating and managing dashboard
- Power BI Q&A
- Explaining Report scheduling concept
- Data Analysts
- Excel Users
- Data Scientists
- AI Engineers
- BI Specialists
- Managers seeking data-driven decision-making capabilities