SQL

I use SQL on a daily basis to query and aggregate data that we hold at work; it's an invaluable tool for me as an analyst. The platform that I am familiar with from my professional life is Redshift or Microsoft SQL server but I also have some experience with SQLite and PostgreSQL. Below are some examples of personal projects that demonstrate part of my competency with SQL. These are a bit dated now, i've since extended my knowledge of SQL to include more advanced topics such as windows functions, stored procedures and so on.

SQL projects

Answering business questions for a record store (SQL)

A challenging business-analysis scenario, answering business questions and using complex queries. Bonus visualisations in python!

Github link

Sales insight analysis (SQL)

Exploring some common themes in sales environments, from the perspective of an insight analyst.

Github link

CIA factbook, worldwide demographics (SQL)

basic, introductory SQL walkthrough. This project uses data from the CIA World Factbook which contains demographic information such as populations for each country, land and water by area, birth and death rates, etc.

Github link