← Back

Tagged: SQL

3 articles tagged with “SQL”


Case Studies

Retail Analytics for an Imported Candy Store

Built inventory, demand forecasting, and basket analysis systems for an imported candy store to guide purchasing, anticipate short-term demand, and improve cross-sell decisions.

PythonBigQuerySQLPandasLooker Studio

Automated Data Pipeline with Quality Monitoring

How I replaced a manual weekly reporting workflow with an automated ETL pipeline and live dashboards, then added a data quality monitoring layer that validates and alerts on the data flowing through it.

PythonPostgreSQLPandasSQLCron

From Minutes to Seconds: Optimizing SQL & BigQuery Performance at Scale

How I cut query time and cloud costs by fixing inefficient SQL and improving data warehouse performance.

SQLBigQueryPythonData Modeling