8-Week Data Analytics Bootcamp
From zero to portfolio-ready using Excel, SQL, Power BI & Python — built around a real Sales, Retail, Product & Market Analytics business case.Who This Is For
What You'll Learn (8-Week Plan)
Weeks 1–2: Excel for Business Analytics
Interface, formatting, data types, tables
Sorting, filtering, lookups (VLOOKUP, XLOOKUP, Index/Match)
Pivot tables/charts, KPI analysis, conditional formatting
Power Query (clean, merge, unpivot)
Interactive dashboards (slicers, timelines)
Weeks 3–4: SQL for Analysis
Set up DB & import Excel/CSV
SELECT, WHERE, ORDER BY; date filtering
Joins, GROUP BY & aggregates; CASE WHEN
CTEs, handling NULLs; window functions
Create views, time-series rollups; export to BI
Weeks 5–6: Power BI for Insights
Data import; star schema (fact & dimensions)
DAX basics (SUM, CALCULATE, FILTER, ALL)
Time intelligence (DATEADD, TOTALYTD, SAMEPERIODLASTYEAR)
KPI cards, slicers/filters; advanced DAX & RLS
Forecasting & executive dashboard design; publish & share
Weeks 7–8: Python for Analytics & Forecasting
Jupyter setup; pandas load/clean/transform
EDA describe(), correlations, visuals (matplotlib/seaborn)
Feature engineering; train/test split
Regression models (Linear, Ridge, RandomForest)
Forecast pipeline; evaluate MAE/RMSE; plot actual vs predicted
Real Business Case: Sales, Retail, Product & Market Analytics
Objective
Run an end-to-end analysis using historical data to understand performance drivers, optimize inventory & pricing, and build forecasts across sales, retail ops, product and market.
Key KPIs
Analyses You'll Perform
Deliverables
Outcomes & Next Steps
Technical Mastery
Mastery of Excel, SQL, Power BI, Python fundamentals
Portfolio Projects
1–2 portfolio projects tied to business KPIs
Presentation Skills
Confidence presenting insights & defending decisions
Career Accelerator
Move into the Accelerator (12 weeks) to build visibility, interview mastery, and earn internship opportunities
L.I.F.T.™ Program
Join the L.I.F.T.™ Program (5 months) for the full transformation
Support, Schedule & Tools
Not just tools — you get skills, proof, visibility, and real-world experience in one program.
Weekly coaching, feedback, and metrics keep you on track.
Excel: Microsoft 365 or 2019+
Power BI Desktop: Free download
SQL: PostgreSQL/MySQL/SQLite (guided install)
Python + Jupyter: Anaconda (guided install)
Ready to Transform Your Career?
Join the next cohort and start your analytics journey today