How rionurfadilah229/e-commerce-data-analyst-project works
This portfolio project demonstrates an analyst workflow from generating dummy PostgreSQL data through extraction, cleaning, and exploratory analysis to a Looker Studio dashboard. The README documents the notebook’s cleaning, merge, and analysis stages, while the shown Python excerpt confirms database reads and raw CSV writes. The notebook and SQL contents were not sampled, so their internal implementation details are not represented.
Main entry points: cleaning.ipynb Dataset Merge · extract.py Table Extraction · 02_seed_dummy_data.sql Dummy Data · raw Raw CSVs
Components 13
Data Source
- Dummy Data
sql/02_seed_dummy_data.sql - PostgreSQL
- Database Schema
sql/01_schema.sql
Data Preparation
- Table Extraction
extract.py - Raw CSVs
data/raw - Data Cleaning
cleaning.ipynb - Clean CSVs
data/clean
Analysis
- Dataset Merge
cleaning.ipynb - Exploratory Analysis
cleaning.ipynb - Analysis CSV
data/clean/merged_for_looker.csv
Visualization
- Google Sheets
- Looker Studio
Other components
- Data Analyst
Connections 13
- Data Analyst → Dummy Data: generates data
readme.md - Dummy Data → PostgreSQL: seeds tables
readme.md - Database Schema → PostgreSQL: defines tables
readme.md - Table Extraction → PostgreSQL: reads tables
extract.py - Table Extraction → Raw CSVs: writes CSVs
extract.py - Raw CSVs → Data Cleaning: supplies data
readme.md - Data Cleaning → Clean CSVs: cleans tables
readme.md - Clean CSVs → Dataset Merge: provides tables
readme.md - Dataset Merge → Exploratory Analysis: prepares analysis
readme.md - Dataset Merge → Analysis CSV: exports dataset
readme.md - Analysis CSV → Google Sheets: uploaded to
readme.md - Google Sheets → Looker Studio: feeds dashboard
readme.md - Data Analyst → Exploratory Analysis: explores data
readme.md