Automated portfolio website to showcase your work
Unlimited daily doubt clearance support via private discord community
Dedicated module to become AI-enabled Data Analyst
Practical job assistance (Resume & Interview preparation + Interview leads + Building online credibility)
Real-time industry-based projects in FMCG, Hospitality, Insurance & Telecom domains & Finance, Sales, Marketing, HR & Supply Chain departments
Complex datasets that have more than 7 million records like you will get in a company
Highly engaging content with the cinematic experience, real business practice problems, business meetings, etc.
Easy explanation of complex topics by Dhaval Patel, a famous Youtuber (906k+ subs) teacher & active data industry expert
Real-time tasks prepared by Hemanand Vadivel, a data analytics leader with 8+ years of experience in Europe
No Questions Asked Refund Policy
Within 30 days of enrollment
If you have already taken any of our paid data analytics courses, you pay only the difference
(Bootcamp price - course price)
Bootcamp Brochure
DownloadKey reasons
We don't make fake job guarantees. But our learners get placed.
30 days refund. No questions asked.
Discounts? We believe in honest pricing!
It's not a boring course. It's an engaging experience.
Social Proof from
Our content is rated 4.9/5 from 29650+ Learners
Aspiring Data Analyst
Cluster Manager - Operations
Manager- Financial Planning & Analysis
I just finished the Data Analyst Bootcamp by Codebasics, and it was a total game-changer for my career. This program went above and beyond my expectations, giving me a hands-on learning experience that boosted not only my technical skills but soft skills also.
What stood out the most was the well-organized curriculum. Codebasics planned it out carefully, covering all the important topics for a data analyst. Each section built on what I learned before, making it easy to follow and understand. The best part was the practical projects during the internship.
The projects were based on real-world scenarios, and I got to use what I learned in a really useful way and what made it even better was having instructors readily available to assist with any challenges encountered during these projects. Plus, being part of a community of learners meant we could share our experiences and learn from each other. It made the whole learning experience collaborative and enjoyable.
Overall, Codebasics' Data Analyst Bootcamp rocks! The well-thought-out curriculum, hands-on projects, and supportive community make it an excellent choice for anyone wanting to kickstart or advance their career in data analysis. I'm so glad I took this bootcamp and would recommend it to anyone interested in the field!
Broadcast Analyst
5 star is very less for this amazing bootcamp course. Currently I am working as an application consultant, where I have to guide users how they can use the application to improve their business where I have to do some analysis based on data. This course has helped me a lot. The price and the quality of the content is no one can match. Thank you so much Dhaval sir for making this course. I am also learning DSML course from a very known online platform, but this content is far better than them and they are charging a hefty money for their course. Thank you again Dhaval Sir and Hemanand Sir.
Sr. Software Consultant
Before the course started, I was afraid of learning Python because of coding. After the course ended, I find myself voluntarily attending Python quizzes on Google and eagerly awaiting Python quizzes on Discord. The lesson I've learned is to break your fear by facing it. Thanks Dhaval Sir.
B.Tech., (CSE)
Thank you for well-managed and customized course. Its so nicely explained even a beginner will be hassle-free while learning it. This course is highly recommended to those who either wants to learn data analysis or are on the verge of building a portfolio(like me).
Data Analyst
Completing the Advanced Excel course was an absolute game-changer for me! From Power Query to DAX, each module was packed with exciting features that completely transformed the way I work with data. Learning to unleash Excel's full potential has been an exhilarating journey, and I feel equipped to tackle any data challenge with confidence. Highly recommend this course to anyone ready to take their Excel skills to the next level! A heartfelt thanks to Peter Pandey for his enthusiastic learning spirit and to Tony Sharma for his passionate business teachings.
Data Science Intern
You can
Use Python, SQL, Excel, and Power BI to provide insights to the executive team in the insurance industry. This is a virtual internship project that simulates working on a client project and involves ad-hoc tasks and final solution implementation.
You will generate revenue insights in hospitality domain by performing data cleaning, data transformation and insights generation using Python and Pandas.
You will implement end to end data analytics solution (along with deployment) in Power BI to generate insights for finance, sales, marketing and supply chain departments in an FMCG company
Create a scenario planning tool in Excel to meet gross margin target. You will analyze best, realistic and worst case scenarios based on various business metrics such as net sales, discount percentage, gross margin, spread between the margin and the target etc.
A project manager is experiencing difficulties in prioritizing projects. To assist them, you will create an Excel tool for a project priority matrix that utilizes a feasibility/impact analysis to prioritize projects effectively.
Overview
00:42 on-demand video
15 Lectures
15 Lectures
Why Should You Become a Data Analyst?
How Do I Know If The Data Analyst Role Is Suitable For Me?
Is Computer Science Degree / Young Age / Relevant Work Experience Mandatory?
What Kind of Job Assistance Do You Provide?
How Do I Get Doubt-Clearing Support? (Discord)
How Much Time Do I Need to Complete The Bootcamp?
Do I get a Real Internship Certificate After Completing a Virtual Internship?
Do the Creators of This Bootcamp Have Real Industry Experience?
How Many Business Projects Will I Complete in This Bootcamp?
How can I Trust That This Bootcamp Has the Best Content on Planet Earth?
What Domain and Functional Knowledge Will You Build and How?
What are the Soft Skills I Will Acquire By the End of Bootcamp?
Bootcamp Syllabus Overview
How Will I Be Informed About The Monthly Live Webinars?
System Requirements
09:01 on-demand video
70 Lectures
12 Lectures
Peter Pandey’s Journey and Need to Learn Excel
Installing Excel: Windows / Mac
Getting Familiar With Excel
Getting More Familiar With Excel
Introduction to Formulas
Formula Behavior
Introduction to Tables
Introduction to Charts
Other Essential Features
Peter Gets His First Assignment From His Senior
Practice Exercise: Personal Expense Tracker
Quiz
8 Lectures
Basic Maths to Business Metrics (Bollywood movies revenue avg)
Commonly Used Business Metrics (P&L)
Commonly Used Statistic Concepts (Mean, Median, Mode)
Commonly Used Statistic Concepts (Variance, Standard Deviation)
Commonly Used Statistic Concepts (Correlation)
Peter Gets to Solve a Real Time Problem
Practice Exercise
Quiz
13 Lectures
Pivot Table Introduction: Apple Product Sales
Pivot Table For Movie Analytics
Creating a Report Using Pivot Table
Pivot Table Options & Formatting
Using Power Pivot & DAX For Powerful Business Reports
Adding Targets Using Data Modelling in Power Pivot
Breaking Down Complex Problems: Thinking Process of a Highly Paid Data Analyst
More Business Metrics and Conditional Formatting
VBA Basics & How Much VBA You Should Learn
Peter Practices On His Own
Practice Exercise
Quiz
I Need a Favour
11 Lectures
ETL (Extract, Transform and Load Data) in Excel I
ETL (Extract, Transform and Load Data) in Excel II
Business Report: Solution Design Thought Process
Creating Connections Among Tables Using Data Modelling
Adding a Date Table Using Power Query
Functional Knowledge: Sales
Sales Analytics: Creating Customer Performance Report
User Empathetic Report Design
Sales Analytics: Creating Market Performance vs Targets Reported
Practice Exercise
Quiz
00:17 on-demand video
4 Lectures
20:10 on-demand video
122 Lectures
13 Lectures
Install Power BI
Power BI: Tool Introduction
Power Query: Intro & Column Transformations
Power Query: Merging and Appending
Power Query: Best Practices
Introduction to DAX
Introduction to DAX - II
Introduction to Data Modeling
Introduction to Creating Visuals
Tony asks Peter to Fix Data Holes
Practice Exercise
Chapter Summary
Quiz
9 Lectures
Problem Statement
The Email that Started this Project
Project Kick-off Meeting
Learn how a ‘Project Charter’ is Used in Companies
Project Kick-off: Session Debrief
Senior Data Analyst Sets Up the Next Steps with Junior Data Analyst
Simplified: Profit and Loss Statement
Chapter Summary
Quiz
10 Lectures
Simplified: Data Warehouse, OLTP vs OLAP, Data Catalog
Install MySQL and Import Data
Simplified: Data Exploration Using SQL, Star Schema, Fact vs Dimension Tables
Load and connect data with MySQL (instructor)
Create a Date Dimension Table
Validate Data against Benchmark Numbers
Tony’s Valuable Advise to Peter
Practice Exercise
Chapter Summary
Quiz
11 Lectures
Power Query or DAX for Generating Calculated Columns?
Data Modelling: Star and Snowflake Schema
Data Modeling: Connect Dimensions with Fact Tables
Simplified: Why Do We Need Dimension Tables?
Mentor Talk: Congratulations! You are Levelling Up!
Create Calculated Columns Using DAX
Easy Way to Verify Your Numbers in Power BI
Assignment: Optimize Report and Reduce File Size by 25 %
I Need a Favour
Chapter Summary
Quiz
15 Lectures
Finance View: Prepare a List of Metrics
Simplified: Calculate Function & Filter Context
Finance View: Creating Metrics
Finance View: Create P&L Table Structure
Finance View: Create Last Year (LY) Column
Finance View: Build an Ultimate DAX Measure for P & L Table Structure - I
Finance View: Build an Ultimate DAX Measure for P & L Table Structure - II
Finance View: Create ‘Quarters’ & ‘YTD/YTG’ Slicers
Mentor Talk: Figuring Out Solutions
Finance View: Create a Line chart to Show Performance Over Time
Finance View: Build Top Product, Market & Region Visuals
Intermediate Review: I Met Product Owner Nick and He Gave this Feedback!
Finance View: Add Net Profit
Chapter Summary
Quiz
10 Lectures
Review Sales View Mockup
Sales View: Build Top Customers & Performance Matrix Visuals
Sales View: Build Product Performance & Unit Economics Visuals
Build Marketing View
Simplified: Supply Chain Basics
Supply Chain View: Review Mock Up
Supply Chain View: Build Key Measures
Supply Chain View: Build Visuals
Chapter Summary
Quiz
16 Lectures
Stakeholder Analysis and its Significance
Peter Recalls the Stakeholder Mapping Meeting
Stakeholder Review Meeting: How did it Go?
This is the secret to be ‘Job Ready’!
Practice Exercise: Quick Fixes
Quick Fix: Chg% formula
Practice Exercise: Implementing Dynamic Benchmark
Practice Exercise: Adding Dynamic Slicer to Filter Visual
Practice Exercise: Create a Toggle Button to Switch between Two Visuals
Practice Exercise: Create a Tool Tip to Show Trend
Learn: Adding Market Share Data
Practice Exercise: Create an Executive Dashboard
Learn: Performance Optimization
Learn: Fix Data Quality Issues
Chapter Summary
Quiz
11 Lectures
Solution: Quick Fixes
Solution: Implementing Dynamic Targets (Add Targets)
Solution: Implementing Dynamic Targets (Create a dynamic switch between Targets and LY)
Solution: Implementing Dynamic Targets (P & L visuals to compare Target or LY based on selection)
Solution: Adding Dynamic Slicer to Filter Visual
Solution: Create a Toggle Button to Switch between Two Visuals
Solution: Create a Tool Tip to Show Trend
Solution: Create an Executive Dashboard (KPI Visuals)
Solution: Create an Executive Dashboard (Key Insights by Subzone )
Solution: Create an Executive Dashboard (Market Share Visual & Conditional Formatting)
Solution: Create an Executive Dashboard (Final Enhancements)
01:28 on-demand video
21 Lectures
7 Lectures
Get a Shareable Public Link For Your Power BI Project
Share Your Power BI Project with Potential Recruiters
Differentiate Your Work with New Design
How to differentiate your work - Expert Webinar
One More Power BI Project for Your Portfolio
Check Your Work With this Guided Project
One Step Closer to Your Dream Portfolio
11:14 on-demand video
84 Lectures
14 Lectures
Install MySQL: Windows
Install MySQL: Linux, Mac
Import Movies Dataset in MySQL
Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)
Exercise - Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)
Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)
Exercise - Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)
Summary Analytics (MIN, MAX, AVG, GROUP BY)
Exercise - Summary Analytics (MIN, MAX, AVG, GROUP BY)
HAVING Clause
Calculated Columns (IF, CASE, YEAR, CURYEAR)
Exercise - Calculated Columns (IF, CASE, YEAR, CURYEAR)
The Data God’s Blessing
Quiz
17 Lectures
Database Normalization and Data Integrity
Entity Relationship Diagram (ERD)
Mentor Talk: Art of Googling
Data Types: Numeric (INT, DECIMAL, FLOAT, DOUBLE)
Data Types: String (VARCHAR, CHAR, ENUM)
Data Types: Date, Time (DATETIME, DATE, TIME, YEAR, TIMESTAMP)
Data Types: JSON, Spatial (JSON, GEOMETRY)
Luck Favors the LinkedIn Post
Primary key
Foreign Key
Create a Database From an Entity Relationship Diagram - ERD
Import Data From a CSV File Into a Database
Insert Statement
Update and Delete
I Need a Favour
Expect the Unexpected: The Intermission Scene
Quiz
10 Lectures
Backlog Grooming Meeting: Gross Sales Report
User-Defined SQL Functions
Exercise: User-Defined SQL Functions
Gross Sales Report: Monthly Product Transactions
Gross Sales Report: Total Sales Amount
Exercise: Yearly Sales Report
Stored Procedures: Monthly Gross Sales Report
Stored Procedure: Market Badge
Benefits of Stored Procedures
Quiz
16 Lectures
Problem Statement and Pre-Invoice Discount Report
Performance Improvement # 1
Performance Improvement # 2
Database Views: Introduction
Database Views: Post Invoice Discount, Net Sales
Exercise: Database Views
Top Markets and Customers
Exercise: Top Products
The Two Most Important Skills for the Data Analyst
Window Functions: OVER Clause
Window Functions: Using it in a Task
Exercise: Window Functions: OVER Clause
Window Functions: ROW_NUMBER, RANK, DENSE_RANK
Exercise: Window Functions: ROW_NUMBER, RANK, DENSE_RANK
5 Ways SQL is Used in the Industry
Quiz
13 Lectures
Supply Chain Basics : Simplified
Problem Statement
Create a Helper Table
Database Triggers
Database Events
Temporary Tables & Forecast Accuracy Report
Exercise: CTE, Temporary Tables
Subquery vs CTE vs Views vs Temporary Table
User Accounts and Privileges
Database Indexes: Overview
Database Indexes: Composite Index
Database Indexes: Index Types
Quiz
07:13 on-demand video
62 Lectures
44 Lectures
Python Installation - Windows
Python Installation - Linux
Python Installation - Mac
How to Download Code and Get Help If I Have a Question?
Variables
Variables - Quiz
Variables - Exercise
Numbers
Numbers - Quiz
Numbers - Exercise
Strings
Strings - Quiz
Strings - Exercise
Lists
Lists - Quiz
Lists - Exercise
Install Pycharm
If Condition
If Condition - Quiz
If Condition - Exercise
For Loop
For loop - Quiz
For loop - Exercise
Functions
Functions - Quiz
Functions - Exercise
Dictionary and Tuples
Dictionary and Tuples - Quiz
Dictionary and Tuples - Exercise
Modules and Pip
Modules and Pip - Quiz
Modules and Pip - Exercise
File Handling
File Handling - Quiz
File handling - Exercise
Classes and Objects
Classes and Objects - Quiz
Classes and Objects - Exercise
Inheritance
Inheritance - Quiz
Inheritance - Exercise
Exception Handling
Exception Handling - Quiz
Exception Handling - Exercise
00:47 on-demand video
6 Lectures
02:45 on-demand video
15 Lectures
14 Lectures
Naveen gets an Interview call
Think like a Hiring Manager
Introducing Yourself
Answering Questions on projects
SQL Questions
Excel Questions
Power BI Questions
Presenting Insights
Scenario Based Questions
Behavioral Questions
Asking Questions to Hiring Managers
Hiring Managers Discussion
Knowledge Check
Checkpoint
00:14 on-demand video
8 Lectures
22 Lectures
Welcome Note
Your Onboarding Letter
Welcome Note From Your Manager
Let's dive right into Week 1!
Getting Help From Your Seniors / Fellow Team Members
Your First Task
Incoming Task Email 1
Have you completed this task?
Quality Check 1
Quality Check 2
Quality Check 3
Quality Check 4
Congratulations you have completed the first task of your internship.
Incoming Task Email 2
Have you completed this task?
Quality Check
Congratulations you have completed 2 tasks in a row!
You Need Scrum Training
Incoming Task Email 3
Have you completed the assigned task?
Scrum Knowledge Check
Congratulations you have completed week 1 Successfully.
33 Lectures
Let's dive right into Week 2!
Create This Variance Report
Incoming Task Email 1
Have you completed the assigned task?
Quality Check 1
Quality Check 2
Quality Check 3
Congratulations on finishing this task!
Incoming Task Email 2
Have you completed the assigned task?
Quality Check 1
Quality Check 2
Quality Check 3
Quality Check 4
Quality Check 5
Quality Check 6
Quality Check 7
Quality Check 8
Quality Check 9
Congratulations on successfully completing the task!
Incoming Task Email 3
Have you completed the assigned task?
Quality Check 1
Quality Check 2
Quality Check 3
Quality Check 4
Quality Check 5
You did an amazing job completing the task.
Critical Presentation Deck
Incoming Task Email 4
Have you completed the assigned task?
Presentation Submission
Congratulations
19 Lectures
Let's dive right into the Final 2 Weeks !
Can You Handle This Insurance Project?
Incoming Task Email: Feature List
Please don't share datasets
Have you completed the feature list?
Download Benchmark Feature List
Quality Check
Don’t Forget to Send A Mock Up to Client
Have you completed the mock up?
Incoming Task
Response from Client
Quality Check
Incoming Task Email: Dashboard Creation
Have you completed the dashboard?
Submission Checklist
Please don't share Datasets
Dashboard Submission
End Note
Get Your Certificate
00:00 on-demand video
14 Lectures
00:00 on-demand video
8 Lectures
6 Lectures
Beginners Guide to Job Seeking - Sep 23
6 Free Internet Tools to Get an Interview Call - Oct 23
How to differentiate your work - Expert Webinar
Smart Job Assistance Portal & Expert Resume Insights
Data Analytics Freelancing Essentials
Mechanical Engineer to Data Analyst at Ford Motors- Expert Webinar
Data analytics
Build the exact skills you need to launch or accelerate your data analytics career with quality teaching. Focus on building online credibility, attend virtual internship and become truly job ready.
Build online credibility
Network on Linkedin
Find the right jobs and companies
Craft an amazing resume and Linkedin profile
Ace the job interview
5,70,000 INR
Based on data from glassdoor.com
3,00,000
Based on data from linkedin.com
No Degree required.
Anyone can become Data Analyst
May we help you?
Sure, take this survey https://codebasics.io/find-your-match-da This survey tells you how much your natural interest matches the data analyst role. It also provides recommendations on the learning path.
No, a computer science degree or relevant work experience is not required. We have many success stories of folks from non-tech backgrounds successfully cracking into a data analytics career.
Yes, this boot camp will work for you even if you have not done coding or have a computer science background. The reason is a data analyst job does not require a lot of coding & this bootcamp prepares you from the basics for what's needed in the job.
Yes, you can enroll in this data analytics bootcamp. We have seen folks who learn data analytics at 40+ age and can still crack into the data analytics industry. Age doesn’t matter. What matters is your attitude!
Yes, we help you with resume and interview preparation along with that we help you in building online credibility, and based on requirements we refer candidates to potential recruiters.
The courses included in this data analytics bootcamp have been completed by 9000+ learners and many of them have secured a job which gives us ample confidence that you will be able to get a job. However, we want to be honest and do not want to make any impractical promises! Our guarantee is to prepare you for the job market by teaching the most relevant skills, knowledge & timeless principles good enough to fetch the job.
To keep the bootcamp affordable, we have kept the lectures as self-paced videos that you can watch at your convenience. However, there will be monthly seminars and live discord community support.
We have created every lecture of this data analytics bootcamp with the motive to explain everything in an easy-to-understand manner. While working on these lectures you could make mistakes in steps or have some doubts. You need to commit yourself to hold patience, make efforts & figure out the solution by googling in order to become truly job ready.
For any questions, that Google cannot answer or if you hit a wall - we got you covered!
You can join our active discord community, which is a dedicated platform to discuss & clear your doubts with fellow learners & mentors.
Our bootcamp is specifically designed for beginners with no prior experience in this field. The only prerequisite is that you need to have a functional laptop with at least 4GB ram, an internet connection, and a thrill to learn data analysis.
The datasets used in this bootcamp are crafted from scratch to mimic the real business world by consolidating our years of experience. The datasets not just contain more than a million rows but also cover multiple facets of the business.
We got you covered. Go ahead and watch this sales insights playlist: https://www.youtube.com/playlist?list=PLeo1K3hjS3uva8pk1FI3iK9kCOKQdz1I9
It is a high-quality material available for free-> If you like it and want to learn further then this bootcamp is the perfect extension.
Yes. No questions asked. No hidden conditions. You will get a 100% refund if you request a refund within 30 days of enrollment.
You can complete this data analytics bootcamp in 3-5 months if you devote 3 hours each day, 6 days a week.
Yes. This data analytics bootcamp is self-paced. You can learn on your own schedule.
You can expect to learn tech skills like Python, Excel, SQL, and Power BI along with other skills like basic project management, stakeholder management, communication skills, and Business knowledge for domains like Finance, Supply chain, Sales, and Marketing.
You need to complete at least 70% of the course and score 70% or more in the Final quiz. After completing the quiz, click “complete and get certificate” to download your certificate.
Yes, this bootcamp will certainly help because we cover the majority of the skills measured in these exams. However, please be informed that this course focuses on Job ready aspects and not on all aspects required to clear the exams.
In addition to this course, you might need to visit the official learning material designed by Microsoft which is available for free on their website.
Our website doesn't support an EMI option right now. But don't worry, you can still pay in installments by following these steps,
(1) First buy the Excel course which is priced at 900 INR (or 25$)
(2) After you have completed the Excel course, buy Power BI course (2700 INR or 50$)
(3) After completing the Power BI course, buy the BootCamp. You will pay 2700 INR (or 75 $)
This way you will pay in 3 installments (900 INR, 2700 INR and 2700 INR).
Remember that the BootCamp includes the same content from individual Excel and Power BI courses that you bought previously hence you will not lose anything in terms learning in your BootCamp curriculum.
Also, all the progress you made in these individual courses will be transferred to BootCamp automatically.
Note: Data Science courses are not part of the Data Analytics Bootcamp 2.0
If you have purchased all four data analytics paid courses, you just need to pay additional Rs.900 to attend our bootcamp 2.0
If you have purchased any of our data analytics courses, you can pay the difference amount to enroll in the bootcamp. For example, if you have already bought Power BI for Rs.2700 and SQL for Rs.900, the total cost would be Rs.3600. You can subtract this from the bootcamp price (Rs.6300 - Rs.3600 = Rs.2700) and pay Rs.2700 to enroll in the BootCamp 2.0.
Note: Data Science courses are not part of the Data Analytics Bootcamp 2.0
We are not able to provide any further discount as we already priced this data analytics bootcamp at the lowest price possible to make it pocket friendly for aspirants. However, we understand that there could be people with extreme financial difficulties and we will facilitate their learning through scholarship programs, periodically. Keep an eye on the Codebasics YouTube channel and also our resume project challenge page.
Till now 9000 + learners have benefitted from the quality of our courses. You can check the review section and also we have attached their LinkedIn profiles so that you can connect with them and ask directly.
Yes, Monthly webinar recordings will be provided. With each new monthly webinar, the older video will be replaced by the new one. As a boot camper, you will always have access to the latest monthly webinar.
The only Bootcamp you need to become a high paying data analyst. With Practical Job Assistance.