Chandoo.org Podcast - Become Awesome in Data Analytics

By
- Training & Data Analysis Specialist
- Chandoo - Microsoft Excel MVP

0 Ratings: 0
Episodes: 62
Avg. duration: 50min
Language: English
Format
Category: Economy & Business

Want to be an AWESOME DATA ANALYST? Chandoo.org Podcast is the place to go. Learn how to use popular Data Analytics software like Power BI, Excel, SQL and more with your host Chandoo – an award winning author, speaker and YouTuber.

Episodes

CP 001: Chandoo.org Podcast First Episode – Introduction, What to expect, Show formalities & Special giftChandoo.org Podcast is here.... Friends, fans & supporters of Chandoo.org, I am so happy to add another dimension to our website. Chandoo.org podcast is finally here. You can listen to the inaugural episode by using the audio player above. The post CP 001: Chandoo.org Podcast First Episode – Introduction, What to expect, Show formalities & Special gift appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
1
|
27min
CP002: VTALKUP – 5 Excel lookup functions demystified + 4 Resources for youIn the second session of Chandoo.org Podcast, We will be learning how to use 5 Excel lookup functions. What is in this session? In this session, we tackle one of the most important areas of Excel. The lookup functions. You will learn, • Why lookup functions are necessary • 5 Important lookup functions in Excel - VLOOKUP, HLOOKUP, LOOKUP, MATCH & INDEX • When & how to use each of these 5 functions? • Extreme scenarios: • What happens when the value you are looking up is not there? • What if too many items match the lookup value? • What if you have too many conditions in the lookup criteria? • • Using IFERROR function • Re-cap of the new powers you acquired • 4 Resources for you to learn lookup functions better The post CP002: VTALKUP – 5 Excel lookup functions demystified + 4 Resources for you appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
2
|
54min
CP003: Business Intelligence for Masses – Interview with Mike AlexanderIn the third session of Chandoo.org podcast, we are going to get BI curious. ;) Not that kind you silly, We are talking about Business Intelligence, Big Data, Power Pivot & other Power BI family members. In this session, I am happy to feature Mike Alexander - Microsoft MVP, Author, Blogger & a good friend. Mike talks about how Excel is shaping the BI (Business Intelligence) revolution with advent of Power BI functionality. You will learn, • Introduction, what Mike is up to these days? • What is BI, what does it mean to an average Excel analyst? • What BI capabilities Excel has - brief intro to each of them • Power Pivot & what it does • Power Query & why it is important • Power View & how it works (and where it sucks) • Power Maps • • How to learn about these new technologies • Recommended Books • Websites • Courses • Live classes • • Special gift for our listeners The post CP003: Business Intelligence for Masses – Interview with Mike Alexander appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
3
|
1H 12min
CP004: Can I Pie Chart in Public? Discussion about Pie charts, their merits and drawbacks, when to use & when to avoid themIn the 4th session of Chandoo.org podcast, lets talk about Pie charts. Pie charts evoke strong opinions among analysts & managers. Some people love them and can't have enough of them in reports. Others despise them and go to any lengths to avoid them. And that is why we are going to talk about them in this session. You will learn, • Special, secret transmission from guest stars • What is a pie chart? • Why they work? 2 reasons • Why they don't work ? 4 reasons • Cousins & siblings of Pie charts • Donut charts • Gauge charts (speedometer) • 3D pies • Area charts • Bubble charts • • 4 Situations when making a pie chart is ok • Alternatives to Pie charts • Mistakes you should avoid • About the resources • Conclusions The post CP004: Can I Pie Chart in Public? Discussion about Pie charts, their merits and drawbacks, when to use & when to avoid them appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
4
|
40min
CP005: Introduction to Form Controls – an interview with Debra DalgleishIn the 5th session of Chandoo.org podcast, we are going to demystify form controls. I am very happy and excited to interview my good friend, fellow Excel MVP, author, blogger and virtual mentor - Debra Dalgleish about this topic. In this podcast, you will learn, • What are form controls • When you would use them? • Example form control - Combo box • How form controls differ from active-x controls • How to enable form controls in your Excel? • Various important form controls • Special bonus & how to obtain it The post CP005: Introduction to Form Controls – an interview with Debra Dalgleish appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
5
|
1H 13min
CP006: How to be a better analyst? – Road map for getting better at Data Analysis & Improving your career prospectsIn the 6th session of Chandoo.org podcast, we focus on making you a better analyst and propose a road map for getting better at data analysis & improving your career prospects. In this podcast you will learn, • Why become a better analyst? • The road map for becoming a better analyst - BETTER framework • B for Business Knowledge • E for Examining user needs • T for Thinking about analysis • T for Tools of Trade ie • Excel • E for Expression • R for Refining yourself • Conclusions The post CP006: How to be a better analyst? – Road map for getting better at Data Analysis & Improving your career prospects appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
6
|
48min
CP007: aweSUM() – Overview of SUM functions in ExcelIn the 7th session of Chandoo.org podcast, lets make you aweSUM(). Imagine for a second that Excel cannot add up numbers. And no it cant subtract them either. What would that look like? A glorified Notepad. That's right. Excel's ability to add up numbers, along with features like formulas, charts, pivot tables & BHATTEXT() are what make it such a lovely software. May be not the BHATTEXT(), but we all agree that Excel is so versatile and useful because it can add up numbers (and perform other calculations) with ease. But how well do you know the SUM formulas of Excel? In this podcast, you will learn, • Special personal fruit announcement :P • + operator • Status bar & total rows in tables • Auto Sum feature • SUM() function • SUMIFS function • Special cases of SUMIFS function • SUBTOTAL & AGGREGATE functions • Other summing functions - SUMPRODUCT etc. The post CP007: aweSUM() – Overview of SUM functions in Excel appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
7
|
44min
CP008: 6 Tips to handle workbooks made by someone else, #4 is something I struggle with too!Here is a problem we all face once in a while. We inherit this bulky, bloated, leaking at the edges workbook from a colleague. Now the onus of maintaining it is on us. The person who made this workbook is nowhere to be found. May be she is vacationing in Hawaii sipping pineapple juice. May be he became a vice president and roaming the country in your company's private jet. So what do we do? How do we handle this inheritance? That is the topic of our podcast, episode 8. In this podcast, you will learn, • An overview of the inheritance problem • 6 Tips to understand workbooks made by someone else • Tip 0: Talk to the creator • Tip 1: Model the workbook on paper • Tip 2: Locate the engine, ie the formulas • Tip 3: See what else is under the hood - hidden sheets, names, VBA code • Tip 4: Annotate (add comments) as you learn • Tip 5: Locate the controls - inputs, assumptions, scenarios • Tip 6: Re-construct from scratch • Deep dive in to understanding the formulas • Deep dive in to understanding VBA code • Conclusions The post CP008: 6 Tips to handle workbooks made by someone else, #4 is something I struggle with too! appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
8
|
49min
CP009: Averages are Mean – Know these things before you make any more AVERAGE()sIn the 9th session of Chandoo.org podcast, lets raise above AVERAGEs. AVERAGEs are a very popular and universal way to summarize data. But do you know they are mean? Mean as in, AVERAGEs do not reveal much about your data or business. In episode 9 of Chandoo.org podcast, we tackle this problem and present solutions. In this podcast, you will learn, • What is AVERAGE? • Pitfalls of averages • 5 statistic concepts you must understand • Standard Deviation • Median • Quartiles • Outliers • Distribution of data • • What next? The post CP009: Averages are Mean – Know these things before you make any more AVERAGE()s appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
9
|
46min
CP010: Averages are Mean – 8 Techniques for making your analysis above averageThis is a continuation of Session 9 - Averages are mean In the earlier episode, we talked about AVERAGE and why it should be avoided. In this session, learn about 8 power analysis techniques that will lift your work above averages. In this podcast, you will learn, • Re-cap - Why avoid averages • 8 Techniques for better analysis • #1: Start with AVERAGE • #2: Moving Averages • #3: Weighted Averages • #4: Visualize the data • ... • Conclusions The post CP010: Averages are Mean – 8 Techniques for making your analysis above average appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
10
|
44min

Listen and read

Step into an infinite world of stories

Read and listen as much as you want
Over 1 million titles
Exclusive titles + Storytel Originals
14 days free trial, then €9.99/month
Easy to cancel anytime

Details page - Device banner - 894x1036

Others have also enjoyed ...

Company

Explore

Storytel Originals

Useful links

Contact and help

Redeem Giftcard

Language and region

English
International

Follow us