← BACK TO LISTINGS DIAGNOSTIC_BLUEPRINT_V2.0

Become a Certified Data
Analytics Associate (CDAA)

Move from guesswork to certainty. Architect the diagnostic logic of a business.

LEVEL 1 – DATA FOUNDATIONS & SQL MASTERY (Months 1–3)

Theme: Structured Data & Analytical Control

Basic Level

  • Data types & formatting
  • Sorting & filtering
  • Conditional formatting
  • Basic formulas (SUM, IF, COUNT, AVERAGE)

Intermediate Level

  • Pivot Tables & Pivot Charts
  • Lookup Functions (VLOOKUP, XLOOKUP, INDEX-MATCH)
  • Data Validation
  • Text & Date functions

Advanced Level

  • Power Query fundamentals
  • Power Pivot concepts
  • Advanced logical formulas
  • Scenario analysis
  • What-If analysis
  • Dashboard building in Excel
  • Power Query transformations (advanced)
  • Data model relationships
  • Performance optimization
  • Database design principles
  • Normalization (1NF–3NF)
  • Primary & Foreign Keys
  • Entity-Relationship Modeling
  • Star schema modeling
  • Slowly Changing Dimensions (SCD) awareness
  • SELECT mastery
  • JOINs (Inner, Left, Right, Full)
  • Subqueries
  • CTEs
  • Window Functions
  • Aggregations & Grouping
  • Performance optimization basics
  • Indexing strategies
  • Execution plan analysis
  • Query optimization techniques
  • Stored procedures basics
Level 1 Milestone

The Database Audit

  • Clean a messy industrial dataset in Excel
  • Design relational schema
  • Import into SQL database
  • Optimize queries
  • Present performance improvement report

Assessment: Practical Database Rebuild + Technical Presentation

LEVEL 2 – BUSINESS INTELLIGENCE VISUALIZATION (Months 4–6)

Theme: The Art of the Dashboard

  • Data modeling
  • DAX fundamentals
  • Relationship management
  • KPI design
  • Interactive dashboards
  • Real-time data integration
  • Advanced DAX
  • Row-level security
  • Data gateway configuration
  • Data connections
  • Calculated fields
  • Parameters & filters
  • Storyboarding
  • Visual best practices
  • Dashboard publishing
  • Level of Detail (LOD) expressions
  • Performance optimization
  • Visual storytelling principles
  • Avoiding misleading charts
  • Executive presentation structure
  • Translating metrics into business language
Level 2 Milestone

The Executive Command Center

  • A real-time fleet performance dashboard
  • Fuel consumption analysis
  • KPI monitoring system
  • Executive summary presentation

Assessment: Live Dashboard Demo + Stakeholder Defense

LEVEL 3 – STATISTICAL STORYTELLING (Months 7–9)

Theme: Why Did It Happen?

  • Descriptive statistics
  • Probability distributions
  • Sampling techniques
  • Confidence intervals
  • Correlation vs Causation
  • A/B testing framework
  • Business experiment design
  • Statistical power concepts
  • Null & Alternative hypotheses
  • T-tests
  • Chi-square tests
  • ANOVA concepts
  • P-values & interpretation
  • Trend detection
  • Outlier analysis
  • Sector benchmarking
  • Regression fundamentals
Level 3 Milestone

The Market Insight Report

  • Analyze real Nigerian sector data (Fintech, Retail, etc.)
  • Conduct full diagnostic analysis
  • Test hypotheses
  • Build supporting visuals
  • Present strategic recommendations

Assessment: Market Intelligence Presentation + Written Report

Certified Data Analytics Associate (CDAA)
Cohort 1.0

Date: 9th March 2026.

Program Level Online (Private) Online (Classroom) Onsite
Beginner ₦250,000 ₦200,000 ₦150,000
Intermediate ₦325,000 ₦260,000 ₦195,000
Advanced ₦350,000 ₦280,000 ₦210,000

Bank Transfer Details

Account Name: Querytech Limited

Bank Name: Moniepoint MFB

Account Number: 4697182181

To complete your enrollment, kindly send a screenshot of your payment receipt via WhatsApp using the link below. Open WhatsApp

Thank you.