Automated portfolio website to showcase your work
Unlimited daily doubt clearance support via private discord community
Dedicated module to become AI-enabled Data Analyst
Practical job assistance (Resume & Interview preparation + Interview leads + Building online credibility)
Real-time industry-based projects in FMCG, Hospitality, Insurance & Telecom domains & Finance, Sales, Marketing, HR & Supply Chain departments
Complex datasets that have more than 7 million records like you will get in a company
Highly engaging content with the cinematic experience, real business practice problems, business meetings, etc.
Easy explanation of complex topics by Dhaval Patel, a famous Youtuber (840k+ subs) teacher & active data industry expert
Real-time tasks prepared by Hemanand Vadivel, a data analytics leader with 8+ years of experience in Europe
No Questions Asked Refund Policy
Within 30 days of enrollment
If you have already taken any of our paid courses, you pay only the difference
(Bootcamp price - course price)
Bootcamp Brochure
DownloadKey reasons
We don't make fake job guarantees. But our learners get placed.
30 days refund. No questions asked.
Discounts? We believe in honest pricing!
It's not a boring course. It's an engaging experience.
Social Proof from
Our content is rated 4.9/5 from 22802+ Learners
Performance Analyst
Data Aspirant At Codebasics
Senior Analyst
I must say it's a game-changer! This course is exactly what the market needs, and I wholeheartedly recommend it as the only path to pursue a data analyst career.
The team at codebasics.io deserves a standing ovation for their comprehensive approach to Power BI, SQL, and advanced Excel. It's not just a course; it's a transformational experience. Kudos to Dhaval Patel and Hemanand Sir.
Business Intelligence Analyst
I recently had the privilege of enrolling in the Power BI course offered by Codebasics, and I cannot express my gratitude enough to Dhaval Patel Sir for creating such an invaluable resource. This course has been a game-changer for me, and I would like to share my thoughts and appreciation.
From the very beginning, it was evident that this course was meticulously designed to cater to both beginners and experienced users of Power BI. The comprehensive curriculum covered every aspect of Power BI, and the clear and concise explanations made it easy to grasp even for someone like me, who had limited prior experience with the tool. The course started from the basics and gradually progressed to more advanced topics, ensuring that students of all levels could benefit from it.
One of the standout features of this course was Dhaval Patel Sir's teaching style. He has an incredible ability to break down complex concepts into understandable, manageable pieces. His teaching is not only informative but also engaging, and his enthusiasm for Power BI is contagious. I appreciated how he not only explained the "how" but also delved into the "why" of various techniques, which helped me develop a deeper understanding of the subject matter.
The course also included practical exercises and real-world examples that allowed me to apply what I had learned. These hands-on experiences were instrumental in cementing my knowledge and skills in Power BI. Additionally, the course provided a supportive community of fellow learners where we could ask questions, share insights, and seek guidance, making the learning experience more interactive and enjoyable.
As someone who was seeking to enhance my data visualization and reporting skills, this Power BI course proved to be an invaluable resource. The insights and techniques I gained have already proven to be immensely beneficial in my professional life. I am now able to create interactive, insightful reports and dashboards with ease, which has significantly improved my decision-making processes.
I want to extend my sincere gratitude to Codebasics and, in particular, Dhaval Patel Sir for their dedication to creating such a high-quality course. The knowledge I have gained has opened up new opportunities in my career, and I am now equipped with the skills to excel in the world of data analysis and visualization.
In conclusion, if you are looking to master Power BI, I wholeheartedly recommend the Power BI course by Codebasics, and I can't thank Dhaval Patel Sir enough for his exceptional guidance and expertise. This course is a true gem, and it's a must for anyone looking to excel in the field of data analytics and business intelligence. Thank you, Codebasics, and Dhaval Patel Sir, for this incredible learning experience!
Data Analyst
I recently had the incredible opportunity to enroll in the Data Analyst Bootcamp, and I can confidently say that it has been a transformative experience. This intensive program exceeded all my expectations and has set me on a path towards a promising career in the world of data analysis.
From the moment I joined the bootcamp, I was impressed by the level of organization and professionalism demonstrated by the instructors and staff. The curriculum was meticulously designed to cover a wide range of essential topics in data analysis, and it struck a perfect balance between theory and hands-on practice. The bootcamp didn't just teach me how to analyze data; it taught me how to think critically and solve complex problems using data.
Engineer
Code Basics' data analytics course has been an exceptional journey from basic to advanced concepts. It provides a well-structured, engaging, and comprehensive learning experience. The inclusion of quizzes and practice exercises adds an element of fun while reinforcing knowledge, and the instructor's clear teaching style simplifies complex ideas for learners of all levels. Code Basics' commitment to students' success, along with high-quality resources, makes it a highly recommended platform for mastering data analytics.
My experience with Code Basics in learning data analytics has been enlightening and enjoyable. I eagerly anticipate exploring more courses on this platform in the future.
At the very first instance, the overview of this Bootcamp was an eye-opener for me towards the career of Data Analytics which I want to pursue so desperately. I truly appreciate the structured and well-organized content which itself is so refreshing during the course. The insights are so enriched with industry-level perspective. The Assignments, quizzes which has been infused along with the course has upgraded my understanding of Data Analytics into a different level which has been an advantage for me. I truly appreciate the teacher and am so grateful for this content.!
You can
Use Python, SQL, Excel, and Power BI to provide insights to the executive team in the insurance industry. This is a virtual internship project that simulates working on a client project and involves ad-hoc tasks and final solution implementation.
You will generate revenue insights in hospitality domain by performing data cleaning, data transformation and insights generation using Python and Pandas.
You will implement end to end data analytics solution (along with deployment) in Power BI to generate insights for finance, sales, marketing and supply chain departments in an FMCG company
Create a scenario planning tool in Excel to meet gross margin target. You will analyze best, realistic and worst case scenarios based on various business metrics such as net sales, discount percentage, gross margin, spread between the margin and the target etc.
A project manager is experiencing difficulties in prioritizing projects. To assist them, you will create an Excel tool for a project priority matrix that utilizes a feasibility/impact analysis to prioritize projects effectively.
Overview
00:42 on-demand video
15 Lectures
15 Lectures
Why Should You Become a Data Analyst?
How Do I Know If The Data Analyst Role Is Suitable For Me?
Is Computer Science Degree / Young Age / Relevant Work Experience Mandatory?
What Kind of Job Assistance Do You Provide?
How Do I Get Doubt-Clearing Support? (Discord)
How Much Time Do I Need to Complete The Bootcamp?
Do I get a Real Internship Certificate After Completing a Virtual Internship?
Do the Creators of This Bootcamp Have Real Industry Experience?
How Many Business Projects Will I Complete in This Bootcamp?
How can I Trust That This Bootcamp Has the Best Content on Planet Earth?
What Domain and Functional Knowledge Will You Build and How?
What are the Soft Skills I Will Acquire By the End of Bootcamp?
Bootcamp Syllabus Overview
How Will I Be Informed About The Monthly Live Webinars?
System Requirements
09:01 on-demand video
70 Lectures
12 Lectures
Peter Pandey’s Journey and Need to Learn Excel
Installing Excel: Windows / Mac
Getting Familiar With Excel
Getting More Familiar With Excel
Introduction to Formulas
Formula Behavior
Introduction to Tables
Introduction to Charts
Other Essential Features
Peter Gets His First Assignment From His Senior
Practice Exercise: Personal Expense Tracker
Quiz
8 Lectures
Basic Maths to Business Metrics (Bollywood movies revenue avg)
Commonly Used Business Metrics (P&L)
Commonly Used Statistic Concepts (Mean, Median, Mode)
Commonly Used Statistic Concepts (Variance, Standard Deviation)
Commonly Used Statistic Concepts (Correlation)
Peter Gets to Solve a Real Time Problem
Practice Exercise
Quiz
13 Lectures
Pivot Table Introduction: Apple Product Sales
Pivot Table For Movie Analytics
Creating a Report Using Pivot Table
Pivot Table Options & Formatting
Using Power Pivot & DAX For Powerful Business Reports
Adding Targets Using Data Modelling in Power Pivot
Breaking Down Complex Problems: Thinking Process of a Highly Paid Data Analyst
More Business Metrics and Conditional Formatting
VBA Basics & How Much VBA You Should Learn
Peter Practices On His Own
Practice Exercise
Quiz
I Need a Favour
11 Lectures
ETL (Extract, Transform and Load Data) in Excel I
ETL (Extract, Transform and Load Data) in Excel II
Business Report: Solution Design Thought Process
Creating Connections Among Tables Using Data Modelling
Adding a Date Table Using Power Query
Functional Knowledge: Sales
Sales Analytics: Creating Customer Performance Report
User Empathetic Report Design
Sales Analytics: Creating Market Performance vs Targets Reported
Practice Exercise
Quiz
00:17 on-demand video
4 Lectures
17:10 on-demand video
121 Lectures
13 Lectures
Install Power BI
Power BI: Tool Introduction
Power Query: Intro & Column Transformations
Power Query: Merging and Appending
Power Query: Best Practices
Introduction to DAX
Introduction to DAX - II
Introduction to Data Modeling
Introduction to Creating Visuals
Tony asks Peter to Fix Data Holes
Practice Exercise
Chapter Summary
Quiz
9 Lectures
Problem Statement
The Email that Started this Project
Project Kick-off Meeting
Learn how a ‘Project Charter’ is Used in Companies
Project Kick-off: Session Debrief
Senior Data Analyst Sets Up the Next Steps with Junior Data Analyst
Simplified: Profit and Loss Statement
Chapter Summary
Quiz
10 Lectures
Simplified: Data Warehouse, OLTP vs OLAP, Data Catalog
Install MySQL and Import Data
Simplified: Data Exploration Using SQL, Star Schema, Fact vs Dimension Tables
Load and connect data with MySQL (instructor)
Create a Date Dimension Table
Validate Data against Benchmark Numbers
Tony’s Valuable Advise to Peter
Practice Exercise
Chapter Summary
Quiz
11 Lectures
Power Query or DAX for Generating Calculated Columns?
Data Modelling: Star and Snowflake Schema
Data Modeling: Connect Dimensions with Fact Tables
Simplified: Why Do We Need Dimension Tables?
Mentor Talk: Congratulations! You are Levelling Up!
Create Calculated Columns Using DAX
Easy Way to Verify Your Numbers in Power BI
Assignment: Optimize Report and Reduce File Size by 25 %
I Need a Favour
Chapter Summary
Quiz
15 Lectures
Finance View: Prepare a List of Metrics
Simplified: Calculate Function & Filter Context
Finance View: Creating Metrics
Finance View: Create P&L Table Structure
Finance View: Create Last Year (LY) Column
Finance View: Build an Ultimate DAX Measure for P & L Table Structure - I
Finance View: Build an Ultimate DAX Measure for P & L Table Structure - II
Finance View: Create ‘Quarters’ & ‘YTD/YTG’ Slicers
Mentor Talk: Figuring Out Solutions
Finance View: Create a Line chart to Show Performance Over Time
Finance View: Build Top Product, Market & Region Visuals
Intermediate Review: I Met Product Owner Nick and He Gave this Feedback!
Finance View: Add Net Profit
Chapter Summary
Quiz
10 Lectures
Review Sales View Mockup
Sales View: Build Top Customers & Performance Matrix Visuals
Sales View: Build Product Performance & Unit Economics Visuals
Build Marketing View
Simplified: Supply Chain Basics
Supply Chain View: Review Mock Up
Supply Chain View: Build Key Measures
Supply Chain View: Build Visuals
Chapter Summary
Quiz
16 Lectures
Stakeholder Analysis and its Significance
Peter Recalls the Stakeholder Mapping Meeting
Stakeholder Review Meeting: How did it Go?
This is the secret to be ‘Job Ready’!
Practice Exercise: Quick Fixes
Quick Fix: Chg% formula
Practice Exercise: Implementing Dynamic Benchmark
Practice Exercise: Adding Dynamic Slicer to Filter Visual
Practice Exercise: Create a Toggle Button to Switch between Two Visuals
Practice Exercise: Create a Tool Tip to Show Trend
Learn: Adding Market Share Data
Practice Exercise: Create an Executive Dashboard
Learn: Performance Optimization
Learn: Fix Data Quality Issues
Chapter Summary
Quiz
11 Lectures
Solution: Quick Fixes
Solution: Implementing Dynamic Targets (Add Targets)
Solution: Implementing Dynamic Targets (Create a dynamic switch between Targets and LY)
Solution: Implementing Dynamic Targets (P & L visuals to compare Target or LY based on selection)
Solution: Adding Dynamic Slicer to Filter Visual
Solution: Create a Toggle Button to Switch between Two Visuals
Solution: Create a Tool Tip to Show Trend
Solution: Create an Executive Dashboard (KPI Visuals)
Solution: Create an Executive Dashboard (Key Insights by Subzone )
Solution: Create an Executive Dashboard (Market Share Visual & Conditional Formatting)
Solution: Create an Executive Dashboard (Final Enhancements)
01:28 on-demand video
21 Lectures
7 Lectures
Get a Shareable Public Link For Your Power BI Project
Share Your Power BI Project with Potential Recruiters
Differentiate Your Work with New Design
How to differentiate your work - Expert Webinar
One More Power BI Project for Your Portfolio
Check Your Work With this Guided Project
One Step Closer to Your Dream Portfolio
11:14 on-demand video
84 Lectures
14 Lectures
Install MySQL: Windows
Install MySQL: Linux, Mac
Import Movies Dataset in MySQL
Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)
Exercise - Retrieve Data Using Text Query (SELECT, WHERE, DISTINCT, LIKE)
Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)
Exercise - Retrieve Data Using Numeric Query (BETWEEN, IN, ORDER BY, LIMIT, OFFSET)
Summary Analytics (MIN, MAX, AVG, GROUP BY)
Exercise - Summary Analytics (MIN, MAX, AVG, GROUP BY)
HAVING Clause
Calculated Columns (IF, CASE, YEAR, CURYEAR)
Exercise - Calculated Columns (IF, CASE, YEAR, CURYEAR)
The Data God’s Blessing
Quiz
17 Lectures
Database Normalization and Data Integrity
Entity Relationship Diagram (ERD)
Mentor Talk: Art of Googling
Data Types: Numeric (INT, DECIMAL, FLOAT, DOUBLE)
Data Types: String (VARCHAR, CHAR, ENUM)
Data Types: Date, Time (DATETIME, DATE, TIME, YEAR, TIMESTAMP)
Data Types: JSON, Spatial (JSON, GEOMETRY)
Luck Favors the LinkedIn Post
Primary key
Foreign Key
Create a Database From an Entity Relationship Diagram - ERD
Import Data From a CSV File Into a Database
Insert Statement
Update and Delete
I Need a Favour
Expect the Unexpected: The Intermission Scene
Quiz
10 Lectures
Backlog Grooming Meeting: Gross Sales Report
User-Defined SQL Functions
Exercise: User-Defined SQL Functions
Gross Sales Report: Monthly Product Transactions
Gross Sales Report: Total Sales Amount
Exercise: Yearly Sales Report
Stored Procedures: Monthly Gross Sales Report
Stored Procedure: Market Badge
Benefits of Stored Procedures
Quiz
16 Lectures
Problem Statement and Pre-Invoice Discount Report
Performance Improvement # 1
Performance Improvement # 2
Database Views: Introduction
Database Views: Post Invoice Discount, Net Sales
Exercise: Database Views
Top Markets and Customers
Exercise: Top Products
The Two Most Important Skills for the Data Analyst
Window Functions: OVER Clause
Window Functions: Using it in a Task
Exercise: Window Functions: OVER Clause
Window Functions: ROW_NUMBER, RANK, DENSE_RANK
Exercise: Window Functions: ROW_NUMBER, RANK, DENSE_RANK
5 Ways SQL is Used in the Industry
Quiz
13 Lectures
Supply Chain Basics : Simplified
Problem Statement
Create a Helper Table
Database Triggers
Database Events
Temporary Tables & Forecast Accuracy Report
Exercise: CTE, Temporary Tables
Subquery vs CTE vs Views vs Temporary Table
User Accounts and Privileges
Database Indexes: Overview
Database Indexes: Composite Index
Database Indexes: Index Types
Quiz
07:13 on-demand video
70 Lectures