Deglecy Computer · Data & AI
Data Analytics with Power BI: From Beginner to Dashboard
Learn to transform raw data into insightful visual reports and interactive dashboards using Microsoft Power BI. This hands-on course covers data import, cleaning, modeling, DAX basics, and report publishing through real…
40lessons
Beginnerlevel
22 hoursto complete
0already enrolled
About this course
Learn to transform raw data into insightful visual reports and interactive dashboards using Microsoft Power BI. This hands-on course covers data import, cleaning, modeling, DAX basics, and report publishing through real-world projects.
What’s included
Free to joinCreate an account and enroll at no cost.
Final examFinish all lessons, then take the exam.
CertificatePass the exam to earn your certificate.
Course content
Module 1: Introduction and Power BI Setup5 lessons
Installing Power BI Desktop10 min
Navigating the Power BI Interface15 min
Importing Excel and CSV Files20 min
Connecting to Online Data Sources18 min
Understanding Data Types and Preview12 min
Module 2: Data Cleaning and Transformation5 lessons
Opening Power Query Editor10 min
Removing Duplicates and Empty Rows15 min
Splitting and Merging Columns20 min
Changing Data Types and Formats18 min
Filtering and Sorting Data12 min
Module 3: Data Modeling and Relationships5 lessons
Creating Table Relationships20 min
Understanding Cardinality and Cross-filtering15 min
Hiding and Organizing Columns12 min
Creating Calculated Columns18 min
Introduction to Data Tables14 min
Module 4: Basic DAX and Calculations5 lessons
What is DAX and Basic Syntax15 min
Creating Simple Calculated Columns18 min
Building Basic Measures with SUM and COUNT20 min
Using FILTER and RELATED Functions22 min
Date and Time Intelligence Basics16 min
Module 5: Data Visualization Fundamentals5 lessons
Adding and Configuring Charts15 min
Customizing Visual Properties18 min
Using Slicers for Filtering12 min
Creating Interactive Drill-throughs20 min
Formatting Reports for Readability14 min
Module 6: Building Interactive Dashboards5 lessons
Designing Dashboard Layout15 min
Pinning Visuals to Dashboards12 min
Adding KPI Indicators18 min
Creating Bookmark Navigation20 min
Testing Dashboard Interactivity14 min
Module 7: Sharing and Collaboration5 lessons
Publishing to Power BI Service15 min
Creating and Managing Workspaces18 min
Setting Up Row-level Security20 min
Sharing Reports and Dashboards14 min
Exporting Data and Reports12 min
Module 8: Final Project: Business Analytics Dashboard5 lessons
Project Planning and Requirements15 min
Importing and Cleaning Sales Data20 min
Building Financial Performance Metrics22 min
Creating Customer and Product Visuals18 min
Assembling and Publishing Final Dashboard25 min