If you’re looking to drive insights in your current role or prepare for higher-impact positions, this course equips you with the tools, techniques, and hands-on experience to thrive in a data-driven world.

Course Dates & Time:

  • Start Date: Saturday, February 21, 2026

  • Duration: 4 weeks

  • Time: 2:00 PM – 3:30 PM US CT (Saturdays), 2:00 PM – 2:30 PM US CT (Sundays)

Here’s a clear, structured 4-week curriculum designed for an Intermediate → Advanced Data Analytics Bootcamp. This is ideal for professionals who already understand basic Excel, data concepts, or reporting and want job-ready, decision-driven analytics skills.

Intermediate–Advanced Data Analytics Bootcamp (4 Weeks)

Format: 90 minutes per session | Hands-on + real-world use cases

Outcome: Learners move from reporting → insight → decision support

Week 1: Advanced Data Foundations & Analytical Thinking

Goal: Strengthen analytical mindset and data readiness

Key Topics

   •   Analytical problem framing (business questions → metrics → insights)

   •   Data types & structures (structured, semi-structured)

   •   Advanced Excel techniques:

      •   Power Query (data cleaning & transformation)

      •   Dynamic arrays, XLOOKUP, INDEX-MATCH

      •   Advanced Pivot Tables & Pivot Charts

   •   Data quality, validation & governance basics

   •   KPI design & metric alignment


Hands-On

   •   Clean and transform messy datasets

   •   Build executive-ready KPI tables


Week 2: SQL & Data Modeling for Analysis

Goal: Extract and model data efficiently

Key Topics

   •   Advanced SQL:

      •   Complex JOINs

      •   Subqueries & CTEs

      •   Window functions

      •   Performance optimization basics

   •   Data modeling fundamentals:

      •   Star vs Snowflake schemas

      •   Fact & Dimension tables

   •   Data integration concepts (multiple sources)

   •   Analytical datasets vs transactional datasets


Hands-On

   •   Write production-style SQL queries

   •   Design a reporting data model


Week 3: Data Visualization, Storytelling & Tools

Goal: Turn insights into executive-level stories

Key Topics

   •   Advanced Power BI / Tableau concepts:

      •   DAX basics (CALCULATE, FILTER, context)

      •   Measures vs calculated columns

      •   Drill-throughs & interactive dashboards

   •   Data storytelling frameworks

   •   Visualization best practices for executives

   •   Avoiding misleading charts

   •   Dashboard performance tuning


Hands-On

   •   Build an interactive executive dashboard

   •   Present insights using storytelling techniques


Week 4: Advanced Analytics, Automation & Real-World Applications

Goal: Move beyond reporting into predictive and automated insights

Key Topics

   •   Intro to Python for analytics:

      •   Pandas & NumPy

      •   Exploratory Data Analysis (EDA)

   •   Statistical concepts for analysts:

      •   Correlation vs causation

      •   Hypothesis testing basics

      •   Regression analysis

   •   Predictive & trend analysis

   •   Automation:

      •   Automated reports & dashboards

      •   Intro to APIs & data pipelines

   •   AI-assisted analytics & prompt engineering for analysts

Capstone Project

   •   End-to-end analytics project:

      •   Data extraction

      •   Cleaning & modeling

      •   Visualization

      •   Executive insight presentation


What Participants Will Gain

   •   Confidence working with real enterprise datasets

   •   Advanced Excel, SQL, Power BI/Tableau skills

Why This Class Matters

Data is no longer optional — it’s the backbone of every decision. By the end of this course, you’ll:

  • Be proficient in key analytics tools and techniques.

  • Transform raw data into actionable insights.

  • Build dashboards and reports that influence decision-making.

  • Showcase your skills with an end-to-end project for your portfolio.

Meet Your Instructor: Afora Olorunfemi

Data Analytics & Workforce Insights Expert

Afora is a Certified Data Analyst and analytics educator who specializes in helping professionals turn raw data into clear insights, compelling dashboards, and confident, data-driven decisions.     In addition to her analytics expertise, Aforading strong foundations in tools like Excel and visualization, to deriving insights that inform strategy, performance, and growth.

With deep experience in data interpretation, reporting, and analytics storytelling, Afora teaches how data is actually used in real-world environments—not just theory. She is known for breaking down complex concepts into simple, actionable frameworks that professionals across industries can apply immediately.

Her approach equips learners to think analytically, communicate insights clearly, and use data to stand out in today’s competitive workplace.

In addition to her analytics expertise, Afora brings a valuable perspective from her background in HR and talent acquisition, including experience at Amazon, giving her a unique understanding of how data skills impact hiring, performance, and career progression.

Who Should Attend?

  • Professionals looking to enhance their analytics and decision-making capabilities.

  • Individuals preparing for leadership roles or data-driven positions.

  • Non-technical professionals seeking to leverage data for strategic impact.