TopPodcast.com
Menu
  • Home
  • Top Charts
  • Top Networks
  • Top Apps
  • Top Independents
  • Top Podfluencers
  • Top Picks
    • Top Business Podcasts
    • Top True Crime Podcasts
    • Top Finance Podcasts
    • Top Comedy Podcasts
    • Top Music Podcasts
    • Top Womens Podcasts
    • Top Kids Podcasts
    • Top Sports Podcasts
    • Top News Podcasts
    • Top Tech Podcasts
    • Top Crypto Podcasts
    • Top Entrepreneurial Podcasts
    • Top Fantasy Sports Podcasts
    • Top Political Podcasts
    • Top Science Podcasts
    • Top Self Help Podcasts
    • Top Sports Betting Podcasts
    • Top Stocks Podcasts
  • Podcast News
  • About Us
  • Podcast Advertising
  • Contact
Not in our directory?
Add Show Here
Podcast Equipment
Center

toppodcastlogoOur TOPPODCAST Picks

  • Comedy
  • Crypto
  • Sports
  • News
  • Politics
  • True Crime
  • Business
  • Finance

Follow Us

toppodcastlogoStay Connected

    View Top 200 Chart
    Back to Rankings Page
    Technology

    Chandoo.org Podcast – Become Awesome in Data Analytics

    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.

    Advertise

    Copyright: © Chandoo.org

    • Apple Podcasts
    • Google Play
    • Spotify

    Latest Episodes:
    CP041: 6 charts you’ll see in hell – v2.0 Aug 06, 2015
    Show notes

    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.

    6 charts you should avoid - Chandoo.org podcast - session 41

    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

    Listen to this session

    Click here to download the MP3 file.

    Learn more about which charts to avoid, which ones to make

    On Pie charts:

    Here is an ugly, clumsy pie chart to prove the point. [ Source: Bill the Lizard ]

    What people are saying about your pie charts

    • Should you use pie charts? – podcast session 004
    • Why 3D pie charts are evil

    On making charts when you have too much data:

    • Panel charts (or small multiples) in Excel
    • Panel Chart case study – Survey results visualized
    • Sparklines

    On formatting:

    • Avoid Gangnam styles
    • Impressing your boss with Excel charts – 6 step road map for you – podcast session 029

    Transcript of this session:

    Download this podcast transcript [PDF]

    Do you create any of these charts? Share your story

    As a fresh analyst, I created all of these 6 charts. But I quickly realized that each time I made a 3D pie chart, I am selling a small piece of my soul to the devil. So I atoned my sins by scattering everywhere and visiting lots of bars. 😉

    What about you? Have you ever created any of these charts? What did your users say when they saw these charts? Share your story in the comments.

    Note: This is a part of Awesome August Excel festival.

    The post CP041: 6 charts you’ll see in hell – v2.0 appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.


    CP040: Intro. to Power Query – What is it and how to get started – with Miguel Escobar Jul 30, 2015
    Show notes

    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.

    Introduction to Power Query - What is it and how to get started? An interview with Miguel Escobar - Chandoo.org Podcast - CP040

    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

    Listen to this session

    Click here to download the MP3 file.

    Learn more about Power Query

    Books:

    I recommend 2 books for learning more about Power Query.

    • Power Query for Power BI & Excel by Chris Webb
    • M is for Data Monkey – A guide to M language in Power Query by Ken Puls & Miguel Escobar (pre-order only, release in November 2015)

    Online classes:

    Ken & Miguel regularly run an online class teaching hands-on techniques, implementation guidelines and secrets about Power Query. I have signed up for their next class and eagerly looking forward to it. I recommend going for their class if you want to seriously improve your Power Query skills.

    Special offer worth $59 for Chandoo.org listeners

    As a podcast listener, here is a special offer for you from PowerQuery.Training.

    Use the discount code CHANDOO when signing up for their upcoming live session and get 10% off on the course fees.

    Click here to signup for their upcoming class.

    Note: Ken & Miguel are good friends and partners of Chandoo.org. When you join this course from above link, I receive a small commission. I am recommending this course because I genuinely think their program is suitable & awesome for anyone needing Power Query instruction.

    Transcript of this session:

    Download this podcast transcript [PDF]

    Are you using Power Query? What has been your experience with it?

    I have been playing with Power Query for last 18 months. I really like the technology and what it can do for us, analysts. I regularly use it to clean data, do quick transformations and set up models.

    What about you? Have you been using Power Query? What is your experience like? Please share your success story in the comments.

    The post CP040: Intro. to Power Query – What is it and how to get started – with Miguel Escobar appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.


    CP039: May the FOR Loop be with you – Introduction to For Loops in Excel VBA Jul 23, 2015
    Show notes

    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.

    Introduction to Excel VBA FOR Loops - What are they, how to use them - Chandoo.org Podcast - Session 039

    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

    Listen to this session

    Click here to download the MP3 file.

    Links & Resources mentioned in this podcast

    Introduction to VBA

    • Introduction to Excel VBA – 5 part crash course
    • Introduction to VBA – what is it and how to get started – Podcast #22

    Using FOR Loops – Examples

    • Looking up when data wont play nice – Using FOR Loops
    • Understanding variables, conditions & loops in VBA
    • Split an Excel file in to many using For Each loop

    Optimization & Performance of VBA code

    Transcript of this session:

    Download this podcast transcript [PDF]

    Are FOR loops strong with your VBA code?

    I personally favor FOR loops over While loops. I learned about loops in 1996 (in BASIC language).Any powerful application or program I have built ever since has its share of FOR loops. They are vital for doing awesome things with computers.

    What about you? Do you use FOR loops often? When do you use them? What are your favorite implementations. Please share your tips & thoughts in the comments area.

    Remember: Email me at chandoo.d@gmail.com once you finish the task mentioned in the podcast to get your FOR loops example workbook.

    The post CP039: May the FOR Loop be with you – Introduction to For Loops in Excel VBA appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.


    CP038: Data to Ink Ratio – What is it, How to optimize it, Techniques & Discussion Jul 09, 2015
    Show notes

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

    Data to Ink ratio - What is it, how to optimize it, techniques and discussion - Chandoo.org Podcast - CP038

    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

    Listen to this session

    Click here to download the MP3 file.

    Links & Resources mentioned in this podcast

    Recommended Books for creating better charts:

    • Information Dashboard Design by Stephen Few
    • Visual Display of Quantitative Information by Edward Tufte

    Optimizing data to ink ratio – Charting case studies

    • Closing gaps in gender equality chart
    • Why 3D pie charts are evil…
    • Visualizing world education rankings

    Techniques for highlighting what is important

    • Display alerts in dashboards to grab user attention
    • Adding meaning titles & legends to charts
    • Never show simple numbers in your dashboards

    Invitation to “Becoming a better analyst” Webinar

    As mentioned in the podcast, I am running my first ever webinar on Wednesday, July 15th – 2015 (2PM EST). The topic is “How to become a BETTER analyst?”

    Please click here to register for the webinar & become a better analyst.

    Transcript of this session:

    Download this podcast transcript [PDF]

    How do you optimize Data to Ink Ratio?

    What about you? Do you worry about data to ink ratio when making charts? How do you optimize it? Do you have a process for it? Please share your tips by posting a comment.

    Subscribe to Chandoo.org Podcast

    Other options to subscribe

    The post CP038: Data to Ink Ratio – What is it, How to optimize it, Techniques & Discussion appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.


    CP037: Error error on the wall, How do I fix you all? – Understanding & Fixing Excel Errors Jun 25, 2015
    Show notes

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

    CP037 - Error error on the wall, how do I fix you all? - Understanding & Fixing Excel Errors - Chandoo.org Podcast

    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

    Listen to this session

    Click here to download the MP3 file.

    Links & Resources mentioned in this podcast

    Understanding & Fixing Excel Errors:

    • Various Excel formula errors – what do they mean and how to fix them?
    • What to do when your Excel formula is not working
    • Using F9 key to debug formulas

    Error handing in Excel

    • IFERROR formula – what is it, how to use it?
    • Excel formula auditing features – how to use them?
    • Hiding errors in print outs

    Using Errors deliberately

    • As in dynamic charts – example
    • As in better user data validation – example

    Related Podcasts:

    • CP026: Excel operators – an introductions & overview
    • CP008: How to maintain workbooks created by others

    Transcript of this session:

    Download this podcast transcript [PDF]

    How do you tackle errors?

    My favorite techniques for error handling are – IFERROR & F9 key.

    What about you? What kind of errors do you face frequently. How do you handle them? What do you do to ensure fewer errors in your reports and dashboards? Please share your tips in the comments area.

    Also, tell me which formulas you will write to produce #NULL error in Excel.

    The post CP037: Error error on the wall, How do I fix you all? – Understanding & Fixing Excel Errors appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.


    CP036: How to do trend analysis using Excel? Jun 11, 2015
    Show notes

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

    How to do trend analysis in Excel - episode 36 - chandoo.org podcast

    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

    Listen to this session

    Click here to download the MP3 file.

    Links & Resources mentioned in this podcast

    Trend Analysis – formulas & chart techniques:

    • Trend analysis & forecasting – part 1
    • Trend analysis & forecasting – part 2
    • Trend analysis & forecasting – part 3

    Calculating moving averages in Excel

    Regression & complex trend analysis:

    Reference book: Data smart by John Foreman

    Transcript of this session:

    Download this podcast transcript [PDF]

    How do you analyze trends?

    For my work, I use both cyclical & linear trend analysis techniques. The insights from these help me to optimize my blog posts, understand best times to publish new articles & analyze how well various marketing initiatives are working out.

    What about you? How do you analyze trends? What techniques do you apply? Please share your tips in the comments area.

    The post CP036: How to do trend analysis using Excel? appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.


    CP035: on Solver, its story and future – Interview with Dan Fylstra May 21, 2015
    Show notes

    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.

    CP035: Interview with Dan Fylstra on origin of Solver & its future - Chandoo.org podcast

    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

    Listen to this session

    Click here to download the MP3 file.

    Links & Resources mentioned in this podcast

    Dan’s website:

    • Solver.com
    • Dan Fylstra on Wikipedia

    Transcript of this session:

    Download this podcast transcript [PDF]

    What is your solver story?

    I have learned about optimization algorithms in 2000. It has been a love-hate relationship for first several years, but then as I started my own business, I now understand how relevant modelling & optimization skills are.

    What about you? What is your favourite solver story? Please share it in the comments section.

    Note: Dan’s image is copyright of computerhistory.org

    The post CP035: on Solver, its story and future – Interview with Dan Fylstra appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.


    CP034: Advanced Excel Essentials book talk with Jordan Goldmeier Apr 23, 2015
    Show notes

    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.

    CP034 - Advanced Excel Essentials book talk with Jordan Goldmeier

    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

    Listen to this session

    Click here to download the MP3 file.

    Links & Resources mentioned in this podcast

    Books recommended / mentioned in this podcast

    • Advanced Excel Essentials by Jordan Goldmeier
    • Data Smart by John Foreman
    • Professional XL Development by Rob, Dennis & Stephen
    • Predictive Analytics by Conrad Carlberg
    • Data Science for Business by Foster & Tom

    User form examples:

    • Creating a spreadsheet wizard to collect data

    Resources on learning VBA & Advanced Excel

    • Introduction to VBA
    • Advanced Excel skills & resources

    About Jordan & his work:

    • Option Explicit VBA – Jordan’s blog
    • Excel TV – where Jordan along with Rick & Oz share tips & interviews

    Transcript of this session:

    Download this podcast transcript [PDF]

    Have you read Advanced Excel Essentials book?

    I will be honest, I only thumbed thru a few chapters. But I plan to read the book on my flight back to India (I am typing this from my hotel room in Santa Clara).

    What about you? Have you read Jordan’s book? If so how do you like it? Please share your feedback & book recommendations in the comments area.

    Note: All the links to books mentioned in this page use my Amazon affiliate code. This means, when you buy the book from Amazon thru these links, I get a few cents commission. My motivation for recommending these books is very simple. They make you awesome, so I recommend them. I would have recommended them even when there is no commission involved. Thanks for supporting Chandoo.org & happy reading.

    The post CP034: Advanced Excel Essentials book talk with Jordan Goldmeier appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.


    CP033: There is an Easter egg in this podcast!!! Apr 09, 2015
    Show notes

    In the 33rd session of Chandoo.org podcast, let’s turn the mic to our listeners and hear their tips.

    CP033 - There is an Easter egg in this podcast - Excel tips from Chandoo.org podcast listeners

    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 to download the MP3 file.

    Links & Resources mentioned in this podcast

    Keyboard & Mouse shortcuts

    • Comprehensive list of Excel keyboard shortcuts
    • Double click tricks for Excel

    Chart formatting tips:

    • 5 rules for making awesome column charts
    • More charting principles

    Transcript of this session:

    Download this podcast transcript [PDF]

    Did you find the Easter egg?

    Now that you found the Easter egg, it is your turn. Go ahead and leave a comment with cryptic message. Share your favorite Excel tip or ideas with us.

    Thanks to the contributors

    Many many thanks to both Roberts, Micky, TJ, Val & Orkun. It was fun learning from you.

    The post CP033: There is an Easter egg in this podcast!!! appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.


    CP032: Rules for making legendary column charts Apr 02, 2015
    Show notes

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

    CP032: Rules for making legendary column charts - Chandoo.org podcast - Become awesome in Excel

    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

    Listen to this session

    Click here to download the MP3 file.

    Links & Resources mentioned in this podcast

    Companion article

    • 5 rules for making awesome column charts
    • More charting principles

    Transcript of this session:

    Download this podcast transcript [PDF]

    How do you make your column charts awesome?

    I shared my favorite techniques in the podcast. Now it’s your turn.

    What about you? What rules & techniques do you use to make your column charts awesome? Please share in the comments section.

    Subscribe to our podcast and get latest episodes automatically

    Use below link to add our podcast to iTunes. For other options (Android, Windows phone or RSS) click the link below. Thank you.

    Other options to subscribe

    The post CP032: Rules for making legendary column charts appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.


    Previous 1 2 3 4 5 7 Next

    Related Podcasts

    Reply All

    1

    Reply All Games & Hobbies
    Inside VR & AR

    2

    Inside VR & AR Gadgets
    Note to Self

    3

    Note to Self News
    BrainStuff

    4

    BrainStuff Natural Sciences
    This Week in Tech (Audio)

    5

    This Week in Tech (Audio) News
    Hands-On Tech (Audio)

    6

    Hands-On Tech (Audio) Technology
    footer-logo

    Contact Us

    Toll Free: 844-670-7747

    Links

    • Home
    • Top Charts
    • Networks
    • Apps
    • Independents Podcasts
    • Podcast Advertising
    • Podcast News
    • Contact Us
    • About Us
    • Analytics & Insights

    Stay Connected

      Privacy, Terms of Use & Our Code of Ethics Protecting Content Creators Copyrights