Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Power BI Desktop for Beginners - FREE
Rating: 4.6 out of 5(517 ratings)
9,245 students

Power BI Desktop for Beginners - FREE

Get into the fundamentals of Power BI Desktop with a real case study
Created byMyExcelAcademy .
Last updated 3/2026
English
English [Auto],

What you'll learn

  • Students moving from Excel to the Power BI Desktop
  • Beginners who want to know the basics of Power BI Desktop before the Advanced stage
  • Basics of Data analytics and visualizations
  • Real world case study on London Dairy Ice cream sales to customers

Course content

2 sections • 17 lectures • 1h 59m total length

  • Power BI Environment10:45

    Explore the Power BI desktop environment, create a blank report, import data from Excel and other sources, and transform data with Power Query Editor to build visuals and dashboards.

  • Power Query transformations9:25

    Promote headers, remove top rows, and format data types in the Power Query editor, then load to the Power BI Desktop and save as a named file.

  • Using the Card Visuals8:36
  • Basic Transformations in Power Query4:59

    Explore transforming data with Power Query in Power BI desktop, including switching between table and matrix visuals, drilling down into data, and capitalizing store names and cities through uppercase formatting.

  • What is Row Context7:25
  • What is Filter Context4:17

    Explore how filter context fixes row context issues in Power BI by using the DAX calculate function to convert row context into filter context, ensuring correct totals.

  • Matrix Visual5:22

    Learn how to format a matrix visual, switch to tabular layout, adjust headers and totals, and analyze sales by day (weekends vs weekdays) in Power BI Desktop.

  • Calculated Columns12:44

    Create calculated columns in Power BI Desktop to extract weekday names from dates, sort by weekday order, and analyze sales by day with a clustered bar chart.

  • New Card Visual14:04
  • Calculating Min, Max and Percentage of Total6:35
  • Donut Chart3:36
  • Lets slice Data using a Slicer3:56
  • Analyze and Validate the numbers3:58
  • Using Themes2:42
  • Creating a custom Background and Logo8:32
  • Decomposition Tree and Custom Visual11:32
  • Test your knowledge
  • What is Power Query and do we have to download it
  • Data Types in Power Query
  • Applied Steps in Power Query
  • What is Row Context
  • What is DAX
  • Which Visualization acts as a Pivot table in Excel

Requirements

  • No prior knowledge of Power BI is needed
  • Your attention and focus is what matters most to learn and keep learning

Description

This course is designed for students and professionals looking to get started with Power BI. You will learn the fundamentals of data visualization, report building, and interactive dashboards. The course covers:

  • Connecting to Excel

  • Transforming and cleaning data with Power Query - Basic transformations and data types

  • Creating dynamic reports using visuals, cards, matrix, Donut chart, bar chart

  • Understanding Calculated Columns & DAX basics for calculations

  • Use of Quick Measures and Visual Calculations

  • Row Context, Filter Context explained

  • Using and customizing Slicer

  • Decomposition Tree - AI Analytics

  • ChatGPT usage to create background


  • By the end of this course, you'll be able to have the confidence of importing data into Excel and creating your first Power BI Dashboard. Perfect for beginners with no prior experience!

  • If you're comfortable working with data in Excel but want to take your analytics skills to the next level, this course is perfect for you!

  • By the end of this course, you'll understand how Power BI enhances Excel’s capabilities, making it easier to analyze and visualize large datasets efficiently. Whether you're an Excel power user or just getting started with data analytics, this course will set you on the right path to Power BI!

  • Quiz to check your understanding level of the topics covered


Who this course is for:

  • Those who are looking to move to Power BI Desktop, coming from an Excel background
  • Inquisitive to step into the Power BI Data Analytics area
  • Integrate Excel and Power BI

Report abuse