Power BI Fundamentals

The CFO who stopped asking for reports

A mid-size manufacturing company had a problem every data team knows: the CFO needed a weekly revenue report. Every Monday morning, an analyst spent 3 hours pulling data from SAP, cleaning it in Excel, building charts, and emailing a PDF. By Wednesday, the CFO would reply with follow-up questions. By Thursday, the analyst would deliver an updated report. By Friday, the numbers were stale.

Then the analyst built a Power BI dashboard. It connected directly to the company's database, refreshed automatically every morning, and let the CFO filter by region, product line, and time period — himself. No more Monday morning reports. No more back-and-forth emails. No more stale data.

The CFO went from asking "Can you send me the numbers?" to opening his browser and finding the answer in 10 seconds. The analyst went from report monkey to strategic partner, spending those 3 hours per week on actual analysis instead of data plumbing.

That's Power BI. Not a chart tool — a self-service analytics platform.

What Power BI actually is

Power BI is Microsoft's business intelligence platform. It lets you connect to data sources, transform and model data, create interactive visualizations, and share dashboards with your organization.

The Power BI ecosystem

There Are No Dumb Questions

"Is Power BI free?"

Power BI Desktop is free to download and use. You can build complete dashboards without spending a cent. To share dashboards with others online, you need Power BI Pro ($10/user/month) or a Premium capacity. Many companies already have this through their Microsoft 365 license.

"Should I learn Power BI or Tableau?"

If your company uses Microsoft products (Excel, Teams, SharePoint, Azure), Power BI is the natural choice — it integrates natively. If you're freelancing or at a startup, either works. Power BI has a larger installed base. Tableau has a stronger visualization pedigree. Both are listed interchangeably on job postings.

Connecting to data

Power BI can connect to almost anything. This is its superpower — one dashboard pulling from multiple sources.

Common data sources

Power Query: clean data before it hits your report

Power Query is Power BI's data transformation engine. Think of it as a visual pipeline where each step transforms the data — remove columns, filter rows, merge tables, change types, split text.

Every step is recorded. When new data arrives, Power Query replays all your steps automatically. No more manual cleaning.

Building visualizations

Power BI's visualization canvas works by drag and drop. Select a visual type, drag fields into it, and it renders instantly.

The most useful visuals

Slicers: make it interactive

Slicers are dropdown filters, date ranges, or button groups that let users filter the entire report page. Add a slicer for "Region" and clicking "East" filters every visual on the page to show only Eastern region data.

This is the self-service magic. Instead of building 4 versions of a report (one per region), build one report with a region slicer. Users get the exact view they need.

Cross-filtering

When a user clicks a bar in one chart, all other charts on the page filter to match. Click "Q4" on a revenue bar chart, and the product table, customer map, and KPI cards all update to show Q4 data. This happens automatically — no configuration needed.

There Are No Dumb Questions

"How many visuals should I put on one page?"

Five to eight, maximum. Each visual should answer one question. If you have 15 metrics, use 2-3 pages with a navigation tab. A cluttered dashboard is worse than no dashboard — people won't use it.

"Should I use pie charts?"

Rarely. Power BI's donut chart works for 2-4 segments showing parts of a whole. Beyond that, use a bar chart. Humans are bad at comparing angles and areas — we're much better at comparing lengths.

DAX basics: the formula language

DAX (Data Analysis Expressions) is Power BI's formula language. It's how you create calculated columns and measures that go beyond what drag-and-drop can do.

Measures vs. calculated columns

Essential DAX functions

// Basic aggregation
Total Revenue = SUM(Sales[Revenue])
Order Count = COUNTROWS(Sales)
Average Order = AVERAGE(Sales[Amount])

// Conditional aggregation
High Value Orders = CALCULATE(
    COUNTROWS(Sales),
    Sales[Amount] > 1000
)

// Time intelligence
Revenue YTD = TOTALYTD(SUM(Sales[Revenue]), Calendar[Date])
Revenue Last Month = CALCULATE(
    SUM(Sales[Revenue]),
    DATEADD(Calendar[Date], -1, MONTH)
)

// Percentage
Revenue Share = DIVIDE(SUM(Sales[Revenue]), CALCULATE(SUM(Sales[Revenue]), ALL(Sales[Region])))

Sharing and collaboration

A dashboard nobody sees is a dashboard that doesn't exist. Power BI's sharing model determines who can see, edit, and interact with your reports.

The most effective delivery method is embedding reports in the tools people already use. If your sales team lives in Teams, embed the dashboard in a Teams tab. If leadership uses SharePoint, embed it there. Meet people where they are.

Key takeaways

• Power BI turns static reports into live, self-service dashboards. The CFO doesn't ask for a report — they open a browser and get answers themselves.
• Power Query is your data cleaning autopilot. Record transformation steps once, and they replay every time data refreshes. No more manual cleaning.
• Five to eight visuals per page. Cards for KPIs, bar charts for comparisons, line charts for trends, slicers for interactivity. Less is more.
• DAX is the formula language. CALCULATE is the most important function — it changes filter context. Master SUM, CALCULATE, DIVIDE, and time intelligence functions first.
• Share where people already work. Embed in Teams, SharePoint, or email subscriptions. A dashboard nobody opens is worthless.
• Power BI Desktop is free. You can build complete reports without spending anything. Sharing requires Pro ($10/user/month) or a company license.