Pinned Loading

1. octopus_energy_pipeline octopus_energy_pipeline Public

   automated data pipeline that requests API data from energy provider and stores it in a cloud database

   Jupyter Notebook

2. Python_health_data_project Python_health_data_project Public

   A data integration project that standardizes and analyzes personal health metrics from Samsung Health, Fitbit, and clinical datasets. Benchmarks personal performance against population averages.

   Jupyter Notebook

3. sale_data_pipeline sale_data_pipeline Public

   A data quality script that cleans dirty retail data by recovering missing values through cross-column logic. Uses GitHub Actions for CI/CD to automatically test data quality and prevent issues from…

   Jupyter Notebook

4. SQL_student_performance SQL_student_performance Public

   An SQL investigation into the relationship between study habits and exam results. Uses CASE statements to group continuous data and DENSE_RANK to create performance leaderboards.

   Jupyter Notebook

5. northwind_SQL_project northwind_SQL_project Public

   An SQL analysis of the Northwind database to identify top-performing customers and products using CTEs and Window Functions. Includes a complete Entity Relationship Diagram (ERD) to model the datab…

   Jupyter Notebook

6. retail_data_pipeline retail_data_pipeline Public

   A modular Python (Pandas) ETL pipeline that merges SQL and Parquet data, performs data cleaning (null imputation, date parsing), and aggregates weekly sales. Includes automated validation to ensure…

   Jupyter Notebook