Power BI Basic to Intermediate

Duration: 3 days – 21 hrs

 

Overview

 

This course equips participants with the foundational and intermediate-level skills needed to transform raw data into meaningful insights using Microsoft Power BI. Participants will learn the end-to-end process—from loading and cleaning data with Power Query, designing effective dashboards, and applying basic DAX functions—to producing interactive reports. The training concludes with a practical case study, allowing participants to create their own dashboards based on business requirements.

 

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

 

Part 4: 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 5: Basic DAX

 

• Calculated Measure vs. Calculated Column
• CALCULATE Function
• Aggregate Functions
• DIVIDE Function

 

Part 6: Case Study

 

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