Freelance › Projects › Software development › Data Analytics Pipeline: PostgreSQL + Python + Dashboard
Data Analytics Pipeline: PostgreSQL + Python + Dashboard
Employer
Web
Project parameters
Type of cooperationOne-time project
SectionSoftware development
Prepaymentwithout prepayment
Payment methodsCash, Bank transfer
Acceptance of requestsfrom yesterday, 21:05 until Aug 30, 2026
Project description
Project Overview
We have raw event data in MySQL and want to build a proper analytics pipeline with a BI dashboard.
Components
1. ETL Pipeline — extract from MySQL, transform (clean, aggregate), load to PostgreSQL
2. Data Models — fact/dimension tables for event, user, revenue analysis
3. Scheduled Jobs — daily/hourly aggregation runs (via cron or Airflow)
4. Analytics Dashboard — Grafana or Metabase connected to PostgreSQL
5. Key Metrics — DAU, MAU, retention, ARPU, funnel conversion
6. Data Quality Checks — automated row counts and null checks
Tech Stack
Python 3 (pandas, SQLAlchemy, psycopg2)
PostgreSQL
Grafana or Metabase
Docker Compose for local setup
Budget: $400. Timeline: 21 days.
We have raw event data in MySQL and want to build a proper analytics pipeline with a BI dashboard.
Components
1. ETL Pipeline — extract from MySQL, transform (clean, aggregate), load to PostgreSQL
2. Data Models — fact/dimension tables for event, user, revenue analysis
3. Scheduled Jobs — daily/hourly aggregation runs (via cron or Airflow)
4. Analytics Dashboard — Grafana or Metabase connected to PostgreSQL
5. Key Metrics — DAU, MAU, retention, ARPU, funnel conversion
6. Data Quality Checks — automated row counts and null checks
Tech Stack
Python 3 (pandas, SQLAlchemy, psycopg2)
PostgreSQL
Grafana or Metabase
Docker Compose for local setup
Budget: $400. Timeline: 21 days.
