Data Analysis with Power BI

Program Code: DAPBI

8 weeks Online Microsoft Online

Program Overview

Transform raw data into actionable insights using Microsoft Power BI. Learn data visualization, DAX, dashboard creation, and business intelligence reporting. This course teaches you how to turn data into stories that drive business decisions.

Curriculum & Modules

Week 1: Introduction to Power BI

What is Business Intelligence?
Power BI ecosystem overview
Installing Power BI Desktop
Power BI interface tour
Connecting to data sources
Understanding data types
Creating your first report

Week 2: Power Query for Data Transformation

Introduction to Power Query
Connecting to Excel, CSV, and databases
Data cleaning and transformation
Merging and appending queries
Data shaping techniques
Handling missing data
Creating custom columns

Week 3: Data Modelling

Data model concepts
Creating relationships between tables
Cardinality and cross-filter direction
Star schema design
Fact and dimension tables
Hierarchies and levels

Week 4: DAX Fundamentals

Introduction to DAX
Calculated columns vs measures
SUM, AVERAGE, COUNT functions
CALCULATE function
FILTER and ALL functions
Time intelligence functions
Year-to-Date, Quarter-to-Date calculations

Week 5: Advanced DAX

SUMX, AVERAGEX iterators
RANKX and TOPN functions
Conditional logic in DAX (IF, SWITCH)
Variables in DAX
Advanced time intelligence
Performance optimization

Week 6: Data Visualization

Creating charts and visuals
Customizing visuals
Using slicers and filters
Bookmarks and buttons for interactivity
Drill-through and drill-down
Conditional formatting
Tooltips and report pages

Week 7: Dashboard Design

Dashboard design principles
Creating executive dashboards
Designing mobile-friendly reports
Power BI themes and branding
Performance optimization
Q&A visual and natural language

Week 8: Power BI Service & Final Project

Publishing reports to Power BI Service
Power BI Service workspace management
Sharing and collaboration
Scheduling data refresh
Row-level security
Final dashboard project presentation

Entry Requirements

Basic computer literacy. Some Excel knowledge recommended. Microsoft Power BI Desktop (free) required. Laptop with minimum 8GB RAM recommended.

Learning Outcomes

What is Business Intelligence?

Power BI ecosystem overview

Installing Power BI Desktop

Power BI interface tour

Connecting to data sources

Understanding data types

Creating your first report

Introduction to Power Query

Connecting to Excel, CSV, and databases

Data cleaning and transformation

Merging and appending queries

Data shaping techniques

Handling missing data

Creating custom columns

Data model concepts

Creating relationships between tables

Cardinality and cross-filter direction

Star schema design

Fact and dimension tables

Hierarchies and levels

Introduction to DAX

Calculated columns vs measures

SUM, AVERAGE, COUNT functions

CALCULATE function

FILTER and ALL functions

Time intelligence functions

Year-to-Date, Quarter-to-Date calculations

SUMX, AVERAGEX iterators

RANKX and TOPN functions

Conditional logic in DAX (IF, SWITCH)

Variables in DAX

Advanced time intelligence

Performance optimization

Creating charts and visuals

Customizing visuals

Using slicers and filters

Bookmarks and buttons for interactivity

Drill-through and drill-down

Conditional formatting

Tooltips and report pages

Dashboard design principles

Creating executive dashboards

Designing mobile-friendly reports

Power BI themes and branding

Performance optimization

Q&A visual and natural language

Publishing reports to Power BI Service

Power BI Service workspace management

Sharing and collaboration

Scheduling data refresh

Row-level security

Final dashboard project presentation

Program Fees

Course Fee

ZMW 3,000.00

One-time payment

Application Fee ZMW 30.00

Total Investment:

ZMW 3,030.00

All inclusive

Certification

Microsoft

Apply Now Request More Info Back to Programs

8
weeks

8
Modules

Hands-on
Practical