The scenario
SalesPulse covers the analyst’s full loop: clean and model data in SQL, design measures in DAX, build an interactive report with drill-downs by region, product and rep, and use AI tools to draft the monthly commentary.
System architecture
01 Raw sales CSV + ERP export
02 SQL model Star schema
03 Power BI Measures + visuals
04 Insights AI summary
High-level flow of SalesPulse, from input to output.
What you will learn
- Star-schema modelling
- DAX measures and time intelligence
- Report design for decision-makers
What you will build
- SQL data model
- Power BI report
- AI-assisted monthly summary
Build plan
- Clean data
- Model
- Measures
- Report
- Insights