Why this is the most effective Data Analytics Bootcamp?
-
Automated Resume Builder and 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 and Job Application Playbook + Interview Leads + Building Online Credibility + Mock Interview)
-
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
Begin Your Bootcamp Journey with US$36
Know HowBegin Your Bootcamp Journey with
US$36
Know HowKey Reasons
Why Should You Enroll in This Data Analytics Bootcamp?
/uploads/bundle/enrolment_reasons/whats-new_v1.webp)
Industry project-based Bootcamp designed by hiring experts
/uploads/bundle/enrolment_reasons/ms-fabric-for-da_v1.webp)
Gain practical experience with real-world projects
/uploads/bundle/enrolment_reasons/job_v1.webp)
We don't make false job guarantees, but our learners get hired!
/uploads/bundle/enrolment_reasons/interview-support_v1.webp)
Interview guidance to help you land your dream job
2491 learners have created their portfolio websites
Explore PortfoliosHear It From
Our Happy Learners
Our content is rated 4.9/5 from 51420+ Learners
/fit-in/600x600/uploads/video_testimonials/video_thumbnail/30462/223799_6790ed403ab0afaizal-ahmed.png)
/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/uploads/testimonials/30462/thumbnail/6404f5765e2abphoto.jpg)
/fit-in/600x600/uploads/video_testimonials/video_thumbnail/437834/223799_6790ed0359979sebastian-torres-franco.png)
/fit-in/600x600/uploads/video_testimonials/video_thumbnail/187497/293508_66a8974d616cekrish-das-dutta.png)
/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/uploads/testimonials/187497/thumbnail/652f867755b2f316067830-1308887223298953-8018313621677742676-n.jpg)
Landed a Job
/fit-in/600x600/uploads/video_testimonials/video_thumbnail/146809/223799_66a0abbc5f571mohd-akif.png)
Landed a Job
/fit-in/600x600/uploads/video_testimonials/video_thumbnail/18959/223799_669f57de8d195prateeek-bhikadiya.png)
Landed a Job
This course provides a comprehensive introduction to the Python programming language. The course is well structured, starting with the basics and gradually building up to more advanced concepts. The lessons are taught through clear and concise video tutorials, accompanied by interactive coding exercises that reinforce the concepts covered. The course covers topics such as data types, functions, object-oriented programming, and more. The instructor is knowledgeable and passionate about Python, and the course is well-paced, making it easy to follow along and absorb the material. Overall, the Code Basics Python course is an excellent resource for anyone looking to learn Python, from beginners to those with some programming experience.
/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/uploads/images/1644324460184.jpeg)
Landed a Job
Being from a non-tech background and I know only economics and statistics, I feel happy because these industry experts made our life so easy. From the bottom of my heart, I congratulate Mr Dhaval Patel for introducing this fantastic course.
/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/filters:format(webp)/fit-in/100x100/uploads/testimonials/103097/thumbnail/64d0e750c08febharathphoto.jpg)
Landed a Job
The best excel course that I had ever taken, The Videos are of optimum length with best information than ever, The Projects are of so good quality and we have worked so smoothly on them that I didn't even realize that I had just worked with data of over 1 million records.
Also making cinematic videos to make us feel like as if we are working as a data analyst in company kudos for that to all the codebasics team.
Also apart from just technical knowledge they taught us Real time Business skills like Project priority Matrix , Scenario planning etc which makes this course best among all.
/fit-in/100x100/filters:format(webp)/fit-in/100x100/27335/avatar/64c8fbd52c7c6.png)
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.
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.
Landed a Job
You Can
Work On Real World Projects
That
Hiring Managers Like
/uploads/bundle/real_world_project/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.
/uploads/bundle/real_world_project/icon2.png)
Revenue Analytics: Hospitality Domain
You will generate revenue insights in the hospitality domain by performing data cleaning, data transformation, and insights generation using Python and Pandas.
/uploads/bundle/real_world_project/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.
/uploads/bundle/real_world_project/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.
/uploads/bundle/real_world_project/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
00h:45m:43s 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
08h:59m:02s on-demand video
|
70 Lectures
Excel Basics: Getting Started
13 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
-
Chapter Summary
Excel Basics: Applying Business Maths & Statistics
9 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
-
Chapter Summary
Excel Basics+: Creating Business Reports Using Pivot Table & Power Pivot
14 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
-
Chapter Summary
Excel Advanced: Sales Analytics
12 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
-
Chapter Summary
Excel Advanced: Finance Analytics
11 Lectures
-
Understanding P & L
-
Functional Knowledge: Finance
-
Adding the Finance Data to Data Model
-
Finance Analytics: P & L by Year Report
-
Fine Tuning P & L By Year Report
-
Adding Months & Quarters in Data Model
-
Finance Analytics: P & L by Months Report
-
Fine Tuning P & L By Month Report
-
Practice Exercise
-
Quiz
-
Chapter Summary
Start Building Your Online Credibility
00h:26m:24s on-demand video
|
6 Lectures
Get Job Ready: Power BI Data Analytics for All Levels 3.0
19h:10m:41s on-demand video
|
137 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
-
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)
PBI Monthly Update Tasks
16 Lectures
-
Intro
-
Feature Updates Task -1
-
Solution: Task - 1
-
Feature Updates Task- 2
-
Solution: Task - 2
-
Feature Updates Task - 3
-
Solution: Task - 3
-
Feature Updates Task - 4
-
Solution: Task - 4
-
Feature Updates Task - 5
-
Solution: Task - 5
-
Feature Updates Task - 6
-
Solution: Task - 6
-
Feature Updates Task - 7
-
Solution: Task - 7
-
Feature Updates Task - 8
Building Online Credibility, Portfolio Projects & ATS Resume
03h:59m:49s on-demand video
|
23 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
11h:15m:16s on-demand video
|
84 Lectures
SQL Basics: Data Retrieval - Single Table
15 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
-
Chapter Summary
SQL Basics: Database Creation & Updates
18 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
-
Chapter Summary
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: Beginner to Advanced For Data Professionals
16h:57m:31s on-demand video
|
108 Lectures
Project 2: Expense Tracking System
11 Lectures
-
Problem Statement & Tech Architecture
-
Database CRUD Operations
-
Automated Tests Setup for CRUD
-
Expense Management: Backend (FastAPI)
-
Expense Management: Logging
-
Streamlit Introduction
-
Expense Management: Frontend (Streamlit)
-
Analytics: Backend (FastAPI)
-
Analytics: Frontend (Streamlit)
-
README and Requirements.txt
-
Exercise
Start Applying for Jobs
00h:48m:46s on-demand video
|
7 Lectures
Interview Preparation / Job Assistance
05h:06m:32s on-demand video
|
17 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
00h:13m:46s 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 Letter Of Completion
Tableau Mini
04h:34m:44s on-demand video
|
23 Lectures
Microsoft Fabric Mini: For Data Analysts
01h:52m:13s on-demand video
|
14 Lectures
DA 2.0: The AI Enabled Data Analyst
04h:47m:25s 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
Virtual Internship 2
00h:11m:04s on-demand video
|
9 Lectures
Week 1
27 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.
-
Python Script Task
-
Incoming Task Email 2
-
Have you completed this task?
-
Quality Check 1
-
Quality Check 2
-
Quality Check 3
-
Quality Check 4
-
Quality Check 5
-
Congratulations you have completed 2 tasks in a row!
-
You need Kanban Training
-
Incoming Task Email 3
-
Have you completed the assigned task?
-
Kanban Knowledge Check
-
Congratulations you have completed week 1 Successfully.
Week 2
11 Lectures
-
Let's dive right into Week 2!
-
Rhonda MVP Project - Your First Power BI Task
-
Incoming Task Email 1
-
Have you completed the assigned task?
-
Quality Check - 1
-
Quality Check - 2
-
Designing and Enhancing a Dashboard
-
Create a Mock-up for the Client
-
Incoming Task Email: Dashboard Creation
-
Have you completed the dashboard?
-
Congratulations
Week 3 & 4
14 Lectures
-
Let's dive right into the Final 2 Weeks !
-
Can you help our Marketing Team?
-
Incoming Task Email: Netflix Analysis
-
Have you completed the analysis?
-
Quality Check - 1
-
Quality Check - 2
-
Write a mail to the Social Media Analytics Team
-
Response from the Social Media Analytics Team
-
Appreciation & New Project Task
-
Incoming Task Email: Tech Instagram Influencer Analysis
-
Have you completed the analysis?
-
Presentation submission
-
End Note
-
Get Your Letter Of Completion
Unguided Projects
00h:01m:39s on-demand video
|
1 Lectures
Supplementary Learning
01h:07m:59s on-demand video
|
8 Lectures
Power BI Scenarios
26 Lectures
-
Scenario - 1
-
Quality Checks
-
Scenario - 2
-
Quality Checks
-
Scenario - 3
-
Quality Checks
-
Scenario - 4
-
Quality Checks
-
Scenario - 5
-
Quality Checks
-
Scenario - 6
-
Quality Checks
-
Scenario - 7
-
Quality Checks
-
Scenario - 8
-
Quality Checks
-
Scenario - 9
-
Quality Checks
-
Scenario - 10
-
Quality Checks
-
Scenario - 11
-
Quality Checks
-
Scenario - 12
-
Quality Checks
-
Scenario - 13
-
Quality Checks
Live Webinar
30h:18m:35s on-demand video
|
22 Lectures
Career Development Session
5 Lectures
-
Beginners Guide to Job Seeking - Sep 23
-
6 Free Internet Tools to Get an Interview Call - Oct 23
-
Smart Job Assistance Portal & Expert Resume Insights
-
The Secret Behind Resumes and Portfolios That Landed Jobs: Decode with your Talent Manager
-
Strategic Job Search with Google, LinkedIn and Naukri - 22nd November
Expert Webinars
9 Lectures
-
Transitioning from Non-Tech to Data Analytics - Journey and Tips by Shail Sahu
-
PL-300 Certification: What You Need to Know & How to Prepare - Anmol Malviya
-
How to Approach Scenario-Based Questions and Guesstimates in the Interviews - Shashank Singh
-
Tips and Tricks to Approach Data Analyst Interviews - Gaurav Agrawal
-
How I would prepare for Data Analyst Interviews If I had to start over - Munna Das
-
Key Lessons and Interview Tips from My Journey as a Data Analyst - Bharath Kumar G
-
My Life as a Data Analyst at Ford Motors- Raghavan P
-
Data Analytics Freelancing Essentials - Santhanalakshmi Ponnurasan
-
How to differentiate your work - Ashish Babaria
Practice Arena
1:
Scenario Based - Interview Questions
SQL
29
Questions
-
1.1: Future Purchase Prediction Date
-
1.2: Customer Purchase Behavior Analysis
-
1.3: Travel Booking Analysis
-
1.4: Top 3 Customer Revenue Analysis
-
1.5: Cricket Match Scheduling
-
1.6: Travel Booking and Revenue Analysis
-
1.7: Customer Revenue Analysis
-
1.8: Monthly Transaction Analysis for Fraud Detection
-
1.9: Fitness MemberShip
-
1.10: Travel Pattern Analysis
-
1.11: Customer Loyalty Analysis
-
1.12: Product Sales by Store in Bangalore
-
1.13: Analyzing Revenue from High-Demand, Premium Products
-
1.14: Calculating Total Revenue by Product Category
-
1.15: Identifying Unsold Products in Inventory
-
1.16: Analyzing Above-Average Salaries by Department
-
1.17: Identifying Top Customers by Average Purchase Amount
-
1.18: Analyzing Monthly Customer Retention Rates for Q2 2024
-
1.19: Identifying Store Leaders: Most Popular Products by Sales
-
1.20: Identifying APAC Markets for Atliq Exclusive
-
1.21: Sorting Unique Product Counts by Segment at Atliq Exclusive
-
1.22: Optimizing Costs: High and Low Manufacturing Costs at Atliq Exclusive
-
1.23: 2020 Quarterly Sales Trends at Atliq Exclusive
-
1.24: Top 3 Products by Sold Quantities Across Divisions, FY 2021
-
1.25: 2021 Sales Channel Performance at Atliq Exclusive
-
1.26: Segment Growth in Unique Products: 2020-2021 Analysis
-
1.27: Monthly Gross Sales Analysis for Atliq Exclusive Customer
-
1.28: Yearly Product Diversification Increase: 2020-2021
-
1.29: Top 5 Indian Customers by Pre-Invoice Discounts, 2021
2:
MySQL Course Exercises
SQL
24
Questions
-
2.1: Print All Marvel Studios Movies with Titles and Release Year
-
2.2: Select All THOR Movies by Release Year
-
2.3: Select All Movies Not from Marvel Studios
-
2.4: Retrieving Movies with Their Language Names
-
2.5: Retrieve Hollywood Movies with High Profit After 2000
-
2.6: Count Movies Released Between 2015 and 2022
-
2.7: Determine the Range of Movie Release Years
-
2.8: Count Movies Released Annually in Descending Order
-
2.9: Calculate Profit Percentage for All Movies
-
2.10: Retrieve Telugu Movies
-
2.11: Count Movies by Language
-
2.12: Generate a Report of Hindi Movies Sorted by Revenue
-
2.13: Retrieve Movies with Minimum and Maximum Release Year
-
2.14: Retrieve Movies with IMDb Rating Above Average
-
2.15: Select Movies by Marvel Studios and Hombale Films
-
2.16: List Movies by Latest Release Year
-
2.17: All Movies Released After 2020 with Rating Greater Than 8
-
2.18: All Movies Released After 2020
-
2.19: All Movies Released in 2022
-
2.20: Order Movies by Release Year
-
2.21: List Distinct Bollywood Studios
-
2.22: Release Year of The Godfather
-
2.23: Search for Avengers Movies
-
2.24: List Marvel Studios Movies
Welcome to The Bootcamp Experience
00h:45m:43s on-demand video
|
15 Lectures
1:
Welcome to The Bootcamp Experience
15 Lectures
-
1.1: Why Should You Become a Data Analyst?
Free -
1.2: How Do I Know If The Data Analyst Role Is Suitable For Me?
Free -
1.3: Is Computer Science Degree / Young Age / Relevant Work Experience Mandatory?
Free -
1.4: What Kind of Job Assistance Do You Provide?
Free -
1.5: How Do I Get Doubt-Clearing Support? (Discord)
-
1.6: How Much Time Do I Need to Complete The Bootcamp?
Free -
1.7: Do I get a Real Internship Certificate After Completing a Virtual Internship?
Free -
1.8: Do the Creators of This Bootcamp Have Real Industry Experience?
Free -
1.9: How Many Business Projects Will I Complete in This Bootcamp?
Free -
1.10: How can I Trust That This Bootcamp Has the Best Content on Planet Earth?
Free -
1.11: What Domain and Functional Knowledge Will You Build and How?
Free -
1.12: What are the Soft Skills I Will Acquire By the End of Bootcamp?
Free -
1.13: Bootcamp Syllabus Overview
Free -
1.14: How Will I Be Informed About The Monthly Live Webinars?
Free -
1.15: System Requirements
Excel: Mother of Business Intelligence
08h:59m:02s on-demand video
|
70 Lectures
2:
Excel Basics: Getting Started
13 Lectures
-
2.1: Peter Pandey’s Journey and Need to Learn Excel
-
2.2: Installing Excel: Windows / Mac
Free -
2.3: Getting Familiar With Excel
Free -
2.4: Getting More Familiar With Excel
Free -
2.5: Introduction to Formulas
Free -
2.6: Formula Behavior
Free -
2.7: Introduction to Tables
Free -
2.8: Introduction to Charts
Free -
2.9: Other Essential Features
Free -
2.10: Peter Gets His First Assignment From His Senior
Free -
2.11: Practice Exercise: Personal Expense Tracker
-
2.12: Quiz
-
2.13: Chapter Summary
4:
Excel Basics: Applying Business Maths & Statistics
9 Lectures
-
4.1: Basic Maths to Business Metrics (Bollywood movies revenue avg)
-
4.2: Commonly Used Business Metrics (P&L)
-
4.3: Commonly Used Statistic Concepts (Mean, Median, Mode)
-
4.4: Commonly Used Statistic Concepts (Variance, Standard Deviation)
-
4.5: Commonly Used Statistic Concepts (Correlation)
-
4.6: Peter Gets to Solve a Real Time Problem
-
4.7: Practice Exercise
-
4.8: Quiz
-
4.9: Chapter Summary
6:
Excel Basics+: Creating Business Reports Using Pivot Table & Power Pivot
14 Lectures
-
6.1: Pivot Table Introduction: Apple Product Sales
-
6.2: Pivot Table For Movie Analytics
-
6.3: Creating a Report Using Pivot Table
-
6.4: Pivot Table Options & Formatting
-
6.5: Using Power Pivot & DAX For Powerful Business Reports
-
6.6: Adding Targets Using Data Modelling in Power Pivot
-
6.7: Breaking Down Complex Problems: Thinking Process of a Highly Paid Data Analyst
-
6.8: More Business Metrics and Conditional Formatting
-
6.9: VBA Basics & How Much VBA You Should Learn
-
6.10: Peter Practices On His Own
-
6.11: Practice Exercise
-
6.12: Quiz
-
6.13: I Need a Favour
-
6.14: Chapter Summary
8:
Excel Advanced: Sales Analytics
12 Lectures
-
8.1: ETL (Extract, Transform and Load Data) in Excel I
-
8.2: ETL (Extract, Transform and Load Data) in Excel II
-
8.3: Business Report: Solution Design Thought Process
-
8.4: Creating Connections Among Tables Using Data Modelling
-
8.5: Adding a Date Table Using Power Query
-
8.6: Functional Knowledge: Sales
-
8.7: Sales Analytics: Creating Customer Performance Report
-
8.8: User Empathetic Report Design
-
8.9: Sales Analytics: Creating Market Performance vs Targets Reported
-
8.10: Practice Exercise
-
8.11: Quiz
-
8.12: Chapter Summary
9:
Excel Advanced: Finance Analytics
11 Lectures
-
9.1: Understanding P & L
-
9.2: Functional Knowledge: Finance
-
9.3: Adding the Finance Data to Data Model
-
9.4: Finance Analytics: P & L by Year Report
-
9.5: Fine Tuning P & L By Year Report
-
9.6: Adding Months & Quarters in Data Model
-
9.7: Finance Analytics: P & L by Months Report
-
9.8: Fine Tuning P & L By Month Report
-
9.9: Practice Exercise
-
9.10: Quiz
-
9.11: Chapter Summary
10:
Excel Advanced: Real-Time Business Applications
9 Lectures
-
10.1: Wanda’s Challenge With Prioritizing Projects
-
10.2: Peter & Tony Creates a Project Priority Matrix
-
10.3: Mentor Talk: Being A Problem Solver
-
10.4: Practice Exercise
-
10.5: Bruce Haryali Needs Help With Excel
-
10.6: Peter & Tony Creates a Scenario Planning Tool
-
10.7: Mentor Talk: Growth Zone
-
10.8: Practice Exercise
-
10.9: Quiz
Start Building Your Online Credibility
00h:26m:24s on-demand video
|
6 Lectures
Get Job Ready: Power BI Data Analytics for All Levels 3.0
19h:10m:41s on-demand video
|
137 Lectures
2:
Power BI Basics: Getting Started
13 Lectures
-
2.1: Install Power BI
-
2.2: Power BI: Tool Introduction
-
2.3: Power Query: Intro & Column Transformations
-
2.4: Power Query: Merging and Appending
-
2.5: Power Query: Best Practices
-
2.6: Introduction to DAX
-
2.7: Introduction to DAX - II
-
2.8: Introduction to Data Modeling
-
2.9: Introduction to Creating Visuals
-
2.10: Tony asks Peter to Fix Data Holes
-
2.11: Practice Exercise
-
2.12: Chapter Summary
-
2.13: Quiz
3:
Project Planning and Scoping
9 Lectures
-
3.1: Problem Statement
Free -
3.2: The Email that Started this Project
Free -
3.3: Project Kick-off Meeting
Free -
3.4: Learn how a ‘Project Charter’ is Used in Companies
-
3.5: Project Kick-off: Session Debrief
-
3.6: Senior Data Analyst Sets Up the Next Steps with Junior Data Analyst
-
3.7: Simplified: Profit and Loss Statement
-
3.8: Chapter Summary
-
3.9: Quiz
4:
Power BI Basics: Data collection, Exploration & Validation
10 Lectures
-
4.1: Simplified: Data Warehouse, OLTP vs OLAP, Data Catalog
Free -
4.2: Install MySQL and Import Data
-
4.3: Simplified: Data Exploration Using SQL, Star Schema, Fact vs Dimension Tables
Free -
4.4: Load and connect data with MySQL
-
4.5: Create a Date Dimension Table
-
4.6: Validate Data against Benchmark Numbers
-
4.7: Tony’s Valuable Advise to Peter
-
4.8: Practice Exercise
-
4.9: Chapter Summary
-
4.10: Quiz
7:
Power BI Advanced: Data Modeling & Calculated Columns
11 Lectures
-
7.1: Power Query or DAX for Generating Calculated Columns?
Free -
7.2: Data Modelling: Star and Snowflake Schema
Free -
7.3: Data Modeling: Connect Dimensions with Fact Tables
-
7.4: Simplified: Why Do We Need Dimension Tables?
-
7.5: Mentor Talk: Congratulations! You are Levelling Up!
-
7.6: Create Calculated Columns Using DAX
-
7.7: Easy Way to Verify Your Numbers in Power BI
-
7.8: Assignment: Optimize Report and Reduce File Size by 25 %
Free -
7.9: I Need a Favour
-
7.10: Chapter Summary
-
7.11: Quiz
8:
Power BI Advanced: Build Finance View
15 Lectures
-
8.1: Finance View: Prepare a List of Metrics
-
8.2: Simplified: Calculate Function & Filter Context
-
8.3: Finance View: Creating Metrics
-
8.4: Finance View: Create P&L Table Structure
-
8.5: Finance View: Create Last Year (LY) Column
-
8.6: Finance View: Build an Ultimate DAX Measure for P & L Table Structure - I
-
8.7: Finance View: Build an Ultimate DAX Measure for P & L Table Structure - II
-
8.8: Finance View: Create ‘Quarters’ & ‘YTD/YTG’ Slicers
-
8.9: Mentor Talk: Figuring Out Solutions
-
8.10: Finance View: Create a Line chart to Show Performance Over Time
-
8.11: Finance View: Build Top Product, Market & Region Visuals
-
8.12: Intermediate Review: I Met Product Owner Nick and He Gave this Feedback!
Free -
8.13: Finance View: Add Net Profit
-
8.14: Chapter Summary
-
8.15: Quiz
9:
Power BI Advanced: Build Sales, Marketing & Supply Chain View
10 Lectures
-
9.1: Review Sales View Mockup
-
9.2: Sales View: Build Top Customers & Performance Matrix Visuals
-
9.3: Sales View: Build Product Performance & Unit Economics Visuals
-
9.4: Build Marketing View
-
9.5: Simplified: Supply Chain Basics
-
9.6: Supply Chain View: Review Mock Up
-
9.7: Supply Chain View: Build Key Measures
-
9.8: Supply Chain View: Build Visuals
-
9.9: Chapter Summary
-
9.10: Quiz
10:
Power BI Advanced: Designing an Effective Dashboard
9 Lectures
-
10.1: Simplified: Dashboard vs Report
-
10.2: 15 Design Rules for an Effective Dashboard
-
10.3: Finalize Page Layout Design
-
10.4: Create Home Page
-
10.5: Design Finance Dashboard
-
10.6: Add Key Elements to Finance Dashboard
-
10.7: Copy the Design to Sales, Marketing & Supply Chain Dashboard
-
10.8: Chapter Summary
-
10.9: Quiz
12:
Stakeholder review & Feedback implementation
16 Lectures
-
12.1: Stakeholder Analysis and its Significance
-
12.2: Peter Recalls the Stakeholder Mapping Meeting
Free -
12.3: Stakeholder Review Meeting: How did it Go?
Free -
12.4: This is the secret to be ‘Job Ready’!
-
12.5: Practice Exercise: Quick Fixes
-
12.6: Quick Fix: Chg% formula
-
12.7: Practice Exercise: Implementing Dynamic Benchmark
-
12.8: Practice Exercise: Adding Dynamic Slicer to Filter Visual
-
12.9: Practice Exercise: Create a Toggle Button to Switch between Two Visuals
-
12.10: Practice Exercise: Create a Tool Tip to Show Trend
-
12.11: Learn: Adding Market Share Data
-
12.12: Practice Exercise: Create an Executive Dashboard
-
12.13: Learn: Performance Optimization
-
12.14: Learn: Fix Data Quality Issues
-
12.15: Chapter Summary
-
12.16: Quiz
13:
Deploying the Solution: Power BI Service
7 Lectures
-
13.1: Power BI Service Overview, Report Sharing, and Apps
-
13.2: How to Set Up Automatic Data Refresh: My SQL
-
13.3: How to Set Up Automatic Data Refresh: Excel
-
13.4: Simplified: Collaboration, Bookmarks, and Insights in Power BI Service
-
13.5: Driving the Extra Mile: Documentation and Maintenance
-
13.6: Chapter Summary
-
13.7: Quiz
14:
Practice Exercise Solutions
11 Lectures
-
14.1: Solution: Quick Fixes
-
14.2: Solution: Implementing Dynamic Targets (Add Targets)
-
14.3: Solution: Implementing Dynamic Targets (Create a dynamic switch between Targets and LY)
-
14.4: Solution: Implementing Dynamic Targets (P & L visuals to compare Target or LY based on selection)
-
14.5: Solution: Adding Dynamic Slicer to Filter Visual
-
14.6: Solution: Create a Toggle Button to Switch between Two Visuals
-
14.7: Solution: Create a Tool Tip to Show Trend
-
14.8: Solution: Create an Executive Dashboard (KPI Visuals)
-
14.9: Solution: Create an Executive Dashboard (Key Insights by Subzone )
-
14.10: Solution: Create an Executive Dashboard (Market Share Visual & Conditional Formatting)
-
14.11: Solution: Create an Executive Dashboard (Final Enhancements)
16:
PBI Monthly Update Tasks
16 Lectures
-
16.1: Intro
-
16.2: Feature Updates Task -1
-
16.3: Solution: Task - 1
-
16.4: Feature Updates Task- 2
-
16.5: Solution: Task - 2
-
16.6: Feature Updates Task - 3
-
16.7: Solution: Task - 3
-
16.8: Feature Updates Task - 4
-
16.9: Solution: Task - 4
-
16.10: Feature Updates Task - 5
-
16.11: Solution: Task - 5
-
16.12: Feature Updates Task - 6
-
16.13: Solution: Task - 6
-
16.14: Feature Updates Task - 7
-
16.15: Solution: Task - 7
-
16.16: Feature Updates Task - 8
Building Online Credibility, Portfolio Projects & ATS Resume
03h:59m:49s on-demand video
|
23 Lectures
2:
Build Your Resume, Now!
8 Lectures
-
2.1: What is ATS and Why it is Important?
-
2.2: Follow These Guidelines to Build an Amazing Resume
-
2.3: Improve the ATS Score of Your Resume
-
2.4: Customize Resume as Per Job Posting
-
2.5: Career Transition: Sample Experience Sections
-
2.6: Meet Naveen, He is applying for a Job Like You!
-
2.7: Knowledge Check
-
2.8: Checkpoint
5:
Power BI Project(s) for Your Portfolio!
7 Lectures
-
5.1: Get a Shareable Public Link For Your Power BI Project
-
5.2: Share Your Power BI Project with Potential Recruiters
-
5.3: Differentiate Your Work with New Design
-
5.4: How to differentiate your work - Expert Webinar
-
5.5: One More Power BI Project for Your Portfolio
-
5.6: Check Your Work With this Guided Project
-
5.7: One Step Closer to Your Dream Portfolio
SQL Beginner to Advanced For Data Professionals
11h:15m:16s on-demand video
|
84 Lectures
2:
SQL Basics: Data Retrieval - Single Table
15 Lectures
-
2.1: Install MySQL: Windows
Free -
2.2: Install MySQL: Linux, Mac
Free -
2.3: Import Movies Dataset in MySQL
Free -
2.4: Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)
Free -
2.5: Exercise - Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)
Free -
2.6: Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)
Free -
2.7: Exercise - Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)
Free -
2.8: Summary Analytics (MIN, MAX, AVG, GROUP BY)
Free -
2.9: Exercise - Summary Analytics (MIN, MAX, AVG, GROUP BY)
Free -
2.10: HAVING Clause
Free -
2.11: Calculated Columns (IF, CASE, YEAR, CURYEAR)
Free -
2.12: Exercise - Calculated Columns (IF, CASE, YEAR, CURYEAR)
Free -
2.13: The Data God’s Blessing
Free -
2.14: Quiz
-
2.15: Chapter Summary
5:
SQL Basics: Database Creation & Updates
18 Lectures
-
5.1: Database Normalization and Data Integrity
-
5.2: Entity Relationship Diagram (ERD)
-
5.3: Mentor Talk: Art of Googling
-
5.4: Data Types: Numeric (INT, DECIMAL, FLOAT, DOUBLE)
-
5.5: Data Types: String (VARCHAR, CHAR, ENUM)
-
5.6: Data Types: Date, Time (DATETIME, DATE, TIME, YEAR, TIMESTAMP)
-
5.7: Data Types: JSON, Spatial (JSON, GEOMETRY)
-
5.8: Luck Favors the LinkedIn Post
-
5.9: Primary key
-
5.10: Foreign Key
-
5.11: Create a Database From an Entity Relationship Diagram - ERD
-
5.12: Import Data From a CSV File Into a Database
-
5.13: Insert Statement
-
5.14: Update and Delete
-
5.15: I Need a Favour
-
5.16: Expect the Unexpected: The Intermission Scene
-
5.17: Quiz
-
5.18: Chapter Summary
6:
AtliQ Hardware & Problem Statement
9 Lectures
-
6.1: The Rise of Databases at AtliQ
Free -
6.2: Relational vs No-SQL Database
-
6.3: AtliQ Hardware’s Business Model
-
6.4: Profit & Loss Statement
-
6.5: ETL, Data Warehouse, OLAP vs OLTP, Data Catalog
-
6.6: Fact vs Dimension Table, Star vs Snowflake Schema, Data Import
-
6.7: Simplified: What is Kanban?
-
6.8: Quiz
-
6.9: Chapter Summary
7:
SQL Advanced: Finance Analytics
10 Lectures
-
7.1: Backlog Grooming Meeting: Gross Sales Report
-
7.2: User-Defined SQL Functions
-
7.3: Exercise: User-Defined SQL Functions
-
7.4: Gross Sales Report: Monthly Product Transactions
-
7.5: Gross Sales Report: Total Sales Amount
-
7.6: Exercise: Yearly Sales Report
-
7.7: Stored Procedures: Monthly Gross Sales Report
-
7.8: Stored Procedure: Market Badge
-
7.9: Benefits of Stored Procedures
-
7.10: Quiz
8:
SQL Advanced: Top Customers, Products, Markets
16 Lectures
-
8.1: Problem Statement and Pre-Invoice Discount Report
-
8.2: Performance Improvement # 1
-
8.3: Performance Improvement # 2
-
8.4: Database Views: Introduction
-
8.5: Database Views: Post Invoice Discount, Net Sales
-
8.6: Exercise: Database Views
-
8.7: Top Markets and Customers
-
8.8: Exercise: Top Products
-
8.9: The Two Most Important Skills for the Data Analyst
-
8.10: Window Functions: OVER Clause
-
8.11: Window Functions: Using it in a Task
-
8.12: Exercise: Window Functions: OVER Clause
-
8.13: Window Functions: ROW_NUMBER, RANK, DENSE_RANK
-
8.14: Exercise: Window Functions: ROW_NUMBER, RANK, DENSE_RANK
-
8.15: 5 Ways SQL is Used in the Industry
-
8.16: Quiz
9:
SQL Advanced: Supply Chain Analytics
13 Lectures
-
9.1: Supply Chain Basics : Simplified
-
9.2: Problem Statement
-
9.3: Create a Helper Table
-
9.4: Database Triggers
-
9.5: Database Events
-
9.6: Temporary Tables & Forecast Accuracy Report
-
9.7: Exercise: CTE, Temporary Tables
-
9.8: Subquery vs CTE vs Views vs Temporary Table
-
9.9: User Accounts and Privileges
-
9.10: Database Indexes: Overview
-
9.11: Database Indexes: Composite Index
-
9.12: Database Indexes: Index Types
-
9.13: Quiz
Python: Beginner to Advanced For Data Professionals
16h:57m:31s on-demand video
|
108 Lectures
6:
Python Basics: Functions, Dictionaries, Tuples and File Handling
9 Lectures
-
6.1: Functions
-
6.2: Dictionary and Tuples
-
6.3: Modules and Pip
-
6.4: File Handling
-
6.5: Quiz: Functions, Dictionaries, Tuples and File Handling
-
6.6: Peter’s Request to Tony
-
6.7: Exercise: Functions, Dictionaries, Tuples and File Handling
-
6.8: Two Deadly Viruses Infecting Learners
-
6.9: Chapter Summary
15:
Project 2: Expense Tracking System
11 Lectures
-
15.1: Problem Statement & Tech Architecture
-
15.2: Database CRUD Operations
-
15.3: Automated Tests Setup for CRUD
-
15.4: Expense Management: Backend (FastAPI)
-
15.5: Expense Management: Logging
-
15.6: Streamlit Introduction
-
15.7: Expense Management: Frontend (Streamlit)
-
15.8: Analytics: Backend (FastAPI)
-
15.9: Analytics: Frontend (Streamlit)
-
15.10: README and Requirements.txt
-
15.11: Exercise
18:
Bonus Medical Data Extraction Project: Prescription Document
10 Lectures
-
18.1: Technical Architecture of the Project
Free -
18.2: Installation of Necessary Libraries
-
18.3: Extract text from a pdf document
-
18.4: Thresholding in OpenCV
-
18.5: Regular Expressions or Regex
-
18.6: Regex Exercise
-
18.7: Python class for prescription
-
18.8: Code Refactoring
-
18.9: Unit Tests using pytest
-
18.10: I Need a Favour
Start Applying for Jobs
00h:48m:46s on-demand video
|
7 Lectures
Interview Preparation / Job Assistance
05h:06m:32s on-demand video
|
17 Lectures
3:
Data Analyst Mock Interviews
14 Lectures
-
3.1: Naveen gets an Interview call
-
3.2: Think like a Hiring Manager
-
3.3: Introducing Yourself
-
3.4: Answering Questions on projects
-
3.5: SQL Questions
-
3.6: Excel Questions
-
3.7: Power BI Questions
-
3.8: Presenting Insights
-
3.9: Scenario Based Questions
-
3.10: Behavioral Questions
-
3.11: Asking Questions to Hiring Managers
-
3.12: Hiring Managers Discussion
-
3.13: Knowledge Check
-
3.14: Checkpoint
Virtual Internship
00h:13m:46s on-demand video
|
8 Lectures
2:
Week 1
22 Lectures
-
2.1: Welcome Note
-
2.2: Your Onboarding Letter
-
2.3: Welcome Note From Your Manager
-
2.4: Let's dive right into Week 1!
-
2.5: Getting Help From Your Seniors / Fellow Team Members
-
2.6: Your First Task
-
2.7: Incoming Task Email 1
-
2.8: Have you completed this task?
-
2.9: Quality Check 1
-
2.10: Quality Check 2
-
2.11: Quality Check 3
-
2.12: Quality Check 4
-
2.13: Congratulations you have completed the first task of your internship.
-
2.14: Incoming Task Email 2
-
2.15: Have you completed this task?
-
2.16: Quality Check
-
2.17: Congratulations you have completed 2 tasks in a row!
-
2.18: You Need Scrum Training
-
2.19: Incoming Task Email 3
-
2.20: Have you completed the assigned task?
-
2.21: Scrum Knowledge Check
-
2.22: Congratulations you have completed week 1 Successfully.
3:
Week 2
33 Lectures
-
3.1: Let's dive right into Week 2!
-
3.2: Create This Variance Report
-
3.3: Incoming Task Email 1
-
3.4: Have you completed the assigned task?
-
3.5: Quality Check 1
-
3.6: Quality Check 2
-
3.7: Quality Check 3
-
3.8: Congratulations on finishing this task!
-
3.9: Incoming Task Email 2
-
3.10: Have you completed the assigned task?
-
3.11: Quality Check 1
-
3.12: Quality Check 2
-
3.13: Quality Check 3
-
3.14: Quality Check 4
-
3.15: Quality Check 5
-
3.16: Quality Check 6
-
3.17: Quality Check 7
-
3.18: Quality Check 8
-
3.19: Quality Check 9
-
3.20: Congratulations on successfully completing the task!
-
3.21: Incoming Task Email 3
-
3.22: Have you completed the assigned task?
-
3.23: Quality Check 1
-
3.24: Quality Check 2
-
3.25: Quality Check 3
-
3.26: Quality Check 4
-
3.27: Quality Check 5
-
3.28: You did an amazing job completing the task.
-
3.29: Critical Presentation Deck
-
3.30: Incoming Task Email 4
-
3.31: Have you completed the assigned task?
-
3.32: Presentation Submission
-
3.33: Congratulations
4:
Week 3 & 4
19 Lectures
-
4.1: Let's dive right into the Final 2 Weeks !
-
4.2: Can You Handle This Insurance Project?
-
4.3: Incoming Task Email: Feature List
-
4.4: Please don't share datasets
-
4.5: Have you completed the feature list?
-
4.6: Download Benchmark Feature List
-
4.7: Quality Check
-
4.8: Don’t Forget to Send A Mock Up to Client
-
4.9: Have you completed the mock up?
-
4.10: Incoming Task
-
4.11: Response from Client
-
4.12: Quality Check
-
4.13: Incoming Task Email: Dashboard Creation
-
4.14: Have you completed the dashboard?
-
4.15: Submission Checklist
-
4.16: Please don't share Datasets
-
4.17: Dashboard Submission
-
4.18: End Note
-
4.19: Get Your Letter Of Completion
Tableau Mini
04h:34m:44s on-demand video
|
23 Lectures
Microsoft Fabric Mini: For Data Analysts
01h:52m:13s on-demand video
|
14 Lectures
DA 2.0: The AI Enabled Data Analyst
04h:47m:25s on-demand video
|
35 Lectures
3:
Machine Learning/ AI Project Lifecycle
11 Lectures
-
3.1: 10 Stages of AI Project Lifecycle
-
3.2: Requirements and Scope of Work (SOW)
-
3.3: Data Collection
-
3.4: Data Preparation & Exploratory Data Analysis
-
3.5: Feature Engineering
-
3.6: Model Selection & Training
-
3.7: Model Evaluation Metrics (Accuracy, Prediction, Recall & F1 Score)
-
3.8: Model Evaluation Metrics: When to use which Metric?
-
3.9: Model Fine Tuning
-
3.10: Model Deployment
-
3.11: Deployment & Monitoring Using ML Ops
Virtual Internship 2
00h:11m:04s on-demand video
|
9 Lectures
2:
Week 1
27 Lectures
-
2.1: Welcome Note
-
2.2: Your Onboarding Letter
-
2.3: Welcome Note From Your Manager
-
2.4: Let's dive right into Week 1!
-
2.5: Getting Help From Your Seniors / Fellow Team Members
-
2.6: Your First Task
-
2.7: Incoming Task Email 1
-
2.8: Have you completed this task?
-
2.9: Quality Check 1
-
2.10: Quality Check 2
-
2.11: Quality Check 3
-
2.12: Quality Check 4
-
2.13: Congratulations you have completed the first task of your internship.
-
2.14: Python Script Task
-
2.15: Incoming Task Email 2
-
2.16: Have you completed this task?
-
2.17: Quality Check 1
-
2.18: Quality Check 2
-
2.19: Quality Check 3
-
2.20: Quality Check 4
-
2.21: Quality Check 5
-
2.22: Congratulations you have completed 2 tasks in a row!
-
2.23: You need Kanban Training
-
2.24: Incoming Task Email 3
-
2.25: Have you completed the assigned task?
-
2.26: Kanban Knowledge Check
-
2.27: Congratulations you have completed week 1 Successfully.
3:
Week 2
11 Lectures
-
3.1: Let's dive right into Week 2!
-
3.2: Rhonda MVP Project - Your First Power BI Task
-
3.3: Incoming Task Email 1
-
3.4: Have you completed the assigned task?
-
3.5: Quality Check - 1
-
3.6: Quality Check - 2
-
3.7: Designing and Enhancing a Dashboard
-
3.8: Create a Mock-up for the Client
-
3.9: Incoming Task Email: Dashboard Creation
-
3.10: Have you completed the dashboard?
-
3.11: Congratulations
4:
Week 3 & 4
14 Lectures
-
4.1: Let's dive right into the Final 2 Weeks !
-
4.2: Can you help our Marketing Team?
-
4.3: Incoming Task Email: Netflix Analysis
-
4.4: Have you completed the analysis?
-
4.5: Quality Check - 1
-
4.6: Quality Check - 2
-
4.7: Write a mail to the Social Media Analytics Team
-
4.8: Response from the Social Media Analytics Team
-
4.9: Appreciation & New Project Task
-
4.10: Incoming Task Email: Tech Instagram Influencer Analysis
-
4.11: Have you completed the analysis?
-
4.12: Presentation submission
-
4.13: End Note
-
4.14: Get Your Letter Of Completion
Unguided Projects
00h:01m:39s on-demand video
|
1 Lectures
Supplementary Learning
01h:07m:59s on-demand video
|
8 Lectures
5:
Power BI Scenarios
26 Lectures
-
5.1: Scenario - 1
-
5.2: Quality Checks
-
5.3: Scenario - 2
-
5.4: Quality Checks
-
5.5: Scenario - 3
-
5.6: Quality Checks
-
5.7: Scenario - 4
-
5.8: Quality Checks
-
5.9: Scenario - 5
-
5.10: Quality Checks
-
5.11: Scenario - 6
-
5.12: Quality Checks
-
5.13: Scenario - 7
-
5.14: Quality Checks
-
5.15: Scenario - 8
-
5.16: Quality Checks
-
5.17: Scenario - 9
-
5.18: Quality Checks
-
5.19: Scenario - 10
-
5.20: Quality Checks
-
5.21: Scenario - 11
-
5.22: Quality Checks
-
5.23: Scenario - 12
-
5.24: Quality Checks
-
5.25: Scenario - 13
-
5.26: Quality Checks
Live Webinar
30h:18m:35s on-demand video
|
22 Lectures
2:
Career Development Session
5 Lectures
-
2.1: Beginners Guide to Job Seeking - Sep 23
-
2.2: 6 Free Internet Tools to Get an Interview Call - Oct 23
-
2.3: Smart Job Assistance Portal & Expert Resume Insights
-
2.4: The Secret Behind Resumes and Portfolios That Landed Jobs: Decode with your Talent Manager
-
2.5: Strategic Job Search with Google, LinkedIn and Naukri - 22nd November
4:
Expert Webinars
9 Lectures
-
4.1: Transitioning from Non-Tech to Data Analytics - Journey and Tips by Shail Sahu
-
4.2: PL-300 Certification: What You Need to Know & How to Prepare - Anmol Malviya
-
4.3: How to Approach Scenario-Based Questions and Guesstimates in the Interviews - Shashank Singh
-
4.4: Tips and Tricks to Approach Data Analyst Interviews - Gaurav Agrawal
-
4.5: How I would prepare for Data Analyst Interviews If I had to start over - Munna Das
-
4.6: Key Lessons and Interview Tips from My Journey as a Data Analyst - Bharath Kumar G
-
4.7: My Life as a Data Analyst at Ford Motors- Raghavan P
-
4.8: Data Analytics Freelancing Essentials - Santhanalakshmi Ponnurasan
-
4.9: How to differentiate your work - Ashish Babaria
Practice Arena
1:
Scenario Based - Interview Questions
-
1.1: Future Purchase Prediction Date
-
1.2: Customer Purchase Behavior Analysis
-
1.3: Travel Booking Analysis
-
1.4: Top 3 Customer Revenue Analysis
-
1.5: Cricket Match Scheduling
-
1.6: Travel Booking and Revenue Analysis
-
1.7: Customer Revenue Analysis
-
1.8: Monthly Transaction Analysis for Fraud Detection
-
1.9: Fitness MemberShip
-
1.10: Travel Pattern Analysis
-
1.11: Customer Loyalty Analysis
-
1.12: Product Sales by Store in Bangalore
-
1.13: Analyzing Revenue from High-Demand, Premium Products
-
1.14: Calculating Total Revenue by Product Category
-
1.15: Identifying Unsold Products in Inventory
-
1.16: Analyzing Above-Average Salaries by Department
-
1.17: Identifying Top Customers by Average Purchase Amount
-
1.18: Analyzing Monthly Customer Retention Rates for Q2 2024
-
1.19: Identifying Store Leaders: Most Popular Products by Sales
-
1.20: Identifying APAC Markets for Atliq Exclusive
-
1.21: Sorting Unique Product Counts by Segment at Atliq Exclusive
-
1.22: Optimizing Costs: High and Low Manufacturing Costs at Atliq Exclusive
-
1.23: 2020 Quarterly Sales Trends at Atliq Exclusive
-
1.24: Top 3 Products by Sold Quantities Across Divisions, FY 2021
-
1.25: 2021 Sales Channel Performance at Atliq Exclusive
-
1.26: Segment Growth in Unique Products: 2020-2021 Analysis
-
1.27: Monthly Gross Sales Analysis for Atliq Exclusive Customer
-
1.28: Yearly Product Diversification Increase: 2020-2021
-
1.29: Top 5 Indian Customers by Pre-Invoice Discounts, 2021
2:
MySQL Course Exercises
-
2.1: Print All Marvel Studios Movies with Titles and Release Year
-
2.2: Select All THOR Movies by Release Year
-
2.3: Select All Movies Not from Marvel Studios
-
2.4: Retrieving Movies with Their Language Names
-
2.5: Retrieve Hollywood Movies with High Profit After 2000
-
2.6: Count Movies Released Between 2015 and 2022
-
2.7: Determine the Range of Movie Release Years
-
2.8: Count Movies Released Annually in Descending Order
-
2.9: Calculate Profit Percentage for All Movies
-
2.10: Retrieve Telugu Movies
-
2.11: Count Movies by Language
-
2.12: Generate a Report of Hindi Movies Sorted by Revenue
-
2.13: Retrieve Movies with Minimum and Maximum Release Year
-
2.14: Retrieve Movies with IMDb Rating Above Average
-
2.15: Select Movies by Marvel Studios and Hombale Films
-
2.16: List Movies by Latest Release Year
-
2.17: All Movies Released After 2020 with Rating Greater Than 8
-
2.18: All Movies Released After 2020
-
2.19: All Movies Released in 2022
-
2.20: Order Movies by Release Year
-
2.21: List Distinct Bollywood Studios
-
2.22: Release Year of The Godfather
-
2.23: Search for Avengers Movies
-
2.24: List Marvel Studios Movies
Data Analytics
Market Opportunity
While the market is tough, you need to build the exact skills to launch or accelerate your data analytics career with quality teaching. However, just building skills is not enough. You need to know how to present your skills in order to stand out from the crowd.
We help you in each and every step to achieve that:
-
Portfolio Website
-
Ace the job interview
-
Create an ATS resume
-
Build online credibility
-
Find the right jobs and companies
-
Network effectively on LinkedIn by showing your work

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
23% GROWTH
Projected Demand for Data Analysts
Source: U.S. Bureau of Labor Statistics
Data Analyst with AI Toolkit Bundle
US$247
one-time payment
Includes: DA Bootcamp
+
AI Toolkit For Professionals
Get a 25% subsidy on AI Toolkit For Professionals
DA Bootcamp
-
Practice with Complex Datasets of over 7M+ Records
-
Practical Job Assistance with Virtual Internships
-
10+ Business Projects to add to your Resume
-
Job Application and Interview Playbooks
-
Access to ATS Resume Builder
-
Build Free Portfolio Website
-
Unlimited Chat Support
-
Live Monthly Webinars
AI Toolkit For Professionals Course
-
Practical Tool Kit to Survive and Thrive in the AI Era
-
Hands on Practice with 10+ in-demand AI Tools
-
8+ Real Business Use Cases & Automations
-
Complimentary Access to 6 LIVE AI Workshops
Get the complete bundle to learn skills practiced by industry experts. Save US$7 with a 25% subsidy.
May we help you?
Frequently Asked
Questions

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. As a boot camper, you will always have access to the latest monthly webinar along with the recordings from the previous 2 months.
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.
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 50000+ 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
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
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.
(2) After you have completed the Excel course, buy Power BI course.
(3) After completing the Power BI course, buy the Bootcamp.
This way you will pay in 3 installments.
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 4.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 fees to enroll in our bootcamp 4.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 and SQL. The amount you paid for these courses will be deducted from the Bootcamp price.
Note: Data Science courses are not part of the Data Analytics Bootcamp 4.0
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
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.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. As a boot camper, you will always have access to the latest monthly webinar along with the recordings from the previous 2 months.
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.
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 50000+ 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
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
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.
(2) After you have completed the Excel course, buy Power BI course.
(3) After completing the Power BI course, buy the Bootcamp.
This way you will pay in 3 installments.
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 4.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 fees to enroll in our bootcamp 4.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 and SQL. The amount you paid for these courses will be deducted from the Bootcamp price.
Note: Data Science courses are not part of the Data Analytics Bootcamp 4.0
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
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.
The only Bootcamp you need to become a high paying data analyst, with Practical Job Assistance.