fbpx

All articles with 'data analyst' Tag

Learn SQL for Data Analysis in one hour

Published on Aug 23, 2022 in Learn Excel, SQL
Learn SQL for Data Analysis in one hour

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 »

35 shortcuts & tricks to make you an #AWESOME Data Analyst

35 shortcuts & tricks to make you an #AWESOME Data Analyst

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 »

Are you an analyst? Use these 25 shortcuts & tricks to boost your productivity

Published on Jul 7, 2015 in Keyboard Shortcuts, Learn Excel
Are you an analyst? Use these 25 shortcuts & tricks to boost your productivity

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 »

CP020: Top 10 time saving strategies for business analysts

Published on Sep 18, 2014 in Chandoo.org Podcast Sessions, Learn Excel
CP020: Top 10 time saving strategies for business analysts

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
Continue »

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
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 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
Continue »