Chandoo.org Podcast - Become Awesome in Data Analytics

In the 41st session of Chandoo.org podcast, Let's take a trip to data hell and meet 6 ugly, clumsy, confusing charts. I am revisiting a classic Chandoo.org article - 6 Charts you will see in hell.

What is in this session?

In this podcast,

Quick announcement about Awesome August

6 charts you should avoid

3D charts

Pie / donut charts with too many slices

Too much data

Over formatting

Complex charts

Charts that don't tell a story

Conclusions

In the 40th session of Chandoo.org podcast, Let's talk about Power Query. I have the pleasure and fortune to catch up with Miguel Escobar (who along with Ken Puls runs PowerQuery.Training website) and talk about this very exciting piece of technology and how it can make our life simpler.

What is in this session?

In this podcast,

Welcome

Miguel's introduction, background and current projects

What is Power Query

How to install it

Sample use cases of Power Query

What is Power BI

Resources for learning Power Query - Books & Courses

In the 39th session of Chandoo.org podcast, Let's learn about FOR loops.

There is a special giveaway in this podcast. It is a workbook with several FOR loop VBA code examples. Listen to the episode for instructions.

What is in this session?

In this podcast,

Announcements

What is a loop - plain English & technical definitions

For Loop vs. other kind of loops (While & Until)

For Next loops

For Each loops

Nested For loops

Special tips on For loops

Performance issues & infinite loops

Conclusions & giveaway

In the 38th session of Chandoo.org podcast, Let's optimize data to ink ratio of your charts.

What is in this session?

In this podcast,

Announcements

What is Data to Ink Ratio?

Obvious ways to optimize Data to Ink Ratio

More ways to optimize Data to Ink ratio

Highlighting what is important

Conclusions

In the 37th session of Chandoo.org podcast, Let's debug 'em #VALUEs & #N/As.

What is in this session?

In this podcast,

Introduction to Excel formula errors

The easy kind: syntax errors

The triky ones: # ERRORs

Fixing errors - using IFERROR & ISERROR

Error checking & debug options

Using Errors deliberately - charts & data validation

A challenge for you - produce #NULL error

Conclusions

In the 36th session of Chandoo.org podcast, Let's follow the trend.

What is in this session?

In this podcast,

A quick trip to down under

What is trend analysis

4 types of common trends

linear

curve

cyclical

strange

Doing trend analysis in Excel - the process

How to use trend analysis results

Conclusions

In the 35th session of Chandoo.org podcast, Let's hear from Dan Fylstra, the creator of Excel Solver. I had the fortune of meeting Dan when I was in Santa Clara last month. I immediately asked him to be part of Chandoo.org podcast and he was kind enough to agree. So today let's take a trip down the memory line, hear him talk about some of the fascinating all the early development stories of Solver, VisiCalc & Excel.

What is in this session?

In this podcast,

Introduction

Early days of Solver

Working with VisiCalc, migration to Excel

What keeps Dan busy these days

Advice for anyone planning to learn Solver & business modelling

In the 34th session of Chandoo.org podcast, Let's hear from Jordan Goldmeier - my friend, fellow blogger, Excel blogger & author. After many years of interaction thru email, blogs, Skype calls, finally I met him at PASS BA conference at Santa Clara this week. He gave me a copy of his new book - Advanced Excel Essentials and I immediately asked him to do a podcast. So here we go.

What is in this session?

In this podcast,

Introduction

What is this book all about

Sample chapter review - User forms

Design principles for creating advanced user interactions

How to become advanced Excel user - pathway recommended by Jordan

More info about Jordan

A secret for you

In the 33rd session of Chandoo.org podcast, let’s turn the mic to our listeners and hear their tips. What is in this session? This session has 2 things. A surprise Easter egg (an Excel tip hidden in the podcast audio) Collection of Excel tips recorded & submitted by Chandoo.org readers Listen to this session Click here […]

In the 32nd session of Chandoo.org podcast, let's make legendary column charts.

What is in this session?

Column charts are everywhere. As analysts, we are expected to create flawless, strikingly beautiful & insightful column charts all the time. Do you know the simple rules that can help you create legendary column charts?

That is our topic for this podcast session.

In this podcast, you will learn

Few personal announcements

Rule 0: Start at zero

Rule 1: Sort the chart

Rule 2: Slap a title on it

Rule 3: Axis + grid-lines vs. Lables

Rule 4: Moderate formatting

Conclusions