Close this search box.

CP006: How to be a better analyst? – Road map for getting better at Data Analysis & Improving your career prospects



In the 6th session of Chandoo.org podcast, we focus on making you a better analyst.

How to become a better analyst - Learn the road map to become better at data analysis and improving your career prospects - Chandoo.org podcast - Session 006

Before we proceed in to the session, let me remind you:

Subscribe to Chandoo.org Podcast

Do you know that you can subscribe and receive latest episodes of our podcast right to your ears? Use one of the below links to get started.

What is in this session?

One of the most popular questions I get, goes like this:

I recently became an analyst. I want to succeed in my work. How do I go about it?

So in this episode, lets explore the road map to becoming a better analyst.

Mindmap for becoming a better analyst - CP006 - Chandoo.org podcastIn this podcast, you will learn,

  • Announcement about Easter Egg hunt
  • 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

See the mind-map aside (click on it to expand) to understand the BETTER framework.

Go ahead and listen to the show

Links & Resources mentioned in this session:

Easter Egg Hunt:

Courses mentioned:

Case Studies

Resources to learn Excel

Making Interactive Charts in Excel

Spreadsheet Errors & Auditing

Transcript of this session:

Download this podcast transcript [PDF]

Are you becoming better analyst?

As a CEO of a small company, most of my time is spent on analysis & decision making.  So I am always looking for ways to improve my skills.

What about you? How do you become better at your job. Please share your tips, ideas & inspiration in the comments.


Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

12 Responses to “CP006: How to be a better analyst? – Road map for getting better at Data Analysis & Improving your career prospects”

  1. Przemek says:

    another superb podcast, thanks a loooot for great ideas 🙂

  2. GJ says:

    like the mindmap

  3. Adi says:

    Thanks for a great podcast Chandoo, superb mindmap!

  4. DataKrisper says:

    Thank you for this. Wish i had it 10 years ago when i started the career! Still a lot of great advice. A great reminder to never stop refining!

    Thanks again.

  5. hasan says:

    hi chandoo excuse me for late answer to your message . then how are you i wish for you and your family golden life thanks alot again i appratiate and thank you goodby please send to me some note

  6. Estefani says:

    Hi Chadoo
    Thank you for such a great job, your website is already on my bookmarks and I am learning a lot from you. =)

  7. Dear Chandoo,
    Thank you so much for sharing this insightful podcast. Due to your limitless and altruistic collaboration to MS Excel world knowledge, you have inspired me to initiate a community of Excel users in Lima, Peru named "Excel Spyders". I aim to share my tips and tricks in English and Spanish to help Latin American professionals become better at Excel and data analysis. I hope you received this message and potentially meet over skype. It would be a pleasure to meet you.

    Carlos from Excel Spyders

  8. […] started off with Episode 6, “How to be a Better Analyst.” This title appealed as an analyst who reads and writes often on the […]

  9. mustafa says:

    Dear Chandoo,
    I am a beginner of Data Analyst, I would like to learn and wished to become Expert in Analyst and also to grasp in depth knowledge & skills in MS excell on my finger tips.

    So, plz share it from the beginning .

    Thanks & best regards,

  10. […] started off with Episode 6, “How to be a Better Analyst.” This title appealed as an analyst who reads and writes often on the […]

  11. wellinston says:

    Thanks chandoo for sharing its really helpful road map keep going, actually i want to share something about business analyst that may help someone; Business analysts (BAs) are responsible for bridging the gap between IT and the business using data analytics to assess processes, determine requirements and deliver data-driven recommendations and reports to executives and stakeholders.

  12. I am learning data analytics. But I am from non-tech background. Is it good for me or not. Please guide me.

Leave a Reply