Menu
All articles with 'data analyst' Tag
Analyst’s life is busy. We have to gather data, clean it up, analyze it, dig the stories buried in it, present them, convince our bosses about the truth, gather more evidence, run tests, simulations or scenarios, share more insights, grab a cup of coffee and start all over again with a different problem.
So today let me share with you 35 shortcuts, productivity hacks and tricks to help you be even more awesome.
Continue »
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
On the left side, we have a veteran warrior with 37 years of data battle scars and redundant six pack. They call him SQL.
On the right side, there is a young challenger with transformative powers and “never say undo” attitude. He goes by the moniker Power Query.
Who is going to win this battle?!?
Continue »{ 22 Comments }
Learn SQL for Data Analysis in one hour
Published on Aug 23, 2022 in Learn Excel, SQL
SQL is an important skill to have for people working with Data. In this article and the companion video, learn how to use SQL to perform common data tasks in under one hour. Sample files are provided.
Continue »{ 15 Comments }
Are you an analyst? Use these 25 shortcuts & tricks to boost your productivity
Published on Jul 7, 2015 in Keyboard Shortcuts, Learn Excel
Analyst’s life is busy. We have to gather data, clean it up, analyze it, dig the stories buried in it, present them, convince our bosses about the truth, gather more evidence, run tests, simulations or scenarios, share more insights, grab a cup of coffee and start all over again with a different problem.
So today let me share with you 25 shortcuts, productivity hacks and tricks to help you be even more awesome.
Continue »{ 16 Comments }
CP020: Top 10 time saving strategies for business analysts
Published on Sep 18, 2014 in Chandoo.org Podcast Sessions, Learn Excel
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 20th session of Chandoo.org podcast, lets save some time.
What is in this session?
We all want to save time and stay productive. The obvious answer seems like using keyboard shortcuts. But they can only get you so far. So what about the real productive strategies? That is what we address in this podcast.
In this podcast, you will learn,
- Announcements
- 5 key areas of business analyst work – tracking, analysis, reporting, data management & modeling
- Time saving strategies for tracking
- for analysis
- for reporting
- for data management
- for modeling
- Conclusions
{ 12 Comments }
CP006: How to be a better analyst? – Road map for getting better at Data Analysis & Improving your career prospects
Published on Apr 24, 2014 in Chandoo.org Podcast Sessions
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In 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
