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 Microsoft Power BI from Basics to Advance

Name: Master Microsoft Power BI from Basics to Advance
Rating: 4.5 (80 reviews)

Learn skills for Microsoft Power BI certification using the free Power BI Desktop. Power Query, DAX Helps with PL-300

Highest Rated

Created bySudhanshu Kumar Singh

Last updated 11/2025

Hindi

What you'll learn

Build professional-quality business intelligence reports from the ground up
Blend and transform raw data into beautiful interactive visuals & dashboards using Power BI
Design and implement the same data visualization tool used by Microsoft professionals
Explore powerful artificial intelligence tools and advanced data analysis & visualization techniques
Showcase your skills with two full-scale real time projects

Course content

13 sections • 51 lectures • 22h 22m total length

Microsoft Power BI Installation Guide1:10
Class 1 - Power BI Introduction1:10:00
In Class 1: Power BI Introduction, students will learn the fundamentals of Power BI, its interface, and key features. They will explore different data sources and connection types, understanding how to import and link data efficiently. This class sets the foundation for working with Power BI, preparing students for data transformation and visualization in later lessons.
PowerBI_Introduction(PDF)0:01
Class 2 - Starting Power Query Editor1:06:15
Students will learn the basics of Power Query Editor, including how to clean, reshape, and structure data. They will understand data types and how to efficiently prepare raw data for analysis in Power BI.
PDF for Class-20:03
Class 3 - Data Transformation1:13:53
Students will learn essential data transformation techniques, focusing on text transformations such as formatting, splitting, and extracting data. This will help in preparing clean, structured datasets.
PDF for Class-30:02
Class 4 - Data Transformation Cont.1:14:46
This class is an important continuation of Class 3.
PDF for class-40:02
Class 5 - Advanced Data Transformations1:04:17
Students will explore advanced transformation techniques, including appending and merging datasets, enabling them to efficiently combine multiple data sources for comprehensive analysis in Power BI.
PDF for Class-50:03

Class 6 - Bar Chart in Power BI1:01:23
Students will learn to create, customize, and format Bar Charts in Power BI. They will explore sorting, labeling, and interactive features to enhance data visualization and interpretation.
Charts_in_PowerBI PDF0:02
Class 7 - Line Charts1:13:19
Students will learn to create and customize Line Charts to visualize trends over time. They will explore formatting, axis settings, and interactive features to enhance data interpretation.
Class 8 - Pie, donut, scatter plot and Funnel Charts56:37
Students will learn to create and customize Pie, Donut, Scatter, and Funnel Charts in Power BI, understanding their use cases and formatting techniques for effective data comparison and analysis.
Charts_Practice
Class 8 - WaterFall and Funnel chart1:13:50
Students will learn to create and customize Waterfall and Funnel Charts in Power BI, understanding their role in visualizing cumulative changes, process stages, and data flow effectively.
Class 9 - Cards and KPI charts and Filters59:00
Students will learn to create Cards and KPI charts to display key metrics and apply Filters to refine data views, enhancing report interactivity and data-driven decision-making in Power BI.
Filters_in_PowerBI0:02
Power BI Questions Assignment0:01
Class 10 - Drill Down and Tooltip1:12:32
Students will learn to use Drill Down to navigate data hierarchies and Tooltips to display additional insights, improving interactivity and depth in Power BI visualizations.
Hierarchy_and_drilldown0:02
Sample Dataset0:01
Report Assignment0:01
Please download the sample Dataset from above lecture and use it to complete this assignment

Class 11 - Selection Pane, Button, Bookmark, Sync slicers and interactivity1:04:47
Students will learn to use Selection Pane, Buttons, Bookmarks, and Sync Slicers to create interactive reports, improve navigation, and enhance user experience in Power BI.
PDF for Class-110:01
Class 12 - Drill through and Parameters50:00
Students will learn to use Drill Through to focus on specific data insights and Parameters to create dynamic, customizable reports for enhanced interactivity in Power BI.
Global Superstore Orders Data Set0:02
Global Superstore Challenge Assignment0:02
Please use Global Superstore Orders Dataset to complete this assignment.

Class 13 - Relationships in Power BI34:48
Class 13 covers relationships in Power BI, teaching how to connect tables, define one-to-many and many-to-many relationships, and use them for accurate data analysis and reporting.
Class 14 - Modelling in Power BI41:41
Class 14 covers modeling in Power BI, teaching how to create data models, define relationships, use DAX functions, and optimize data for better analysis and reporting.

Class 15 - Basics of DAX53:46
This class introduces the fundamentals of Data Analysis Expressions (DAX), the formula language used in Power BI, Excel, and other Microsoft data tools. You will learn about DAX syntax, operators, and basic functions used to create calculated columns, measures, and tables. The session will also cover the importance of context (row and filter context) in DAX calculations.
Class 16 - Aggregate and Text Functions in DAX48:50
This class covers aggregate functions (such as SUM, AVERAGE, MIN, MAX) and text functions (such as CONCATENATE, LEFT, RIGHT, MID) in DAX. You will learn how to perform mathematical operations on datasets and manipulate text values within Power BI. The session will also include practical examples to demonstrate how these functions can be used in real-world data analysis.
Class 17 - Date and logical Functions in DAX46:50
This class explores date functions (such as TODAY, NOW, DATE, YEAR, MONTH) and logical functions (such as IF, SWITCH, AND, OR) in DAX. You will learn how to work with date values, extract specific date components, and create time-based calculations. Additionally, the session will cover logical conditions to apply decision-making logic in your DAX formulas, enabling more dynamic and flexible data analysis.
Class 18 - Filter and Time Intelligence Functions1:03:04
This class focuses on filter functions (such as FILTER, ALL, CALCULATE) and time intelligence functions (such as TOTALYTD, PREVIOUSMONTH, DATESBETWEEN) in DAX. You will learn how to manipulate and control data context using filters and how to perform advanced time-based calculations. The session includes practical examples to demonstrate how these functions enhance data analysis and reporting in Power BI.
Class 19 - Time Intelligence Functions in DAX47:45
This class provides an in-depth understanding of Time Intelligence functions in DAX, which help analyze data over time. You will learn functions like SAMEPERIODLASTYEAR, TOTALYTD, DATESYTD, PREVIOUSYEAR, and PARALLELPERIOD to perform year-over-year comparisons, cumulative calculations, and period-based analysis. The session includes practical examples to apply these functions effectively in Power BI reports.

Class 20 - Row Level Security38:30
This class covers the concept of Row-Level Security (RLS) in Power BI, which allows you to restrict data access for different users based on roles. You will learn how to define security roles using DAX expressions and apply filters to control what data users can see. The session will also demonstrate how to implement static and dynamic RLS to enhance data security in Power BI reports.
Class 21 - Dynamic RLS30:35
This class explores Dynamic Row-Level Security (RLS) in Power BI, which enables user-specific data access based on login credentials. You will learn how to implement DAX functions like USERPRINCIPALNAME() and LOOKUPVALUE() to dynamically filter data for each user. The session will also cover the difference between static and dynamic RLS and provide practical examples to apply dynamic security in Power BI reports.

Requirements

Microsoft Power BI Desktop (free download)
This course is designed for PC/Windows users (currently not available for Mac)

Description

This comprehensive Power BI course takes you from a beginner to an advanced level, equipping you with the skills to analyze data, create interactive reports, and build powerful dashboards.

You’ll start with Power BI fundamentals, including data connections, the Power Query Editor, and data transformations. Next, you’ll explore visualizations, learning to create bar charts, line charts, KPI cards, and advanced filters. Intermediate concepts such as drill-throughs, bookmarks, and interactivity will help you design dynamic reports.

Learn data visualization through Microsoft Power BI and create opportunities for you or key decision-makers to discover data patterns such as customer purchase behavior, sales trends, or production bottlenecks.

Use Microsoft Power BI to Analyze and Visualize Data So You Can Respond Accordingly

Connect Power BI to a Variety of Datasets
Drill Down and Up in Your Visualization and Calculate Data
Visualize Data in the Form of Various Charts, Plots, and Maps

Convert Raw Data Into Compelling Data Visualizations Using Microsoft Power BI

Each section provides exercises that will challenge you so you can learn by immediately applying what you're learning.

Content is updated as new versions of Power BI are released. You can always return to the course to further hone your skills, while you stay ahead of the competition.

Contents and Overview

This course begins with Power BI basics. You will navigate the software, connect it to a data file, and export a worksheet, so even beginners will feel completely at ease.

To be able to find trends in your data and make accurate forecasts, you'll learn how to work with hierarchies and time series.

Also, to make data easier to digest, you'll tackle how to use aggregations to summarize information. You will also use granularity to ensure accurate calculations.

In order to begin visualizing data, you'll cover how to create various charts, maps, scatterplots, and interactive dashboards for each of your projects.

You'll even learn how to join multiple data sources into one in order to combine diverse sources of information in one analytical solution.

Finally, you'll cover some of the latest and most advanced custom visualizations in Microsoft Power BI, where you will create histograms, brick charts, and more.

By the time you complete this course, you'll be a highly proficient Power BI user. You will be using your skills as a data scientist to extract knowledge from data so you can analyze and visualize complex questions with ease.

You'll be fully prepared to collect, examine, and present data for any purpose, whether you're working with scientific data or you want to make forecasts about buying trends to increase profits.

Who this course is for:

Anyone looking for a hands-on, project-based introduction to Microsoft Power BI Desktop
Data analysts and Excel users hoping to develop advanced data modeling, dashboard design, and business intelligence skills
Aspiring data professionals looking to master the business intelligence tool on the market
Anyone looking to pursue a career in data analysis, analytics or business intelligence
Students who want a comprehensive, engaging, and highly interactive approach to training

Master Microsoft Power BI from Basics to Advance

What you'll learn

Explore related topics

Course content

Introduction11 lectures • 5hr 51min

Starting with visuals in power BI13 lectures • 6hr 37min

Power BI Intermediate Concepts5 lectures • 1hr 55min

PBI Project - 17 lectures • 1min

Power Pivot in Power BI2 lectures • 1hr 16min

Quiz0

DAX in Power BI5 lectures • 4hr 20min

Quiz0

PBI Project - 2 (Sales Challenge)2 lectures • 1min

RLS in Power BI2 lectures • 1hr 9min

Requirements

Description

Who this course is for: