Data and Analytics

Business Intelligence Analyst

Design the data models and dashboards executives actually make decisions from

24h4 lessonsTier 2 hireabilityTier 1 certificate

What you'll be able to do

You can design a simple star-schema data model, build an interactive multi-page dashboard with proper drill-down and filtering, write DAX or calculated field formulas for business metrics, and present a BI solution's design decisions to non-technical stakeholders.

Job titles this qualifies you for

Business Intelligence AnalystBI DeveloperAnalytics EngineerReporting Manager
Market intelligence
Demand
High
Remote
70% remote roles
Nigeria salary
₦200,000–₦900,000+/month (experience-dependent)
Remote (USD)
Generally commands a premium over general Data Analyst roles given added modelling and dashboard-design scope

Before you start — primers

Short reads that give you the foundation to get more from the program.

SQL Basics
Spreadsheet Fundamentals

Lessons

Stage 1 — Foundation
1
Dimensional Modelling and the Star Schema
30 min
2
Power BI and Tableau Dashboard Design
30 min
Stage 2 — Applied
1
DAX and Calculated Field Fundamentals
30 min
2
Presenting BI Solutions to Stakeholders
20 min
Tier 2 Proof Submission

Executive Dashboard with Data Model

Design and build a complete BI solution from data model through to a presentable executive dashboard.

1.A star schema design (fact table grain and measures, 3+ dimension tables) for a chosen business scenario
2.An interactive multi-page dashboard (Power BI or Tableau) built from that model, including at least one drill-down/cross-filter interaction
3.At least 2 DAX measures or Tableau calculated fields, including one time-intelligence calculation
4.A short data dictionary explaining what each key metric means and how it's calculated
Create a free account to join this programJoin free →