CH
Coding Hub
Power BIBeginner7 min read read

What Is Microsoft Power BI? Architecture & Dashboard Basics

A business intelligence overview explaining Power BI Desktop, data modeling, and reporting visuals.

Coding Hub Technical Editorial Team(Software Engineering & Education)
•
Updated 2026-03-12

Overview & Context

Modern businesses generate enormous volumes of transactional data daily across CRM systems, SQL databases, ERP software, and Excel spreadsheets. Raw data sitting in disconnected spreadsheets provides zero strategic insight. Microsoft Power BI is a unified business analytics platform that ingests, cleans, models, and visualizes complex data, allowing leaders to make data-driven decisions through interactive reports.

What You Will Learn
Understand the purpose and role of Business Intelligence (BI) in modern organizations
Differentiate between Power BI Desktop, Power BI Service (Cloud), and Power BI Mobile
Explore the 3 core internal engines: Power Query (ETL), VertiPaq (Model), and Visual Canvas
Understand the standard workflow from raw ingestion to report publishing
Table of Contents

1. The Power BI Ecosystem Explained

Desktop vs Service vs Mobile

Power BI is not a single application; it is an integrated ecosystem:

- **Power BI Desktop:** The free Windows authoring tool where data analysts connect to data sources, clean data, build relational data models, write DAX formulas, and design visual report pages.

- **Power BI Service (Cloud):** The SaaS cloud platform (app.powerbi.com) where published reports are hosted, shared across enterprise teams, and scheduled for automated background data refreshes.

- **Power BI Mobile:** Native apps for iOS and Android allowing executives to inspect live KPI dashboards securely on smartphones.

2. The Three Core Internal Engines

Under the hood, Power BI Desktop combines three distinct Microsoft technologies:

1. **Power Query Engine (M):** Handles Extract, Transform, Load (ETL). Ingests data from hundreds of sources and reshapes it.

2. **VertiPaq Analytical Engine:** An ultra-fast in-memory columnar database that compresses millions of rows into RAM and handles calculations.

3. **Visual Canvas:** The report design interface rendering interactive bar charts, matrices, maps, and KPI cards.

3. The End-to-End Report Workflow

Every successful Power BI project follows an established sequence:

Step 1: **Get Data:** Connect to databases, Web APIs, or spreadsheets.

Step 2: **Transform Data:** Clean columns, remove blanks, and standardize types in Power Query.

Step 3: **Data Modeling:** Connect fact tables to dimension tables using 1-to-Many relationships.

Step 4: **DAX Measures:** Write business calculations (e.g. Total Revenue, YoY Growth %, Average Attendance Rate).

Step 5: **Visual Report Layout:** Drag visuals onto the canvas and apply unified color themes.

4. Data Modeling: Star Schema Architecture

The golden rule of Power BI data modeling is building a **Star Schema**.

A Star Schema features a central **Fact Table** containing numerical transaction metrics (e.g. exam scores, sales orders) surrounded by related **Dimension Tables** containing contextual attributes (e.g. students, dates, courses). Avoid flat, single-table spreadsheets containing 50+ mixed columns.

Best Practice Tip
  • Always create a dedicated Date/Calendar dimension table in Power BI to enable Time Intelligence DAX functions like YTD and SamePeriodLastYear.

5. Common Power BI Mistakes

Treating Power BI like Microsoft Excel. Excel is designed for ad-hoc cell-based formulas; Power BI is an enterprise relational database modeling engine. Avoid attempting to build 200-column spreadsheet views in Power BI.

Using bidirectional cross-filtering without a specific requirement. Bidirectional filters degrade query performance and introduce ambiguity in relationship calculations.

Summary & Key Takeaways

  • 1Power BI is an end-to-end business analytics platform.
  • 2Work in Power BI Desktop to build models; publish to Power BI Service to share.
  • 3Always design data models in a clean Star Schema (Fact table surrounded by Dimension tables).
  • 4Power Query handles ETL before data enters the in-memory VertiPaq engine.
Frequently Asked Questions

Is Power BI Desktop free?

Yes, Power BI Desktop is completely free to download and use on Windows for building reports and analyzing local data. A paid Power BI Pro or Premium license is only required when sharing and collaborating on reports via the cloud Power BI Service.

What is DAX?

DAX stands for Data Analysis Expressions. It is a formula expression language similar to Excel formulas, but designed specifically to query relational tabular data models.