Course Details

This course is appropriate for a wide range of professionals but not limited to:

• Individuals interested in hands-on learning about Microsoft Power BI Desktop
• Data analysts and Excel users seeking to develop advanced data modeling, dashboard design, and business intelligence skills
• Data Scientist
• AI Engineer
• BI Specialist
• Managers who want to learn how to use BI tools to make better business decisions

• Expert-led sessions with dynamic visual aids
• Comprehensive course manual to support practical application and reinforcement
• Interactive discussions addressing participants’ real-world projects and challenges
• Insightful case studies and proven best practices to enhance learning

By the end of this course, participants should 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

DAY 1

Module 1: Introduction to Power BI

• Pre-test
• Introduction to Data Analysis and Business Intelligence
• Overview of self-service business intelligence (SSBI) tools
• Comparison between traditional BI and Power BI
• Installing Power BI Desktop and Datasets
• Introduction to Power BI elements
• Power BI installation
• Power BI workflow

Module 2: Connecting With Different Data Source Using Connectors in Power BI Desktop

• Data connectors and data source connections
• Connecting with CSV, XLSX
• Connecting with Microsoft SQL database
• Introduction to Query Editor
• Data Exploration

DAY 2

Module 3: Data Exploration and Transformation Using Query Editor

• Power Query Transformation vs. Add Column Options
• Text Column Transformation
• Working with number-specific and data-specific tools
• Data Transformation for Date Column
• Merging/joining queries
• Apply data appending/union
• Using folder option to append rows
• Pivoting and unpivoting data
• Grouping data
• Adding conditional columns
• Adding index columns
• Data source settings
• Query refreshing and data category definition
• LAB – Connecting and shaping data with Power BI Desktop

DAY 3

Module 4: Data Modelling

• Introduction to database normalization
• Understand the difference between primary and foreign key
• Data (“Fact”) tables vs. Lookup (“Dimension”) tables
• Understanding “Star” vs. “Snowflake” schemas
• Creating table relationships in Power BI
• Active vs. inactive relationships
• Hiding fields from the Power BI report view
• Connecting multiple data tables
• Filtering and cross-filtering techniques
• LAB – Data Modelling

DAY 4

Module 5: DAX (Data Analysis Expressions)

• Importance of DAX in Power BI
• DAX syntax and data types
• Calculated fields vs. measures
• Working with measures and DAX operators
• Exploring DAX operators
• Text functions
• Time functions
• Logical functions
• Statistical functions
• Introduction to Data Visualization
• LAB - DAX

DAY 5

Module 6: Data Visualization

• Creating a complete visual report using 10 different charts
• Adding text, images and shapes
• Explore different formatting options for each visual
• Utilizing slicers for data filtering and customization using user filter, pre-defined filter and sync filters
• Using Bookmark
• Key performance indicator (KPI) visuals
• Row-level security
• Creating mobile reports

Module 7: Power BI Services

• Introduction to Power BI Service
• Creating workspaces in Power BI Service
• Publishing reports
• Dashboard vs. reports
• Sharing BI reports
• Creating and Managing Dashboards
• Power BI Q&A
• Explaining Report scheduling concept
• Post-test

There will be a laptop available for each participant to conduct practical training on Power BI software.