Free Course Image Power BI beginner to intermediate

Free online course Power BI beginner to intermediate

Duration of the online course: 4 hours and 44 minutes

3.8

StarStarStarStar

(5)

Turn raw data into clear dashboards with this free Power BI course—learn Power Query, modeling, and visuals fast to boost your BI skills and career.

In this free course, learn about

  • What Power BI is and the core workflow: connect, transform, model, visualize, share
  • Benefits of installing Power BI Desktop via Microsoft Store (updates, management, reliability)
  • Key Power BI Desktop Options categories explored and where to configure settings
  • When/why to use Transform Data to open Power Query and shape/clean data before loading
  • Power Query Editor basics: steps, applied transformations, and preparing tables for the model
  • How to troubleshoot refresh errors when using provided instructor files (paths, credentials, data types)
  • Using Merge Queries to join tables and enrich datasets within Power Query
  • Diagnosing missing visuals (e.g., missing table/fields, load disabled, model issues, filters)
  • Why a dedicated Date table is essential for time intelligence and correct date relationships
  • Using the FORMAT function in calculated columns to create display-friendly text or custom formats
  • Purpose and tradeoffs of calculated columns: row-by-row logic, modeling, sorting, categorization

About the free online course

Build confidence turning messy spreadsheets into insights that people can actually act on. This free online course takes you from Power BI beginner to a solid intermediate level by guiding you through the real workflow used in reporting and business intelligence: getting data in, shaping it, modeling it correctly, and presenting results with clear, compelling visuals.

You’ll start by understanding what Power BI is and how it fits into a modern data analytics toolkit. From there, you’ll work inside Power BI Desktop and learn settings that make your environment smoother and more reliable. A strong focus is placed on Power Query because clean data is the foundation of every good report. You’ll practice using Transform Data to open the Power Query Editor, fix common issues, and prepare datasets so refreshes work consistently instead of breaking at the last moment.

As you progress, you’ll see how separate files and tables come together in a useful model. You’ll learn why merge queries matter when you need to combine information across sources, and you’ll understand the kind of problems that cause visuals to disappear or show incomplete results. Instead of memorizing clicks, you’ll build a mental model for diagnosing what went wrong and how to correct it efficiently.

The course also emphasizes modeling choices that unlock better analysis. You’ll explore why adding a dedicated dates table is essential for time-based reporting and for making filters and trends behave the way decision-makers expect. You’ll use calculated columns with intention, including formatting values for readability, and you’ll understand when calculated columns help your model support more meaningful reporting.

By the end, you’ll be able to prepare data, connect tables thoughtfully, and produce dashboards that communicate insights quickly—skills that translate directly into day-to-day tasks in data science and business intelligence roles.

Course content

  • Video class: Microsoft Power BI Beginner to Intermediate Course: 4 Hours Data Visualization Training 4h44m
  • Exercise: _What is Power BI?
  • Exercise: _What is the benefit of installing Power BI Desktop from the Microsoft store?
  • Exercise: _What are the three categories that the author explores in the "Options" section of Power BI Desktop?
  • Exercise: _What is the purpose of clicking on "Transform Data" in Power Query?
  • Exercise: _What is the purpose of clicking on "Transform data" in the Power Query Editor?
  • Exercise: _What should you do if you encounter an error while refreshing the Power BI report using the files provided by the instructor?
  • Exercise: _What is the purpose of using merge queries in Power Query?
  • Exercise: _Why is the visual with the sales prep table missing on the report page?
  • Exercise: _What is the main reason why a dates table should be added to a Power BI model?
  • Exercise: _What is the purpose of using the "format" function in the third calculated column?
  • Exercise: _What is the purpose of the calculated columns in Power BI?

This free course includes:

Icon for learning via the audio course

4 hours and 44 minutes of online video course

Icon for the digital course completion certificate

Digital certificate of course completion (Free)

Icon for exercises to practice what you've learned

Exercises to train your knowledge

Icon for courses that are 100% free from start to finish

100% free, from content to certificate

What is the purpose of using Merge Queries in Power BI Power Query?

Merge Queries combines tables using matching columns, similar to a database join, so related data can be analyzed together.

Why should I add a dedicated date table to a Power BI data model?

A date table supports accurate time-intelligence calculations such as year-to-date totals, monthly comparisons, and period filtering.

What does Transform Data do in Power BI Desktop?

Transform Data opens Power Query Editor, where you can clean, reshape, combine, and prepare data before loading it into the model.

Ready to get started?Download the app and get started today.

Install the app now

to access the course
Icon representing technology and business courses

Over 5,000 free courses

Programming, English, Digital Marketing and much more! Learn whatever you want, for free.

Calendar icon with target representing study planning

Study plan with AI

Our app's Artificial Intelligence can create a study schedule for the course you choose.

Professional icon representing career and business

From zero to professional success

Improve your resume with our free Certificate and then use our Artificial Intelligence to find your dream job.

You can also use the QR Code or the links below.

QR Code - Download Cursa - Online Courses

Course comments: Power BI beginner to intermediate

SA

Sarah Adhiambo Ohanga

StarStarStar

Kindly be attaching the data that the instructor is using for easy follow up and practical cases

BF

Beevi Fathima

StarStarStarStar

hello sir,

More free courses at Data Science and Business Intelligence

Free Ebook + Audiobooks! Learn by listening or reading!