What Power BI Is (and the BI Mindset)

Every Monday, Maria pulls sales numbers into a spreadsheet. She copies last week’s export from the ordering system, pastes it under a dozen worksheets, fixes the columns that shifted, rebuilds the same three charts, and emails a PDF to her regional managers. It takes most of the morning. By Tuesday the numbers are already stale, and when her boss asks “how did the Northeast do versus last quarter?” she has to go build a whole new version by hand.

Maria is doing real work. She is also doing it the hard way. Power BI exists to take that Monday morning and turn it into a report that updates itself, that anyone on her team can open on their phone, and that answers new questions with a click instead of a rebuild.

Why this matters

You do not need to love numbers to need this skill. If your job involves tracking anything over time (sales, tickets, patients, donations, inventory, hours), someone eventually asks you to explain what the numbers mean. Most people answer that question with spreadsheets they rebuild by hand, which is slow and easy to get wrong.

Power BI is Microsoft’s tool for turning raw data into interactive reports and dashboards that people use to make decisions. Learning it changes how you work. Instead of being the person who assembles the report, you become the person who set up the report once and now answers questions in seconds. That is a genuinely valuable position to hold on any team.

This chapter is the orientation. You will learn what Power BI is, its three parts, how it relates to Excel, the five-step flow behind every report, and how to install the free app and find your way around it. Later chapters go deep on each step.

What Power BI actually does

Start with two plain-language terms.

Business intelligence, usually shortened to BI, is the practice of turning raw data into information people can act on. That is the whole game. Raw data is a pile of rows nobody can read. BI is what makes it a story a manager can use.

A visualization, or visual, is any chart, map, table, or single number tile that shows data in a form your eye can read quickly. A bar chart of sales by region is a visual. A big number that says “$1.2M this month” is a visual.

Power BI takes data from wherever it lives, lets you clean and organize it, and lets you build visuals on top of it. The result is a report: an interactive page (or set of pages) of visuals that people can filter, sort, and explore on their own. When Maria’s manager clicks “Northeast” on a Power BI report, every chart on the page instantly updates to show only the Northeast. She did not build a new version. The report just responds.

The word interactive is the heart of it. A PDF is frozen. A Power BI report is alive: people poke at it and it answers.

The three pieces: Desktop, Service, and Mobile

Power BI is not one program. It is three parts that work together, and knowing which is which saves a lot of early confusion.

Power BI Desktop is where you build. It is a free application that you install on a Windows computer. You connect to your data, clean it, design your visuals, and lay out your report here. Think of Desktop as the workshop.

The Power BI Service is where you share. It is the online version that runs in a web browser at app.powerbi.com. When your report is ready, you publish it from Desktop to the Service, and now your teammates can open it online. The Service is also where you set data to refresh on a schedule and where you assemble dashboards. Think of the Service as the gallery where finished work goes on the wall.

Power BI Mobile is where people view on the go. It is a free app for iPhone, iPad, and Android that lets your audience open the reports and dashboards you published, right on their phone. Think of Mobile as the pocket view. You build in Desktop, publish to the Service, and your team reads it in Mobile.

A note on cost, because it comes up immediately. Power BI Desktop is free to download and use. To publish and share reports broadly, you or your organization generally need a paid license. Power BI Pro runs about $14 per user per month, and Power BI Premium Per User runs about $24 per user per month, as of the check date below. Many people can view content for free if their organization already pays for the right capacity. You can learn the whole tool for $0 in Desktop before anyone spends anything.

One more practical point. Power BI Desktop runs on Windows only. If you use a Mac, you can run it inside a Windows virtual machine or use the Power BI Service in your browser for lighter work. Keep that in mind before you go to install it.

Where Power BI fits next to Excel

Almost everyone comes to Power BI from Excel, so it helps to be honest about how they differ.

Excel is a grid. You type values into cells, write formulas, and the sheet is both your data and your presentation. That is wonderful for a quick calculation or a one-off analysis, and Excel is not going anywhere.

Excel starts to strain when the same report has to be produced again and again, when the data gets large, or when several people need to explore it without breaking your formulas. That Monday morning of Maria’s is Excel being asked to do a job it was never built for.

Power BI separates the pieces that Excel jams together. Your data connection, your cleanup steps, your table relationships, and your visuals are each their own layer. Refresh the data and every visual updates on its own. Nobody edits a cell by accident, because your audience is looking at a report, not a spreadsheet.

A simple rule of thumb. Reach for Excel for a quick, personal calculation. Reach for Power BI when a report needs to be repeatable, shared, refreshed, or explored by other people. The two also cooperate: Excel files are one of the most common data sources Power BI connects to.

The five-step flow (your map for the whole track)

Every Power BI report you will ever build follows the same five steps. Memorize this flow and the rest of the course is just detail on each stage.

   Connect   ->   Transform   ->   Model   ->   Visualize   ->   Share
     |               |              |             |               |
  Get data       Power Query   relationships   charts &        publish to
  from Excel,     clean &       between         tables on       the Service,
  databases,      reshape       your tables     the canvas      view on Mobile
  the web...

Connect means pointing Power BI at your data. You do this with the Get data button. Your data might be an Excel file, a database, a website, or an online service.

Transform means cleaning and reshaping the data before you use it. Real data is messy: extra columns, text where you need numbers, blank rows. You do this cleanup in a built-in tool called Power Query Editor, and the best part is that Power Query records every step. Next week’s data goes through the exact same cleanup automatically.

Model means connecting your tables to each other. If you have one table of orders and another of customers, you tell Power BI how they relate (each order belongs to one customer). That web of connections is your data model, and it is what lets a single click filter every visual at once.

Visualize means building the charts, maps, tables, and number tiles that make up your report, then arranging them on the page.

Share means publishing the finished report to the Service so your team can open it, on the web or in the Mobile app.

Connect, transform, model, visualize, share. That is the spine of this entire track.

Getting Power BI Desktop and a tour of the interface

Time to open the workshop. Power BI Desktop is free. Install it from the Microsoft Store (search for “Power BI Desktop”), which keeps it updated automatically, or download it from Microsoft’s Download Center. Microsoft ships an update roughly every month, so expect the app to refresh itself often.

When you open Power BI Desktop, close the welcome screen and you land on a blank canvas. Here is what you are looking at.

The ribbon runs across the top, the same style of toolbar you know from Word and Excel. Its tabs group related tools. The Home tab holds the commands you use most, including Get data. Other tabs like Insert, Modeling, and View hold more specialized tools you will meet later.

Down the left edge are three small icons that switch between the three views of your work. This is worth learning on day one.

Report view is the big blank canvas where you build visuals and lay out report pages. This is where you spend most of your time.

Data view (sometimes called Table view) shows your actual rows and columns, like a spreadsheet, so you can inspect what really loaded.

Model view shows your tables as boxes with lines drawn between them, so you can see and manage the relationships in your data model.

On the right side are the panes that do the building.

The Data pane (older versions and many tutorials still call it the Fields pane) lists every table and field you have loaded. You drag items from here onto the canvas to build visuals.

The Visualizations pane is where you pick a chart type and decide which field goes on the axis, which becomes the value, and which becomes the color.

The Filters pane lets you narrow what a visual, a page, or the whole report shows, for example only this year, or only one region.

That is the entire layout: a ribbon on top, three view icons on the left, and three working panes on the right. Everything else is detail.

Try It Build your first report from a real dataset in about ten minutes.

Install Power BI Desktop (free) from the Microsoft Store.

Download Microsoft’s free practice file, the Financial Sample Excel workbook, from the official quickstart page: https://learn.microsoft.com/power-bi/connect-data/desktop-quickstart-connect-to-data. Save it somewhere you can find it.

Open Power BI Desktop and close the welcome screen.

On the Home ribbon, select Get data, choose Excel workbook, find the Financial Sample file, and select Open.

In the Navigator window that appears, check the box next to the table named financials, then select Load.

Look at the Data pane on the right. You should see the financials table with fields like Country, Product, Sales, and Profit.

From the Data pane, drag Country onto the blank canvas, then drag Sales on top of the same visual. Power BI builds a bar chart of sales by country automatically.

Click the three view icons on the left edge one at a time. Watch the screen change between Report, Data, and Model views.

What did you notice? You just did the first four steps of the flow (connect, and a bit of model and visualize) without writing a single formula.

In business

Picture a regional coffee chain with eleven locations. Each store sends its daily sales through the point-of-sale system, and the operations manager wants one place to see how the business is doing.

In Power BI, that manager connects to the sales data once, cleans it in Power Query so store names and dates are consistent, and models it against a small table of store details (city, square footage, opening date). Then she builds a report: total revenue up top, a map of stores colored by sales, a line showing the trend over the last twelve weeks, and a table of the bottom five products by margin.

She publishes it to the Service. Now the owner opens it on his phone during his morning drive and sees last night’s numbers. A district lead clicks her three stores and every visual reshapes to just her territory. When a new question comes up (“are pastries selling better since the price change?”), the answer is a filter, not a fresh spreadsheet. The report that took an afternoon to build saves that afternoon every week after.

That is the BI mindset. You stop producing reports by hand and start building a living system that produces answers.

Common pitfalls

Thinking a report and a dashboard are the same thing. In Power BI they are different. A report is one or more full pages of visuals, built in Desktop, and it is interactive. A dashboard is a single-page summary you assemble in the Service by pinning individual visuals from one or more reports. You cannot build a dashboard in Desktop, only in the Service. Beginners mix these words up constantly, so pin the distinction now.

Skipping the transform step. It is tempting to load messy data and start making charts. Ten minutes of cleanup in Power Query saves you hours of confusing, wrong-looking visuals later. The cleanup also repeats itself automatically on every refresh, so it pays for itself again and again.

Treating Power BI like a fancier Excel. If you try to type values directly into visuals or edit numbers by hand, you are fighting the tool. Power BI works on a model that refreshes from a source. Change the source, refresh, and the report follows. Let it.

Waiting until you feel “ready” to install it. You learn this by clicking, not by reading. The app is free and so is the practice data. The best predictor of whether someone picks up Power BI is whether they opened it in the first week.

Practice

Do the Try It above if you have not yet, then extend it. In your Financial Sample report, drag the field Segment onto a blank part of the canvas, then add Profit to it, to build a second chart showing profit by customer segment. Now click a single bar in your first chart (a single country) and watch what happens to the second chart.

Write one sentence describing what that click did. That single behavior, one selection reshaping every other visual on the page, is the thing that makes Power BI worth learning. In the next chapter you will connect to your own messy data and start cleaning it in Power Query.

Part of the Power BI track. Developed with AI assistance and reviewed by a human editor. Power BI changes often; menu names, features, and prices may have shifted since the “checked on” dates in this chapter. Verify anything critical against Microsoft’s official documentation.