📈 Upwork Data Analytics Pipeline

June 7, 2025 · View on GitHub

An end-to-end data analytics pipeline designed for the Upwork platform, demonstrating real-world skills in data modeling, ETL, and data visualization. This project combines MySQL Workbench, Snowflake, and QlikView to deliver insightful dashboards and optimized queries for business decision-making.

🚀 Project Overview

This project simulates the full analytics workflow for a freelancing platform like Upwork, aimed at roles in Data Analytics and Data Engineering. It covers:

  • 📐 ERD and Dimensional Modeling for optimized schema design
  • 🔄 ETL Integration between MySQL and Snowflake
  • 📊 Interactive Dashboards in QlikView for KPIs and trends

🧰 Technologies Used

  • Database Design: MySQL Workbench
  • Cloud Data Warehouse: Snowflake
  • ETL/Integration: SQL-based data pipelines
  • Visualization: QlikView

🔧 Key Features

  • 🗃️ Designed both Entity-Relationship Diagrams (ERD) and Star Schema models to structure Upwork data efficiently
  • 💾 Created and populated normalized and dimensional tables in MySQL
  • 🔄 Developed ETL workflows to transfer data from MySQL to Snowflake
  • 📊 Built QlikView dashboards for real-time exploration of:
    • Top freelancers and clients
    • Revenue trends
    • Job categories and contract types
  • ⚡ Improved data processing speed and report generation by 35%

Screenshots:

ERD Model

image

Dimensional Model

image

Sample Dashboard in QlikView:

image