SQL Queries for Data Analyst
As a data analyst or data scientist, knowing the right SQL queries can help you get the data you need from your database tables quickly and easily. Whether you’re a new user or a pro, you need to know how to use the basic SQL queries to analyze and change data. In this blog post, […]
Where to Find Data?
It’s often a struggle to find the good data that you really need to help enhance your data projects. However, Let’s continue to build a comprehensive list of sources that hopefully provide you with a wealth of datasets to work with. Check Out Data Camp to Practice Real-World Data Analysis Data Analysis Project Datasets: You […]
How to Compare Previous and Current Rows in SQL
One of the easiest ways, to compare this is using the lag function. The lag function will allow you to shift the rows downward so that you can view these rows as one observational row. Here is a simple example of how to use the lag function to shift rows downward. You can Practice FANG […]
What Makes a Good Data Analyst CV
I thought this might be helpful. I have been working in data. I get a lot of DMs on LinkedIn on what makes a good data analyst CV. I’ve hired about 30 analyst in my career and interviewed a many. Here are the things I think really work and get the attention of HR, CV […]
How to Become a Data Analyst | Advice from a Senior Data Analyst
Data analysis is among the most in-demand skills in 2021. It is a field with many facets – from working with raw data to uncover actionable insights to knowing how to showcase these in a way that’s easy to consume, data analysis can help any project – big or small.As someone who has worked in […]