Duration: 3 days – 21 hrs

 

Overview 

 

This hands-on course teaches the end-to-end Power BI workflow for turning raw data into trustworthy, actionable insights. Participants will connect to diverse sources, clean and shape data with Power Query (including column profiling and basic M concepts), and design robust star-schema models with relationships, hierarchies, and a calendar table. You’ll write core DAX such as CALCULATE, aggregations, X-functions, DIVIDE, logical, text, ranking, and time-intelligence to create accurate, reusable measures. Using visualization best practices, you’ll build interactive, branded dashboards with slicers, drill-down, and the Analytics pane, then publish and share through the Power BI Service. The course culminates in a practical case study where learners translate business requirements into a working report, demonstrating repeatable techniques they can apply immediately on the job.

 

Objectives 

 

• Understand the core components, benefits, and interface of Power BI.
• Apply the Power BI project lifecycle for structured dashboard development.
• Use Power Query for data loading, cleaning, and transformation.
• Apply visualization best practices and customize dashboards using interactive features.
• Use basic DAX functions for calculations and data analysis.
• Design and deliver a functional Power BI dashboard in response to real-world business needs.

 

 

 

Audience 

 

• Business Analysts
• Data Analysts
• Reporting Specialists
• IT Professionals
• Professionals new to Power BI seeking data-driven reporting skills

Pre- requisites  

• Basic knowledge of Microsoft Excel (formulas, pivot tables, charts)

• No prior Power BI experience required

 

Course Content 

 

Part 1: Introduction to Power BI

 

• Definition of Terms
• Benefits of Power BI for report generation
• 3 parts of Power BI (Desktop, Service, Mobile)
• Navigating through the user interface

 

Part 2: Power BI Project Lifecycle

 

• Different approaches in Power BI Projects
• 4 Phases of Dashboard Development

 

Part 3: Power Query

 

• Loading Data
• Navigating the Power Query Interface
• Data Cleaning and Transformation
• Introduction to M Query
• Column Profiling
• Pivoting using Power Query

 

Part 4: Data Modeling

• Keys
• Star Schema and Snowflake Schema
• The Calendar Table
• Hierarchies
• Grouping Columns 
• Filtering Levels

 

Part 5: DAX

 

• Calculated Measure vs. Calculated Column
• CALCULATE Function
• Aggregate Functions
• X-Aggregators
• DIVIDE Function
• Time Intelligence Functions 
• Logical Functions
• Text Functions
• Rank Functions

 

Part 6: Data Visualization

 

• Principles of Data Visualization
• Best Practices
• Creating Simple Objects and Branding Elements
• Customizing Visualizations
• Slicers
• Hierarchies and Drill Down
• AI tools in Power BI
• Analytics Pane in Visualizations

 

Part 7: Case Study

 

• Develop your own dashboard using the provided business requirements
• Presentation and peer review of dashboards