Close this search box.

everything you need

in one place





Data Analyst Bootcamp - 2023

Data Analyst Bootcamp - 2023 by Chandoo
Enrollments closed. Come back in 2024.

What is this bootcamp?

Today, data Analysts are expected to know many technologies. That is why, I created this bootcamp. In this live cohort based training, I will teach you how to get awesome with 3 of the most popular data platforms.

  • Excel
  • Power BI
  • SQL

You will learn:

  • Effective data analysis with Excel
  • Interactive Charting to impress your boss
  • Advanced Excel features for your success
  • Essential SQL for data analysis
  • Powerful dashboards with Power BI
  • One click insights with Power BI

What will you get?

data analyst bootcamp

The training will run via online Zoom / teams call. You can interact, ask questions or share your screen if needed.

When & How

This training runs on 5 days between 11th to 17th of October, 2023. 

Detailed agenda is further down the page.

Exact date & time in few popular locations:

The time & date shown below is as per local time on the day of training.

  • Wellington, NZ: 6AM to 8AM
  • New Delhi, India: 10:30PM to 12:30AM
  • London, UK: 6PM to 8PM
  • New York, USA: 1PM to 3PM
  • Seattle, USA: 10AM to 12Noon

Chandoo.org students work in...

Chandoo.org students work in...

Topics Covered

11 October

Day 1️⃣

Advanced Excel Day

  • “New” Dynamic Array Functions
  • Power Pivot in Excel
  • Interactive Charting
  • 10 Data Analysis Problems & How to solve them with Excel
  • Thinking like a “data analyst” with Excel

12 October

Day 2️⃣

Power BI Day

  • Data cleanup and transformations with PQ
  • Setting up a star schema data model
  • Data modeling Creating DAX measures
  • Visual Interactions & Tooltips
  • Answering 5 business questions with Power BI

13 October

Day 3️⃣


  • SQL concepts for data analysis
  • SELECT & WHERE statements
  • GROUPING data (Pivots)
  • 10 Data analysis problems with SQL

16 October

Day 4️⃣

Excel Project: Financial Performance Dashboard

  • KPIs & layout for the dashboard
  • Data modeling & calcs. with Pivots
  • Creating custom charts
  • Conditional formatting to elevate data 
  • “Interactive” dashboard with slicers
  • Publishing & Updating  the dashboard

17 October

Day 5️⃣

Power BI Project: HR Dashboard

  • Goals & design for the dashboard
  • Data modeling
  • Visuals & interactions
  • Drillthrough pages
  • Conditional formatting to highlight results
  • Custom chart titles
  • Publishing & updating the dashboard
What do I use and recommend - Chandoo

Who is this bootcamp for?

  • Aspiring Data Analysts
  • Work with data often and want to IMPROVE
  • Familiar with Excel / Power BI and want to go to NEXT level

How it works?

Prep. Course

Before the bootcamp, you will be given 3 hours prep. course to bring you up to speed with Excel & Power BI.

Daily Learning & Growing

During the bootcamp, we meet everyday for 2 hours and unpack a new concept. Everyday ends with a Q&A session and homework problem for you to practice. You will also get sample files & recordings everyday to help you learn offline.


We meet again after 10 days to check the progress and share the experiences.

Book your spot now

Data Analyst Bootcamp

October 2023
$ 599
  • 5 days x 2 hours
  • 11 to 17 Oct
    1PM to 3PM (ET)
  • Live Classes + Recording
  • Workbooks, Datasets, SQL
  • Q&A session
Enrolments closed. Comeback in 2024.

Sample files & recording

You can download sample files & recordings for reference.

Homework problems

Daily homework problems for practice.

Ask questions

You can ask questions and interact with other participants.

Frequently Asked Questions

Who is this training for?

This training is perfect for Excel & Power BI beginners & intermediate users. If you work in a data profession (data analyst, reporting analyst or similar) and need to use Excel, Power BI & SQL on a regular basis, you will find this training extremely valuable.

How this is training is run?

This training will be thru a Zoom video session. You will be able to see my presentation & explanations as well as share your audio (and screen if you want) when asking questions.

What software do I need?

You need:

  • Microsoft Excel (365 or 2016+)
  • Power BI Desktop software (latest version)
  • SQL Server Management Studio (SSMS)
  • Zoom

What topics are covered?

This training covers Advanced Excel, SQL & Power BI based data analysis. You will learn a ton of useful, practical concepts developed from my 15+ years of experience using these technologies.

Do I need any prior skills?

It is recommended that you have prior basic skills in Excel & Power BI. No prior knowledge of SQL is necessary although a familiarity with databases / SQL is appreciated.

Can I ask questions?

The session will be highly interactive. You will have lots of opportunities to share your experiences or ask questions.

What if I can’t attend part of the training?

It is highly recommended that you plan to attend all 5 days. While you can watch the recording, you will miss out on the interaction and break-out sessions. 

Can I get an invoice so my company can pay for this?

Sure. Please email me at Chandoo.d@gmail.com so I can send invoice. Please include your name, company name and other details.

I want to enroll multiple people for this…

Please specify the quantity when purchasing this class. You will get 25% discount when enrolling 3 or more people in one go. Email me at chandoo.d@gmail.com if you need any help with the process or need an invoice.