9-Month Career Program · June 2026 Cohort Open

Become a Data Analyst with Gen AI

Master Excel, SQL, Power BI & Python in a structured 5-phase career program — built for real industry outcomes and powered by Generative AI at every step.

Data Analytics Dashboard with highlights
Scroll
Advanced Excel
Power Query
SQL & PostgreSQL
Power BI
Python
Generative AI
📉 Data Visualization
🔍 EDA & Statistics
🎯 Interview Prep
💼 Portfolio Building
Advanced Excel
Power Query
SQL & PostgreSQL
Power BI
Python
Generative AI
📉 Data Visualization
🔍 EDA & Statistics
🎯 Interview Prep
💼 Portfolio Building
The Curriculum

5 Phases, One Career

A progressive, project-first curriculum designed to take you from spreadsheet basics to full-stack data analytics — with Gen AI woven throughout.

01
Phase 1

Advanced Excel & Power Query

Master data manipulation, advanced formulas, PivotTables, VBA basics, and end-to-end ETL pipelines using Power Query's M language.

XLOOKUP PivotTables Power Query
02
Phase 2

SQL with PostgreSQL

Build professional SQL skills from schema design to advanced window functions, CTEs, and PostgreSQL-specific features on real datasets.

Window Functions CTEs PostgreSQL
03
Phase 3

Power BI

Transform data into business decisions. Learn data modeling, DAX from basics to advanced, and build production-grade interactive dashboards.

DAX Data Modeling Dashboards
04
Phase 4

Python & Gen AI

From Pandas wrangling to ML foundations — and then into OpenAI & Claude API integration, LangChain, and building AI-powered analytics tools.

Pandas & ML OpenAI API Streamlit
05
Phase 5 · Final Phase

Capstone Projects & Interview Preparation

Synthesize all skills into a full-stack analytics capstone across your chosen industry domain. Build your GitHub portfolio, get resume reviewed, and go through 3 rounds of mock interviews with working data analysts and hiring managers.

Portfolio Mock Interviews Placement

Gen AI at Every Stage

This isn't a separate AI module. Generative AI tools are woven into the workflow from day one — the way real analysts use them in industry today.

Excel & Power QueryFormula generation and VBA code writing with AI assistants
🗄️
SQLNatural language to SQL query generation and optimization
📊
Power BICopilot for AI-generated visuals and Smart Narrative summaries
🤖
PythonOpenAI & Claude API, LangChain pipelines, Streamlit AI apps
Live Preview

What Your Dashboards Will Look Like

Build stunning, data-driven dashboards like these — powered by the tools you'll master in each phase of the program.

💰
$0K
Total Revenue
▲ 12.4%
👥
0
Active Users
▲ 8.2%
📊
0%
Conversion Rate
▲ 3.1%
⏱️
0ms
Avg Response
▼ 5.7%
Monthly Revenue Breakdown
Traffic Distribution
User Growth Trend — Last 12 Months
Performance Gauges
Completion Rate
87%
Student Satisfaction
96%
Placement Rate
91%
Job-Ready Score
93%
Learning Journey

Phase-by-Phase Progression

Phase 1
Foundation — Data Handling & Transformation
Build confidence with Excel's most powerful features. Learn to clean, transform, and model data without writing a single line of code — using Power Query's intuitive ETL workflow.
ExcelPower QueryVBA Basics
Phase 2
Relational Databases & Analytical Querying
Learn to speak the language of data. Write queries from simple SELECTs to complex window functions across 50,000+ row real-world datasets in PostgreSQL.
SQLPostgreSQLpgAdmin
Phase 3
Business Intelligence & Dashboards
Turn raw data into decisions. Build star-schema data models, write powerful DAX measures, and create executive-grade dashboards connected to live data.
Power BIDAXData Modeling
Phase 4
Analytical Programming & Generative AI
Go from spreadsheets to scripts. Wrangle data with Pandas, visualise with Plotly, build ML models with Scikit-learn, and integrate LLM APIs for AI-powered analytics workflows.
PythonPandasScikit-learnOpenAI API
Phase 5
Capstone, Portfolio & Career Launch
Ship a full-stack analytics project. Present to industry mentors. Receive personalised resume reviews, LinkedIn optimisation, and 3 structured mock interview rounds.
CapstoneGitHub PortfolioMock InterviewsPlacement
Hands-On Learning

5 Real Projects,
Not Toy Datasets

Every phase culminates in a business-grade project built on real data — ready to showcase in your portfolio and discuss in interviews.

Phase 1 Project

Sales Performance Dashboard

Import multi-source sales CSVs, clean and transform via Power Query, then build an interactive Excel dashboard with PivotTables, slicers, and KPI cards.

ExcelPower QueryVBA
Phase 2 Project

E-Commerce Analytics Database

Design a PostgreSQL schema, import 50,000+ transactional rows, and produce analytical SQL reports for cohort analysis, revenue trends, and inventory.

PostgreSQLpgAdminSQL
Phase 3 Project

Executive BI Suite

Multi-page Power BI report for a retail business: sales, inventory, customer, and regional dashboards — connected live to the Phase 2 PostgreSQL database.

Power BIDAXRLS
Phase 4 Project

AI-Powered Analytics Pipeline

End-to-end Python pipeline: PostgreSQL ingestion → Pandas EDA → churn prediction model → LLM API auto-generates insight summaries → Streamlit app.

PythonScikit-learnOpenAI APIStreamlit
Phase 5 · Capstone

Full-Stack Capstone Project — Your Domain, Your Data

Choose your industry (finance, healthcare, retail, HR, logistics). Define a real business problem. Build a complete solution spanning SQL database, Python analysis, Power BI dashboard, and Gen AI integration. Present to a panel of industry mentors.

All ToolsGen AIGitHubPanel Presentation
What You'll Walk Away With

Built for Real Careers

🎓
Industry Certificate
Skill Sphere Academy Certified Data Analyst with Gen AI — awarded after panel evaluation and project submission.
💼
GitHub Portfolio
5 fully documented projects on GitHub with README files, notebooks, SQL scripts and a personal portfolio page.
🎯
Interview Readiness
3 full mock interview rounds with feedback. 50+ SQL challenges, Python tasks, and business case practice sessions.
🚀
Placement Support
Reviewed resume, optimised LinkedIn, job search strategy, referral network access, and alumni community.

Tools You'll Master

Industry-standard applications used by data analysts worldwide — you'll gain hands-on mastery of each.

Microsoft Excel
Advanced Formulas & Dashboards
Phase 1
Power Query
ETL & M Language
Phase 1
PostgreSQL
Database & SQL
Phase 2
Power BI
DAX & Dashboards
Phase 3
Python
Pandas · ML · APIs
Phase 4
Generative AI
OpenAI · Claude · LangChain
All Phases
2026 Cohort · Limited Seats

Your Data Career Starts Here

9 months. 5 tools. 5 real projects. One career-ready certification. Join the next cohort at Skill Sphere Academy.