Data Career Podcast: Helping You Land a Data Analyst Job FAST

176: I Asked 7 Data Analysts What Tools They ACTUALLY Use

Sep 9, 2025
Discover which data tools are truly essential for analysts working at top companies like Google and Apple. Learn why SQL remains the backbone of data analysis, while Excel and Tableau are daily staples for visualization. Hear how Google Colab outshines Jupyter for collaboration, and why Microsoft Teams and Jira are pivotal in project management. Analysts also share insights on tools like Snowflake and Power BI that are shaping the future of data analytics. Tune in for a wealth of practical advice straight from the pros!
Ask episode
AI Snips
Chapters
Transcript
Episode notes
ADVICE

Master SQL And Use Shareable Notebooks

  • Learn SQL deeply because it’s used across analyst, scientist, and engineer roles.
  • Use Google Colab for shareable Python work to present projects to recruiters and teammates.
ADVICE

Excel And Tableau Drive Daily Work

  • Prioritize Excel and Tableau; they solve most day-to-day analyst problems even at Apple.
  • Automate repetitive Excel tasks with macros to save hours and impress stakeholders.
ADVICE

Query, Then Visualize; Learn Warehouses

  • Start analysis in SQL, structure data, then visualize in Tableau or Power BI.
  • Learn cloud warehouses like Snowflake on the job as teams migrate to them.
Get the Snipd Podcast app to discover more snips from this episode
Get the app