Lesson 1 of 16 · Level 1: Beginner

What Is Power BI? What It's Used For and Your First Report

  • ⏱ 14 min read
  • ❓ 4 review questions
  • ✍️ Exercise with solution
  • 📥 Downloadable template
In this lesson
  1. What Power BI is used for
  2. Power BI vs. Excel
  3. The pieces of Power BI
  4. Installing Power BI Desktop
  5. The views in Power BI Desktop
  6. Your first report in 15 minutes
  7. The Power BI workflow
  8. Meet the course data: Summit Supply Co.
  9. Common beginner mistakes
  10. Summary
What you'll learn
  • What Power BI is, what it's used for and when to choose it over Excel.
  • The pieces of the platform: Power BI Desktop, the Power BI service and the mobile apps.
  • How to install Power BI Desktop and find your way around its views.
  • How to build your first interactive report in about 15 minutes.
  • The Summit Supply Co. dataset you'll use for the rest of the course.
📥 Course dataset

Download it now: it's the database you'll use in every lesson and in the final project. For your first report you can load just the Sales sheet.

Power BI is Microsoft's tool for turning raw data into interactive reports and dashboards. It connects to Excel files, databases, accounting systems and cloud apps, cleans and relates that data, and displays it in charts anyone can filter with a click. It shows up constantly in U.S. job postings for data, financial and business intelligence analysts, and if you already work in Excel, it's one of the best skills you can add to your résumé.

Throughout this course you'll build the sales dashboard for Summit Supply Co., a fictional distributor selling groceries, dairy and beverages to stores in 11 U.S. cities. You'll finish with a professional, published report powered by advanced DAX.

4,430order lines (2,205 orders) from 2025 and 2026 in the practice file
5related tables: products, customers, sales reps, sales and targets
$515,969in sales you'll learn to slice, compare and explain
  1. Get data
  2. Transform
  3. Model
  4. Calculate with DAX
  5. Visualize and publish

What Power BI is used for

  • Reports that refresh themselves: build once, then click Refresh (or schedule it) and every number recalculates.
  • Combining sources: sales from your ERP, targets from Excel, customers from your CRM, all connected.
  • Millions of rows without a sluggish file, thanks to its compression engine.
  • Interactivity: click a region and every chart on the page filters to it.
  • Secure sharing: publish once and each person sees only what they're allowed to, in a browser, in Teams or on a phone.

Power BI vs. Excel

ExcelPower BI
Best forCalculations, financial models, lists, one-off analysisRecurring reports and dashboards, multiple data sources, sharing with many people
Data volumeUp to 1,048,576 rows per sheet (more with Power Pivot)Millions of rows
Data cleanupPower Query (the same engine)Power Query
CalculationsCell-by-cell formulasDAX measures that recalculate for every filter
SharingYou email the file (and its many versions)You publish one version with permissions

They aren't competitors; they complement each other. Many analysts prep data or run quick checks in Excel and build recurring reports in Power BI. If you'd like to sharpen your spreadsheet skills first, the lesson on Excel and Google Sheets for data analysis in our free Data Analytics course is a great warm-up.

The pieces of Power BI

Power BI Desktop

A free Windows application.

What you use it for: connecting to data, transforming it, modeling it and designing reports. You'll spend most of the course here.

Power BI service

The web platform at app.powerbi.com.

What you use it for: publishing, sharing, scheduling refreshes, and building dashboards and apps.

Mobile apps

For iOS and Android.

What you use them for: checking reports on the go, using the mobile layout you'll design in Lesson 4.
On a Mac?

Power BI Desktop only runs on Windows. On a Mac, use a Windows virtual machine, a cloud PC or a remote desktop, or build basic reports in the Power BI service in your browser. Windows is the most comfortable way to follow the course.

Installing Power BI Desktop

  1. Open the Microsoft Store on Windows and search for "Power BI Desktop". This is the recommended option because it updates itself every month. You can also download the installer from the official Power BI website.
  2. Install it and open it. You don't need an account to work in Desktop; a work or school account is only required to publish.
  3. Check the language and locale under File › Options and settings › Options › Regional Settings. This course uses the English interface with U.S. formats (MM/DD/YYYY dates, a period as the decimal separator).

The views in Power BI Desktop

The icons on the left edge switch between views:

ViewWhat it's for
Report viewThe canvas where you place charts, tables and slicers. It's what your end users see.
Table viewBrowse the rows of each loaded table, like a read-only spreadsheet.
Model viewSee tables as boxes and the relationships between them (Lesson 5).
DAX query viewWrite queries to test calculations (advanced).
TMDL viewView and edit the model definition as text, handy for copying measures between files (advanced).

In Report view, the key panes sit on the right: Visualizations (chart types and their formatting), Data (your tables and columns) and Filters.

Desktop gets a new version every month and buttons sometimes move. If a menu isn't where we say, use the search box at the top of the window.

1. Where are Power BI reports usually built?

  • In the mobile apps.
  • In Power BI Desktop, and then published to the Power BI service.
  • Only in Excel.

Desktop is the authoring tool; the web service is where you publish, share and schedule refreshes.

Your first report in 15 minutes

In Excel, create a file called sales_demo.xlsx with a table named Sales and about 20 made-up rows in these columns: Date, City (Chicago, Atlanta, Denver), Product (Rice, Oil, Sugar, Pasta), Quantity and Amount.

  1. Get data: on the Home ribbon, choose Get data › Excel workbook, pick the file, check the Sales table and click Load.
  2. A card with the total: in the Visualizations pane choose Card and drag Amount into its field. You'll see the grand total.
  3. A bar chart: click an empty spot on the canvas, choose Clustered bar chart, drag City to the Y-axis and Amount to the X-axis.
  4. A line chart: put Date on the X-axis and Amount on the Y-axis. Power BI groups dates into year, quarter, month and day; use the arrows on the chart to drill up or down.
  5. A slicer: choose Slicer and drag Product into it. Click "Oil": every chart filters.
  6. Interaction: click the Atlanta bar and the other visuals show only Atlanta.
  7. Save your work. Power BI files use the .pbix extension.
Power BI sums automatically, so keep an eye on it

When you drag a numeric column into a visual, Power BI summarizes it automatically, usually with Sum. That's right for Amount, but wrong for columns like Year or ZIP code. In Lesson 6 you'll create explicit measures, the professional way to calculate.

2. You click the "Chicago" bar in one chart and the other charts change. What's happening?

  • The report has a bug.
  • The data for the other cities was deleted.
  • Visual interactions: the click filters or highlights the rest of the page.

Cross-filtering is one of Power BI's biggest advantages: you explore data by clicking, without writing formulas.

The Power BI workflow

  1. Get dataConnect to your sourcesExcel, CSV, databases, SharePoint, the web… It all starts at Home › Get data.
  2. Transform · Lesson 2Power QueryClean and shape: remove title rows, fix data types, unpivot months stored as columns.
  3. Model · Lesson 5Relationships between tablesA star schema: sales in the center, with products, customers, reps and dates around it.
  4. Calculate · Lessons 6, 7, 8 and 11DAX measuresSales, gross margin, year-over-year growth, rankings.
  5. Visualize · Lessons 3, 4 and 9Charts, filters and interactivityPages that answer business questions in seconds.
  6. Publish · Lesson 10Share in the Power BI serviceAutomatic refresh, permissions and security so each person sees only their own data.

This is the order of the course. Most report problems (numbers that don't tie out, slow visuals) start in steps 2 and 3.

3. When does Power BI make more sense than Excel?

  • For a monthly sales report that combines ERP data with targets and is viewed by 20 people.
  • For calculating a loan payment once.
  • For making a party guest list.

Recurring reports, multiple sources and many viewers are the sweet spot for Power BI.

Meet the course data: Summit Supply Co.

The file summit-sales-power-bi.xlsx mimics an export from a U.S. distributor's order system. Summit sells pantry staples, dairy and beverages to 40 customers in 11 cities, from Chicago and New York to Denver and Atlanta. The data is fictional, but it deliberately includes real-world data problems so you can practice fixing them:

SheetRowsWhat it containsWhere you'll use it
Products12Product, category (3), brand, unit cost and list priceLessons 5, 6 and 15
Customers40Customer, city, state, region (Midwest, Northeast, South, West) and channelLessons 5, 11 and 15
SalesReps4One rep per region, with an email addressLessons 9 and 10
Sales4,430One row per product on each order, from 1/1/2025 to 12/31/2026The whole course
Targets8Monthly sales target by rep and year, with months as columnsLessons 2 and 12

One important detail: the Sales sheet has no amount column, only Quantity and UnitPrice. You'll calculate revenue with DAX in Lesson 6 and discover insights like this one:

Share of sales by category (2025–2026)

Dairy39.5%
Pantry30.8%
Beverages29.6%

Dairy brings in $203,742; pantry, $158,945; and beverages, $152,775. The missing 0.1% ($508) comes from three sales with a product code that doesn't exist, an error you'll learn to track down in Lesson 5.

A first look at the real file

Before the exercise, try Power BI with the course data. Load only the Sales sheet and create:

  1. A card with Quantity: it should show 75,923 units (the sum of all 4,430 rows). If you see that number, the data loaded correctly.
  2. A card with OrderID. Because it's text, Power BI counts it. In the field's drop-down menu, switch Count to Count (Distinct): the card drops from 4,430 to 2,205 orders, because each order has about two products on average.
  3. A bar chart with RepID on the axis and Quantity as the value: R1 sold 19,792 units; R2, 19,266; R4, 19,195; and R3, 17,670.

That gap between rows and orders is your first analytics lesson: before counting, ask what one row represents.

4. A card shows 4,430 when you count OrderID, but the order system says there were 2,205 orders. What's going on?

  • Power BI duplicated the data while loading it.
  • Each row is one product on an order; to count orders you need Count (Distinct).
  • Canceled orders are being counted twice.

The Sales table has one row per order line: 4,430 lines that belong to 2,205 distinct orders. Counting rows isn't the same as counting orders.

Common beginner mistakes

Opening Power BI and dragging charts onto the canvas without knowing what question they answer.

Write down 3 to 5 questions your users ask first; every visual should answer one (Lesson 4).

Clicking Load without checking the data.

Click Transform data and review types, headers and totals in Power Query (Lesson 2).

Letting Power BI add up columns like Year, ZIP code or phone number.

Set them to "Don't summarize" and create explicit measures for real numbers (Lesson 6).

Cramming everything into one giant table, Excel style.

Separate facts from dimensions and relate them in a star schema (Lesson 5).

Keeping the only copy of your .pbix file on your desktop.

Save it to OneDrive or SharePoint so you have version history.

Practice exercise: your first report

  1. Install Power BI Desktop.
  2. Create the sample Excel file and load it.
  3. Build a report with a total-amount card, sales by city, a monthly trend and a product slicer.
  4. Answer with clicks: which product sells best in Denver? Which month was best for Oil?
See solution
  • The card says "Count of Amount": the column loaded as text. Make sure the amounts are plain numbers and reload (or fix the type in Power Query, Lesson 2).
  • The line chart shows a single point: Date loaded as text. Change its type to Date.
  • Best product in Denver: add a bar chart of Amount by Product, then click the Denver bar in the city chart. The longest product bar is your answer.
  • Best month for Oil: click "Oil" in the slicer and read the highest point of the line chart, drilled down to month level.

Summary

  • Power BI turns data from many sources into interactive reports that refresh and can be shared securely.
  • Power BI Desktop (free, Windows) is for building; the Power BI service is for publishing and sharing.
  • Report, Table and Model views organize your work.
  • The workflow is: get data, transform, model, calculate, visualize and publish.
  • Before counting anything, ask what one row represents: 4,430 order lines are only 2,205 orders.

Next lesson: Power Query in Power BI: How to Clean and Transform Data. You'll learn to get and clean data, the step that decides whether anyone can trust your report.

🎓 Save your progress and get a free certificate

Create your account in 30 seconds, mark your lessons and download your certificate at the end.

Enroll for free