Excel · SQL · Power BI · Tableau · Python Analytics · Gen AI  ·  Batch Open

Turn Spreadsheets
Into Business Decisions.
Get Hired.

Not Excel formulas in isolation. You'll clean real business datasets, write advanced SQL queries, build Power BI and Tableau dashboards for actual clients, and deliver insights that drive real decisions — a portfolio companies hire analysts from.

Advanced Excel
SQL Analytics
Power BI
Tableau
Python Analytics
📊 medha_analytics_query.sql · SQL Workbench
Query:
-- Medha EduTech · Analytics Internship · Regional Sales Report
SELECT region, category,
  SUM(revenue) AS total_revenue,
  RANK() OVER(PARTITION BY region
    ORDER BY SUM(revenue) DESC) AS rnk
FROM sales_fact
WHERE order_date >= '2024-01-01'
GROUP BY region, category;
Result:
✔ 24 rows returned · 0.18s
South | Electronics | ₹ 18,42,300 | rank 1
North | Apparel    | ₹ 14,90,100 | rank 1
West  | Electronics | ₹ 12,33,500 | rank 1
Power BI:
-- DAX measure for executive dashboard
YoY Growth % =
DIVIDE(
  [Total Revenue] - CALCULATE([Total Revenue], SAMEPERIODLASTYEAR(Dates[Date])),
  CALCULATE([Total Revenue], SAMEPERIODLASTYEAR(Dates[Date]))
)
✔ Dashboard refreshed · 5 KPI cards updated
📈
Revenue +18.4% YoY
Regional Sales Report
📊
Dashboard Live
Power BI · Client Ready
💼
Offer Received!
₹7.5 LPA → Accenture
📍 Data Analytics Track Journey

The 90-Day Data Analytics Roadmap

From Excel fundamentals to delivering executive Power BI dashboards for real clients — mentor-guided every step of the way.

📗
Phase 1 · Days 1–22
Excel + SQL + Statistics
Advanced Excel (Pivot Tables, VLOOKUP, Power Query), SQL fundamentals, descriptive statistics, data cleaning on real business datasets — 2 mini-projects done.
📊
Phase 2 · Days 23–52
Power BI + Tableau Mastery
Power BI DAX measures, drill-throughs, data modelling, Tableau calculated fields, interactive dashboards — built for real client business requirements.
🐍
Phase 3 · Days 53–75
Python Analytics + Gen AI
Python with Pandas for automated reporting, statistical analysis, A/B testing, LangChain + OpenAI for AI-assisted analysis, advanced SQL — analytics automation.
🚀
Phase 4 · Days 76–90
Portfolio + Placement
Published dashboard portfolio, GitHub case studies, mock analytics interviews, business case prep, direct referrals to 200+ data-hiring companies — offer in hand.
📈 Analytics Team · Sprint #3
Dashboard Build Live
NK
Navya Krishnan
Power BI Analyst · Intern
Building
RS
Rahul Sharma
SQL / Data Analyst · Intern
Published ✓
AM
Mentor Anand
Sr. Analytics Manager · Medha
Reviewing
📈
Today: Finish the regional sales DAX measures, validate the data model relationships, and present the dashboard to the mock client panel at 5 PM.
🎯
5 Dashboards Shipped
📈
Dashboard: 12 KPIs
Data Analytics Experience Hub

Real Datasets.
Real Business Decisions.

You won't be playing with sample files. You'll clean real client business data, write SQL that answers actual revenue questions, build Power BI and Tableau dashboards that get presented to mock client panels — the full analytics workflow from raw spreadsheet to boardroom decision.

🔍
Real Business Data Cleaning
Clean and transform actual sales, customer, and operational spreadsheets — Power Query, missing values, duplicates, and standardisation that businesses depend on.
🗄️
Advanced SQL on Real Databases
Window functions, CTEs, joins across multiple tables, and query optimisation — answering real business questions about revenue, churn, and growth.
📊
Power BI & Tableau Dashboards for Clients
Build executive-level dashboards on real client data — DAX measures, drill-through reports, and live data connections published to Power BI Service.
📜
Analytics Portfolio + Certificate
GitHub with SQL case studies, published Power BI and Tableau dashboards, Excel automation projects, and a senior mentor endorsement for your LinkedIn.
🛠 Data Analytics Toolkit

Skills You'll Actually Master

Hands-on proficiency with every tool in the modern analytics stack — skills that show up in your published dashboards and SQL portfolios.

📗
Advanced Excel
Pivot Tables
VLOOKUP / XLOOKUP
Power Query
Macros / VBA
🗄️
SQL
Joins / Subqueries
Window Functions
CTEs
Query Optimisation
📊
Power BI
DAX Measures
Data Modelling
Power Query
Power BI Service
📈
Tableau
Calculated Fields
Dashboard Design
Story Points
Tableau Server
🐍
Python Analytics
Pandas / NumPy
Matplotlib / Seaborn
Statistical Testing
Report Automation
🤖
Gen AI for Analytics
ChatGPT / Copilot
AI-Assisted SQL
Power BI Copilot
Prompt Engineering
🗓 Week-by-Week Curriculum

What You'll Analyse & Build

13 weeks of real analytics work — every module ends with a dashboard or SQL case study pushed to GitHub and reviewed by a senior analytics manager.

📗
Week 1–2
Excel + Statistics Foundations
Pivot Tables, VLOOKUP/XLOOKUP, conditional formatting
Power Query — data cleaning and transformation
Descriptive statistics, probability basics
Business problem framing, KPI definition
🗄️
Week 3–4
SQL for Analytics
Joins, subqueries, GROUP BY, HAVING
Window functions — RANK, LAG, LEAD, running totals
CTEs, views, query optimisation
Real business case studies — revenue, retention queries
📊
Week 5–7
Power BI Mastery
Data modelling — star schema, relationships
DAX — calculated columns, measures, time intelligence
Interactive dashboards — slicers, drill-through, bookmarks
Power BI Service — publishing, scheduled refresh, sharing
📈
Week 8
Tableau Dashboards
Tableau calculated fields and parameters
Dashboard design principles — layout, storytelling
Story Points for executive presentations
Tableau Public publishing
🐍
Week 9–10
Python Analytics + Gen AI
Pandas for automated reporting and data pipelines
Statistical testing — A/B tests, hypothesis testing
ChatGPT / Copilot for SQL and Excel formula assistance
Automating Excel/SQL reports with Python scripts
🚀
Week 11–13
Capstone + Placement Sprint
End-to-end capstone — business problem to dashboard
Client presentation skills and storytelling with data
Portfolio polish — published dashboards, GitHub case studies
Mock analytics interviews, 200+ company referrals
Data Analytics Portfolio

Real Dashboards You'll Actually Publish

Real business datasets, real SQL case studies, real published dashboards — the kind of portfolio that makes analytics hiring managers stop scrolling.

📈
Power BI · Sales
Executive Sales Dashboard
Power BI dashboard for a retail client — 12 DAX measures, drill-through by region/category/salesperson, YoY growth visuals, published to Power BI Service with live refresh.
Power BIDAXSQLPower Query
🛍️
SQL · Retention
Customer Retention Analysis
SQL-driven cohort analysis on subscription data — churn rate calculations, retention curve visuals, segmentation by customer lifetime value, presented in Tableau.
SQLCohort AnalysisTableauExcel
🤖
Gen AI · Reporting
AI-Assisted Analytics Bot
ChatGPT + Power BI Copilot workflow — natural language to SQL queries, auto-generated insight summaries from dashboards, weekly report automation with Python.
ChatGPTPower BI CopilotPythonSQL
🏥
Healthcare BI
Hospital Operations Dashboard
Power BI dashboard tracking bed occupancy, patient flow, department revenue — real-time KPI cards, drill-through to patient-level detail, role-based access control.
Power BIDAXRLSSQL Server
📑
Excel Automation
Finance Reporting Automation
Python + Pandas script automating a monthly finance report — pulls from multiple Excel files, applies business rules, generates formatted output, cut report time from 6 hours to 12 minutes.
PythonPandasExcelopenpyxl
📈
Tableau · Marketing
Marketing Campaign Performance
Tableau dashboard combining Google Ads, Meta Ads, and email campaign data — ROI by channel, story points for executive presentation, calculated fields for blended CAC.
TableauSQLExcelStory Points
Week by Week

Your Data Analytics Journey

From your first Pivot Table to a published executive Power BI dashboard — every week ends with a real deliverable.

Week 1–2
📗 Excel + SQL Foundations
Set up your analytics toolkit, master Excel Pivot Tables and Power Query, write your first SQL joins and aggregations on a real sales dataset by day 5.
📌 Deliverable: Cleaned dataset + first SQL report submitted
Week 3–5
🗄️ Advanced SQL Case Studies
Write window functions, CTEs, and complex joins to answer real business questions — top customers, regional performance, churn signals — across multiple linked tables.
📌 Deliverable: 5 SQL case studies documented on GitHub
Week 6–7
📊 Power BI Dashboard for Real Client
Receive an actual client brief, build a Power BI dashboard with DAX measures, drill-through reports, and publish to Power BI Service — then present to the mentor panel.
📌 Deliverable: Published Power BI dashboard + client presentation deck
Week 8–10
📈 Tableau + Python Automation
Build a second dashboard in Tableau with story points for executive storytelling. Automate a recurring Excel report using Python and Pandas — saving real hours of manual work.
📌 Deliverable: Tableau dashboard + Python automation script
Week 11
🤖 Gen AI for Analytics Workflow
Use ChatGPT and Power BI Copilot to accelerate SQL writing and report generation. Build an AI-assisted weekly reporting workflow that demonstrates modern analytics practice.
📌 Deliverable: AI-assisted reporting workflow demo
Week 12–13
💼 Portfolio + Placement Sprint
Polish GitHub case studies, finalise your published dashboard portfolio. 10+ mock analytics interviews — SQL rounds, Excel case studies, dashboard walkthroughs, HR. Direct referrals to 200+ companies.
🎉 Goal: Data Analyst Offer Letter in Hand
Data Analytics Placement Accelerator

We Don't Stop Till
You're Hired as an Analyst

Data Analyst roles are among the highest-volume hiring categories in India — but they demand real dashboard portfolios, not just certificates. Our placement team connects your published work directly with analytics teams, consulting firms, and product companies hiring now.

1,100+
Analytics professionals placed
200+
Hiring partner companies
₹9L
Highest analytics offer
4.9★
Google rating from alumni
01
Dashboard Portfolio Packaging
Published Power BI and Tableau dashboards with live links, documented SQL case studies, Excel automation projects — the evidence hiring managers check before calling.
02
ATS Resume + LinkedIn for Analyst Roles
SQL, Power BI, Tableau, Excel, and Python keyword-rich resume and LinkedIn targeting Data Analyst, Business Analyst, and BI Developer roles.
03
10+ Analytics Mock Interviews
SQL case studies, Excel scenario tests, dashboard walkthroughs, business case studies — written feedback with specific improvement areas after every session.
04
Direct Referrals to Analytics Companies
Your portfolio shared with hiring teams at TCS iON, Accenture, Deloitte, Amazon, Flipkart, and analytics consulting firms — warm intros not cold applications.
05
Certification Guidance
Guidance for Microsoft Power BI Data Analyst (PL-300), Google Data Analytics, or Tableau Desktop Specialist — credentials that pair with your portfolio.
Data Analytics professionals from Medha EduTech are hired at
Data Analytics Alumni Stories

From Excel Beginner to Data Analyst

Real analytics alumni. Real dashboards they published. Real offers that launched their careers.

↑ 280% hike
"

The Accenture interviewer asked me to walk through a Power BI dashboard. I opened a live dashboard I'd built for a real retail client during the internship — DAX measures, drill-throughs, the works. They said it was the most polished work they'd seen from a fresher candidate that month. Offer came two days later.

NK
Navya Krishnan
Data Analyst
@ Accenture — ₹7.8 LPA
↑ 230% hike
"

The SQL case study round at Deloitte was what I was most worried about. But I'd spent weeks writing window functions, CTEs, and complex joins on real datasets during the internship. I finished their test in 30 minutes when they gave us 60. Got the offer two days later.

RS
Rahul Sharma
Business Analyst
@ Deloitte — ₹7.2 LPA
↑ 350% hike
"

I switched from a back-office data entry job to analytics at 25. The Excel automation project I built — cutting a 6-hour monthly report to 12 minutes with Python — was what got me the TCS iON role. Nobody else in that hiring round had built something that actually saved a company real time.

PM
Preethi Menon
Data Analyst
@ TCS iON — ₹7 LPA
↑ 260% hike
"

Building the cohort retention analysis in SQL was the project that surprised WNS most in the interview. I explained the churn calculation logic, why I chose specific time windows, and backed every chart with the underlying query. They said it showed analytical thinking they usually only see in candidates with experience.

VN
Varun Naik
Data Analyst
@ WNS Global — ₹6.8 LPA
↑ 300% hike
"

The hospital operations dashboard I built with row-level security became the centrepiece of my portfolio. Tiger Analytics' panel spent 20 minutes asking me about the data model design and the RLS implementation. It was the most enjoyable interview I've ever had — they were genuinely impressed by a fresher's work.

AK
Asha Kapoor
BI Developer
@ Tiger Analytics — ₹8.5 LPA
↑ 240% hike
"

The marketing campaign dashboard I built in Tableau, blending Google Ads and email campaign data into one ROI view, is exactly the kind of work I do at Amazon now on day one. The internship didn't just teach me tools — it taught me how to think about what a business actually needs to see.

DN
Deepak Nair
Business Intelligence Analyst
@ Amazon India — ₹9 LPA
Apply Today · Data Analytics Track

Your first SQL report.
Your first published dashboard.
Your first analyst offer.

Applications open for the next Data Analytics batch — only 12 seats. Free to apply. We'll call you in 30 minutes.

📈
Apply for Data Analytics Internship
We'll call you within 30 minutes — 9 AM to 9 PM, every day.

Free to apply. Merit-based selection. No spam, ever.

Real Business Datasets
Published Power BI Dashboards
Advanced SQL Case Studies
200+ Hiring Partners
Zero Hidden Costs

Contact Us