Pinned Loading

1. stock-streaming stock-streaming Public

   Automated hourly stock price collection pipeline. Fetch data from Yahoo Finance, store in PostgreSQL, and visualize with Power BI dashboards. Runs on GitHub Actions (free) or Docker locally.

   Python

2. citi-bike-data citi-bike-data Public

   An automated data pipeline that extracts Citi Bike trip data, processes it with Apache Airflow and dbt, and stores analytics-ready datasets in PostgreSQL for visualization and business intelligence.

   Python

3. dbt-ecommerce dbt-ecommerce Public

   A dbt-based e-commerce analytics pipeline using DuckDB. Transforms raw Looker e-commerce data into staging models and dimensional marts with SCD Type 2 snapshots for product tracking.

4. ms-fabric-citibike ms-fabric-citibike Public

   Using Microsoft Fabric to build an automated end-to-end pipeline to fetch and load data to a Lakehouse, then to a Warehouse with star schema ready models for reporting.

   Python

5. bikeshare-analytics-engineering bikeshare-analytics-engineering Public

   A dbt-based bike share analytics pipeline using ClickHouse for data transformation and analysis

   Python