50 ways to analyze data course opens on 24th of February, 2016 (Wednesday)

Posted on February 10th, 2016 in Learn Excel , Training Programs - 6 comments

Hi friends & readers of Chandoo.org

I am very happy to invite you to our newest online class, 50 ways to analyze your data. This program is aimed to make you an awesome analyst, training you on vital skills like data analysis, data science, visualization of outputs, modeling business problems and finding best solutions.

Please take a few minutes to read this. If you are interested in the program, sign up for the waiting list.

What is this course?

50 Ways to analyze your data - an online course from Chandoo.org to make you a better analyst

It is the age of big data. Alas, what we need is big insights. But finding even small insights buried in our data is a hard task. To find the stories hidden in your data, you need to follow a process like this:

  1. Collect & clean data
  2. Structure the data
  3. Model business problems
  4. Analyze the data (or solve the problem)
  5. Visualize results
  6. Find conclusions
  7. Add layers of complexity to the problem
  8. Build what-if scenarios
  9. Reach conclusions
  10. Take action

This is where the 50 ways to analyze your data course helps. In this program, we analyze 50 familiar, important and diverse business situations using several of the above steps.

My goal is to make you say “YES” every-time your boss asks “Can you analyze this data and tell me what is going on?”

Can I join 50 ways course?

If you are an analyst or manager, running a business or handle resources / people / projects, you will certainly need this course.

You need at least intermediate or higher level of Excel knowledge.

If you have difficulties with VLOOKUPS, INDEX+MATCHES, Pivot Tables, Conditional Formatting & Form controls, then please consider for enrolling Excel School + 50 Ways bundle option for best results.

This course works best with Excel 2016, Excel 2013, Excel 2010 or Excel 2007. Most of the concepts we teach are universal and can be applied to Excel 2003, Excel for Mac (2011 & 2014) as well with minor tweaks to downloadable workbooks.

What is covered in this course?

As the name suggests, 50 ways to analyze data contains 50 video lessons, each exploring one analysis technique or situation.

You can consume these lessons in any order. The only requirement is that you should be good with Excel. If you are a beginner, I suggest enrolling for the option – Advanced Excel + 50 Ways course package.

Let’s see the lesson plan.

General Analysis techniques (24 lessons):

  • Moving averages
  • Weighted averages
  • Top 5 / bottom 5 analysis (2 lessons)
  • Trend analysis (4 lessons)
  • Descriptive statistics
  • Visual analysis of distribution (2 lessons)
  • Budget vs. Actual analysis (3 lessons)
  • How many items are due?
  • Overlapping dates & times
  • Monthly totals from daily data
  • Quarterly totals & reporting from data (2 lessons)
  • Unique & duplicate data analysis
  • Panel charts
  • XY Relationship analysis & charts
  • Indexed charts
  • Word frequency & sentiment analysis

Marketing & Operations analysis techniques (12 lessons):

  • Pareto analysis & charting
  • Us vs. competition analysis & charts
  • Solver & optimization techniques (2 lessons)
  • Planning a project
  • FIFO inventory analysis
  • BCG matrix analysis
  • Random allocation & scheduling (2 lessons)
  • Analytical charts
  • Cluster Analysis using K means technique
  • Finding outliers using K Nearest Neighbors technique

Financial analysis techniques (8 lessons):

  • Break-even analysis
  • Buy vs. Rent analysis
  • Time value of money
  • Cost benefit analysis
  • 2 way data tables & what if analysis
  • Internal rate of return
  • Circular calculations & scenarios
  • Simulation using Data tables

Case studies (6 lessons):

  • Case studies on detailed analysis reports, dashboards & articles featured on chandoo.org hall of fame.

Bonus material:

  • Introduction to Excel
  • Techniques on working with raw data (clean up techniques, connecting to external databases)
  • Special bonus – Excel formula crash course (for Excel School + 50 ways option)
  • Example workbooks for each lesson

Lessons for Advanced Excel (Excel School) module:

This is an optional module you can sign-up for. It includes 32 hours of training on beginner to advanced Excel concepts and dashboard reporting. This module has below lessons:

  • Excel basics – 3 lessons
  • Excel formulas – 11 lessons
  • Advanced formulas – 7 lessons
  • Formatting & presentation of data – 3 lessons
  • Conditional formatting – 3 lessons
  • Excel charting basics – 4 lessons
  • Advanced charting in Excel – 2 lessons
  • Interactive & dynamic charts in Excel -2 lessons
  • Using data validation, sorting & filtering features –
  • Excel Pivot tables – 2 lessons
  • Working with external data – 5 lessons
  • Excel Dashboards – 12 lessons

Sample of what you will learn:

Here are a few analysis & dashboards you will learn how to create:

Example dashboards and analysis techniques you will master in 50 ways + Excel School programs

Interactive Pareto Analysis – Lesson from 50 Ways course
Demo - Pareto Analysis - Lesson in 50 ways to analyze data course

Interactive What-if Cost Benefit Analysis model – Lesson from 50 Ways course

What-if analysis - cost benefit workbook demo

Interactive density plot to analyze distribution – 50 ways course

Interactive density plot - demo from 50 ways to analyze data course

There are many more.

Important Dates

This is a closed online course. The enrollment window is open for 10 days, starting Wednesday – 24th of February, 2016.

Please keep these dates in mind when joining this class.

  • Enrollment opens: 24-FEB-2016 (Wednesday)
  • Enrollment closes: 4-MAR-2016 (Friday, End of day, Pacific Time)
  • Classes begin: As soon as you enroll.

Signup for the waiting list

If all this sounds interesting, sign up for the course waiting list below. (Click here in case you don’t see the form)

I will email you on 24th with the course details. As a bonus, I will send you 1 video lesson today so you can get started early.

6 Responses to “50 ways to analyze data course opens on 24th of February, 2016 (Wednesday)”

  1. Abhishek says:

    I am trying to register but the sign up page pops up the error e-mail ID not valid and prompts for an alternate ID to be used. but this is a gmail ID I have been using forever.
    Please help me to register.

  2. rohan says:

    i use excel every day but i am not pro in it, i am good at simple statistical data analyse . my concern is does it help me to analyse google analytic data ?? so that i can analyse the data and apply changes on my website.

  3. Vincent says:

    Could I get a cost for the course. I live in south Africa and the South African Rand is not doing too well against the American Dollar.

    • Pedro says:

      I live in Brazil and have the same concern. In 2014 1 USD buys 2,24 BRL (local currency). Today 1 USD buys 4 BRL, and is getting worse.

  4. Rama says:

    Is this is chargeable ?

  5. Ryan says:

    Hi Chandoo,

    Excel School + 50 Ways bundle.

    How much is this and when does it commence?
    How to sign up?


Leave a Reply