Power BI Tutorial
Learn Power BI
Power BI is a Microsoft tool that turns data into interactive reports.
You connect to data, such as an Excel file, build charts and tables, and share the report with others. Readers can click and filter the report to explore the data themselves.
What You Will Learn
This tutorial takes you from a spreadsheet to an interactive report.
You will learn:
- What Power BI is, and how Power BI Desktop, the Power BI service and the mobile apps work together
- How to install Power BI Desktop and find your way around it
- The Power BI workflow: get data, transform it, model it, visualize it, and publish it
- How to build your first report from an Excel file, step by step
Later chapters cover cleaning data with Power Query, building a data model with relationships and DAX, and publishing and sharing reports in the Power BI service.
Learn with Poke Mart Data
All the examples use sales data from the Poke Mart, the Pokemon shop from our Excel tutorial.
You download one Excel file and build a real report from it, one step at a time.
The tutorial uses Power BI Desktop, which is free and runs on Windows.
The online Power BI service is used only for publishing and sharing.
Why Learn Power BI?
Power BI lets you build reports that other people can explore on their own, and keep them up to date when the data changes.
Example use areas:
- Sales and finance reporting
- Business dashboards and KPIs
- Data analysis across many data sources
If you already know some Excel, you have a head start.