FarawaACADEMY
Sign In
HomeDesignationsData Analytics & Business Intelligence
Data & IntelligenceFarawa Professional Designation Level IVScholarship Eligible

Data Analytics & Business Intelligence

Advanced SQL, Executive Dashboards, Revenue Intelligence, Metric Trees & Predictive Modeling

Transform complex operational and financial data into strategic executive decisions. Write high-performance SQL transformations, build interactive dashboards in Power BI and Metabase, architect metric trees and unit economics tracking, and deploy statistical forecasts for customer churn and revenue growth.

Duration
6 months
Proficiency
Beginner
Start Date
November 2026
Credit Units
60 Units
Data Analytics & Business IntelligenceAccredited Track
Credential:Farawa Certified Data & BI Analyst (FCDB)
Tuition Assessment:₦350,000 (Farawa Fellowship Eligible)
Study Mode:Hybrid (Studio + Digital)
Accreditation:Farawa Academy Standard for Intelligent Work (FAS-IW)
Apply For This CohortConsult Advisory Model
Terrain-Optimized Learning

Syllabus & Practical Application Modules

Built for practical execution across African operating realities. Study online or export complete lesson guides for offline learning.

Curriculum Lessons & Strategic Walkthroughs (2)
Lesson 1 • 90 minsPractical Guide

Data Analytics & BI: Architecture & Deep Principles of Advanced SQL Modeling & Dimensional Schemas

In the West African operating landscape, implementations of Advanced SQL Modeling & Dimensional Schemas face extreme infrastructural constraints including frequent brownouts, high bandwidth costs, and legacy system interoperability. Systems must be engineered with defensive fault tolerance, low resource overhead, and strict regulatory compliance.

Lesson 2 • 100 minsPractical Guide

Data Analytics & BI: Hands-On Implementation & Enterprise Drill for Advanced SQL Modeling & Dimensional Schemas

Translating theory into tangible enterprise deliverables requires mastery of production debugging tools, schema migrations, and real-time observability across the African corporate landscape.

Key Topics & Analytical Concepts

Complex JOINs, Subqueries & Recursive Common Table Expressions (CTEs)
Window Functions: Analytical Partitioning, Ranking, and Moving Averages
Date/Time Manipulations, String Parsing & Data Cleaning in PostgreSQL
Query Optimization: Indexes, Execution Plans & Performance Tuning
Hands-On Milestone: Complex E-Commerce Transaction SQL Transformation SuiteBeginner

Write a 10-query analytical script answering complex business questions on customer repeat purchase intervals and churn rates from 200,000 raw transaction logs.

Toolchain & Operating Stack:
PostgreSQL / BigQueryDBeaver / DataGripGitHub

Recommended Module Literature

SQL for Data Analysis: Advanced Techniques for Transforming Data into Insights
Source: Cathy Tanimura (O'Reilly Media) • Practical SQL recipes for cohorts, funnels, and time-series.
Textbook / E-Book

Graduation Competencies

✓
Write advanced SQL queries with window functions and analytical CTEs
✓
Model clean dimensional data warehouses using Kimball star schemas
✓
Develop executive dashboards in Power BI with complex DAX calculations
✓
Translate raw data into compelling narrative presentations that guide strategy

Technologies Mastered

Advanced SQL (Window Functions / CTEs)Power BI & DAXPython for Data (Pandas / NumPy)Metabase & Looker StudioData Modeling (Star Schema)Revenue Intelligence & Metric TreesCohort AnalysisExecutive Storytelling

Prerequisites

  • •Basic familiarity with spreadsheets (Excel / Google Sheets)
  • •Logical curiosity for numbers and business mechanics

Target Industry Roles

Senior Data AnalystBusiness Intelligence EngineerRevenue Operations AnalystAnalytics Manager
Farawa Academy | The School of Intelligent Work