Business intelligence: Excel and Power BI
10 lessons that take you from “I have data” to “I have a decision”: KPIs, Excel formulas, pivot tables, choosing charts, data modelling, dashboard design and Power BI. With a formula lab, a pivot builder and an interactive dashboard.
Lessons
What is business intelligence?
From data to decisions, the four levels of analytics, and the data pipeline.
Key performance indicators
Metrics versus KPIs, choosing a SMART KPI, and the classic KPIs for each department.
Excel for business: core formulas
Relative and absolute references, SUMIFS and COUNTIFS, with an interactive formula lab.
Lookups and data cleaning
XLOOKUP for joining tables, and the most common data-quality problems with their fixes.
Pivot tables
Summarise thousands of rows in seconds, with a tool to build your own pivot and see the matching SQL.
Choosing the right chart
Every question has a chart that fits it, plus the mistakes that mislead readers.
Data modelling for analysis
The star schema, fact and dimension tables, and grain.
Designing dashboards
The rules of a good dashboard, with an interactive one for Nakhla's sales.
Power BI step by step
The Power BI workflow, Power Query, relationships and your first DAX measures.
Data storytelling and careers
Presenting findings to management, AI in BI, and the field's roles and certifications.