Learn Without Walls
Jump to: 📌 Before 💡 Concept 🔗 Why It Matters 🛠️ Tool Setup 🖐️ Practice 🧠 Break ✅ Wrap Up
📄 Save or print this lesson:
← Back to Phase 3
Phase 3 — Python for Data
Module 8 of 14

Power BI — Visualize with Microsoft

Microsoft’s answer to Tableau. The visualization tool of the Microsoft ecosystem — and where SAP data often lands.

~20 minutes
📌 Before You Start
Mac users: Power BI Desktop is Windows only. Use Google Looker Studio at lookerstudio.google.com instead — it is fully browser-based, free, and covers the same concepts in this module.

Windows users: Download Power BI Desktop from microsoft.com/power-bi (free). Allow time to download and install before starting.

What you’ll do: Load the Superstore dataset from Module 5, build a bar chart, add a filter, and create a KPI card. These three elements appear in almost every real business dashboard.

💡 The Concept

Power BI is Microsoft’s data visualization tool — a direct competitor to Tableau that dominates the Microsoft ecosystem.

Tableau vs. Power BI — what you need to know:

Tableau

  • Most widely used overall
  • Excellent drag-and-drop interface
  • Tableau Public = free portfolio
  • Strong in non-Microsoft shops
  • Used by data analysts, marketing, HR

Power BI

  • Dominant in Microsoft shops
  • Integrates with Excel, Teams, Azure
  • SAP integrations available
  • DAX formulas (like Excel)
  • Often in finance, enterprise, government

The interface is different from Tableau but the concepts are the same: you have data fields, you drag them into visual areas, and the chart builds. The terminology differs (Fields pane vs. Data pane, Visualizations pane vs. Marks card) but the logic is identical.

New concept: KPI Card. A KPI (Key Performance Indicator) card shows a single number prominently — like “Total Revenue: $1.2M” or “Open Orders: 847.” Every executive dashboard has them. They are the first thing people look at.

🔗 Why It Matters

Power BI appears alongside Tableau in thousands of job postings. Many companies use both. Knowing both — even at a basic level — means you can step into almost any visualization role without a tool-specific gap.

SAP (Phase 5 of this course) integrates directly with Power BI. Companies that run SAP often use Power BI to visualize SAP data. Understanding both is a genuinely powerful combination.

🛠️ Tool Setup — Power BI Desktop (Windows)
1
Open Power BI Desktop. You will see the start screen with Recent, Open, and New options.
2
Click “Get Data” at the top (or from the start screen). Select “Excel Workbook” or “Text/CSV”. Navigate to your Sample Superstore file from Module 5.
3
A preview appears. Select the table/sheet you want and click “Load.” Power BI imports the data into its data model.
4
You are now in the Report view. On the right: Fields pane (your data columns), Visualizations pane (chart types). Center: the blank report canvas. This is where you build.
🖐️ Practice
1
In the Visualizations pane on the right, click the Clustered Bar Chart icon (it looks like horizontal bars). An empty chart placeholder appears on the canvas.
2
In the Fields pane (right side), find Category. Drag it into the “Y-axis” box in the Visualizations pane below the chart icons. Then find Sales and drag it into the “X-axis” box. A bar chart appears showing sales by category.
3
Click somewhere on the empty canvas (outside your chart) to deselect it. In the Visualizations pane, click the Slicer visual (it looks like a funnel). A slicer placeholder appears. Drag Region from the Fields pane into the slicer. You now have a region filter that controls your bar chart.
4
Click on your region slicer and select just “West.” Your bar chart updates instantly to show only West region sales. Click “West” again to deselect and return to all regions. That is interactive filtering.
5
Add a KPI card. Click on empty canvas space. In Visualizations, click the Card visual (looks like a rectangle with a number). Drag Sales into the “Fields” well below the visual icons. Power BI shows total sales as a large number. That is your KPI card.
6
Click File → Save and save your Power BI file (.pbix). This file is your Power BI report. Add “Power BI report saved” to your portfolio notes document.
7
Now add this to your skills list: Power BI, Tableau Public, Google Colab/pandas, SQL, Google Sheets. That is five tools in three weeks. That is a real analyst toolkit.
🛑 Phase 3 complete after this module. Great stopping point.
🧠 Brain Break

Two visualization tools in your toolkit now. Your brain has been doing a lot of comparison work today — “this is like Tableau but the terms are different.” That is high-order transfer learning. Rest your eyes. Look out a window if you can.

Rest your eyes Look somewhere far away Roll your shoulders back Take a water break
✅ You Got This

The ONE thing to remember from this module:

Power BI = Microsoft’s answer to Tableau. Both do the same job. Knowing both = more opportunities. Add Power BI to your skills list.

🏁 Phase 3 Complete

You completed Python for Data. You can write pandas, use Google Colab, and build reports in Power BI. Phase 4 is your Capstone — the real portfolio project that proves everything you have learned.

← Module 7: Python/pandas 📋 Course Home Phase 4: Capstone →