Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Master in Microsoft Power BI Desktop and Service

Name: Master in Microsoft Power BI Desktop and Service
Rating: 4.6 (4879 reviews)

Hands-on Guide to Mastering Power BI Desktop and Power BI Service

Created byLearnsector LLP, Navya Kannan

Last updated 7/2025

English

What you'll learn

Understand Power BI concepts like Microsoft Power BI desktop layouts, BI reports, dashboards, and Power BI DAX commands and functions.
Create compelling reports and visualizations, derive real-time insights, and deploy it on demand.
Create, share, collaborate, and benefit from business information with purpose-built dashboards.
Form relationships in your data model and learn data visualization best practices.

Course content

8 sections • 82 lectures • 7h 40m total length

Introduction to Business Intelligence5:00
In this lecture, you will get an introduction to Microsoft Power BI and also recognize the five Whats that Power BI helps us answer.
The Relation Between Business Intelligence and Data Warehouse4:10
In this lecture, you will understand what an ETL (Extract, Transform, Load) Process is and the relationship between Business Intelligence and data warehouse.
Power BI Overview & Installation3:24
In this lecture, you will be introduced to the different components of Power BI and then taken through step-by-step on how to install Power BI desktop.
Introduction Power BI Desktop9:54
In this lecture, you will be taken through the Power BI Interface and understand the Power BI settings.
Connecting with Data4:03
In this lecture, you will be given a brief introduction to connecting data and also explore the different file formats and different data sources that can be connected to Power BI.
Knowledge Check

Downloadable resources for Hands-on Excercise0:04
Connect to Excel in Power BI Desktop5:22
In this lecture, you will learn how to connect Excel File to Power BI desktop
Connect to CSV files in Power BI Desktop3:04
In this lecture, you will learn how to connect CSV or Text File to Power BI desktop
Connect to SQL Server in Power BI Desktop1:49
In this lecture, you will learn how to connect SQL Server to Power BI desktop
Connect to a Web page from Power BI Desktop4:04
In this lecture, you will learn how to connect data on web to Power BI desktop
Enter data directly into Power BI Desktop3:13
In this lecture, you will learn how to manually enter data into Power BI desktop
Knowledge Check

Introduction to Power Query2:11
In this section, we'll look at how to transform data using Power Query. It is very important to transform or edit your data before actually loading it to your Power BI to create an effective report and visualization.
Query Editor12:49
In this lecture, we will look into the working of a query editor.
Data formatting Troubleshoot- Option 20:29
Data formatting Troubleshoot - Option 1 (recommended)0:30
Text Transformations18:02
In this lecture, we will look into how to perform text transformation on a column in Query Editor.
Number Column Calculations5:22
In this lecture, we will look into how to perform number calculations on a column in Power Query Editor.
Data Type6:57
In this lecture, we will look into how to identify the data types and how to change from one data type to another.
Date and Time Calculations13:28
In this lecture, we will look into the Date transformation, group by, and conditional column options in Power Query.
Append Queries and Merge Queries20:00
In this lecture, we will look at how to append queries, merge queries, and to combine multiple workbooks using folder options.
Data Source Settings and Refresh Setings7:08
In this lecture, we will look at features of Data source settings and Refresh settings options in Power BI.
Power Query Data Formatting8:26
In this lecture, we will look into Data formatting which includes Date formatting, Currency formatting, and presenting our data in the form of a map.
Hierarchy Creation in PowerBI4:00
In this lecture, we will look Hierarchy creation and its levels.
Knowledge check

Data Modeling Introduction3:29
In this lecture, let's do some analysis on data present in the tables to create a Data Model.
Primary key vs Foreign Key2:54
In this lecture, we will look primary and foreign key concepts.
Relationship build, Edit, Delete8:54
In this lecture, we will look at how to create, edit, and delete a relationship.
Snowflake Scheme4:33
In this lecture, we will look into Snowflakes scheme.
Active vs In Active relationship4:09
In this lecture, we will look into how to activate and inactivate relationships in Power BI.
Relationship Primary key with multiple foreign keys from different data9:50
In this lecture, we will look into how to create relationships where a primary key is related to multiple foreign keys, create reports and dashboards.
Knowledge Check

Data Analysis Expression (DAX)3:06
In this lecture, let's have an introduction on Data Analysis expression concepts in Power BI.
Creating Calculated Columns, Creating Measures8:50
In this lecture, we will explore at how to create calculated columns and calculated measures.
DAX Date and Time Functions10:51
In this lecture, let us look at DATE and Time functions in New Column and New Measure that can be used to create reports in Power BI.
DAX Text Functions6:13
In this lecture, let us look at some of the commonly used Text functions in Power BI.
DAX Logical Functions13:21
In this lecture, let us look at DAX logical functions 'AND' and 'OR' in Power BI.
DAX Related Function9:05
In this lecture, let us look at how RELATED function is used in Power BI.
DAX Implicit Vs Explicit Measures3:12
In this lecture, let us look into implicit and explicit function measures in Power BI.
DAX Statistical Functions1:43
In this lecture, let us look at the DAX statistical functions in Power BI.
DAX Filter Functions7:40
In this lecture, let us look at the DAX filter functions in Power BI.
DAX X-factor Functions5:26
In this lecture, let us look at the X-Factor functions in Power BI.
DAX Time Intelligence Functions10:50
In this lecture, let's look into Time intelligence functions in DAX.
DAX Rank Functions5:09
In this lecture, let's look into DAX Rank functions with their representations in Power BI.
New Table and Quick Measure5:07
In this lecture, let's look into New Table and Quick Measure features in Power BI.
Knowledge Check

Reports and Visualization types in Power BI1:32
In this lecture, let's have an introductions on Reports and Visualization types in Power BI.
Page Settings5:27
In this lecture, let's look at Page settings and it's formatting options.
Getting started with color formatting and axis properties7:34
In this lecture, let's look at Color formatting and axis properties.
Customize Visualization and X-axis and Y-axis properties8:13
In this lecture, let's look at how to customize Visualizations and format X-axis and Y-axis fields and properties.
Filters in Power BI5:15
In this lecture, let's look at various filter options available in Power BI.
Slicers in Power BI6:03
In this lecture, let's looks at Slicer features in Power BI and how they help to filter the data.
Table and Matrix4:25
In this lecture, let's look at how Tables and Matrix helps in Visualization and reports.
Conditional formatting on visuals4:57
In this lecture, let's look at Conditional formatting to visuals.
Card and Multi-row card12:49
In this lecture, let's discuss on Card, Multi-row card, and KPI in Visualizations.
Treemap2:49
In this lecture, let us discuss about Treemap visualization.
Combo Chart3:22
This lecture covers Combo Chart in Power BI, which is a combination of more than one chart. You will learn how to add a line chart to depict the percentage of revenue growth and change the color, font, and background of the chart. The lecture also explains how to add data labels and borders to the chart.
Line chart, Area chart, and Stacked area chart2:56
Gauge chart7:19
KPI5:19
Drill through4:08
Map and Filled map6:11
Pie chart and Doughnut charts3:13
Ribbon charts4:28
Waterfall Chart3:42
Funnel chart2:52
Import Data model to Power BI desktop2:11
Phone layout2:02
Bookmark7:52
Knowledge Check

Comparing Power BI desktop and Power BI Service3:10
Sign in to Power BI3:02
Power BI Service walkthrough5:59
Publishing a report from Power BI desktop to Power BI Service7:24
Create a Dashboard in Power BI Service5:21
Power BI Service Workspace UI4:18
Edit a Report in Power BI Service4:39
Power BI Report - Reading View14:31
Power BI Report - Usage Metrics3:11
Analyze in Excel4:07
Power BI Report - Quick insights2:58
Dashboard walkthrough2:31
Add Tile in Dashbaord3:06
Q and A4:15
Dataset Settings1:44
Get More Visuals3:09
Row-level security with Power BI4:11
Knowledge Check

Requirements

Microsoft Power BI Desktop installed on your computer (which is free).
Knowledge of Excel Power Query is an added advantage.

Description

More than 120k satisfied students worldwide have enrolled in this course writing thousands of 5 star reviews.

I recommend this course for anybody starting with Power BI It touches all aspects of the desktop and online tool for visual development If multiple data source examples are included then it would be very complete like data gateway data flow etc Given the scope of the course I still considered this one of the best available I am able to follow at 2x speed and complete the course.

Vidya L

If you want to know all about PowerBi then this course for you Concepts are explained in detail simple as well which makes us understand the concepts clearly I strongly recommend this course for beginners go for it Happy learning Special Thanks to Navya Mam for making this course and boosting my career skills.

Sundaram Subramanian

The instructor has done a very good job by explaining all the features of Power BI in a much simpler way which anyone with any experience can understand easily I am really happy and have all the required knowledge to implement for the real-time project.

Shani Jaiswal

I think covering the entire in true sense end to end tool with an example makes a first-time viewer like me a good hold and develops an encouragement for its use Nicely covered and an informative tutorial.

Shreyas Shringi

This is an excellent course to learn Power BI its components and various functionalities All the modules are very clearly explained with examples.

Chiranjeevi Rao Boddu

What a great course The instructor was so detailed showing us how to perform various functions from manual to automated The case studies were very real and I can vouch for that as a data scientist with a business background It is obvious that the lesson planning was done meticulously and if I could rate this 6 stars I would.

Len Kwok

One of the BEST resources to learn power Bi that I found in Udemy thanks a lot and keep it up.

Naag Sadineni

Goes in-depth for even a person who just starts with PowerBI can follow There are some issues with date formatting in few data sets different sheets had different date formats which I solved using the tips provided on date formatting in the 14 and 15 points All in all very helpful for a person who is starting with PowerBI.

Yasintha Jayaratne

Excellent course excellent teacher I appreciate following this course because the teacher knows and explains well the concepts.

Abdoul Traoré

And many thousands more

Course Description

This Microsoft Power BI course will help you to become a Power BI expert It will enhance your skills by offering you comprehensive knowledge on Power BI Desktop Power BI Online and the required hands-on experience for solving real-time industry-based Power BI projects.

As we progress through this course youll learn to unleash the capabilities of Power BI to perform a comprehensive analysis of data from multiple sources and present the data using the perfect visualization.

In this course you will gain an understanding of the concept and working of Power BI Desktop and Power BI online services
You will learn how to connect Power BI to different data sources
You will be able to transform your data using Power Query and create data models
You will also level up your data analysis skills using DAX and create calculated columns and measures
With the help of Reports and Visualization in Power BI you will be able to present your data in an efficient and interactive way
And lastly you will learn how to publish your reports and dashboards to the Power BI online service

Why Learn Power BI

Power BI is a business intelligence tool by Microsoft that provides analytics services It provides interactive dashboards and visualizations with self-service business intelligence capabilities where end users can create reports and dashboards by themselves without having to depend on anyone else as Power BIs artificial intelligence is there to help you out Power BI provides cloudbased BI services known as Power BI Services along with a desktopbased interface called Power BI Desktop It offers Data modeling capabilities along with data preparation data discovery and interactive dashboards.

Why should you take up this Power BI course

Worldwide Business Intelligence and Analytics Market to grow to 228 billion in the next 2 years Gartner
70 of leading companies say that analytics is integral to how they make decisions IBM Survey
A Senior Business Intelligence Analyst can earn 89000 in the United States Payscale

Who this course is for:

Individuals looking for jobs as Business Analysts, Business Development Manager.
Suitable for business intelligence (BI) and reporting professionals, data analysts.
Statisticians aiming to implement their statistics skill to derive business insights.
Marketing, Finance, Sales, and other domain Professionals who need extensive business intelligence.

Master in Microsoft Power BI Desktop and Service

What you'll learn

Explore related topics

Course content

Business Intelligence (BI) Concepts & introduction5 lectures • 27min

Connecting Power BI with Different Data sources6 lectures • 18min

Power Query for Data Transformation12 lectures • 1hr 39min

Power BI Data Modeling – Relationship View and PowerPivot6 lectures • 34min

Data Analysis Expression (DAX)13 lectures • 1hr 31min

Reports & Visualization types in Power BI23 lectures • 1hr 55min

Power BI Publishing - Reports17 lectures • 1hr 18min

Course project0

Requirements

Description

Who this course is for: