Master Power BI in Under 3 Hours: From Data Import to Advanced Dashboards

Introduction

• Power BI is a leading data‑visualisation tool within the Microsoft ecosystem.
• The tutorial shows how to become proficient in Power BI in a single, comprehensive video.

Getting Started

• Download Power BI Desktop – free from the Microsoft Store (link provided in the video description).
• Open Power BI and click Get Data to choose a source.

Importing Data

• The example uses an Excel workbook named Apocalypse Food Prep.
• In the Navigator window, select the required sheet and either Load or Transform Data.

Power Query – Basic Transformations

• Rename columns (e.g., change "Date" to "Date Purchased").
• Filter rows (remove unwanted items such as milk).
• Remove top rows that contain only nulls.
• Promote first row as headers.
• Change data types (e.g., set price columns to Fixed Decimal Number).
• Unpivot columns to turn month columns into rows, creating a tidy table ready for visualisation.
• All steps are recorded in the Applied Steps pane, allowing easy rollback.

Building Visualisations

• Use the Report tab to drag fields onto the canvas.
• Common visual types demonstrated:
• Stacked/Clustered Column Chart – compare spending by store.
• Clustered Column Chart – show product‑by‑store price differences.
• Card – display single‑value KPIs (e.g., total purchase amount).
• Table – list detailed rows.
• Add Legends, Data Labels, and adjust Display Units for clarity.
• Rename visual titles via the Format → General → Title pane.

Analysing Store Purchases (Apocalypse Food Prep)

• Quick insight: Costco offers the lowest total spend ($210) compared with Target ($219) and Walmart ($225).
• A clustered column chart reveals product‑level price differences across stores, highlighting that rice is cheapest at Target while most other items are cheapest at Costco.

Modelling Relationships

• Import multiple tables (Apocalypse Store, Apocalypse Sales, Customer Information).
• Power BI auto‑detects relationships; you can edit them:
• Cardinality – One‑to‑Many, Many‑to‑One, etc.
• Cross‑filter direction – Single vs. Both.
• Active relationship – determines the default join.
• Demonstrated building relationships from scratch by dragging key columns (e.g., Customer ID, Product ID).

DAX Basics

• Measures (e.g., Count of Sales = COUNT('Apocalypse Sales'[Order ID])).
• Aggregations – SUM, AVERAGE.
• Iterator functions – SUMX to calculate row‑level profit.
• IF statements – classify orders as "Big" or "Small" based on quantity.
• Date functions – extract weekday, month, etc., for pattern analysis.

Bins and Lists

• Create list groups for categorical fields (e.g., best vs. worst prepping stores).
• Create numeric bins for age or date fields (e.g., 10‑year age brackets, monthly bins).
• Use these groups in visuals to simplify large categorical sets.

Conditional Formatting

• Apply Background Color gradients or rule‑based colours to highlight high/low values.
• Use Data Bars to visualise magnitude directly in tables.
• Add Icons (traffic‑light style) for quick status indication.

Drill‑Down & Hierarchies

• Enable drill‑down on visuals to explore data at multiple levels (store → product, date → month → day).
• Demonstrated hierarchy navigation: click to drill down, expand all, or return to higher levels.

Final Project – Real Survey Data

• Imported a CSV of a data‑professional survey (≈630 respondents).
• Data cleaning in Power Query:
• Split multi‑value columns (e.g., job titles, programming languages).
• Standardise salary ranges by extracting numeric values and computing an average.
• Remove unnecessary columns.
• Built a dashboard with:
• Cards for total respondents and average age.
• Bar chart for average salary by job title.
• Column chart for favourite programming languages.
• Tree map for respondents by country.
• Gauges for work‑life balance and salary happiness.
• Gender‑based salary comparison (donut chart).
• Difficulty‑to‑break‑into‑data chart with custom colour rules.
• Adjusted titles, colours, and layout to create a cohesive visual story.

Dashboard Design Tips

• Keep high‑level KPIs on cards for instant insight.
• Use consistent colour palettes; Power BI themes can be customised.
• Group related visuals and align them for a tidy layout.
• Leverage drill‑down to let stakeholders explore details without cluttering the main view.

Conclusion

• Power BI enables end‑to‑end analytics—from raw data import, through transformation and modelling, to interactive visualisations—within a few hours of focused learning.
• Mastering the core steps (Power Query, relationships, DAX, formatting) empowers analysts to build professional dashboards without needing extensive coding or external tools.

Power BI can be learned quickly and provides a complete, low‑code workflow for turning raw data into insightful, interactive dashboards, making it an essential tool for any data‑driven organization.