fbpx

MODERN
Data Analyst Course

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

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.

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.

8 Steps to Mastery

Purchase Now

Alternative Payment Link 💳

ENROLLMENTS CLOSE IN

Days
Hours
MINS
SECS

Modern Data Analyst course is a “closed” program. Enrollments close on October 27th, 2024.

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

Anonymous X

The examples were great for my level of understanding and the sample files were very helpful to match what you were showing

Lisa Fetrow

Nice flow of information, like most the DAX formulas and the explanations around them. Definitely much more to learn for me 🙂

Patrick W

Business Product Manager

Anonymous X

Superb beginning for the new learners of Power bi
Focus was not only on learning the application but also to understand the logic behind it.
A wonderful course to start with.

Ramya

What happens after purchase?

  • 24 hours later: We send your login details
  • Soon after: You start learning
  • 7th December: We have a Live Q&A call
  • Soon after: You become a modern data analyst
your skills after joining modern data analyst course

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 intermediate level users. So if you have a little 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. Please note that this course is not for noobs.

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.

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