This guide is for beginner data analysts taking their first step into a SQL course. If you are looking for a list of videos, cheat sheets, and resources to refer back to, these links cover everything you need to get started.
SQL
Beginner friendly resources on how to use relational databases, SQL basics, and tips on performing ad hoc analysis and reporting.
- What makes a good Data Analyst? – being an analyst is more than making graphs and number crunching. Analysts also need to tell stories with data, be creative problem solvers and communicate well with stakeholders.
- SQL Crash Course – by far the best self-paced course to learn SQL that I’ve come across. It uses PostgreSQL to take you through the basics in an approachable way.
- Learn Basic SQL in 10 Minutes (video 9:35)
- How to Make the Leap from Excel to SQL (post)
Requirements gathering
Being a great data analyst is more than just churning out SQL and knowing your way around the database. As a beginner data analyst, it’s important to learn how to listen to stakeholders and determine what it is they need from a report or dashboard … not what they think they need.
- Develop Soft Skills for Analysts (post)
- Requirement Gathering Techniques (post)
Visualisation
Just pulling a data set out of the database isn’t the end of the job. Interpreting the story behind the numbers and bringing it to life is just as important.
- Data Visualisation Catalogue
- Visualisation decision tree
- Presentation Tips for Data Professionals (post)
Advanced Excel
Just because you are moving into the world of SQL and queries doesn’t mean you won’t need to update your Excel toolkit. It’s used across organisations big and small and will most likely be your visualisation tool if your workplace doesn’t have a speciality tool.
- You Suck at Excel with Joel Spolsky (video 54:00)
- Excel functions list (post)
Photo by cottonbro from Pexels
Comments are closed, but trackbacks and pingbacks are open.