How sahbimlesh007/end-to-end-e-commerce-analytics-project works
This repository documents an e-commerce analytics workflow: Olist CSV data is loaded into PostgreSQL, modeled and analyzed with SQL, then exposed to Power BI for measures and interactive reporting. The dashboard covers executive, sales, customer, product, logistics, seller, payment, and review analysis; reported insights support business decisions. The graph follows the README’s stated workflow and the available file tree. No source excerpts were provided, so detailed SQL calls, Power BI internals, and wiring beyond documented transfers are not inferred.
Main entry points: Project PowerBI.pbix Interactive dashboards · import_query.sql CSV loading · import_geo.sql Geolocation loading · view.sql SQL views
Components 23
PostgreSQL Data
- CSV loading
SQL queries/import_query.sql - Geolocation loading
SQL queries/import_geo.sql - Relational schema
SQL queries/create_table.sql - Key constraints
SQL queries/add_constraints.sql - PostgreSQL database
- Query indexes
SQL queries/index.sql
SQL Analytics
- SQL views
SQL queries/view.sql - Analysis queries
project assets/BIViews.txt
Power BI Reporting
- Data model
project assets/Tables.txt - Date dimension
project assets/DateDim.txt - DAX measures
project assets/DAX Measures.txt - Interactive dashboards
Project PowerBI.pbix - Executive overview
Project PowerBI.pbix - Sales analytics
Project PowerBI.pbix - Customer analytics
Project PowerBI.pbix - Product analytics
Project PowerBI.pbix - Logistics performance
Project PowerBI.pbix - Seller performance
Project PowerBI.pbix - Payment analytics
Project PowerBI.pbix - Review analytics
Project PowerBI.pbix
Business Outcomes
- Business insights
Report.pdf
Other components
- Olist CSV data
- Business stakeholders
Connections 23
- Olist CSV data → CSV loading: loads CSV
- Olist CSV data → Geolocation loading: loads geography
- CSV loading → PostgreSQL database: writes rows
- Geolocation loading → PostgreSQL database: writes rows
- Relational schema → PostgreSQL database: creates tables
- Key constraints → PostgreSQL database: adds keys
- Query indexes → PostgreSQL database: indexes columns
- PostgreSQL database → SQL views: reads data
- SQL views → Interactive dashboards: imports views
- Data model → Interactive dashboards: documents model
- Date dimension → Interactive dashboards: documents dates
- DAX measures → Interactive dashboards: defines measures
- Analysis queries → PostgreSQL database: documents analysis
- Interactive dashboards → Executive overview: presents KPIs
- Interactive dashboards → Sales analytics: reports sales
- Interactive dashboards → Customer analytics: reports customers
- Interactive dashboards → Product analytics: reports products
- Interactive dashboards → Logistics performance: reports delivery
- Interactive dashboards → Seller performance: reports sellers
- Interactive dashboards → Payment analytics: reports payments
- Interactive dashboards → Review analytics: reports reviews
- Interactive dashboards → Business stakeholders: serves reports
- Business insights → Business stakeholders: communicates insights