Complete Microsoft Power BI course

Name: Complete Microsoft Power BI course
Rating: 4.1 (18 reviews)

Your all-in-one guide to Power BI: from connecting data to building interactive dashboards—perfect for beginners/ expert

Created byRahul Gupta

Last updated 1/2024

English

What you'll learn

Install and set up Power BI
Connect to various data sources
Create reports and dashboards
Use Power BI's powerful visualization tools to create compelling charts, graphs, and other visualizations
Apply advanced data modeling techniques, including creating relationships between data tables and creating calculated fields
Create custom visuals to enhance their data analysis and visualization
Share and collaborate on reports and dashboards with other users, both inside and outside of their organization.

Course content

9 sections • 74 lectures • 9h 16m total length

About the Module1:15
About Power BI5:06
Installing Power BI Desktop3:54
Connecting Data Sources14:06
Connect data sources in Power BI by loading and transforming CSV and Excel files with Power Query Editor, adjusting data types, splitting columns, and applying changes.
Creating First Visual15:27
Excel Vs Power BI2:50

Introduction To Module -32:08
Explore module three of the Microsoft Power BI course to learn data preparation, cleaning raw data, handling missing values and anomalies, and applying basic to advanced data shaping techniques.
What comes in Data Preparation2:34
Data Connections11:14
Handling Rows in Data9:09
Learn practical Power Query row operations in Power BI, turning the first row into headers, counting rows, and removing top, bottom, duplicate, and blank rows across datasets.
Application of Filter Features4:34
Filter data in the Power Query Editor to load only United States rows and remove no data before loading to the data model.
Checking Data Quality7:50
Special Features4:45
Application of Append Features8:08
Application of Transpose Features4:21
Learn to fix append query errors by aligning column name and data type between winter and summer datasets, then explore the transform tab's transpose feature and its impact on queries.
Application of Replace value8:37
Advance Features11:23
Master advanced Power Query features like unpivoting and pivoting, manual data type assignment, delimiter-based extraction, splitting, and group by with sum or average to prep data for visualization.
Assigning the Right Data Type16:17
Application of Unpivot / Pivot5:01
Apply unpivot and pivot transformations in Power Query to reshape data, demonstrated on a small table, and note that these advanced features may not be required in every project.
Application of Extract / Split6:05
Application of Group By8:39

About The Module1:33
Importance of Data Model4:10
Star Schema Data Model Theory With Example10:51
Fitting Star Schema in Project5:38
Reference vs Duplicate feature4:07
Merge & Join Feature2:24
Type of Joiners5:06
Explore merge queries in Power BI to perform left, right, inner, and full outer joins using student IDs as examples, and prep for a star schema data model.
Creating Player Dim Table12:37
Creating Game - Dim table4:13
Creating Region - Dim Table8:41
Creating central Fact Table9:00
Arranging & Load Enabling of Queries5:20

About The Module2:42
Loading Table To Data Model4:23
Important Elements in Relationship6:00
One to Many Relationship5:14
Explore how cardinality connects tables in Power BI desktop, focusing on one-to-one, one-to-many, and many-to-one relationships. See practical examples with student and marks tables to determine connections.
One to One & Many to Many Relationship6:28
Learn to model Power BI data using one-to-one and many-to-many relationships by linking the student, address, subjects, and games tables via student IDs and apply cardinality concepts.
Cross Filter & Active / Inactive Relationship5:07
Application of Relationship in Project5:31

About The Module2:18
Explore the two languages in Power BI, M language and DAX, and learn basic to advanced DAX functions for exploratory data analysis and data manipulation before building an interactive dashboard.
Creating a Conditional Column Using M Language6:18
Creating a Conditional Column Using Dax4:43
M Language Vs Dax3:12
Explore the roles of M language and DAX. M handles data transformation in Power Query Editor, while DAX performs analysis and calculations in Power BI Desktop.
Basic Understanding About Dax Function13:18
Dax Operators13:46
Nested IF Function Using Dax6:58
Learn how to use DAX nested if function to bucket ages in the player team table into less than 20, 20 to 40, 40 to 50, and 50 plus.
Related & Filter function in Dax3:30
Explore the related function in dax to fetch the player name from the player dimension into the athletes fact table using the model relationship.
Calculate & Filter Function In Dax8:14
Creating a Measure4:05
Hide Column For Report View7:33

About The Module2:11
Final Dashboard Tour7:12
About Report View & Setting up The Canvas8:29
Arranging The Shape & Images in The Dashboard13:47
Arrange shapes and images in a Power BI dashboard by inserting a white rectangle, adjusting shape options, and layering images using bring to front or send to back.
Creating Cards Visual19:24
Learn how to create and customize card visuals in Power BI to display medal counts, including total medals and counts by gold, silver, and bronze, with filters and formatting.
Creating a Trend Line12:39
Creating a Tabular View8:54
Create a tabular view in Power BI by listing top three athletes with their country and medal count, using winner and top N filters and table formatting.
Creating A Bar chart10:02
Creating a Stacked Bar chart12:21
Build a clustered column chart of top five countries by total medals with bronze, gold, and silver, and a stacked bar chart of gold medals by gender.
Creating a donut Chart6:59
Creating a slicer to report11:46

About The Module2:30
Exploring App Source For New Visuals11:12
Explore AppSource to add new visuals to Power BI and learn to import or get more visuals, featuring zebra cards, spider charts, and word clouds for dashboards.
Creating Search Filter in Report5:32
Creating Data Story in Dashboard19:58
Create four data stories in a Power BI dashboard using the data story visual, highlighting total athletes, top medal country, leading medalist, and youngest gold medalist.

Requirements

Basic computer skills: Learners should have a basic understanding of computer skills such as how to use a mouse and keyboard, how to navigate through different folders and files, and how to open and close applications.
Basic knowledge of data analysis and visualization: Although it is not mandatory, having some prior knowledge of data analysis and visualization concepts can help learners better understand the course material.
Microsoft Power BI Desktop: Learners will need to download and install Microsoft Power BI Desktop, which is a free software tool used for creating Power BI reports and dashboards.
Internet connection: Learners will need to have a reliable internet connection to access the course materials, watch videos, and download any required software.

Description

Master Microsoft Power BI: Data Visualization & Business Intelligence Course

Unlock the full potential of Microsoft Power BI, the leading data visualization and business intelligence (BI) platform used by top organizations worldwide. This hands-on course is perfect for data analysts, business professionals, and IT specialists looking to transform raw data into actionable insights through interactive dashboards, reports, and custom visuals.

What You'll Learn

Getting Started with Power BI Learn how to install Power BI Desktop, connect to diverse data sources (Excel, SQL Server, Azure, Salesforce, Google Analytics), and build your first interactive dashboard.
Data Visualization Techniques Create compelling charts, graphs, heatmaps, and KPIs using Power BI’s built-in visualization tools. Learn best practices for storytelling with data and designing user-friendly reports.
Advanced Data Modeling Master DAX (Data Analysis Expressions), build calculated columns, measures, and create complex relationships between tables using star schema and snowflake schema modeling.
Custom Visuals & Themes Explore the Power BI Marketplace, import and configure custom visuals, and design branded report themes for enhanced user experience.
Data Transformation with Power Query Use Power Query Editor to clean, filter, and transform data with M code, enabling efficient ETL (Extract, Transform, Load) workflows.
Sharing & Collaboration Publish reports to Power BI Service, set up workspaces, manage row-level security (RLS), and collaborate via Microsoft Teams, SharePoint, and Power BI Mobile App.

Who this course is for:

Business professionals: Power BI can be used to gain insights into various business metrics and key performance indicators, making it an ideal tool for business professionals who need to analyze data to make informed decisions.
Data analysts: The course can help data analysts learn how to use Power BI to perform more complex data modeling and analysis tasks, as well as create custom visuals and dashboards to communicate their findings to others.
IT professionals: The course can also benefit IT professionals who need to work with data and create reports and dashboards to share with others in their organization.
Students and learners: Anyone who is interested in data analysis and visualization, regardless of their background or experience, can benefit from taking this course.
Career switchers: The course can be a valuable tool for those looking to switch careers into data analysis or business intelligence, as it provides a comprehensive introduction to a widely-used data analysis and visualization tool.

Complete Microsoft Power BI course

What you'll learn

Explore related topics

Course content

Introduction6 lectures • 43min

Basic Understanding of Power BI Desktop4 lectures • 19min

Preparing the Data Layer15 lectures • 1hr 51min

Preparing the Data model12 lectures • 1hr 14min

Managing The Relationship Between Tables7 lectures • 35min

Data Analysis Using Dax Function in Power BI11 lectures • 1hr 14min

Data Visualization Basic11 lectures • 1hr 54min

Advance Visualization Technique4 lectures • 39min

Final Touch Up in Dashboard4 lectures • 48min

Requirements

Description

Who this course is for: