Skip to content

Power BI Tutorial for Beginners: From an Excel File to Your First Report in One Hour

Gulab Chand Tejwani

Gulab Chand Tejwani

PMP · PL-300 · Microsoft Certified Trainer

· 10 min read

Power BIPower BI TutorialBeginnersExcelData Analysis
Power BI Tutorial for Beginners: From an Excel File to Your First Report in One Hour

Power BI is Microsoft's tool for turning data into interactive reports. As a beginner you'll spend most of your time in Power BI Desktop, a free Windows app with three views (Report, Table and Model) and three main panes (Data/Fields, Visualizations and Filters). In one hour you can install it, load an Excel file, clean it in Power Query, build five visuals, write your first DAX measure and save a report you can explain. This tutorial does exactly that, one step at a time. Steps were re-checked against Microsoft's Power BI Desktop Get Data and Power Query documentation on 4 November 2026.

I'm Gulab Chand Tejwani, Microsoft Certified Trainer at TechNet Consultancy. I've taught Power BI to people who'd never written a formula, and the ones who stick with it all get past the same early confusion: what's a view, what's a pane, why did my numbers add up wrong. This tutorial is the first hour I'd spend with you in class.

What do you need to start?

  • A Windows PC. Power BI Desktop doesn't run natively on a Mac.
  • Power BI Desktop, free from the Microsoft Store or Microsoft's download page. The Store version updates itself every month.
  • An Excel file. Use your own, or Microsoft's free Financial Sample: in Power BI Desktop choose Use sample data.

You don't need a licence to build reports on your own machine. You only need one to publish and share them, which comes later.

What are the views and panes in Power BI Desktop?

Power BI Desktop interface: Report, Table and Model views on the left; Filters, Visualizations and Data panes on the right; canvas in the middle
The parts of Power BI Desktop you'll use in the first hour.

Down the left side are three views:

  • Report view is the canvas where you build visuals.
  • Table view shows the data in each table, like a spreadsheet you can't type into.
  • Model view shows tables as boxes and the relationships between them.

On the right are three panes:

  • Data (also called Fields) lists your tables, columns and measures.
  • Visualizations is where you pick a chart type and drop fields into its wells (axis, values, legend).
  • Filters applies filters to one visual, one page or every page.

Step 1: How do you load an Excel file?

Power BI Desktop now has two Get Data experiences (Microsoft Learn, checked 4 November 2026): the newer Get data (Power Query) pane, and the legacy Get Data dialog with category folders. Either path works for Excel.

  1. On the Home ribbon, open Get data. Choose Excel workbook from Common data sources, or open More / the Get Data dialog and pick Excel workbook under File.
  2. Choose your file. The Navigator shows each sheet and table. Tick the checkbox next to the one you need (clicking the name alone only previews it; Transform data stays disabled until the box is checked).
  3. Select Transform data (sometimes labelled Transform Data), not Load. This opens Power Query so you can check the data first.

If your Excel data is formatted as an Excel table (Ctrl+T), pick the table rather than the sheet. Tables keep their headers and don't pick up stray cells.

If you do not have a file of your own, download Microsoft's Financial Sample workbook, then use Home → Excel workbook, open the downloaded file, tick the checkbox next to the financials table in Navigator, and choose Transform data. That path opens Power Query the same way as your own file (the built-in "Use sample data" shortcut loads straight to the model and skips this cleaning step).

Step 2: How do you clean the data in Power Query?

Power Query records every step you take and replays them on each refresh, so you clean once and reuse it.

For a first pass, check five things:

  1. Headers. Are column names in the first row? If not, use Use first row as headers. Look for odd spaces too: Microsoft's sample has a column called " Sales" with a leading space. Rename it.
  2. Data types. Each column shows an icon (123, ABC, a calendar). Make dates dates and money decimal numbers.
  3. Blank rows and totals rows. Remove them. A "Total" row inside the data doubles your sums.
  4. Columns you don't need. Remove them now. A smaller model is a faster model.
  5. Errors. On the Power Query View tab, in Data preview, turn on Column quality to see the share of valid, error and empty values in each column (Microsoft's data-profiling docs, checked 4 November 2026).

Then select Close & Apply. For more on this stage, see Power Query data cleaning steps.

Step 3: How do you make your first visuals?

Go to Report view and try these five, in this order:

  1. Card: select the card icon in Visualizations, then tick Sales in the Data pane. One big number.
  2. Clustered bar chart: Segment on the Y-axis, Sales on the X-axis. Then sort it by Sales, descending (the "..." menu on the visual).
  3. Line chart: Date on the X-axis, Sales on the Y-axis. Power BI builds a Year > Quarter > Month hierarchy automatically; use the drill arrows to move between levels.
  4. Table: Country and Sales. Tables are underrated for exact numbers.
  5. Slicer: Product. Click a product and watch every other visual filter. That's cross-filtering, and it's what makes Power BI more than a chart tool.
QuestionVisualTip
What's the total?CardOne number, clearly labelled
Which category is biggest?Bar chartSort descending
How is it changing over time?Line chartDate on the axis, not a category
What are the exact values?Table or matrixKeep columns few
Let the reader chooseSlicerPut slicers in one place
Which visual answers which question

Step 4: What's a measure, and how do you write your first one?

When you drag Sales onto a visual, Power BI quietly sums it. That's an implicit measure, and it works until you need anything more. A measure written in DAX is explicit, reusable and named:

Total Sales = SUM ( financials[Sales] )

Total Profit = SUM ( financials[Profit] )

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

Create each with Home > New measure, then use them in your visuals instead of the raw columns. DIVIDE handles division by zero safely, and Profit Margin % now works correctly for any filter, which a column-level percentage can't do.

Check one number against Excel: total Sales in the Financial Sample should come to about 118.7 million. If yours matches, your model is right.

One-hour plan: 10 minutes install and load, 15 minutes Power Query cleaning, 20 minutes visuals, 10 minutes measures, 5 minutes save and review
Where the first hour goes.

Step 5: How do you save and share it?

Save the file (it's a .pbix). You can send the file to someone who has Power BI Desktop, but the proper way to share is to Publish to the Power BI service, which needs a Pro or Premium Per User licence. A Premium capacity or a Fabric capacity of F64 or larger lets people with free licences view what you publish, but you still need Pro or PPU to publish it. The Power BI service guide explains workspaces, apps and refresh.

What mistakes do beginners make?

  • Skipping Power Query. Cleaning inside visuals with filters works once, then breaks next month.
  • Dragging raw columns everywhere. Write measures instead.
  • Using pie charts for everything. A sorted bar chart is easier to read for more than three or four categories.
  • One giant table. It works for a first report, but split it into a star schema as soon as you have more than one source.
  • Not checking a total. Always compare one number with the source.

Quick check

Question 1Power BI · Basics

Where do you see the relationships between your tables?

  1. AReport view
  2. BModel view
  3. CTable view
  4. DThe Filters pane
Show answer and explanation

Correct answer: B

Model view shows each table as a box and the relationships as lines between them. Table view shows the rows inside one table.

Question 2Power BI · Power Query

Your Excel sheet has a 'Total' row at the bottom, and every sum in Power BI is exactly double what you expect. What's the right fix?

  1. ADivide every measure by 2
  2. BAdd a visual-level filter
  3. CDelete the row in Excel each month by hand
  4. DRemove the total row in Power Query so it's removed on every refresh
Show answer and explanation

Correct answer: D

Power Query repeats its steps on every refresh, so the row is removed automatically each time. Visual filters and manual edits don't scale.

What should you learn after this first hour?

Build a full one-page dashboard next: the step-by-step dashboard guide adds a date table, time intelligence and layout. Then learn the DAX functions you'll use most in DAX functions in Power BI. If you're comparing with what you already know, Power BI vs Excel explains where each fits.

If you want a guided path from here, the Power BI Mastery course takes you through 14 modules and 83 text lessons in the order real BI work happens, with datasets, hands-on labs with step-by-step solutions, 966 quiz questions, 568 flashcards and 8 PL-300 practice exams, for ₹1,999 personal access.

FAQ

Is Power BI free?

Power BI Desktop is free for building reports on your own computer. Publishing and sharing reports through the Power BI service needs a Pro or Premium Per User licence. On a Premium capacity or a Fabric capacity of F64 or larger, viewers can use free licences, but the publisher still needs Pro or PPU.

Can I learn Power BI without knowing Excel?

Yes, but basic Excel comfort helps: tables, filters, SUM and pivot tables. If you know those, Power BI concepts will feel familiar.

How long does it take to learn Power BI?

You can build a simple report in an hour. Being job-ready, with solid Power Query, modelling and DAX, usually takes a few weeks to a few months of regular practice. Is Power BI easy to learn? covers coding, DAX and SQL in more depth.

Does Power BI work on a Mac?

Power BI Desktop is a Windows application. Mac users typically run it in a Windows virtual machine or use the Power BI service in a browser, which has more limited editing.

What should a beginner learn first in Power BI?

Loading and cleaning data in Power Query, then basic visuals, then measures in DAX, then relationships and a star schema.

Choose optional cookies

We use necessary cookies for account security. With your permission, we also use analytics and advertising cookies on marketing pages. See our Privacy Policy.