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 (840k+ 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 courses, you pay only the difference
(Bootcamp price - course price)
Bootcamp Brochure
DownloadSocial Proof from
Our content is rated 4.9/5 from 18317+ Learners
Data Aspirant At Codebasics
Data Scientist
Data Analyst, Freelancer, Varanasi
Site engineer, DK Group, Nashik
Product Introducer at Hoben Infotech
I must say it's a game-changer! This course is exactly what the market needs, and I wholeheartedly recommend it as the only path to pursue a data analyst career.
The team at codebasics.io deserves a standing ovation for their comprehensive approach to Power BI, SQL, and advanced Excel. It's not just a course; it's a transformational experience. Kudos to Dhaval Patel and Hemanand Sir.
Business Intelligence Analyst
Hi Dhaval Sir , I am Jeet Shah I enrolled in Data Analytics Bootcamp in April. I successfully converted Hindustan Gold for the Job of Data Analytics and also converted the Numerator for the job of Associate in Analyst Field . The things which you explained were really really very good and crisp and clear . I worked on the Project which you explained and also worked on LinkedIn and Github profile .
Thank you so so so much sir , being from Non-tech background and also completing my Graduation in 2023 with the Recession crisis in Market , I never thought that I would be able to get Full Time job and also multiple Internship Offers.
Thank you so much sir , I really appreciate the Handwork and Efforts you are putting in . I am also recommending my friends to Enroll into your course.
Data Analyst
I am delighted to inform you that I got a job as a Data Analyst after completing the bootcamp. I am overflowing with gratitude towards Dhaval Sir, Hemanand Sir, and the entire codebasics team for their exceptional guidance and unwavering support, which played a pivotal role in helping me achieve this milestone. I am immensely grateful to codebasics team.
I'm thoroughly enjoying my current role and the company, especially given its position in the financial sector. I'm continuously learning new concepts, many of which are closely aligned with the teachings of Dhavel Sir and Hemanand Sir. It's quite remarkable that the content from the recent office meeting about SQL star scheme, snowflake scheme, OLTP, and OLAP closely mirrored what I had learned from their classes. I'm truly grateful to codebasics for equipping me with a deeper understanding of complex issues.
Data Analyst Intern
This course excel: mother of business intelligence in data analyst boot camp helped me to one step forward to become a data analyst and succeed in career transition into data industry thank you sir for helping me to achieve this
student
Enrolling in the Code Basics Data Analytics BootCamp has been a fantastic decision for me. The combination of informative lessons and hands-on practice sessions, especially with Excel, has given me a deep understanding of data analysis. Working with Excel spreadsheets in real-world scenarios has made the learning process not only enjoyable but also incredibly practical. I'm truly appreciative of the comprehensive content and the emphasis on developing Excel skills, which are crucial in the field of data analysis. Highly recommended
Project Coordinator
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
17:10 on-demand video
100 Lectures
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
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
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
15 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
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
18 Lectures
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
70 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