Power BI Project Focused Course

Name: Power BI Project Focused Course
Rating: 4.2 (29 reviews)

Comprehensive guide on how to import, transform, visualize data with Power BI, with practical exercises and case studies

Created byIfiokobong Akpan

Last updated 1/2025

English

English [Auto],

What you'll learn

Importing datasets from various sources (Excel, databases, etc.)
Data Visualization and Dashboard Creation
Designing interactive and responsive dashboards
Using different visual elements: charts, tables, slicers, and cards

Course content

4 sections • 12 lectures • 2h 9m total length

Downloadable Materials0:03

Importing Datasets11:48
Import datasets into Power BI from CSV and other sources, then transform and clean data with Power Query Editor. Build relationships using primary and foreign keys to create basic reports.
Data Type Conversion in Power Query6:14
Master data type conversion in Power Query using column profiling and distribution. Convert IDs to text and merge queries to join primary keys for the dashboard.
Column Profiling and Column Quality5:53
Explore column profiling and column quality in the Power Query editor to assess distribution, validate data types, identify empty or faulty values, and prepare clean Power BI data.
Adding Conditional Columns4:17
Learn to add a conditional column in Power Query to label progress as not started (0), in progress (1–99), or completed (100) for the Power BI project course.
Table Merging with Primary and Foreign Keys11:41
Identify primary keys and foreign keys in enrollment and student tables, then merge queries to link students, courses, and instructors for Power Query data modeling and dashboards.

Power BI Report Design – Part 136:17
Design a student dashboard in Power BI by renaming the page, setting a 16 by 9 canvas, adding shapes and visuals, using slicers and cards to summarize students and courses.
Power BI Dashboard Report Design – Part 214:09
Design Power BI dashboards by building student and enrollment reports, refining visuals, and enabling drill-through across pages, with navigation and interactive charts.
Power BI Dashboard Report Introduction10:24
Explore the Power BI dashboard introduction and learn to use the report canvas, insert visuals, create pages, and apply single-page and across-page filters to build dynamic reports.
Power BI Dashboard Report Design – Part 38:30
Design a student Power BI dashboard by moving elements, adding a donut chart for payment methods, and formatting visuals to reveal percentage shares; plan pagination in the next video.
Adding Pagination to Dashboard Report11:35
Learn to add pagination to a Power BI dashboard by creating summary and student buttons, configuring page navigation, and applying hover and active states.

Requirements

Basic understanding of using a computer (no prior Power BI experience required).
Willingness to learn and explore data analytics
Access to a computer with Power BI Desktop installed (free download from Microsoft).

Description

This Power BI course is a hands-on, project-based learning experience tailored for learners at all levels, from beginners to advanced users. The course focuses on building a complete dashboard report for an e-learning company, guiding you through the entire process of data extraction, transformation, and loading (ETL) within Power BI.

Throughout this course, you will learn how to:

Clean and prepare data: Learn how to clean raw datasets and merge them effectively, ensuring data quality and consistency.
Data Modeling: Build relationships between different datasets and create meaningful data models to drive accurate analysis.
Dashboard Design: Use Power BI’s intuitive tools to create stunning, interactive dashboards that present key insights clearly.
Pagination in Dashboards: Add professional touches by implementing pagination features in reports to enhance navigation and readability.

By the end of this course, you will have built a comprehensive Power BI dashboard from scratch, enabling you to apply these skills in real-world e-learning or business analytics scenarios.

Material Includes

Sample datasets for practice (related to the e-learning company project)
Step-by-step video tutorials
Power BI Dashboard templates
Access to the course discussion forum for peer support
Certificate of completion

What Will You Learn?

Overview of Power BI and its components
Data Extraction, Transformation, and Loading (ETL)
Importing datasets from various sources (Excel, databases, etc.)
Cleaning and transforming raw data for analysis
Merging multiple datasets for comprehensive insights
Creating relationships between datasets
Understanding the use of primary keys and foreign keys
Building calculated columns and measures using DAX
Data Visualization and Dashboard Creation
Designing interactive and responsive dashboards
Using different visual elements: charts, tables, slicers, and cards
Customizing visualizations to match specific audience needs
Advanced Power BI Features
Adding pagination to Power BI reports
Best Practices

Who this course is for:

Intermediate Power BI Users
Data Analysts and Business Intelligence Professionals
Business Owners and Decision Makers
Students and Graduates

Power BI Project Focused Course

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 1min

Data Extraction and Transformation5 lectures • 40min

Data Modelling, Cardinality and Relationships1 lecture • 9min

Dashboard and Report Design5 lectures • 1hr 21min

Requirements

Description

Who this course is for: