SQLZOO Solutions

• MySQL
• SQL

This repository contains my solutions to the challenging SQL exercises from SQLZOO. SQLZOO is an interactive platform that provides a hands-on learning experience for SQL beginners and enthusiasts. Each exercise presents a real-world scenario and challenges you to write SQL queries to retrieve and manipulate data from a given database. In this repository, you will find my solutions to some SQL exercises available on SQLZOO, specifically focusing on the hard ones. Each solution is organized in separate files, named according to the exercise number.

LeetCode SQL Solutions

• MySQL
• SQL
• LeetCode

This repository contains a curated collection of my solutions to challenging SQL problems sourced from LeetCode. Each solution showcases my proficiency in SQL querying, database manipulation, and efficient problem-solving. Organized by specific LeetCode problems, this collection offers a glimpse into my approach to tackling complexity and delivering effective results.

Centauri Alpha's Retail Data Consulting Project

• dbt
• GCP BigQuery
• ELT
• Power BI
• pandas
• Data Analytics
• Analytics Engineering
• SQL
• Python

A data consulting project that I implemented for a retail business client during my employment at Centauri Alpha. The experience includes extracting and loading data to GCP BigQuery using Fivetran, transforming data within the data warehouse with dbt, analysing online sales data from the data warehouse using SQL queries and Python pandas, performing customer retention analysis employing statistical methods, developing and evaluating a business strategy based on the retention analysis, and presenting data insights to stakeholders with Power BI in weekly meetings.

Cloud Data Warehousing with AWS Redshift

• Amazon Redshift
• Cloud Solution
• Data Warehousing
• ETL
• Data Engineering
• Python
• SQL

The project implements a scalable cloud solution for Sparkify's analytics team to gain insights from their user and song data. The goal is to build an ETL pipeline that extracts data from AWS S3 staging area, loads it into staging tables in a database hosted on Amazon Redshift cluster, and transforms it into a dimensional model with fact and dimension tables in a star schema that allows for efficient querying to answer business questions such as popular songs, user listening patterns, and peak activity times.