Prerequisites Basic computer literacy and a willingness to document experiments.
Learning objectives Explain the stage-specific model and its limits Apply the listed concepts using a controlled exercise Record results, failure cases and a reproducible evidence trail
Topics to learn KPI definitions and grain Source profiling and data types Missing values and duplicates Data lineage and refresh cadence Excel for Data Analysis specialization: Track-specific focus: Excel for Data Analysis. Use the tools and standards named in this path; avoid treating this route as a generic overview of Data Science & Data Engineering.
Tools Excel or Power Query SQL client Data dictionary
Hands-on exercise Profile a raw dataset and write definitions for five business metrics. Context for this route: Track-specific focus: Excel for Data Analysis. Use the tools and standards named in this path; avoid treating this route as a generic overview of Data Science & Data Engineering.
Suggested project A data dictionary and KPI specification. The outcome must directly demonstrate Excel for Data Analysis, not merely list tools.
Learning resources Completion criteria Metric definitions are unambiguous and reconcile with the source. Evidence must be reproducible and tied to Excel for Data Analysis.
Next: Cleaning, transformation & modelling
✓ Mark this node as complete
Prerequisites Completion of the previous stage and a working local practice environment.
Learning objectives Explain the stage-specific model and its limits Apply the listed concepts using a controlled exercise Record results, failure cases and a reproducible evidence trail
Topics to learn Type correction and null handling Joins and append operations Star schema and relationships Date dimensions and granularity Excel for Data Analysis specialization: Track-specific focus: Excel for Data Analysis. Use the tools and standards named in this path; avoid treating this route as a generic overview of Data Science & Data Engineering.
Tools Power Query or Tableau Prep SQL Data model view
Hands-on exercise Transform a messy multi-file dataset and validate row counts after each step. Context for this route: Track-specific focus: Excel for Data Analysis. Use the tools and standards named in this path; avoid treating this route as a generic overview of Data Science & Data Engineering.
Suggested project A refreshable analytical model. The outcome must directly demonstrate Excel for Data Analysis, not merely list tools.
Learning resources Completion criteria Transformations are repeatable and totals reconcile with source files. Evidence must be reproducible and tied to Excel for Data Analysis.
Next: Measures, calculations & analytical logic
✓ Mark this node as complete
Prerequisites Completion of the previous stage and a working local practice environment.
Learning objectives Explain the stage-specific model and its limits Apply the listed concepts using a controlled exercise Record results, failure cases and a reproducible evidence trail
Topics to learn Calculated columns vs measures Filter context or LOD concepts Time intelligence Distinct counts and ratios Excel for Data Analysis specialization: Track-specific focus: Excel for Data Analysis. Use the tools and standards named in this path; avoid treating this route as a generic overview of Data Science & Data Engineering.
Tools DAX or Tableau calculations Sample business dataset
Hands-on exercise Implement KPIs and test them against manually calculated examples. Context for this route: Track-specific focus: Excel for Data Analysis. Use the tools and standards named in this path; avoid treating this route as a generic overview of Data Science & Data Engineering.
Suggested project A measure library with definitions and validation examples. The outcome must directly demonstrate Excel for Data Analysis, not merely list tools.
Learning resources Completion criteria Measures behave correctly under filters and drill-down. Evidence must be reproducible and tied to Excel for Data Analysis.
Next: Dashboard composition & information design
✓ Mark this node as complete
Prerequisites Completion of the previous stage and a working local practice environment.
Learning objectives Explain the stage-specific model and its limits Apply the listed concepts using a controlled exercise Record results, failure cases and a reproducible evidence trail
Topics to learn Chart selection and visual hierarchy Filters, drill-through and interactions Annotations and comparative context Accessibility and colour use Excel for Data Analysis specialization: Track-specific focus: Excel for Data Analysis. Use the tools and standards named in this path; avoid treating this route as a generic overview of Data Science & Data Engineering.
Tools Power BI or Tableau Wireframe tool
Hands-on exercise Build a dashboard from a storyboard and conduct a five-question usability walkthrough. Context for this route: Track-specific focus: Excel for Data Analysis. Use the tools and standards named in this path; avoid treating this route as a generic overview of Data Science & Data Engineering.
Suggested project An executive dashboard and its design rationale. The outcome must directly demonstrate Excel for Data Analysis, not merely list tools.
Learning resources Completion criteria Users can answer the target questions without misreading the chart. Evidence must be reproducible and tied to Excel for Data Analysis.
Next: Data storytelling & decision support
✓ Mark this node as complete
Prerequisites Completion of the previous stage and a working local practice environment.
Learning objectives Explain the stage-specific model and its limits Apply the listed concepts using a controlled exercise Record results, failure cases and a reproducible evidence trail
Topics to learn Variance and cohort analysis Outliers and uncertainty Narrative flow and annotations Decision-oriented recommendations Excel for Data Analysis specialization: Track-specific focus: Excel for Data Analysis. Use the tools and standards named in this path; avoid treating this route as a generic overview of Data Science & Data Engineering.
Tools BI platform Presentation software
Hands-on exercise Present an evidence-backed finding and state what the data cannot establish. Context for this route: Track-specific focus: Excel for Data Analysis. Use the tools and standards named in this path; avoid treating this route as a generic overview of Data Science & Data Engineering.
Suggested project A decision brief linked to the dashboard. The outcome must directly demonstrate Excel for Data Analysis, not merely list tools.
Learning resources Completion criteria Recommendations separate observed facts from hypotheses. Evidence must be reproducible and tied to Excel for Data Analysis.
Next: Performance, security & governance
✓ Mark this node as complete
Prerequisites Completion of the previous stage and a working local practice environment.
Learning objectives Explain the stage-specific model and its limits Apply the listed concepts using a controlled exercise Record results, failure cases and a reproducible evidence trail
Topics to learn Model size and query folding Row-level security Workspace and dataset permissions Certified metrics and change management Excel for Data Analysis specialization: Track-specific focus: Excel for Data Analysis. Use the tools and standards named in this path; avoid treating this route as a generic overview of Data Science & Data Engineering.
Tools BI service Performance analyser Role test accounts
Hands-on exercise Test a user role with restricted data and profile a slow report page. Context for this route: Track-specific focus: Excel for Data Analysis. Use the tools and standards named in this path; avoid treating this route as a generic overview of Data Science & Data Engineering.
Suggested project A governed report with documented access roles and performance results. The outcome must directly demonstrate Excel for Data Analysis, not merely list tools.
Learning resources Completion criteria Access rules are verified and refresh errors are visible. Evidence must be reproducible and tied to Excel for Data Analysis.
Next: Publishing, refresh & adoption
✓ Mark this node as complete
Prerequisites Completion of the previous stage and a working local practice environment.
Learning objectives Explain the stage-specific model and its limits Apply the listed concepts using a controlled exercise Record results, failure cases and a reproducible evidence trail
Topics to learn Gateway and refresh schedules Deployment pipeline Version control and change log Usage metrics and support process Excel for Data Analysis specialization: Track-specific focus: Excel for Data Analysis. Use the tools and standards named in this path; avoid treating this route as a generic overview of Data Science & Data Engineering.
Tools BI service Gateway Release checklist
Hands-on exercise Publish to a test workspace and demonstrate refresh failure notification. Context for this route: Track-specific focus: Excel for Data Analysis. Use the tools and standards named in this path; avoid treating this route as a generic overview of Data Science & Data Engineering.
Suggested project A release package with support and ownership notes. The outcome must directly demonstrate Excel for Data Analysis, not merely list tools.
Learning resources Completion criteria The report refreshes predictably and has a named support workflow. Evidence must be reproducible and tied to Excel for Data Analysis.
Next: Capstone: business intelligence product
✓ Mark this node as complete
Prerequisites Completion of the previous stage and a working local practice environment.
Learning objectives Explain the stage-specific model and its limits Apply the listed concepts using a controlled exercise Record results, failure cases and a reproducible evidence trail
Topics to learn Stakeholder requirements and metric model Validated data transformations Dashboard and narrative Access, refresh and maintenance Excel for Data Analysis specialization: Track-specific focus: Excel for Data Analysis. Use the tools and standards named in this path; avoid treating this route as a generic overview of Data Science & Data Engineering.
Tools Power BI/Tableau SQL or Power Query Documentation
Hands-on exercise Run a stakeholder review and revise the dashboard based on observed confusion. Context for this route: Track-specific focus: Excel for Data Analysis. Use the tools and standards named in this path; avoid treating this route as a generic overview of Data Science & Data Engineering.
Suggested project A dashboard, data model, KPI dictionary and executive summary. The outcome must directly demonstrate Excel for Data Analysis, not merely list tools.
Learning resources Completion criteria Metrics reconcile, permissions work and the intended decision is supported. Evidence must be reproducible and tied to Excel for Data Analysis.
End of roadmap: Complete the final project and build your portfolio.
✓ Mark this node as complete