A list of tools, concepts, and learning resources for data analysts. This list covers essential technologies, platforms, and best practices. While most links focus on data analytics, some overlap with data science due to shared skills and concepts.
Feel free to contribute to this list by adding links you've found helpful. Submit a Pull Request (PR) with your suggestions.
- Affiliate Link Disclosure: The only links that are affiliate links (indicated with a *) are for courses I've created. Purchasing through this affiliate link gives me a small commission at no extra cost to you. This support lets me to continue creating and sharing content. Thank you for your support! All other links on this readme are non-affiliate links.
- Need real-world data? Check out Sites to Find Public Datasets
- Looking for courses? See Specific Courses
- SQL – Structured Query Language
- PostgreSQL – Open-source relational database
- BigQuery – Google’s serverless data warehouse
- MySQL – Popular relational database
- Tableau – Popular BI tool for dashboards
- Power BI – Microsoft’s BI and reporting tool
- Looker – Data exploration and analytics
- Python – Official Python website
- Pandas – Data manipulation in Python
- NumPy – Numerical computing library
- Matplotlib – Basic visualization library
- Seaborn – Statistical data visualization
- R - Official R Website
- Google Sheets - Google's version of spreadsheets
- Microsoft Excel – Microsoft Excel spreadsheets
- Use consistent naming conventions for tables and columns
- Remove duplicates and handle missing values properly
- Standardize date formats for consistency
- Use indexing to speed up queries in SQL databases
- Avoid SELECT * to improve performance
- Use aggregation functions (SUM, AVG, COUNT) efficiently
- Focus on clarity – Keep visualizations simple and effective
- Use annotations – Explain key trends and insights
- Provide context – Frame analysis with business impact
- Data Analyst Bootcamp (Free) from Alex the Analyst
- Google Data Analytics Course
- Data with Danny Serious SQL Course from Danny Ma
- The Complete Python Bootcamp From Zero to Hero in Python
- Python for Data Science and Machine Learning Bootcamp
- The Complete SQL Bootcamp: Go from Zero to Hero
- ChatGPT for Data Analytics from Luke Barousse
- SQL for Data Analytics - Learn SQL in 4 Hours* from Luke Barousse and Kelly Adams.
- Python for Data Analyitcs - Full Course Tutorial* from Luke Barousse and Kelly Adams.
- Excel for Data Analyitcs - Full Course for Beginners* from Luke Barousse and Kelly Adams.
- How to Become a Data Analyst for Beginners - Under 2 Hours
- Github
- Maven Analytics
- Tableau Public
- Carrd.co
- novyPro (for PowerBI)
- Datahub
- Dataset Search
- Kaggle
- Data Gov
- Maven Analytics Data Playground
- Awesome Public Datasets
- Datacamp Datasets
- NASA Data
- Google BigQuery
- Danny Ma
- Avery Smith
- Albert Bellamy
- Vin Vashishta
- Christian Wanser
- Annie Nelson
- Megan Lieu
- Chris French
- Jess Ramos
- Matt Mike
- Lauren Rosenthal
- Amna Ahmed
- Margaret Efron
- Meri Nova
- Drew Mooney
- Mary Knoeferl
- Kelly Adams
- Dawn Choo
- Data Career Podcast
- How to Get an Analytics Job
- SuperDataScience Podcast
- Data Bytes
- Data Ideas Podcast
- Data Skeptic
- Data Driven
- Analytics Power Hour
- Data & Impact
- Women in Data Science Worldwide
- The Data Scientist Show
- Women Lead Data Podcast
- Career Foundry (Data Analytics Blog)
- freeCodeCamp news
- Towards Data Science on Medium
- Scaler Blogs
- Applied AI Blogs
- Ace the Data Science Interview by Nick Singh and Kevin Huo
- How to Become a Data Analyst by Annie Nelson
- Python for Data Analysis (3rd Edition) by Wes McKinney
- SQL for Data Analysis by Cathy Tanimura
- Practical Statistics for Data Scientists (2nd Edition) by Peter Bruce, Andrew Bruce, Peter Gedeck
- Essential Math for Data Science by Thomas Nield
- Modern Data Analytics in Excel by George Mount
- Excel 365 Bible by Michael Alexander, Dick Kusleika
- The Definitive Guide to DAX by Marco Russo, Alberto Ferrari
- Master Your Data with Power Query in Excel and Power BI by Miguel Escobar, Ken Puls
- Storytelling with Data by Cole Nussbaumer Knaflic
- Fierce Conversations by Susan Scott
- How to Talk to Anyone by Leil Lowndes
- Extreme Ownership by Jocko Willink, Leif Babin
- Never Split the Difference by Chris Voss, Tahl Raz
- Influence: The Psychology of Persuasion by Robert B. Cialdini
- Start with Why by Simon Sinek by Simon Sinek
- Dare to Lead by Brené Brown
- In Search of Excellence by Thomas J. Peters, Robert H. Waterman Jr.
- The No Asshole Rule by Robert I. Sutton
- How to Lie with Statistics by Darrell Huff
- How Charts Lie by Alberto Cairo
- Becoming a Data Head by Alex J. Gutman and Jordan Goldmeier
- DataFrenchy Community - Created by Chris French)
- Break into Data - Created by Meri Nova)
- Data in Motion - Created by Kedeisha Bryan)