Includes Certificates
Power BI: Data Visualization & Business Intelligence
This course will teach you how to turn raw data into meaningful insights using Microsoft Power BI. You will learn to connect to data sources, transform data, create interactive dashboards, and generate reports that help make informed business decisions. The course is practical, hands-on, and suitable for beginners as well as professionals looking to enhance their analytical skills.
TK 7000 TK 7500
15 Live Sessions
2 Real Life Projects
18 Days Remaining
5 Seats Remaning
What We Will Learn
Understand Power BI interface and components
Connect, import, and transform data from multiple sources
Create interactive reports and dashboards
Use DAX (Data Analysis Expressions) for calculations and measures
Apply data modeling and relationships for effective analysis
Visualize data with charts, maps, and other visuals
Share reports and collaborate using Power BI Service
Gain practical skills for business intelligence and data-driven decision making
Course Outline
Lectures
What is Power BI?
Download & Installing Power BI Desktop
Course Outline: What will you learn in this course?
Quick Interface Tour
Importing data (Excel/CSV/database)
Creating Visualizations - Quick Intro
How to learn best with this course?
Data Source Connection
Removing nulls
Fixing data types
Splitting/merging columns
Creating new columns in Power Query
Creating conditional columns
Merging Queries
Using Parameters to dynamically transform data
Why a data model?
Create & edit relationships
One-to-many & one-to-one relationship
Many-to-many (m:n) relationship
Cross filter direction
Activate & deactivate relationships
Module summary
Adding values to visual
The format tab
Understanding tables
Understanding the matrix visual
The Pie Chart
The tree map visual
The decomposition tree
Analytics and Forecasts with line charts
Map Visual
Buttons & Actions
Working with custom visuals
Bookmarks to customize your report
Wrap up - data visualization
Slicer types: dropdown, list, between, date
Hierarchy slicer
Visual-level filters
Page-level filters
Report-level filters
Advanced filter options (contains, starts with, OR)
DAX cheat sheet
Measures vs. Calculated Columns
Automatically creating a date table in DAX
Creating a complete date table with features
Aggregation functions
CALCULATE function
DAX - Time Intelligence
Mastering CALCULATE for complex business logic and filter manipulation
Using ALL, ALLEXCEPT, ALLSELECTED, REMOVEFILTERS effectively
Advanced iterator functions (SUMX, AVERAGEX, RANKX) with performance considerations
Building dynamic measures using VAR and SWITCH(TRUE())
Creating a fully dynamic Date Table in DAX (Fiscal Year, Week, Sorting logic)
Advanced Time Intelligence patterns (Rolling 3/6/12 months, Running Total)
Handling Top N analysis with “Others” category
Solving incorrect totals & blank results in complex visuals
Writing performance-optimized DAX for large datasets
Debugging advanced DAX using step-by-step evaluation logic
KPI logic
Percentage calculations
Rankings
Conditional formatting
Choose an effective Consistent layout
Buttons & navigation
Tooltip pages visual
Make use of natural reading pattern
Avoid chaos & group information
RLS (Row-Level Security)
Export to PDF & PPT
Publish to Power BI Service
Workspace creation
Sharing & Permissions
Sales Performance Dashboard
Sales Performance Dashboard
Proposed Project by the Learner
Proposed Project by the Learner
Bring everything together by finalizing projects, reviewing key learnings, and preparing reports for real-world use
Course Schedule
Session Mode : Offline
Day : Saturday, Friday
Time : 4:30 p.m. - 7:30 p.m.
Class Start : Jan. 9, 2026
Total Month : 2
Total Hour : 45
What’s Included with the Course
Certificate
Assignment
Project
Live Class
Course Features
Industry Standard Course Module
Hands On Projects
Requirements
Windows PC. You can’t natively install Power BI on Mac or Linux
Experience with Excel Power Query
Microsoft account (free) to publish and share reports online
Job Positions You Can Apply For
Business Intelligence (BI) Analyst
Data Analyst
BI Reporting Analyst
BI Data Modeler
Reporting & Insights Analyst
Instructor Details
Nusrat Jahan
Data Analyst, Innovation Hub
1 Courses
15+ Lessons
The instructor has extensive experience working with real-world datasets and contributing to a wide range of data-driven projects, consistently delivering solutions that strengthen decision-making and operational efficiency. With strong capabilities in technical leadership, analytical design, and the use of modern tools—particularly Power BI—the instructor excels at transforming complex information into clear, actionable insights. A deep commitment to teaching and mentoring young professionals shapes the instructor’s approach to training. Clear communication, practical relevance, and the cultivation of analytical thinking are placed at the forefront, ensuring learners gain robust, industry-ready skills in Power BI and data analysis.
Chat with Us
Speak on Call
Chat with Messenger