Tagged: SQL
7 articles tagged with “SQL”
Understanding What Sells Together: Customer Basket Analysis for Imported Retail
Built a basket analysis system to uncover product associations and improve cross-sell strategies in an imported candy store.
Predicting What Sells Next: A Practical Demand Forecasting System for Imported Retail
Built a lightweight demand forecasting system to improve purchasing decisions for an imported candy store with highly unpredictable demand.
Inventory Intelligence for Imported Retail: From Reactive Stocking to Data-Driven Decisions
Built an inventory optimization system for an imported candy store to reduce stockouts, eliminate dead inventory, and improve purchasing decisions.
From Manual Chaos to Automated Clarity: Building a Data Pipeline & Reporting System
How I transformed a messy, manual reporting workflow into a fully automated data pipeline with real-time dashboards.
Catching Silent Failures: Building a Data Quality Monitoring & Alerting System
How I built a system to detect, monitor, and alert data issues before they impact business decisions.
From Minutes to Seconds: Optimizing SQL & BigQuery Performance at Scale
How I reduced query time and cloud costs by optimizing inefficient SQL and improving data warehouse performance.
Snowflake dbt Analytics Platform
An end-to-end dbt project implementing star schema models with comprehensive testing and documentation for supply chain analytics on Snowflake.