fbpx

MODERN
Data Analyst Course

TOTAL VALUE: $1,199 ~ YOUR PRICE: $499

One course, everything you need to be a modern data analyst.

Most data jobs require proficiency across multiple data technologies. That is why I designed this course. Learn everything you need to be a modern data analyst in one place. Right from SQL, all the way to AI & coding.

Say yes to data challenges and opportunities with confidence.

Everything in one place

Advanced SQL

7 Lessons | 25 Queries | 2.5 Hours

Advanced Power BI

20 Lessons | 20+ Files | 12 Hours

Dashboards

8 Lessons | PRO Techniques| 8 Hours

Advanced Excel

24 Lessons | 50+ Files | 20 Hours

AI & CoPilot

6 Lessons | ChatGPT, CoPilot | 3 Hours

Python [Bonus]

4 Lessons | 10+ samples | 3 Hours

Learn by Doing

Modern Data Analyst course is designed from ground up to be hands-on. You won’t find endless slideshows and demos in this course. Instead you will be doing actual data analysis work to uncover insights, solve business problems and create solutions. You will be learning by doing.

Designed to be AWESOME

65+

video lessons

from SQL to advanced Excel to Power BI to Python to AI. Everything clearly and lucidly explained.

100+

workbooks

right from query files to Power BI workbooks, everything loving made to help you learn faster and better.

24x7

access

so you can up your game whenever you want.

Course Topics

6 Modules
Unlimited Potential

45+hours of video ● 65+ lessons ● 100+ sample files

Welcome Module
  • Welcome to the Modern Data Analyst Course
  • How to use the classroom website
  • Getting your course certificate
  • Say hello to the other MDAs
Databases & SQL
  1. Introduction
  2. Why & How SQL is used by Data Analysts?
  3. Installing the Database Server Software (MySQL)
  4. Sample dataset installation (MySQL & SQL Server)
  5. 10 Example Queries
  6. 5 Advanced Data Analysis Scenarios
  7. Using SQL with Power BI
  8. Using SQL with Excel
Advanced Excel
  • Getting started with Excel
    • Intro to Excel
    • Setting up tables
    • Cleaning bad data
    • Cleaning using Power Query
    • Writing formulas
    • Creating pivot tables
    • Making charts
    • Filtering & sorting
    • Shortcuts
  • Working with Data, Tables & Power Query in Excel
    • Excel Tables
    • Filtering, slicing tables
    • Bad data to good with PQ
    • Unpivoting data with PQ
    • Merging multiple files to one table
  • Writing Formulas
    • Referencing data
    • IF condition, CHOOSE, IFS
    • Statistical analysis
    • Conditional sum, count
    • Lookups
    • Advanced Lookups
    • Using XLOOKUP
    • Working with Dynamic Array Functions
    • Date formulas
    • Text analysis
    • Sentiment analysis
    • Exploratory data analysis
  • Pivot Tables
    • Creating pivot tables
    • Data model + relationships
    • Multiple table pivots
    • Customizing pivots
    • Extra calculations in Pivots
    • Grouping data
    • Slicing and dicing
    • GETPIVOTDATA
    • NEW Adv. Pivot Table bonus
  • Charting with Excel
    • Intro to Charting
    • Picking right charts
    • Anatomy of Excel chart
    • Formatting charts
    • New charts in Excel 365
    • Budget vs. Actual charts
    • Then vs. Now charts
    • Conditional charts
    • Sparklines
    • Interactive charts
  • Advanced Excel Concepts
    • Data validation
    • Creating templates
    • Workbook protection
    • Publishing to web
    • Shapes + pictures
    • Navigation buttons
    • Printing
    • Form controls
    • Custom ribbons
Dashboards
  • What is a dashboard?
  • Process for making a dashboard
  • Business dashboard #1
  • Business dashboard #2
  • Business dashboard #3
  • Employee Dashboard
  • Financial metrics dashboard
  • KPI Dashboard
  • Web enabled dashboard
  • Modern Excel Dashboard
  • Call Centre Dashboard
Power BI
  • Getting started with Power BI – Your first ever play
  • Working with Power Query for data collection & processing
    • Data from Excel / CSV
    • Getting data from Web
    • Automating with Power Query functions
    • Transformations & splits
    • Adding columns based on rules & M formulas
  • Power Pivot & DAX
    • Creating implicit measures
    • Writing DAX formulas for explicit measures
    • Measures & filter context
    • Manipulating filter context with CALCULATE
    • Using variables in DAX
    • Time intelligence calculations
    • Creating text messages with DAX
  • Reports & Dashboards with Power BI
    • Overview of Power BI visuals
    • Visual interactions explained
    • Filters
    • Card visuals
    • Tables & Matrices
    • Slicers
    • Maps
    • Formatting charts & other visuals
    • Conditional formatting
      • Colorscales
      • Databars
      • Rule based CF logic
    • Visual analytics
      • Forecasting
      • Symmetry shading
      • Explain feature
    • Q&A
  • Publishing your reports
    • Adding interactivity thru Bookmarks
    • Drillthrough pages
    • Tooltips
    • What-if parameters
    • Power BI online ecosystem
    • Setting up mobile view
Data Analysis + AI
  • The AI Landscape + Intro
  • Using ChatGPT for Data Analysis work
  • How I use CoPilot to analyze data
  • New CoPilot features to simplify your life
  • Text / sentiment analysis with CoPilot / ChatGPT
  • How to use LABS.GENERATIVEAI() function in Excel?
  • Writing DAX with AI
  • SQL queries with AI
  • Strategies and Tactics to use AI better in work + life
Python Coding (Intro)
  • Why and how Python is used in Data Analysis
  • Setting up Python environment on your computer
  • Introduction to programming with Python
  • How to use Pandas + NumPy to analyze data

Beautiful + Insightful

Create stunningly beautiful and acutely insightful dashboards, reports and analysis from your data.

SNAG-3721
SNAG-3621
free download - excel call centre dashboard
portfolio-dashboard-screenshot
SNAG-3728
KPI Dashboard for hotel chain - Excel School
Sales Performance Dashboard
Vacation Dashboard
Business Dashboard
Training Tracker Dashboard
goal tracker with conditional formatting
Data Play - London Population
Comparison matrix with in-cell data bars
Target vs. Actual performance chart #1
Target vs. Actual performance chart #2
Retail Dashboard
Exec. Dashboard
Budget vs. Actual Dashboard
Data Play - Squirrels in Central Park

Designed for PROs
Designed by a PRO

Hi there 👋. My name is Chandoo. I have using SQL, Excel, Power BI and coding platforms for the last 16 years. I worked as a data analyst for many Fortune 500 companies and government organizations. I poured all my knowledge, practical skills and years of experience in to designing this one-stop course for modern data analysts.

Let me help you achieve your data dreams.

PRE-ORDER NOW

Modern Data Analyst Course

by Chandoo
  • 6 Modules
  • 65+ Video Lessons
  • 100+ Sample files
  • 24x7 Access
  • [Bonus] Python Lessons
  • [Bonus] Power BI Cheatsheet
  • 14 day moneyback gaurantee
$1,199 $499
Pre order
Pay in INR ₹32,000

PRE-ORDER DISCOUNT ENDS IN...

Days
Hours
MINS
SECS

People love my courses ❤

This is the first course that I have attended with you. I've already told my supervisor that I can't wait to take another one.

Angie W

Data Professional

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.

Rebekah S

Data Rockstar

Great bootcamp! Worth every penny.

John A

You are just awesome, it's one thing to have the knowledge and a totally different thing to share it so simply.

Aadityendra

Wonderful & Awesome explanation... Learnt a Lot... Thanks Chandoo...

Nandan

FAQs

What software do I need?

You need:

  • MySQL Database
  • MySQL Workbench
  • Microsoft Excel
  • Microsoft Power BI Desktop
  • Visual Studio Code
  • Python with Anaconda

Most of this software is free (except Excel). In the course, you will find detailed instructions on the the installation process.

Can I learn any time?

Yes. The classroom website is accessible 24×7. You can login and learn whenever you want.

Can I watch offline?

Yes. You can download HD quality videos for offline viewing & practice.

Is the Excel module same as "Excel School Dashboards"?

Yes. It is same as my Advanced Excel course – Excel School Dashboards.

Is the Power BI module same as "Power BI Play Date"?

Yes. It is same as my Power BI course – Power BI Playdate.

Do I need any prior skills?

This course is designed for beginner to intermediate level users. So if you have no or little prior data skills, you stand to gain most from this program. That said, even if you are a seasoned user of one of the platforms (say Excel / Power BI), you will learn quite a bit in the modern data analyst course. 

What happens after I purchase?

After purchasing the course, I will set you up in our online classroom and email the details (username, password, access URL) to you. This process usually takes 12-24 hours. Once you have the details, you can start going thru the lessons immediately. All the lessons except,

  • Python
  • AI

are already uploaded. The Coding and AI modules will be available from November 2024.

How long is the enrollment open?

The enrollment window is open from 15th of October until 27th of October, 2024. So don’t miss the opportunity to sign up during this window.

Can I enroll my team?

Sure. We offer 25% team discount when enrolling 3 or more people. Just enter the quantity during the purchase process or email me if you want an invoice.

My question is not here..?

Please get in touch with me so I can help you.

Send me a message

THANK YOU

Thank you for making me a part of your learning journey. I can’t wait to meet you inside the Modern Data Analyst Course.

Thank you

(C) chandoo.org

Send me your question about Modern Data Analyst Course