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
- 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.
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.
- summit-sales-power-bi.xlsx · Summit Supply Co.: products, customers, sales reps, 4,430 order lines and monthly targets
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.
- Get data
- Transform
- Model
- Calculate with DAX
- 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
| Excel | Power BI | |
|---|---|---|
| Best for | Calculations, financial models, lists, one-off analysis | Recurring reports and dashboards, multiple data sources, sharing with many people |
| Data volume | Up to 1,048,576 rows per sheet (more with Power Pivot) | Millions of rows |
| Data cleanup | Power Query (the same engine) | Power Query |
| Calculations | Cell-by-cell formulas | DAX measures that recalculate for every filter |
| Sharing | You 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.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
- 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.
- 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.
- 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:
| View | What it's for |
|---|---|
| Report view | The canvas where you place charts, tables and slicers. It's what your end users see. |
| Table view | Browse the rows of each loaded table, like a read-only spreadsheet. |
| Model view | See tables as boxes and the relationships between them (Lesson 5). |
| DAX query view | Write queries to test calculations (advanced). |
| TMDL view | View 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?
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.
- Get data: on the Home ribbon, choose Get data › Excel workbook, pick the file, check the Sales table and click Load.
- A card with the total: in the Visualizations pane choose Card and drag Amount into its field. You'll see the grand total.
- 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.
- 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.
- A slicer: choose Slicer and drag Product into it. Click "Oil": every chart filters.
- Interaction: click the Atlanta bar and the other visuals show only Atlanta.
- Save your work. Power BI files use the
.pbixextension.
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?
Cross-filtering is one of Power BI's biggest advantages: you explore data by clicking, without writing formulas.
The Power BI workflow
- Get dataConnect to your sourcesExcel, CSV, databases, SharePoint, the web… It all starts at Home › Get data.
- Transform · Lesson 2Power QueryClean and shape: remove title rows, fix data types, unpivot months stored as columns.
- Model · Lesson 5Relationships between tablesA star schema: sales in the center, with products, customers, reps and dates around it.
- Calculate · Lessons 6, 7, 8 and 11DAX measuresSales, gross margin, year-over-year growth, rankings.
- Visualize · Lessons 3, 4 and 9Charts, filters and interactivityPages that answer business questions in seconds.
- 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?
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:
| Sheet | Rows | What it contains | Where you'll use it |
|---|---|---|---|
| Products | 12 | Product, category (3), brand, unit cost and list price | Lessons 5, 6 and 15 |
| Customers | 40 | Customer, city, state, region (Midwest, Northeast, South, West) and channel | Lessons 5, 11 and 15 |
| SalesReps | 4 | One rep per region, with an email address | Lessons 9 and 10 |
| Sales | 4,430 | One row per product on each order, from 1/1/2025 to 12/31/2026 | The whole course |
| Targets | 8 | Monthly sales target by rep and year, with months as columns | Lessons 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:
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:
- 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.
- 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.
- 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?
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
- Install Power BI Desktop.
- Create the sample Excel file and load it.
- Build a report with a total-amount card, sales by city, a monthly trend and a product slicer.
- 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.
Create your account in 30 seconds, mark your lessons and download your certificate at the end.