Edgeworks Institute

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