Menu
×
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP C C++ C# AWS W3.CSS HOW TO BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS DSA TYPESCRIPT ANGULAR ANGULARJS GIT POSTGRESQL MONGODB ASP AI R GO KOTLIN SWIFT SASS VUE GEN AI SCIPY CYBERSECURITY DATA SCIENCE INTRO TO PROGRAMMING HTML & CSS BASH RUST TOOLS MATH

Power BI Introduction


Share

What is Power BI?

Power BI is a business analytics tool from Microsoft.

BI stands for business intelligence: turning raw data into information that helps people make decisions.

With Power BI you connect to data, clean it, and turn it into interactive reports with charts, tables, cards and maps.

The reports are interactive.

When a reader clicks a bar in a chart or picks a value in a filter, every visual on the page updates.

Power BI is typically used for:

  • Sales and finance reports
  • Dashboards that track key numbers (KPIs)
  • Combining data from many sources in one place
  • Sharing reports that stay up to date when the data changes

The Parts of Power BI

Power BI is not one single program.

It is a set of tools that work together:

  • Power BI Desktop is a free Windows application. You use it to connect to data, clean and model it, and design reports. This tutorial uses Power BI Desktop.
  • Power BI service is the online part. It runs in a web browser at app.powerbi.com. You publish reports there, share them with others, and build dashboards.
  • Power BI Mobile apps for iOS and Android let you view and interact with reports and dashboards on a phone or tablet.

A typical project starts in Power BI Desktop and ends in the Power BI service, where other people read the report.

The Power BI service is part of Microsoft Fabric, a larger Microsoft platform for data and analytics.

You may see the Fabric name when you sign in.

For this tutorial, you only need the Power BI parts.



What You Can Build

These are the main things you create in Power BI:

  • Report: one or more pages of interactive visuals, such as charts, tables and cards. You usually build reports in Power BI Desktop.
  • Dashboard: a single page of tiles pinned from one or more reports, used to watch the most important numbers. Dashboards are made in the Power BI service.
  • Semantic model: the data behind a report, together with its relationships and calculations. Older versions of Power BI called it a dataset.

This is the report you will build in the First Report chapter:

A finished Power BI report page with a total sales card, a column chart of sales by category, a region slicer and a line chart of sales by year


Power BI vs Excel

If you know Excel, you already know a lot of Power BI.

Both programs come from Microsoft, and they share two important tools: Power Query, for getting and cleaning data, and the same data model engine, which Excel calls Power Pivot.

They are good at different things:

Excel Power BI
Best for Calculations, what-if analysis and quick, one-off analysis Interactive reports that many people read
Data Usually one workbook, up to 1,048,576 rows per sheet Large amounts of data, often from many sources
Formulas Cell formulas, like =SUM(B2:B10) DAX measures that work on whole columns
Interaction Filters, slicers and PivotTables Every visual on a page filters the others
Sharing Send or share the workbook file Publish to the Power BI service and share a link

Many people use both.

They explore data in Excel, and build the report that the whole team reads in Power BI.

If you have used an Excel PivotTable, you will feel at home.

A Power BI visual works much like a PivotTable: you pick a category and a number, and Power BI adds up the number for each category.

Read our Excel PivotTable Intro for a refresher.


Get Started

This tutorial teaches the basics of Power BI Desktop, step by step.

It helps to know some Excel, but you do not need any programming experience.

Get Started »



Free account

Track your progress

XP earned 0 Day streak 0 Spaces 0 League —

New

Learn in Adventure Mode W3Schools Adventure App

Coding fundamentals as bite-sized lessons and challenges.

×

Contact Sales

If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail:
sales@w3schools.com

Report Error

If you want to report an error, or if you want to make a suggestion, send us an e-mail:
help@w3schools.com

W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using W3Schools, you agree to have read and accepted our terms of use, cookies and privacy policy.

Copyright 1999-2026 by Refsnes Data. All Rights Reserved. W3Schools is Powered by W3.CSS.