Business Intelligence & Analytics — Skills Plan
Planned skill map for Business Intelligence & Analytics. The curriculum will be developed and released in stages.
Model business data and define reusable metrics, then build and review Power BI or Tableau reports with appropriate access, refresh, and governance.
Potential roles: BI Developer · Data Analyst · Analytics Engineer
Before you start
- SQL foundations
- Spreadsheets and basic statistics
What you’ll build
- Executive KPI dashboard
- Operational analytics report
- Governed and documented BI workspace
Prerequisites
PLANNED- SQL foundations
Build the SQL foundations knowledge needed to follow the Business Intelligence & Analytics foundations.
- Spreadsheets and basic statistics
Build the Spreadsheets and basic statistics knowledge needed to follow the Business Intelligence & Analytics foundations.
Foundations
PLANNED- Data modeling for analytics
Explain how Data modeling for analytics works and where it fits in the Business Intelligence & Analytics learning path.
- Metric definitions and dimensional models
Explain how Metric definitions and dimensional models works and where it fits in the Business Intelligence & Analytics learning path.
- Dashboard design and visual perception
Explain how Dashboard design and visual perception works and where it fits in the Business Intelligence & Analytics learning path.
Core Skills
PLANNED- Power BI and DAX
Use Power BI and DAX to implement a working capability and verify its behavior in Business Intelligence & Analytics.
- Tableau worksheets and calculations
Use Tableau worksheets and calculations to implement a working capability and verify its behavior in Business Intelligence & Analytics.
- Power Query and data preparation
Use Power Query and data preparation to implement a working capability and verify its behavior in Business Intelligence & Analytics.
- Filters, drill-through, and interactivity
Use Filters, drill-through, and interactivity to implement a working capability and verify its behavior in Business Intelligence & Analytics.
- Data storytelling
Use Data storytelling to implement a working capability and verify its behavior in Business Intelligence & Analytics.
Advanced / Production
PLANNED- Semantic models and reusable measures
Evaluate Semantic models and reusable measures trade-offs against the performance, reliability, and safety needs of Business Intelligence & Analytics systems.
- Performance and refresh strategies
Evaluate Performance and refresh strategies trade-offs against the performance, reliability, and safety needs of Business Intelligence & Analytics systems.
- Access control and governance
Evaluate Access control and governance trade-offs against the performance, reliability, and safety needs of Business Intelligence & Analytics systems.
- Report testing and release management
Evaluate Report testing and release management trade-offs against the performance, reliability, and safety needs of Business Intelligence & Analytics systems.
Real-World Projects
PLANNED- Executive KPI dashboard
Deliver a working outcome with Executive KPI dashboard, then test it against the project requirements.
- Operational analytics report
Deliver a working outcome with Operational analytics report, then test it against the project requirements.
- Governed and documented BI workspace
Deliver a working outcome with Governed and documented BI workspace, then test it against the project requirements.
Career / Interview Preparation
PLANNED- Metric and visualization reviews
Explain your approach to Metric and visualization reviews, defend key trade-offs, and discuss what you learned.
- BI case studies
Explain your approach to BI case studies, defend key trade-offs, and discuss what you learned.
- Dashboard walkthrough
Explain your approach to Dashboard walkthrough, defend key trade-offs, and discuss what you learned.
Discussion
0Have a better approach? Found something outdated? Share it — your knowledge helps everyone learning here.