Power BI for Beginners: Your First Report in 1 Hour

The fastest way to learn Power BI is to build a small, complete report: data in, a few numbers calculated, a page that answers a question, and a published result. This walkthrough does that in about an hour with Microsoft's free Financial Sample, a workbook of sales and profit by segment and country (Microsoft Learn: Financial Sample). The times are guides; the order matters more. If you have your own spreadsheet of sales, you can follow the same steps with it after trying the sample once.

The report will answer one question: how much do we sell and earn, and which countries are most profitable?

Minutes 0 to 5: install and open

Download Power BI Desktop, which is free (Microsoft: Power BI pricing), and open it. Desktop is where you import data, shape it with Power Query, build visuals and publish reports (Microsoft Learn: get started with Desktop). Along the left edge are the views, including Report, for building pages; Table, for looking at data; and Model, for relationships.

Minutes 5 to 15: load and check the data

Load the sample either from Use sample data on the start screen, choosing the Financials table, or by downloading the workbook and choosing Get data, Excel workbook. Select Transform data rather than Load, to look before you trust:

• Column names. In the downloaded workbook, the Sales column's name starts with a space. Rename it to "Sales" so formulas can find it.
• Data types. Sales, Profit and other amounts should be decimal numbers; Date should be a date.
• Coverage. The data runs from September 2013 to December 2014, so 2013 is only a partial year.

Select Close & Apply to load the data.

Minutes 15 to 25: write three measures

In Report view, select the table in the Data pane, then New measure, and create:

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

Format Margin % as a percentage. Measures are better than dragging columns into visuals, because the margin must be calculated from totals, not averaged row by row; the DAX guide explains why that matters.

Minutes 25 to 45: build the page

1. Three cards across the top for Total Sales, Total Profit and Margin %.
2. A line chart of Total Sales by month, using the Date field. Bear in mind that the sample has more rows in some months than others, so the line shows the sample's structure as much as any seasonality.
3. A bar chart of Total Sales by Country, sorted from largest to smallest, with Margin % added to the tooltips.
4. A slicer for Segment, placed in a top corner.
5. Titles on every visual that say what they show, such as "Sales by country".

Keep the most important numbers top left, and avoid decorating the page; Power BI dashboard design explains the reasoning.

Minutes 45 to 55: check the numbers

Beginners often skip this step, and it is the most important one. Here is what the page should show with no slicer selection, calculated independently from the same workbook:

import io
import urllib.request
import pandas as pd

url = "https://go.microsoft.com/fwlink/?LinkID=521962"
finance = pd.read_excel(io.BytesIO(urllib.request.urlopen(url).read()), keep_default_na=False)
finance.columns = finance.columns.str.strip()
sales, profit = finance["Sales"].sum(), finance["Profit"].sum()
print(f"Sales {sales / 1e6:.2f}m | Profit {profit / 1e6:.2f}m | Margin {profit / sales:.1%}")
by_country = finance.groupby("Country")[["Sales", "Profit"]].sum()
by_country["Margin"] = (by_country["Profit"] / by_country["Sales"]).map("{:.1%}".format)
by_country[["Sales", "Profit"]] = (by_country[["Sales", "Profit"]] / 1e6).round(2)
print(by_country.sort_values("Sales", ascending=False).to_string())

Sales 118.73m | Profit 16.89m | Margin 14.2%
                          Sales  Profit Margin
Country                                       
United States of America  25.03    3.00  12.0%
Canada                    24.89    3.53  14.2%
France                    24.35    3.78  15.5%
Germany                   23.51    3.68  15.7%
Mexico                    20.95    2.91  13.9%

If your cards show 118.73 million sales, 16.89 million profit and a 14.2% margin, the measures are right. The country chart also answers the question the page was built for: the United States sells the most but has the lowest margin, 12.0%, while Germany and France earn the most on each unit of sales. That kind of contrast, volume against profitability, is exactly what a first report should surface.

Minutes 55 to 60: save and publish

Save the file with File, Save. To share it, select Publish on the Home ribbon, sign in, and choose a workspace. Publishing sends the data model and the report to the Power BI service; later edits made in the service are not saved back to your Desktop file (Microsoft Learn: publish from Desktop), so keep editing in Desktop and republish. Sharing with colleagues generally needs a Pro or Premium Per User licence, or a workspace on Premium capacity.

Common first-report mistakes

• Loading without looking. Skipping Transform data means type and naming problems surface later, inside visuals.
• Averaging percentages. Dragging a margin column into a visual and choosing Average gives a different, wrong number from the Margin % measure.
• Too many visuals. A first page with ten charts answers no question well; four is plenty.
• Default titles. Titles such as "Sum of Sales by Country" read like software output; write them for people.
• Publishing without checking. Once a report is shared, a wrong number is quoted in meetings before anyone notices.

What you learned, and what comes next

In an hour you have checked data before loading it, written measures instead of relying on automatic sums, built a page around a question, checked the numbers, and published. Every larger report repeats those steps. The next skills are a proper data model with separate tables, which star schema in Power BI covers, and better headline numbers, covered in KPIs and cards. For a structured path, learning Power BI in 30 days sets out a day-by-day plan.

Power BI installation, the interface, data import and first reports are covered in the introductory modules of the Power BI course.

Sources

• Get started with Power BI Desktop (Microsoft Learn) — Microsoft Learn
• Download the Financial Sample Excel workbook for Power BI (Microsoft Learn) — Microsoft Learn
• Power BI pricing (Microsoft) — Microsoft
• Publish from Power BI Desktop (Microsoft Learn) — Microsoft Learn