Why this is the most effective data analytics bootcamp?
-
Automated portfolio website to showcase your work
-
Unlimited daily doubt clearance support via private Discord community
-
Dedicated module to become an AI-enabled data analyst (Effective Prompts, AI/ML Basics)
-
Practical job assistance (Resume & Interview preparation + Interview leads + Building online credibility)
-
Real-time industry-based projects in FMCG, Hospitality, Insurance, Telecom, Banking & Finance domain, 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 (1M+ subs) teacher & active data industry expert
-
Real-time tasks prepared by Hemanand Vadivel, a data analytics leader with 8+ years of experience in Europe
Recent Placements
125+ Recent Placements
![Belayat Hossain](https://images.codebasics.io/filters:format(webp)/fit-in/120x120/uploads/placementData/Belayat.jpg)
Belayat Hossain
Zaber & Zubair Fabrics Limited
Dhaka, Bangladesh
Deputy Manager & Head of Quality (Proton Mobile)
Manufacturing Data Analyst
![Roshan Sharma](https://images.codebasics.io/filters:format(webp)/fit-in/120x120/uploads/placementData/Roshan Sharma.jpg)
Roshan Sharma
XDBS Worldwide
Pune
Data Aspirant
Market Research Analyst
![Kasikota Mani Deepika](https://images.codebasics.io/filters:format(webp)/fit-in/120x120/uploads/placementData/Kasikota Mani Deepika.jpg)
Kasikota Mani Deepika
P&G
Hyderabad
Data Aspirant
Strategic Planning Analyst
![Manisha Deepshikha Patra](https://images.codebasics.io/filters:format(webp)/fit-in/120x120/uploads/placementData/Manisha Deepshikha Patra.jpg)
Manisha Deepshikha Patra
Chubb
Bhubaneswar
Junior Data Analyst
Business Analyst
![Agatheesh Senthil .Y](https://images.codebasics.io/filters:format(webp)/fit-in/120x120/uploads/placementData/Agatheesh Senthil .Y.jpg)
Agatheesh Senthil .Y
RPM Performance Coatings Group, Inc.
Coimbatore
Data Aspirant
Junior Associate - Pricing
![Dipesh Suthar](https://images.codebasics.io/filters:format(webp)/fit-in/120x120/uploads/placementData/Dipesh Suthar 21.jpg)
Dipesh Suthar
Pacific Data Integrators
Delhi
Data Aspirant
Jr. Data Engineer
![Harshitha Chandaluri](https://images.codebasics.io/filters:format(webp)/fit-in/120x120/uploads/placementData/Harshitha Chandaluri.jpg)
Harshitha Chandaluri
Accelalpha Software solutions
Hyderabad
Associate Software Engineer
Junior Data Analyst
Key Reasons
Why Should You Enroll in This Data Analytics Bootcamp?
![Industry projects-based bootcamp created by hiring managers.](https://files.codebasics.io/v3/images-webp/bootcamp/buy-bootcamp/bootcamp-3-new.webp)
Industry projects-based bootcamp created by hiring managers.
![We don't make fake job guarantees. But our learners get placed.](https://files.codebasics.io/v3/images-webp/bootcamp/SmartJobAssistancePortal.webp)
We don't make fake job guarantees. But our learners get placed.
![It's not a boring course. It's an engaging experience.](https://files.codebasics.io/v3/images-webp/bootcamp/buy-bootcamp/why-us.webp)
It's not a boring course. It's an engaging experience.
![30 days refund. No questions asked.](https://files.codebasics.io/v3/images-webp/bootcamp/buy-bootcamp/full-refund.webp)
30 days refund. No questions asked.
1088 learners have created their portfolio websites
Explore PortfoliosHear It From
Our Happy Learners
Our content is rated 4.9/5 from 37808+ Learners
![testimonial-video-3872](https://images.codebasics.io/filters:format(webp)/fit-in/600x600/uploads/video_testimonials/video_thumbnail/18959/223799_669f57de8d195prateeek-bhikadiya.png)
BI Reporting Analyst - III
Landed a Job
![testimonial-video-3871](https://images.codebasics.io/filters:format(webp)/fit-in/600x600/uploads/video_testimonials/video_thumbnail/297964/223799_669f502125e3eprateeek-pritam-1.png)
Junior Data Analyst
Landed a Job
![testimonial-video-3890](https://images.codebasics.io/filters:format(webp)/fit-in/600x600/uploads/video_testimonials/video_thumbnail/223799/223799_66a0ae5f41f96timothy-kabwe.png)
IT Support Technician
![testimonial-video-3270](https://images.codebasics.io/filters:format(webp)/fit-in/600x600/uploads/video_testimonials/video_thumbnail/146809/223799_66a0abbc5f571mohd-akif.png)
Junior Data Analyst
Landed a Job
The bootcamp's intention of preparing the learners with the interpersonal/soft skills along with the technical skills and leveraging online platforms like LinkedIn for building a personal brand and preparing and pushing us to showcase our learnings and projects has played a crucial role in building the required confidence to face interviews. Also, the codebasics team's recommendation to the hiring manager due to my efforts displayed on LinkedIn and Portfolio helped me to land this job.
BI & Analytics - Senior Officer (Data Analyst)
Landed a Job
I completed Excel and Power BI courses at boot camp. After completing the classes, I took part in "Code basics" online résumé challenges. My interview panel was impressed with my work, especially with all the dashboards I stated in my resume.
Data Analyst (Internship)
Landed a Job
1. Simple and clear knowledge of all the tools and technology.
2. Live projects and doubt clearance.
3. Resume preparation and interview guidance.
4. Last but not least, the amazing CB family and entire community.
Analyst
Landed a Job
The Bootcamp has created a significant boost in my career. It was mind-blowing and a total game-changer for me. Each and every section has been covered so neatly with project-based learning, which I love the most. Also, I would like to thank Dhaval Sir, Hemanand Sir, and the entire Codebasics team for their efforts in making our learning so energetic. Apart from technical skills, business knowledge, and communication skills have been covered so nicely.
Furthermore, their virtual internship program provides you with real industry-level projects, from receiving project mails to receiving final feedback from clients. In my case, before embarking on my virtual internship journey, I was selected in a company but was unable to complete it. However, I would suggest everyone to complete all the sections and also participate in the virtual internships. 🔥
Product Marketing Analyst
Landed a Job
The bootcamp was phenomenal for me, after completing it my technical and practical skills were greatly enhanced, enabling me to confidently showcase my abilities during the interview process and excel in my role.
MIS Executive
Landed a Job
You Can
Work On Real World Projects
That
Hiring Managers Like
![Codebasics work icon](https://files.codebasics.io/v3/images-webp/bootcamp/icon1.png)
Executive Insights: Insurance Domain
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.
![Codebasics work icon](https://files.codebasics.io/v3/images-webp/bootcamp/icon2.png)
Revenue Analytics:
Hospitality Domain
You will generate revenue insights in hospitality domain by performing data cleaning, data transformation and insights generation using Python and Pandas.
![Codebasics work icon](https://files.codebasics.io/v3/images-webp/bootcamp/icon3.png)
Business Insights
360: FMCG Domain
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.
![Codebasics work icon](https://files.codebasics.io/v3/images-webp/bootcamp/icon4.png)
Scenario Planning
Tool
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.
![Codebasics work icon](https://files.codebasics.io/v3/images-webp/bootcamp/icon5.png)
Project Priority
Matrix
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
What you'll learn in
this data analytics bootcamp
Welcome to The Bootcamp Experience
00:42 on-demand video
|
15 Lectures
Welcome to The Bootcamp Experience
15 Lectures
-
Why Should You Become a Data Analyst?
Free -
How Do I Know If The Data Analyst Role Is Suitable For Me?
Free -
Is Computer Science Degree / Young Age / Relevant Work Experience Mandatory?
Free -
What Kind of Job Assistance Do You Provide?
Free -
How Do I Get Doubt-Clearing Support? (Discord)
-
How Much Time Do I Need to Complete The Bootcamp?
Free -
Do I get a Real Internship Certificate After Completing a Virtual Internship?
Free -
Do the Creators of This Bootcamp Have Real Industry Experience?
Free -
How Many Business Projects Will I Complete in This Bootcamp?
Free -
How can I Trust That This Bootcamp Has the Best Content on Planet Earth?
Free -
What Domain and Functional Knowledge Will You Build and How?
Free -
What are the Soft Skills I Will Acquire By the End of Bootcamp?
Free -
Bootcamp Syllabus Overview
Free -
How Will I Be Informed About The Monthly Live Webinars?
Free -
System Requirements
Excel: Mother of Business Intelligence
09:01 on-demand video
|
70 Lectures
Excel Basics: Getting Started
12 Lectures
-
Peter Pandey’s Journey and Need to Learn Excel
-
Installing Excel: Windows / Mac
Free -
Getting Familiar With Excel
Free -
Getting More Familiar With Excel
Free -
Introduction to Formulas
Free -
Formula Behavior
Free -
Introduction to Tables
Free -
Introduction to Charts
Free -
Other Essential Features
Free -
Peter Gets His First Assignment From His Senior
Free -
Practice Exercise: Personal Expense Tracker
-
Quiz
Excel Basics: Applying Business Maths & Statistics
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
Excel Basics+: Creating Business Reports Using Pivot Table & Power Pivot
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
Excel Advanced: Sales Analytics
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
Start Building Your Online Credibility
00:17 on-demand video
|
4 Lectures
Get Job Ready: Power BI Data Analytics for All Levels 2.0
20:10 on-demand video
|
122 Lectures
Power BI Basics: Getting Started
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
Project Planning and Scoping
9 Lectures
-
Problem Statement
Free -
The Email that Started this Project
Free -
Project Kick-off Meeting
Free -
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
Power BI Basics: Data collection, Exploration & Validation
10 Lectures
-
Simplified: Data Warehouse, OLTP vs OLAP, Data Catalog
Free -
Install MySQL and Import Data
-
Simplified: Data Exploration Using SQL, Star Schema, Fact vs Dimension Tables
Free -
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
Power BI Advanced: Data Modeling & Calculated Columns
11 Lectures
-
Power Query or DAX for Generating Calculated Columns?
Free -
Data Modelling: Star and Snowflake Schema
Free -
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 %
Free -
I Need a Favour
-
Chapter Summary
-
Quiz
Power BI Advanced: Build Finance View
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!
Free -
Finance View: Add Net Profit
-
Chapter Summary
-
Quiz
Power BI Advanced: Build Sales, Marketing & Supply Chain View
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
Stakeholder review & Feedback implementation
16 Lectures
-
Stakeholder Analysis and its Significance
-
Peter Recalls the Stakeholder Mapping Meeting
Free -
Stakeholder Review Meeting: How did it Go?
Free -
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
Practice Exercise Solutions
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)
Building Online Credibility, Portfolio Projects & ATS Resume
01:28 on-demand video
|
21 Lectures
Power BI Project(s) for Your Portfolio!
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
SQL Beginner to Advanced For Data Professionals
11:14 on-demand video
|
84 Lectures
SQL Basics: Data Retrieval - Single Table
14 Lectures
-
Install MySQL: Windows
Free -
Install MySQL: Linux, Mac
Free -
Import Movies Dataset in MySQL
Free -
Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)
Free -
Exercise - Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)
Free -
Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)
Free -
Exercise - Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)
Free -
Summary Analytics (MIN, MAX, AVG, GROUP BY)
Free -
Exercise - Summary Analytics (MIN, MAX, AVG, GROUP BY)
Free -
HAVING Clause
Free -
Calculated Columns (IF, CASE, YEAR, CURYEAR)
Free -
Exercise - Calculated Columns (IF, CASE, YEAR, CURYEAR)
Free -
The Data God’s Blessing
Free -
Quiz
SQL Basics: Database Creation & Updates
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
SQL Advanced: Finance Analytics
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
SQL Advanced: Top Customers, Products, Markets
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
SQL Advanced: Supply Chain Analytics
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
Python For Beginner and Intermediate Learners
07:13 on-demand video
|
62 Lectures
Python Basics
44 Lectures
-
Python Installation - Windows
-
Python Installation - Linux
-
Python Installation - Mac
-
How to Download Code and Get Help If I Have a Question?
-
Variables
Free -
Variables - Quiz
-
Variables - Exercise
-
Numbers
Free -
Numbers - Quiz
-
Numbers - Exercise
Free -
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
Start Applying for Jobs
00:47 on-demand video
|
6 Lectures
Interview Preparation / Job Assistance
02:45 on-demand video
|
15 Lectures
Data Analyst Mock Interviews
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
Virtual Internship
00:14 on-demand video
|
8 Lectures
Week 1
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.
Week 2
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
Week 3 & 4
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
Tableau Mini
04:35 on-demand video
|
23 Lectures
DA 2.0: The AI Enabled Data Analyst
04:45 on-demand video
|
35 Lectures
Machine Learning/ AI Project Lifecycle
11 Lectures
-
10 Stages of AI Project Lifecycle
-
Requirements and Scope of Work (SOW)
-
Data Collection
-
Data Preparation & Exploratory Data Analysis
-
Feature Engineering
-
Model Selection & Training
-
Model Evaluation Metrics (Accuracy, Prediction, Recall & F1 Score)
-
Model Evaluation Metrics: When to use which Metric?
-
Model Fine Tuning
-
Model Deployment
-
Deployment & Monitoring Using ML Ops
Live Webinar
00:00 on-demand video
|
11 Lectures
Career Development Session
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
-
The Secret Behind Resumes and Portfolios That Landed Jobs: Decode with your Talent Manager
Practice Arena
Scenario Based - Interview Questions
SQL
18
Questions
-
Product Sales by Store in Bangalore
-
Analyzing Revenue from High-Demand, Premium Products
-
Calculating Total Revenue by Product Category
-
Identifying Unsold Products in Inventory
-
Analyzing Above-Average Salaries by Department
-
Identifying Top Customers by Average Purchase Amount
-
Analyzing Monthly Customer Retention Rates for Q2 2024
-
Identifying Store Leaders: Most Popular Products by Sales
-
Identifying APAC Markets for Atliq Exclusive
-
Sorting Unique Product Counts by Segment at Atliq Exclusive
-
Optimizing Costs: High and Low Manufacturing Costs at Atliq Exclusive
-
2020 Quarterly Sales Trends at Atliq Exclusive
-
Top 3 Products by Sold Quantities Across Divisions, FY 2021
-
2021 Sales Channel Performance at Atliq Exclusive
-
Segment Growth in Unique Products: 2020-2021 Analysis
-
Monthly Gross Sales Analysis for Atliq Exclusive Customer
-
Yearly Product Diversification Increase: 2020-2021
-
Top 5 Indian Customers by Pre-Invoice Discounts, 2021
Welcome to The Bootcamp Experience
00:42 on-demand video
|
15 Lectures
Welcome to The Bootcamp Experience
15 Lectures
-
Why Should You Become a Data Analyst?
Free -
How Do I Know If The Data Analyst Role Is Suitable For Me?
Free -
Is Computer Science Degree / Young Age / Relevant Work Experience Mandatory?
Free -
What Kind of Job Assistance Do You Provide?
Free -
How Do I Get Doubt-Clearing Support? (Discord)
-
How Much Time Do I Need to Complete The Bootcamp?
Free -
Do I get a Real Internship Certificate After Completing a Virtual Internship?
Free -
Do the Creators of This Bootcamp Have Real Industry Experience?
Free -
How Many Business Projects Will I Complete in This Bootcamp?
Free -
How can I Trust That This Bootcamp Has the Best Content on Planet Earth?
Free -
What Domain and Functional Knowledge Will You Build and How?
Free -
What are the Soft Skills I Will Acquire By the End of Bootcamp?
Free -
Bootcamp Syllabus Overview
Free -
How Will I Be Informed About The Monthly Live Webinars?
Free -
System Requirements
Excel: Mother of Business Intelligence
09:01 on-demand video
|
70 Lectures
Excel Basics: Getting Started
12 Lectures
-
Peter Pandey’s Journey and Need to Learn Excel
-
Installing Excel: Windows / Mac
Free -
Getting Familiar With Excel
Free -
Getting More Familiar With Excel
Free -
Introduction to Formulas
Free -
Formula Behavior
Free -
Introduction to Tables
Free -
Introduction to Charts
Free -
Other Essential Features
Free -
Peter Gets His First Assignment From His Senior
Free -
Practice Exercise: Personal Expense Tracker
-
Quiz
Excel Basics: Applying Business Maths & Statistics
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
Excel Basics+: Creating Business Reports Using Pivot Table & Power Pivot
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
Excel Advanced: Sales Analytics
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
Start Building Your Online Credibility
00:17 on-demand video
|
4 Lectures
Get Job Ready: Power BI Data Analytics for All Levels 2.0
20:10 on-demand video
|
122 Lectures
Power BI Basics: Getting Started
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
Project Planning and Scoping
9 Lectures
-
Problem Statement
Free -
The Email that Started this Project
Free -
Project Kick-off Meeting
Free -
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
Power BI Basics: Data collection, Exploration & Validation
10 Lectures
-
Simplified: Data Warehouse, OLTP vs OLAP, Data Catalog
Free -
Install MySQL and Import Data
-
Simplified: Data Exploration Using SQL, Star Schema, Fact vs Dimension Tables
Free -
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
Power BI Advanced: Data Modeling & Calculated Columns
11 Lectures
-
Power Query or DAX for Generating Calculated Columns?
Free -
Data Modelling: Star and Snowflake Schema
Free -
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 %
Free -
I Need a Favour
-
Chapter Summary
-
Quiz
Power BI Advanced: Build Finance View
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!
Free -
Finance View: Add Net Profit
-
Chapter Summary
-
Quiz
Power BI Advanced: Build Sales, Marketing & Supply Chain View
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
Stakeholder review & Feedback implementation
16 Lectures
-
Stakeholder Analysis and its Significance
-
Peter Recalls the Stakeholder Mapping Meeting
Free -
Stakeholder Review Meeting: How did it Go?
Free -
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
Practice Exercise Solutions
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)
Building Online Credibility, Portfolio Projects & ATS Resume
01:28 on-demand video
|
21 Lectures
Power BI Project(s) for Your Portfolio!
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
SQL Beginner to Advanced For Data Professionals
11:14 on-demand video
|
84 Lectures
SQL Basics: Data Retrieval - Single Table
14 Lectures
-
Install MySQL: Windows
Free -
Install MySQL: Linux, Mac
Free -
Import Movies Dataset in MySQL
Free -
Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)
Free -
Exercise - Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)
Free -
Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)
Free -
Exercise - Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)
Free -
Summary Analytics (MIN, MAX, AVG, GROUP BY)
Free -
Exercise - Summary Analytics (MIN, MAX, AVG, GROUP BY)
Free -
HAVING Clause
Free -
Calculated Columns (IF, CASE, YEAR, CURYEAR)
Free -
Exercise - Calculated Columns (IF, CASE, YEAR, CURYEAR)
Free -
The Data God’s Blessing
Free -
Quiz
SQL Basics: Database Creation & Updates
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
SQL Advanced: Finance Analytics
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
SQL Advanced: Top Customers, Products, Markets
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
SQL Advanced: Supply Chain Analytics
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
Python For Beginner and Intermediate Learners
07:13 on-demand video
|
62 Lectures
Python Basics
44 Lectures
-
Python Installation - Windows
-
Python Installation - Linux
-
Python Installation - Mac
-
How to Download Code and Get Help If I Have a Question?
-
Variables
Free -
Variables - Quiz
-
Variables - Exercise
-
Numbers
Free -
Numbers - Quiz
-
Numbers - Exercise
Free -
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
Start Applying for Jobs
00:47 on-demand video
|
6 Lectures
Interview Preparation / Job Assistance
02:45 on-demand video
|
15 Lectures
Data Analyst Mock Interviews
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
Virtual Internship
00:14 on-demand video
|
8 Lectures
Week 1
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.
Week 2
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
Week 3 & 4
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
Tableau Mini
04:35 on-demand video
|
23 Lectures
DA 2.0: The AI Enabled Data Analyst
04:45 on-demand video
|
35 Lectures
Machine Learning/ AI Project Lifecycle
11 Lectures
-
10 Stages of AI Project Lifecycle
-
Requirements and Scope of Work (SOW)
-
Data Collection
-
Data Preparation & Exploratory Data Analysis
-
Feature Engineering
-
Model Selection & Training
-
Model Evaluation Metrics (Accuracy, Prediction, Recall & F1 Score)
-
Model Evaluation Metrics: When to use which Metric?
-
Model Fine Tuning
-
Model Deployment
-
Deployment & Monitoring Using ML Ops
Live Webinar
00:00 on-demand video
|
11 Lectures
Career Development Session
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
-
The Secret Behind Resumes and Portfolios That Landed Jobs: Decode with your Talent Manager
Practice Arena
Scenario Based - Interview Questions
-
Product Sales by Store in Bangalore
-
Analyzing Revenue from High-Demand, Premium Products
-
Calculating Total Revenue by Product Category
-
Identifying Unsold Products in Inventory
-
Analyzing Above-Average Salaries by Department
-
Identifying Top Customers by Average Purchase Amount
-
Analyzing Monthly Customer Retention Rates for Q2 2024
-
Identifying Store Leaders: Most Popular Products by Sales
-
Identifying APAC Markets for Atliq Exclusive
-
Sorting Unique Product Counts by Segment at Atliq Exclusive
-
Optimizing Costs: High and Low Manufacturing Costs at Atliq Exclusive
-
2020 Quarterly Sales Trends at Atliq Exclusive
-
Top 3 Products by Sold Quantities Across Divisions, FY 2021
-
2021 Sales Channel Performance at Atliq Exclusive
-
Segment Growth in Unique Products: 2020-2021 Analysis
-
Monthly Gross Sales Analysis for Atliq Exclusive Customer
-
Yearly Product Diversification Increase: 2020-2021
-
Top 5 Indian Customers by Pre-Invoice Discounts, 2021
Data Analytics
Market Opportunity
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
![](https://files.codebasics.io/v3/images-webp/bootcamp/market_new.webp)
5,70,000 INR
Average Data Analyst Salary
Based on data from glassdoor.com
3,00,000
Number of Job Openings
Based on data from linkedin.com
NO DEGREE
Degree not required.
Anyone can become Data Analyst
May we help you?
Frequently Asked
Questions
![](https://images.codebasics.io/v3/images-webp/bootcamp/faqs.webp)
Q.1
I’m not sure if this data analytics bootcamp is good enough for me to invest some money. What can I do?
We got you covered. Go ahead and watch this sales insights playlist
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.
Q.2
Are there any scholarships or financial aid available for this data analytics bootcamp?
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.
Q.1
What if I don’t like this data analytics bootcamp? Is there a refund policy?
Yes. No questions asked. No hidden conditions. You will get a 100% refund if you request a refund within 30 days of enrollment.
Q.2
How can I trust Codebasics?
Till now 12000 + 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.
Q.1
Do we have an EMI option?
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 (1200 INR or 30$)
(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 4500 INR (or 100$)
This way you will pay in 3 installments (1200 INR, 2700 INR and 4500 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 3.0
Q.2
I have already purchased other Codebasics courses like Excel and Python? Will I have to pay the full amount to enroll in this bootcamp?
If you have purchased all four data analytics paid courses, you just need to pay additional Rs.2100 to enroll in our bootcamp 3.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.1500, the total cost would be Rs.4200. You can subtract this from the bootcamp price (Rs.8400 - Rs.4200 = Rs.4200) and pay Rs.4200 to enroll in the Bootcamp 3.0.
Note: Data Science courses are not part of the Data Analytics Bootcamp 3.0
Q.1
How do I get the certificate?
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.
Q.2
Is this bootcamp enough for me in Microsoft Power BI and Excel certifications?
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.
Q.1
Are the lectures going to be LIVE?
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.
Q.4
What datasets are used in this bootcamp? Are they some toy datasets or something that mimics a real-world business problem?
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.
Q.5
What is the duration of this data analytics bootcamp? How long will it last?
You can complete this data analytics bootcamp in 3-5 months if you devote 3 hours each day, 6 days a week.
Q.6
Can I attend this data analytics bootcamp while working full time?
Yes. This data analytics bootcamp is self-paced. You can learn on your own schedule.
Q.7
What kind of skills can I expect to learn in this bootcamp?
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.
Q.8
Will I get a recording of Zoom monthly webinars if I can't attend the live session?
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.
Q.1
Do you provide any job assistance?
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.
Q.2
Will this data analytics bootcamp guarantee me a job?
The courses included in this data analytics bootcamp have been completed by 12000+ 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.
Q.3
How can I contact the instructors for any doubts/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.
Q.1
I am confused about whether to pursue my career as a data analyst. Can you help?
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.
Q.2
Do I need a computer science degree or relevant work experience?
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.
Q.3
I have never done programming in my life. Can I take this data analytics bootcamp?
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.
Q.4
I am 40+ years old, can I enroll in this data analytics bootcamp?
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!
Q.5
Is there any prerequisite for taking this bootcamp?
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.
![](https://images.codebasics.io/v3/images-webp/bootcamp/faqs-mob.webp)
Q.1
I’m not sure if this data analytics bootcamp is good enough for me to invest some money. What can I do?
We got you covered. Go ahead and watch this sales insights playlist
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.
Q.2
Are there any scholarships or financial aid available for this data analytics bootcamp?
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.
Q.1
What if I don’t like this data analytics bootcamp? Is there a refund policy?
Yes. No questions asked. No hidden conditions. You will get a 100% refund if you request a refund within 30 days of enrollment.
Q.2
How can I trust Codebasics?
Till now 12000 + 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.
Q.1
Do we have an EMI option?
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 (1200 INR or 30$)
(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 4500 INR (or 100$)
This way you will pay in 3 installments (1200 INR, 2700 INR and 4500 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 3.0
Q.2
I have already purchased other Codebasics courses like Excel and Python? Will I have to pay the full amount to enroll in this bootcamp?
If you have purchased all four data analytics paid courses, you just need to pay additional Rs.2100 to enroll in our bootcamp 3.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.1500, the total cost would be Rs.4200. You can subtract this from the bootcamp price (Rs.8400 - Rs.4200 = Rs.4200) and pay Rs.4200 to enroll in the Bootcamp 3.0.
Note: Data Science courses are not part of the Data Analytics Bootcamp 3.0
Q.1
How do I get the certificate?
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.
Q.2
Is this bootcamp enough for me in Microsoft Power BI and Excel certifications?
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.
Q.1
Are the lectures going to be LIVE?
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.
Q.4
What datasets are used in this bootcamp? Are they some toy datasets or something that mimics a real-world business problem?
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.
Q.5
What is the duration of this data analytics bootcamp? How long will it last?
You can complete this data analytics bootcamp in 3-5 months if you devote 3 hours each day, 6 days a week.
Q.6
Can I attend this data analytics bootcamp while working full time?
Yes. This data analytics bootcamp is self-paced. You can learn on your own schedule.
Q.7
What kind of skills can I expect to learn in this bootcamp?
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.
Q.8
Will I get a recording of Zoom monthly webinars if I can't attend the live session?
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.
Q.1
Do you provide any job assistance?
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.
Q.2
Will this data analytics bootcamp guarantee me a job?
The courses included in this data analytics bootcamp have been completed by 12000+ 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.
Q.3
How can I contact the instructors for any doubts/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.
Q.1
I am confused about whether to pursue my career as a data analyst. Can you help?
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.
Q.2
Do I need a computer science degree or relevant work experience?
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.
Q.3
I have never done programming in my life. Can I take this data analytics bootcamp?
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.
Q.4
I am 40+ years old, can I enroll in this data analytics bootcamp?
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!
Q.5
Is there any prerequisite for taking this bootcamp?
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.