Power BI Tutorial Hub

Introduction to Power BI: A Hands-On Tutorial for Beginners

This introduction to Power BI is a hands-on, step-by-step tutorial. Instead of reading about features, you will install the tool, connect to data, build your first interactive report, write your first DAX measure, and publish a dashboard you can share.

Start the Tutorial → View Power BI Course

Beginner friendly Follow along, hands-on

Introduction to Power BI tutorial for beginners

How to use this introduction to Power BI tutorial

If you have wanted to learn Power BI but did not know where to start, this is your starting point. Rather than explaining theory, this guide walks you through building something real, one step at a time. Open Power BI Desktop on a second screen and follow along.

By the end you will have a working report, a basic data model, your first DAX measure, and a published dashboard. That is the fastest way to actually learn the tool: build first, refine later.

💡 New to the concept itself? Read our complete guide on what Power BI is and who uses it first, then come back here to start building.

Outcomes

What you will build in this tutorial

This is a practical introduction. Every section produces something you can see on your screen. Here is what you will have created by the time you finish.

🔌

A live data connection

Connect Power BI to an Excel or CSV file and load it, ready to shape and visualise.

🧹

A cleaned dataset

Use Power Query to remove bad rows, fix data types, and shape your data before building.

📊

An interactive report

Build a bar chart and a table, then add a slicer so the report filters as you click.

🧮

Your first DAX measure

Write a simple measure with SUM and CALCULATE to create a custom calculation.

☁️

A published dashboard

Publish your report to the Power BI Service and share it from the cloud.

📑

A repeatable workflow

Learn the five-stage process so you can build any future report on your own.

Setup

Before you begin

You only need two things to follow this tutorial, and both are free. There is no coding required to get started, and you can complete every step on a standard Windows laptop.

1. Install Power BI Desktop. It is free from the Microsoft Store (search “Power BI Desktop”) or the Microsoft Power BI website. It runs on Windows only. On a Mac, use the web-based Power BI Service or run Windows in a virtual machine.

2. Grab a sample dataset. Any Excel or CSV file with a few columns of real data works. A simple sales file with date, region, product, and amount columns is perfect for practice.

If you are not yet sure what Power BI actually is or which roles use it, start with our pillar guide on what Power BI is, then return here to build.

The Workflow

The five-stage workflow you will follow

Every report you ever build in Power BI follows the same five stages. Learn this flow once and you can repeat it for any dataset. In this tutorial you will perform each stage yourself.

Connect

Link to your data source

Transform

Clean and shape data

Model

Relationships and DAX

Visualise

Build charts and slicers

Publish to the cloud

Connect pulls raw data in from Excel, a CSV, SQL Server, or one of hundreds of other sources. Transform uses Power Query to clean that data: remove duplicates, fix column types, and filter rows. Model defines relationships between tables and adds calculations with DAX. Visualise is where you drag fields onto the canvas to create charts, tables, and slicers. Share publishes the finished report to the Power BI Service so others can use it.

Want to see finished dashboards first?

Browse real Power BI dashboard examples to see what you are working toward.

View dashboard examples →

Hands-On

Build your first Power BI report, step by step

Follow these five steps in order. Each one takes only a few minutes, and by the end you will have a complete, shareable report built from scratch.

Step 1

Download and open Power BI Desktop

Install Power BI Desktop from the Microsoft Store or the Power BI website, then open it. Close the start-up dialog to reach the blank report canvas. This is your workspace: the report canvas in the centre, the Visualizations and Data panes on the right, and the ribbon along the top.

Result: a blank report open and ready, with the ribbon and panes visible.

Step 2

Connect to a data source

Click Get Data on the ribbon and choose Excel workbook or Text/CSV. Select your sample file. Power BI shows a preview, then opens the Power Query Editor so you can clean the data before loading it.

Try this

Remove a blank column, rename a header to something clear, and set a column’s data type to whole number or date.

Then

Click Close & Apply to load the cleaned data into your model.

Result: clean data loaded and visible in the Data pane on the right.

Step 3

Build your first interactive report

Switch to the Report view. Drag a category field (like region or product) and a numeric field (like amount) onto the canvas, then choose a bar chart from the Visualizations pane. Add a table next to it the same way.

Now drag a category field onto the canvas and turn it into a slicer. Click a value in the slicer and watch every visual filter together. That interactivity is the core of what makes Power BI different from a static spreadsheet.

Result: a bar chart, a table, and a working slicer that filters the whole page.

Step 4

Publish and share your report

Click Publish on the ribbon and sign in with a free Microsoft account. Choose a workspace, and your report uploads to the Power BI Service at app.powerbi.com. From there you can schedule automatic data refresh, share with teammates, or embed the report in SharePoint or Teams.

Result: your report live in the cloud, ready to share via a link.

Step 5

Write your first DAX measure

Back in Desktop, right-click your table in the Data pane and choose New measure. Type a simple total, then drag the measure onto a card visual to display it. You have just created a calculation that does not exist in the raw data. The next section breaks DAX down properly.

// your first measure
Total Sales = SUM(‘Sales'[Amount])

Result: a custom Total Sales measure shown on a card visual.

DAX Basics

DAX basics: your first four functions

DAX (Data Analysis Expressions) is the formula language for custom calculations. You do not need to master all of it. These four functions cover most of what a beginner needs, and the most important concept to understand is filter context, which CALCULATE controls.

➕

SUM

Adds up a numeric column. The simplest place to start for totals like revenue or quantity.

Total Sales = SUM(‘Sales'[Amount])

🎯

CALCULATE

Changes the filter context of a calculation. The single most important DAX function to understand.

India Sales =
CALCULATE([Total Sales],
‘Sales'[Region]=”India”)

➖

DIVIDE

Divides safely and returns a blank instead of an error when the denominator is zero.

Margin % =
DIVIDE([Profit],[Total Sales])

📅

DATEADD

Shifts dates for time comparisons, such as comparing this period to the same period last year.

Sales LY =
CALCULATE([Total Sales],
DATEADD(‘Date'[Date],-1,YEAR))

Focus on understanding filter context rather than memorising syntax. Once CALCULATE clicks, most other DAX patterns become much easier to read.

Ready to make your reports faster and cleaner?

Once you are comfortable building, learn how to optimise Power BI reports for speed.

Optimise reports →

Learning Path

Your Power BI learning path after this tutorial

This introduction gets you to a working report. Here is how to keep progressing. Most learners reach a confident intermediate level in one to two months of regular practice.

Stage 1 • Weeks 0 to 2

Foundation

Get comfortable with the basics you practised here: connecting to Excel, CSV, and SQL data, building bar, line, and table visuals, using slicers and filters, and publishing to the Power BI Service.

Connect data Basic visuals Slicers & filters Publish to Service

Stage 2 • Months 1 to 2

Intermediate

Move into the skills that make your reports genuinely useful: Power Query transformations (merge, pivot, group by), basic DAX measures, relationships in the data model, and Row-Level Security. This is the level most working analysts need day to day.

Power Query transforms DAX measures Data modelling Row-Level Security

Stage 3 • Months 3 to 6

Advanced

Build toward full BI delivery: complex DAX (time intelligence, RANKX, dynamic measures), composite models, deployment pipelines, dataflows, and paginated reports. At this level you can architect and deliver enterprise reporting solutions.

Time intelligence Composite models Deployment pipelines Paginated reports

Go from beginner to job-ready with the Power BI Course

This tutorial gets you started. The Techcanvass Power BI Course takes you all the way: structured, project-focused training that turns these basics into real, portfolio-ready skills and prepares you for the PL-300 certification.

Explore the Power BI Course → PL-300 Exam Guide

The course covers

Power Query data transformation in depth
DAX measures and calculated columns
Data model and semantic model design
Report design and dashboard storytelling
Publishing, sharing, and refresh in the Service
Full PL-300 certification preparation

Tutorial Hub

Go deeper: more Power BI tutorials

Once you have finished this introduction, use these focused guides to build specific skills. Each one picks up where this tutorial leaves off.

Concept Guide

FAQs

Power BI tutorial: common beginner questions

Practical questions from people working through their first Power BI introduction.

How do I start learning Power BI as a complete beginner?

Start by installing the free Power BI Desktop, then follow a hands-on path: connect to a simple Excel or CSV file, clean it in Power Query, build a bar chart and a slicer, write one basic DAX measure, and publish the report. Building a real report end to end teaches you far faster than reading about features. This tutorial walks through exactly that sequence.

Is Power BI Desktop free to download?

Yes. Power BI Desktop is completely free to download and use on a Windows computer, and it includes everything you need to connect data, build models, and create reports. You only need a paid Power BI Pro or Premium licence when you want to publish reports to the cloud and share them with colleagues.

How long does it take to learn Power BI?

You can build your first working report in under an hour by following this tutorial. Foundation skills take around one to two weeks of practice. Reaching a confident intermediate level, which covers most real reporting work, typically takes one to two months of regular hands-on practice. Advanced skills build over three to six months.

Do I need coding or programming skills to follow this tutorial?

No. The core of Power BI is drag-and-drop, so you can connect data and build interactive reports with no code. DAX, the formula language for custom calculations, looks similar to Excel formulas and you only need a few functions to start. You can follow this entire introduction without any prior programming experience.

What data should I use to practise Power BI?

Any Excel or CSV file with a few columns of real values works well. A simple sales file with date, region, product, and amount columns is ideal because it lets you practise totals, slicers, and time-based DAX. Using data from your own work makes the practice more meaningful and easier to remember.

What should I learn after this Power BI introduction?

After building your first report, move into Power Query transformations, basic DAX measures, and data modelling, then practise Row-Level Security and report optimisation. Use the tutorial hub above to follow focused guides on dashboards, semantic models, and report performance, and consider a structured course to prepare for the PL-300 certification.