

About Course
Master Microsoft Power BI and learn how to transform raw data into interactive dashboards and professional business reports. This course is designed for beginners, students, working professionals, business owners, and anyone looking to build practical business intelligence and data visualization skills.
Start with the fundamentals of Power BI, including data import, cleaning, transformation, and data modeling. As you progress, you’ll learn DAX, interactive visualizations, dashboard creation, report optimization, and best practices used by industry professionals.
Through step-by-step lessons, practical exercises, and real-world projects, you’ll gain the confidence to build powerful dashboards, analyze business data, and generate actionable insights. You’ll also discover more professional courses and resources available at BeyondUni to continue building your data analytics and business intelligence skills.
What Will You Learn?
- Business Intelligence & Power BI Fundamentals
- Power BI Desktop & Data Import
- Power Query & Data Cleaning
- Data Modeling & Table Relationships
- DAX, Calculated Columns & Measures
- Time Intelligence & Advanced DAX
- Data Visualization, Charts, KPIs & Interactive Reports
- Dashboards, Slicers, Filters & Drill-Through
- Power BI Service, Publishing, Sharing & Row-Level Security
- Report Optimization, Best Practices & Real-World Projects
Course Content
Power BI Introduction
-
Power BI Introduction
-
Power BI Installation
-
Workflow of Power BI
-
Power BI Helpful Resources
Sales Data Integration and Modeling
-
Front End vs back End
-
Types of Data Connectors
-
POWER QUERY EDITOR
-
Basic Data Transformations
-
Assignment-1-Table Transformation Assignment
-
Assignment-1-Table Transformation- Assignment Solution
-
Storage and Connection Mode
-
Connecting To Database
-
Website Data Gathering
-
Data profiling and QA Tools
-
Text Tools Transformation
-
Assignment-2-Text Tools
-
Assignment-2-Text-Tools-Solution
-
Numeric Tools
-
Assignment-3-Numeric Tools
-
Assignment-3-Numeric Tools-Solution
-
DATE AND TIME TOOLS
-
Change Type with Locale
-
Rolling Calendar
-
Assignment-4-Calendar tables Assignment
-
Assignment-4-Calender Tables-Solutions
Returns Analysis and Territory Integration
-
Index and Conditional Column
-
Grouping and Aggregating
-
Pivoting and Unpivoting
-
Merging Queries
-
Appending Queries
-
Data Gathering From Folder
-
Data Source Settings
-
Refresh Button
-
importing Excel Models
Data Model Design and Optimization
-
Creating A Data Model Introduction
-
What is a Data Model
-
Database Normalization
-
Fact And Dimension Tables
-
PRIMARY AND FOREIGN KEYS
-
Merged Table vs Relationships
-
Creating Table Relationship
-
Managing and Editing Relationship
-
Star and SnowFlake Schema
-
Assignment-1-Table-Relationships
-
Assignment-1-Table Relationships- Solution
Relationship Behaviour and Model Stress Testing
-
Active and Inactive Relationship
-
Relationship Cardinality
-
Connecting Multiple Fact Tables
-
Filter Context and Filter Flow
-
BiDirectional Filter and Ambiguity
-
Hide in Report View
-
Assignment-2-Filter Flow
-
Assignment-2-Filter Flow-Solution
Model Optimization and Usability Enhancement
-
Model Layouts
-
Data Format and Category
-
Hierarchies
-
Assignment-3-Heirarchies
-
Assignment-3-Heirarchies-Solution
DAX measures and Analytical Insights
-
DAX Introduction
-
Dax Vs M Code
-
Calculated Columns
-
Dax Measures
-
Implicit vs Explicit Measures
-
Quick Measures
-
Measure Tables
-
Filter Context
-
Dax Syntax and Operators
-
Common Function Category
-
Basic Math and Stats Function
-
Counting functions
-
Assignment-1-Maths and Stats
-
Assignment-1-Maths and Stats-Solutions
Conditional Logic, SWITCH and Text functions in DAX
-
Conditional and Logical Functions
-
Switch Function
-
Assignment-2-Logical functions
-
Assignment-2-Logical functions-Solution
-
Text Functions
-
Assignment-3-Text functions
-
Assignment-3-Text functions-Solution
Time Intelligence in DAX
-
Date and Time Functions
-
Assignment-4-Date and Time
-
Assignment-4-Date and Time-Solutions
Related, Calculate and Measure Totals
-
Joining Data with Related
-
Calculate Function
-
DAX Measure Totals
-
Assignment-5-Calculate Function
-
Assignment-5-Calculate Function-Solutions
ALL, Filter and Iterator functions in DAX
-
ALL Function
-
Assignment-6-Calculate and ALL
-
Assignment-6-Calculate and ALL-Solution
-
Filter Functions
-
Iterator Functions
-
Assignment-7-Iterators
-
Assignment-7-Iterators-Solution
Time Intelligence Patterns in DAX
-
Time Intelligence Patterns
-
Assignment-8-Time Intelligence
-
Assignment-8-Time Intelligence-Solutions
Executive Dashboard Design
-
Dashboard Intro and three key questions
-
Dashboard Sketch
-
Adding Report Pages and objects
-
Naming and Grouping Objects
-
Cards and Multi-Row Cards
-
Assignment-1-Cards
-
Assignment-1-cards-solution
Sales Trend and Forecast Analysis
-
Line Charts
-
Trend lines and Forecasts
-
Assignment-2-Line Charts
-
Assignment-2-Line Charts-Solution
Sales Performance Dashboard
-
KPI Visuals
-
Bar and Donut Charts
-
Filtering Options
-
Assignment-3-Donuts and Filters
-
Assignment-3-Donut Charts and Filters-Solution
Top N Performance Dashboard
-
Table and Matrix Visuals
-
Conditional Formatting
-
TOP N Filtering
-
Assignment-4-tables
-
Assignment-4-Tables-Solution
-
Top N Text Cards
-
Assignment-5-Top N Text Cards
-
Assignment-5-Top N Text Cards-Solution
Geographic Sales Dashboard
-
Map Visuals
-
Slicers
-
Assignment-5-Slicers
-
Assignment-5-Slicers-Solution
Advanced Interactive Dashboard
-
Has One Values Function
-
Gauge Chart
-
Advanced Conditional Formatting
-
Area Chart Visual
-
Drill Up and Drill Down Tools
-
Assignment-6-Drill up and Drill Down
-
Assignment-6-Drill Up and Drill Down-Solution
Drill-Through and Report Interactions
-
Drill Through Filters
-
Report Interactions
-
Assignment-7-Report Interactions
-
Assignment-7-Report Interactions-Solution
Bookmarks, Navigation & Parameters
-
Bookmarks
-
Assignment-8-Bookmarks
-
Assignment-8-Bookmarks-Solution
-
Navigation Buttons
-
Slicer Panel
-
Parameters
-
Assignment-9-Field Parameters
-
Assignment-9-Field Parameters-Solution
-
Custom ToolTip
-
Power BI service Sign In
-
Importing Custom Visuals
-
Mobile Layout
-
Publishing Dashboard
-
Anomaly Detection
-
Smart Narrative
-
Q and A Visual
-
Decomposition Trees
-
Key Influencers
-
Pause Visuals
-
Optimization Preset
-
Apply all Slicers Button
-
Performance Analyzer
-
Power BI New Features and Updates
-
Understanding of the Data.mp4
