❄️
Data Flakes

Back

Projects

Overview

A collection of personal projects demonstrating proficiency in data analysis, machine learning, cloud computing, and data engineering.

View All on GitHub


Python Projects

📈 Stock Analysis Tool

Financial analysis tool using Python, yfinance, matplotlib, streamlit, and VaderSentiment for stock analysis and news extraction.

Python • ⭐ 2 Code

🌸 Iris Prediction

Machine learning application predicting iris flower types based on physical characteristics. Built with Python, sklearn, pandas, and streamlit.

Python • ⭐ 1 Code

💬 Sentiment Analysis

Analyze sentiment, polarity, subjectivity, and extract top keywords from text. Identifies named entities and monitors customer sentiment.

Python • ⭐ 1 Code

🌊 Sea Level Prediction

Analyze historical sea level data, develop predictive models for future sea level rise, and visualize results for stakeholders.

Python • ⭐ 1 Code

📊 Page Views Analysis

Data visualization tool for analyzing freeCodeCamp forum page views (2016-2019) with interactive charts built in Python and Streamlit.

Python • ⭐ 1 Code

Azure Projects

☁️ Google Drive to Azure

Automated file transfer from Google Drive to Azure Blob Storage with incremental syncing using Google Drive API and Azure Blob Storage SDK.

Python • ⭐ 3 Code

Snowflake Projects

🏬 TechTrend Database

Production-grade Snowflake data warehouse for a UK technology retailer. Features medallion architecture, Kimball dimensional modelling, SCD Type 2 history tracking, automated ETL orchestration, and a 25+ rule data quality framework with column and row-level security.

Snowflake SQL Code

🦁 London Lions Analytics

High-ambition Snowflake analytics platform for a fictitious Premier League club. Features a medallion architecture with SCD Type 2 tracking, MD5 change detection, automated Python/Kaggle ingestion, and a Single Player View (SPV) for scouting intelligence.

Snowflake SQL Code

🛡️ SecureLife Database

Production-grade Snowflake implementation of a Single Customer View (SCV) for a UK insurance provider. Integrates Motor, Home, and Life insurance data using a medallion pipeline with robust data governance and UK-specific fiscal standardisation.

Snowflake SQL Code

Snowflake Tutorials

📋 Dynamic Tables

Learn to create, manage, and utilize dynamic tables in Snowflake for real-time data updates and effective data pipeline transformation.

Tutorial Code

🧠 Cortex AI

A comprehensive guide to leveraging Snowflake Cortex AI Functions for AI-powered analytics, including text classification and generation.

Tutorial Code

🎭 Data Masking

Implement robust data governance with Snowflake's Dynamic Data Masking and Row-Level Security policies.

Tutorial Code

🤝 Data Sharing

Explore secure data sharing capabilities and integrate with the Snowflake Data Marketplace for external datasets.

Tutorial Code

Materialized Views

Optimize query performance and reduce compute costs using Snowflake Materialized Views for complex aggregations.

Tutorial Code

📓 Notebooks

Develop and execute Python and SQL workflows directly within Snowflake using interactive notebooks.

Tutorial Code

🔐 RBAC

Design and implement secure and scalable Role-Based Access Control (RBAC) hierarchies in Snowflake.

Tutorial Code

🐍 Snowpark Python

Build scalable data pipelines and machine learning workflows using Snowflake Snowpark for Python.

Tutorial Code

🚰 Snowpipe Loading

Automate continuous data ingestion from cloud storage into Snowflake using Snowpipe.

Tutorial Code

⚙️ Stored Procs & UDFs

Extend Snowflake functionality and automate tasks using custom Stored Procedures and User-Defined Functions.

Tutorial Code

🔄 Streams & Tasks

Orchestrate automated data pipelines and capture data changes using Snowflake Streams and Tasks.

Tutorial Code

⏱️ Time Travel

Recover deleted data and explore historical states utilizing Snowflake's Time Travel and Fail-safe features.

Tutorial Code

Disclaimer

The information provided on this website is for general informational purposes only. While we strive to keep the information up to date and correct, there may be instances where information is outdated or links are no longer valid. We make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability, or availability with respect to the website or the information, products, services, or related graphics contained on the website for any purpose. Any reliance you place on such information is therefore strictly at your own risk.