Resources for Beginner
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.
- 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.
- Bite-Sized Videos For Beginners – Each of these Videos For Beginners is just long enough to get you started, with room to dive into the topic when you feel ready.
SQL – First steps
- Learn Basic SQL in 10 Minutes (video 9:35)
- Relational Database Fundamentals (post)
- How to Make the Leap from Excel to SQL (post)
- Five SQL Server Tips (post)
- All about SQL JOINs (post)
- SQL Cheat Sheet
- Cool Public Datasets to Explore (post)
- Tutorials for SQL Server (tutorial and SSMS download)
SQL – Next steps
- Speed up your queries with Indexes (post)
- Making the most of SSMS (post)
- Why you should use SQL CTEs (post)
- Caleb Curry’s SQL Server Complete Series (playlist)
- All About SQL Aggregate Functions (post)
- 6 Ways to Search with System Tables (post)
- 10 Ways to Tweak Slow SQL Queries (post)
- Datamarts, Data Vault, Data Lake… Data Swamp? (post)
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.
You don’t need to be a BA or Project Manager, but having the skills to gather requirements is beneficial.
- Requirements Gathering Process Flow (post)
- Requirement Gathering Techniques (post)
- Develop Soft Skills for Analysts (post)
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.
- Thoughts on Dashboard Design (post)
- Data Visualisation Catalogue
- Visualisation decision tree
- Presentation Tips for Data Professionals (post)
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)
- Formulas and Functions (post)
- Pivot Tables and Tools (post)
- Excel functions list (post)
Photo by Pixabay on Pexels