Opening soonAI, ML and data scienceBeginner to intermediate

Data analytics course with SQL, Excel and dashboards

A live data analytics course for college students and job seekers, with no Python needed. You learn spreadsheets, SQL, data cleaning, charts and a free dashboard tool, and then tell the story behind the numbers. Small batches, Hinglish classes, and a mentor reviews every assignment.

Join the waitlist Book a free demo class

At a glance

Level: Beginner to intermediate
Duration: About 14 weeks · 4–5 hours a week
Syllabus: 8 modules, 4 capstone ideas
Format: Live online, small batch (max 30)
Language: Classes in Hinglish; code and notes in English
Fee: Announced when the batch opens

Tools

SQLite
PostgreSQL (introduction)
Excel or Google Sheets
Looker Studio
An AI assistant
GitHub

Who it's for

Is this course right for you?

College students who want a practical skill for internships and first jobs.
Job seekers and career switchers who want to work with data.
People who use Excel at work and want to learn SQL and dashboards.
Anyone who wants to answer business questions with data, without learning Python first.

Before you start

What you need

Basic computer use and comfort with numbers. School-level maths is enough.
A laptop or desktop with internet. Phones and tablets are not enough for this course.
A laptop or desktop with a stable internet connection

Please read: safe and age-appropriate use

AI assistants set their own minimum age and rules. Use them only as their terms allow, and never paste private data into them.

Outcomes

What you'll be able to do.

Real skills you can show — every project goes on your GitHub.

Use spreadsheet formulas and pivot tables to summarise data quickly.
Write SQL queries with filters, joins and GROUP BY to answer business questions.
Use window functions at an introductory level, such as running totals and rankings.
Clean messy data and check it before you trust it.
Choose the right chart and build a clear dashboard in a free tool.
Present findings as a short story with a recommendation, and check AI-written queries yourself.

Syllabus

Data Analytics with SQL, Excel and Dashboards syllabus, module by module.

Each module has a clear goal, live classes, a lab session and practice you push to GitHub. Your mentor reviews it and tells you exactly how to improve.

Module 1
Thinking like an analyst
Turn a vague business request into a clear question and a plan for the data you need.
- What data analysts do day to day
- Questions, metrics and the difference between data and insight
- Rows, columns, tables and keys in simple words
- Where data comes from: forms, apps, files and databases
- Setting up the course tools and a project folder
Excel or Google SheetsSQLiteA SQL viewer such as DB Browser for SQLite
Practice: Write three good questions for a college canteen or small shop dataset
Module 2
Spreadsheets: formulas and pivot tables
Calculate, sort, filter and summarise a table in a spreadsheet without mistakes.
- Cell references, absolute and relative
- Formulas for totals, averages, counts and conditions
- Lookup formulas to bring in data from another sheet
- Text, date and logic functions
- Pivot tables and slicers
- Common spreadsheet mistakes and how to check your own work
ExcelGoogle Sheets
Practice: Monthly sales summary with a pivot table
Module 3
SQL basics: SELECT, filters and sorting
Read from a database table and get exactly the rows and columns you need.
- Tables, columns and data types
- SELECT, WHERE, AND, OR, IN, BETWEEN and LIKE
- ORDER BY and LIMIT
- NULL values and how they surprise people
- Aggregates: COUNT, SUM, AVG, MIN, MAX
- Reading someone else's query
SQLiteDB Browser for SQLite
Practice: Answer ten questions from a student or sales database
Module 4
SQL joins and GROUP BY
Combine several tables and summarise them by group.
- Primary keys, foreign keys and how tables connect
- INNER JOIN and LEFT JOIN, with pictures and small examples
- GROUP BY and HAVING
- Counting correctly after a join, and how duplicate rows appear
- Subqueries and CTEs at a beginner level
- Checking a result by hand on a small sample
SQLitePostgreSQL (introduction)
Practice: Sales by city, product and month from a four-table shop database
Module 5
Window functions and date analysis
Answer ranking, running total and change-over-time questions with an intro set of window functions.
- What a window function is, compared with GROUP BY
- ROW_NUMBER, RANK, and running totals with OVER
- Comparing a row with the previous row, such as month-on-month change
- Working with dates: year, month and week groupings
- Top-N per group questions
SQLitePostgreSQL (introduction)
Practice: Top three products per month and a running total of sales
Module 6
Data cleaning and quality checks
Take a messy file, clean it step by step and keep a record of every change.
- Common problems: duplicates, blanks, wrong types, spelling variants and outliers
- Cleaning in a spreadsheet and in SQL
- Importing CSV files into a database
- Simple checks: row counts, totals before and after, and ranges
- Keeping the raw file untouched and documenting your steps
Excel or Google SheetsSQLite
Practice: Clean a messy customer list and show before-and-after counts
Module 7
Charts and dashboards
Pick the right chart and build a one-page dashboard with filters in a free tool.
- Choosing a chart: bar, line, pie (and when not to use it), scatter and table
- Honest axes, colour and labels
- Charts in a spreadsheet
- Building a dashboard in a free tool such as Looker Studio, with Google Sheets or a CSV file as the source
- Filters, KPI cards and a clear layout
- Optional: a look at Power BI Desktop and its free version
Google SheetsLooker StudioExcel
Practice: A one-page sales or attendance dashboard with three filters
Module 8
Storytelling, AI help and capstone
Present your analysis as a short story, use an AI assistant wisely and finish a portfolio project.
- Structure of a data story: question, finding, evidence, recommendation
- Writing a short summary for a manager who has two minutes
- Using an AI assistant to draft and explain SQL queries and formulas
- Checking AI output: test on a small sample, compare with a manual answer, read every line
- Never pasting private or customer data into an AI tool
- Portfolio, resume lines and a GitHub or shared-folder write-up
An AI assistantLooker StudioGitHub
Practice: Capstone: a full analysis with SQL, a dashboard and a five-slide or one-page summary

What a class looks like

One live session, step by step.

So you know exactly what to expect before you join.

0–10
Warm-up question: one small data puzzle from last week.
10–40
The mentor shows a new idea on real data, in a spreadsheet or a SQL window.
40–70
You practise on your own laptop with a worksheet while the mentor helps.
70–90
Compare answers, check results for mistakes, and set the weekly assignment.

Projects

Capstone projects you can build.

Pick one, plan it like a real team with tickets, build it, and present it. It becomes the centrepiece of your portfolio.

Retail sales dashboard
Use SQL to analyse a shop's orders, products and customers, then build a dashboard that shows sales and top products.
College attendance and results analysis
Clean an anonymised sample dataset, find patterns by section and subject, and present three recommendations.
Food delivery order analysis
Study order times, areas and ratings in a practice dataset, and show where delays and drops happen.
Personal budget tracker
Use a spreadsheet and a simple database to track spending by month and category, with a clear chart summary.

Opening soon

Be first in the Data Analytics with SQL, Excel and Dashboards batch.

This specialisation isn't scheduled yet. Join the waitlist and we'll tell you first when a batch opens. We open the courses with the most interest first.

Where it can lead

Roles this skill helps you towards

Junior data analyst
Business or operations analyst
MIS or reporting executive

No course can guarantee a job. We help you build real skills, real projects and a portfolio you can show.

FAQ

Data Analytics with SQL, Excel and Dashboards: your questions.

When does the batch start?

The batch is not scheduled yet. Join the waitlist and we will tell you first when dates are fixed. The first batch is preceded by a free demo class.

Do I need to know programming or Python?

No. This course uses spreadsheets and SQL. If you later want Python, the Data Science with Python course is the next step.

Which tools will I need, and do they cost money?

We choose free tools where we can: SQLite, Google Sheets, Looker Studio and a free SQL viewer. Excel is useful if you have it, and Google Sheets covers the same ideas. Tool plans can change, so we confirm the list before the batch.

Why SQLite and not a bigger database?

SQLite installs in minutes and runs SQL well enough for learning. We also show PostgreSQL, so you see how the same queries work on a server database.

Is this course in Hindi?

Classes are in Hinglish. Notes, queries and datasets are in English, as at most workplaces.

Can an AI assistant do my SQL for me?

It can draft queries, but it can also be wrong with full confidence. We teach you to use it as a helper and to check every result yourself, so you can explain your own numbers in an interview.

Keep going

Related courses.

Opening soonBeginner to intermediate
Data Science with Python
A live data science with Python course for students who already know basic Python. You clean real data, draw charts, use statistics and build first prediction models. Small batches, Hinglish classes, and a mentor reviews every assignment.
14 weeks · 7 modules
Included in Starter and BuilderBeginner to intermediate
Python Programming
This Python course takes you from your very first line of code to useful programs, games, scripts and data tools. Classes are live, in small batches of up to 30, taught in Hinglish, and a mentor reviews every assignment you push to GitHub. Python is taught inside our Starter and Builder programs.
24 weeks · 10 modules
Opening soonBeginner
The AI Toolkit
This course helps you pick the right AI tool for each job without hype or brand bashing. You compare ChatGPT, Gemini, Claude and others on real tasks, learn privacy settings and free versus paid limits, and build a personal AI workflow. Live small batch, taught in Hinglish, so it also works as a ChatGPT course in Hindi and English. No coding needed.
5 weeks · 6 modules
Opening soonIntermediate
Machine Learning with Python
A hands-on machine learning with Python course for students who know Python basics. You learn how models learn from data, build them with scikit-learn and check them honestly. Live classes in small batches, and a mentor reviews every assignment.
14 weeks · 8 modules

All courses

Baking your code to give you a pie

Start with one free class.

Join a live demo class, meet the mentor and see how a CodeBakerz batch works. No payment, no pressure — decide after.

Book a free demo class Enrol in a program

Free demo class

Data analytics course with SQL, Excel and dashboards

Data analytics course with SQL, Excel and dashboards

Is this course right for you?

What you need

What you'll be able to do.

Data Analytics with SQL, Excel and Dashboards syllabus, module by module.

Thinking like an analyst

Spreadsheets: formulas and pivot tables

SQL basics: SELECT, filters and sorting

SQL joins and GROUP BY

Window functions and date analysis

Data cleaning and quality checks

Charts and dashboards

Storytelling, AI help and capstone

One live session, step by step.

Capstone projects you can build.

Retail sales dashboard

College attendance and results analysis

Food delivery order analysis

Personal budget tracker

Be first in the Data Analytics with SQL, Excel and Dashboards batch.

Data Analytics with SQL, Excel and Dashboards: your questions.

Related courses.

Start with one free class.

Data analytics course with SQL, Excel and dashboards

Is this course right for you?

What you need

What you'll be able to do.

Data Analytics with SQL, Excel and Dashboards syllabus, module by module.

Thinking like an analyst

Spreadsheets: formulas and pivot tables

SQL basics: SELECT, filters and sorting

SQL joins and GROUP BY

Window functions and date analysis

Data cleaning and quality checks

Charts and dashboards

Storytelling, AI help and capstone

One live session, step by step.

Capstone projects you can build.

Retail sales dashboard

College attendance and results analysis

Food delivery order analysis

Personal budget tracker

Be first in the Data Analytics with SQL, Excel and Dashboards batch.

Data Analytics with SQL, Excel and Dashboards: your questions.

Related courses.

Start with one free class.