What is Power BI?
Power BI · Power BI Introduction
Theory
Power BI is Microsoft's business analytics platform for turning raw data into interactive reports and dashboards. You connect to sources such as Excel, SQL Server or a web API, clean the data in Power Query, relate the tables in a data model, write calculations in DAX, and then build visuals that people can click, filter and explore.
For example, a retail team can load a Sales table with ₹ order amounts, link it to Customers and Products, and in a few minutes see total sales by region, the top products and the monthly trend, all refreshing automatically when new orders arrive.
Why we use it
Spreadsheets get slow, fragile and hard to share once data grows. Power BI gives one repeatable pipeline from source to shared report, so numbers are calculated the same way for everyone and refresh without copy-paste.
When to use it
Use it when a team needs recurring, interactive reporting on business data. For a one-off calculation a spreadsheet is fine; for heavy data engineering, do the transformation upstream (warehouse or dbt) and let Power BI focus on modeling and visuals.
How it works
- Business question: how are sales doing?
- Connect to the data sources
- Clean and shape data in Power Query
- Relate tables and write DAX measures
- Build interactive visuals on report pages
- Do others need to see it? Yes: Publish to the Power BI Service and share. No: Keep the .pbix file local.
- Decisions made from one trusted report
Syntax
Typical workflow:
1. Get data (connect to a source)
2. Transform data (Power Query)
3. Model data (relationships, DAX)
4. Visualize (report pages)
5. Publish and share (Power BI Service)Example
Mini walkthrough with the course sample model:
1. Home → Get data → Excel workbook → load Sales, Customers, Products.
2. Model view: relate Sales[CustomerID] to Customers[CustomerID] and Sales[ProductID] to Products[ProductID].
3. New measure: Total Sales = SUM(Sales[Amount])
4. Add a clustered bar chart: Region on the Y-axis, [Total Sales] as the value.
Result: North ₹3,200, West ₹2,400, South ₹600.
5. Home → Publish to share it in the Power BI Service.Key points
- Combines data prep, modeling and visualization in one tool
- Desktop is for building; the cloud Service is for sharing and refresh
- Power Query (M) shapes data; DAX calculates measures on the model
- Used across finance, sales, ops and marketing teams
- The same model can feed many reports, so logic is defined once