*** Proof of Product ***
Exploring the Essential Features of “Chandoo – Excel School + 50 Ways Course”
50 Ways to Analyze your Data
Become an awesome analyst
Problem: Too much data, too little action
This is the age of big data. Alas, what we need is big insights, not big data. Unfortunately, finding even small insights buried in heaps of data is hard. And as analysts & managers, we are expected to spot trends before they are obvious, raise red flags early on and prompt action backed by solid insights. But how?
The challenge is complicated due to,
- we have too much data
- too many buzz words (big data, data science, business intelligence, predictive analytics etc.) but no instruction on how to do
- everyone (customers, bosses, regulatory authorities etc.) expect us rely on data to take actions
- the results are expected NOW, not after 6 weeks of analysis
Answer: Analyze data to make better decisions
The answer is obvious. We need to analyze data in agile fashion and derive results that prompt us towards better decisions.
What we need is not the answer. We need the solution.
A solution to help you take any raw data and uncover the story it is hiding. This is where 50 ways to analyze data course can help you.
Reality: 80% of highest paying business jobs require advanced Excel & analysis skills
Preparing you for a deep dive in to the data ocean
Here is one question you should not be afraid to hear.
“Can you analyze this data and tell me what is going on?”
Time for a short story from my past. Rewind to June 2006. Right after my MBA, I became a business analyst with one of the largest technology companies in world. Everything was smooth until my first assignment. My boss called me to her cabin and said, “Can you analyze our top 100 clients and tell me what you find?”
It was the kind of open ended question that has many answers. And I knew none. After several days of frantic analysis (in Excel, of course), I came up with several charts only to be shot down. It is as if I am shooting in dark and hoping to hit the insight my boss wanted.
Only when I applied structured thinking and proper analysis did I find the right insights that helped us take better decisions.
After 13 years, 1,000s of spreadsheets later, I am very happy to create a detailed program to help you attack such opened ended questions confidently.
50 lessons, hundreds of examples
Lesson plan
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 (25 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 (11 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
- Segmentation & 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)
- Example workbooks for each lesson
- Bonus: Cust. complaints case ($99 value)
- Uber vs. Your Car – Bonus Model & Video
- Forecasting time series data – interactive chart – XLS & Video
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
Skills you will gain
In the 50 ways to analyze data course:
- How to analyze data & present results
- How to model & solve business problems
- Multiple approaches to analyze data
- Creating interactive analysis outputs
- Core analysis concepts on statistics, operations & finance
- Obtaining, cleaning & structuring data for analysis
- Speeding up analysis process
- Making your analysis flexible & easy to change
- Simulations and what-if analysis
In the Advanced Excel & Dashboards module:
- Using Excel faster & better
- Creatively using & combining Excel formulas
- Making awesome workbooks
- Creating stunning visualizations & interactive charts
- Bringing outside data to Excel for analysis
- Unlocking the mysteries of Pivot Tables
- Preparing amazing dashboard reports & automating them
- Becoming productive in Excel
What do you get?
Over 50 hours of training
24 hours of Basic to Adv. Excel
20 hours of Data analysis
8 hours of Dashboard training
100+ example workbooks
Bonus: Excel Basics videos
Bonus: Uber vs. your car model
Bonus: Cust. complaints case
Bonus: Forecasting time series data
Bonus: Excel Formula course
Please see the full list of alternative group-buy courses available here: https://lunacourse.com/shop/
