Data Analyst Bootcamp: Excel, SQL & Python (2026)

Learn data analysis with Excel, SQL & Python: dashboards, queries, automation & real-world projects.

  • 0.0 (0 Reviews)
  • 0 Students
  • 119 Lessons
  • Shubham Pareek

Course Overview

Become a Data Analyst with practical, job-ready skills using Excel, SQL, and Python — even if you’re starting from scratch.

This is a complete Data Analyst Bootcamp with real-world projects, designed to teach you how data analysis actually works in real companies.

Instead of learning tools separately, you will follow a structured path:
=> Excel → SQL → Python → Real Projects

What makes this course different?

  • Beginner-friendly and step-by-step learning path

  • Focus on practical data analysis skills

  • Real-world datasets and hands-on projects

  • Covers Excel, SQL, and Python together (not isolated)

In this course, you will learn:

  • Data analysis using Excel (formulas, dashboards, reporting)

  • Writing SQL queries for data extraction and analysis

  • Python fundamentals for data handling and automation

  • Data analysis using Pandas

  • Data visualization techniques

  • How tools work together in real analyst workflows

Hands-On Projects Include:

  • Excel dashboards and reports

  • SQL-based data analysis tasks

  • Python data analysis projects

  • Real-world datasets for practice

Course Structure:

  • Excel for Data Analysis (beginner to advanced)

  • SQL for Data Analysis (queries, joins, functions)

  • Python Basics & Projects

  • Python for Data Analysis (Pandas & visualization)

  • Additional tools and practice datasets

Who This Course Is For:

  • Beginners starting a career in data analysis

  • Students and fresh graduates

  • Professionals switching to data roles

  • Excel users upgrading to SQL and Python

  • Anyone preparing for entry-level data analyst jobs

Why Learn Data Analysis?

Data analysts are in high demand across industries.

With the right skills, you can:

  • Analyze business data

  • Create dashboards and reports

  • Support decision-making

  • Start a career in tech

By the end of this course, you will have the skills to work as a junior data analyst using Excel, SQL, and Python.

Start your journey today and build real-world data analysis skills.

See more

FAQ

FAQ area empty

Course curriculum

9 chương 119 bài học 30 giờ 44 phút 7 bài học thử miễn phí
Chương 1 Introduction & Roadmap
Chương 2 Excel Basics for Data Analysis
Chương 3 Excel Functions & Data Cleaning
  • Advanced Excel Functions 16:12
  • Text Functions 13:28
  • Nested IF 22:54
  • Data Cleaning & Validation 17:49
  • Deconstructing Data 14:47
  • Productivity Tools 20:35
  • Lookup & Reference 12:07
  • Vlookup, Hlookup, IFerror 10:06
  • Index Match 16:55
Chương 4 Excel Analysis, Charts & Projects
  • Mini Project 9:31
  • Monthly budget tracker 21:00
  • Practical Inventory Tracker + Salary Master 9:54
  • Charting & Visualization 11:20
  • Choosing the Right Chart 13:40
  • Combo Charts 12:32
  • Monthly Sales chart dashboard 9:59
Chương 5 Pivot Tables & Dashboards
  • Pivot Tables 16:18
  • Understanding Fields 11:56
  • Calculated Fields 18:18
  • Advanced Excel features 17:20
  • Dashboard Project: planning & setup 12:42
  • Cleaning & Structuring Data 13:06
  • Planning dashboard layout 9:39
  • Dashboard Project -2 8:27
  • Refreshing summary tables 11:58
  • Linking Form controls to charts 10:14
Chương 6 Excel Projects & AI
  • Project I 13:18
  • Project II 20:47
  • Project III 13:21
  • Project IV 19:15
  • Project V 17:13
  • Project VI 14:06
  • Project VII 24:09
  • Project VIII 12:44
  • Excel_ai- I 13:52
  • Excel_ai- II 15:18
  • Excel_ai- III 16:02
  • Excel_ai- IV 11:51
Chương 7 SQL for Data Analysis (Oracle Live SQL)
  • SQL 1 3:04
  • SQL 2 3:41
  • SQL 3 1:49
  • SQL 4 1:35
  • SQL 5 1:04
  • DRL - Data Retrieval Language 11:15
  • DML 1 0:38
  • DML 2 1:30
  • DML 3 6:19
  • DML 4 3:34
  • DML 5 4:17
  • Functions 1 0:44
  • Functions 2 2:01
  • Functions 3 6:36
  • Functions 4 14:23
  • Numeric 1 1:15
  • Numeric 2 8:11
  • Date Time 1 2:11
  • Date Time 2 3:08
  • JOINS 1 2:37
  • JOINS 2 7:40
Chương 8 Python Foundations & Projects
  • Introduction to Python 3:25
  • Software installation and writing our first program 7:54
  • Keywords operators typecasting 8:45
  • Variables datatypes comments indentation 9:26
  • Taking input from User 5:52
  • Conditional statements and loops 15:02
  • Functions and Scope 24:48
  • __name__==__main__ 5:05
  • Data Structures working with LISTS 15:32
  • Data Structures(working with tuples) 11:46
  • Data Structures(working with dictionaries) 10:45
  • Data Structures working with SETS 17:45
  • Calculator app 7:55
  • File Handling_1 22:40
  • Handling CSV files (csv module) 18:08
  • JSON File Handling 8:28
  • Error Handling 17:19
  • Understanding Classes and Objects in Python (OOP Basics) 22:47
  • Methods in Python OOP (Instance, Class & Static Methods) 17:51
  • The Four Pillars of Object-Oriented Programming in Python 19:30
  • Working with External Modules 9:16
  • API in Programming 13:44
  • Building a Weather App with OpenWeather API 16:49
  • To-do list or task manager 6:53
  • Flask – Building Web Apps - Copy 4:22
  • Machine Learning Basics with Python 33:23
  • (Pygame) Build a Simple Color Match Game in Python 27:01
  • Major Project - Expense Tracker 41:21
  • Data Analysis with Pandas 01 23:22
  • Data Analysis with Pandas 02 39:19
  • Data Visualization with Pandas and Matplotlib 42:34
  • Data Analysis Project with Pandas and Matplotlib 55:14
  • Python Web Scraping basics 10:37
  • Python Automation Automating Everyday Tasks 30:04
  • Python Databases Introduction to SQL 38:48
  • Python CRUD App with sqlite (fixed) 35:49
  • Chatbot (Major Project) 40:34
Chương 9 Additional Excel Topics
  • Chart 21:27
  • Chart 3D 29:04
  • New Chart 3D 29:04
  • Stacked Chart 30:24
  • Doughnut Chart 31:36
  • Funnel Chart 28:37
  • Map Chart 36:35
  • Histogram 22:04
  • Scatter Plot Chart 41:26
  • Data Validation 17:13
  • Superstore Sales Dataset (pdf file)
  • Macro and VBA 13:01

Requirment

  • No prior programming or data analysis experience required

  • Basic computer usage knowledge is enough

  • Willingness to learn and practice step by step

Outcomes

  • Analyze data using Microsoft Excel with formulas, functions, charts, pivot tables, dashboards, and projects

  • Clean, organize, and validate real-world data using Excel best practices

  • Create Excel dashboards and reports used in business and analyst roles

  • Write SQL queries to retrieve, filter, group, and analyze data from databases

  • Use SQL functions and JOINs to work with multiple tables

  • Learn Python fundamentals required for data analysis

  • Work with CSV and JSON files using Python

  • Perform data analysis using Python Pandas

  • Visualize data using Python charts and plots

  • Understand when to use Excel, SQL, or Python in real data analyst workflows

  • Apply skills through practical projects and real datasets

  • Build a strong foundation for entry-level data analyst roles

Instructor

...
Shubham Pareek

0.0

  • ... 0 Student
  • ... 1 Course
  • ... 0 review

View Details

Reviews

Rate this course :

Remove all