How rashis26/data_driven_sales_analysis works
This repository documents an Olist marketplace analytics workflow: raw CSVs are loaded into PostgreSQL, cleaned with table-specific SQL scripts, and analyzed in an interactive Power BI report. The report covers sales, sellers, customers, orders, categories, delivery, payments, reviews, and geography. The README describes the workflow and report capabilities; no source excerpts were available, so links reflect documented relationships only.
Main entry points: Brazil_Ecommerce_Analysis.pbix Power BI Report · olist_customers_clean.sql Clean Customers · olist_geolocations_clean.sql Clean Geolocations · olist_order_items_clean.sql Clean Order Items
Components 21
Source Data
- Raw Olist CSVs
raw - PostgreSQL
Data Cleaning
- Clean Customers
SQL Queries/olist_customers_clean.sql - Clean Geolocations
SQL Queries/olist_geolocations_clean.sql - Clean Order Items
SQL Queries/olist_order_items_clean.sql - Clean Payments
SQL Queries/olist_order_payments_clean.sql - Clean Orders
SQL Queries/olist_orders_cleaned.sql - Clean Products
SQL Queries/olist_products_both.sql - Clean Sellers
SQL Queries/olist_sellers_clean.sql - Cleaned Data
cleaned
Power BI Analysis
- Power BI Report
Brazil_Ecommerce_Analysis.pbix - Sales Overview
Brazil_Ecommerce_Analysis.pbix - Seller Analysis
Brazil_Ecommerce_Analysis.pbix - Customer Analysis
Brazil_Ecommerce_Analysis.pbix - Order Analysis
Brazil_Ecommerce_Analysis.pbix - Category Analysis
Brazil_Ecommerce_Analysis.pbix - Delivery Status
Brazil_Ecommerce_Analysis.pbix - Payment Analysis
Brazil_Ecommerce_Analysis.pbix - Review & Price
Brazil_Ecommerce_Analysis.pbix - Geographic Insights
Brazil_Ecommerce_Analysis.pbix
Other components
- Analyst
Connections 28
- Analyst → PostgreSQL: loads CSVs
- Raw Olist CSVs → PostgreSQL: imported into
- Analyst → Clean Customers: runs script
- Analyst → Clean Geolocations: runs script
- Analyst → Clean Order Items: runs script
- Analyst → Clean Payments: runs script
- Analyst → Clean Orders: runs script
- Analyst → Clean Products: runs script
- Analyst → Clean Sellers: runs script
- Clean Customers → PostgreSQL: creates cleaned table
- Clean Geolocations → PostgreSQL: creates cleaned table
- Clean Order Items → PostgreSQL: creates cleaned table
- Clean Payments → PostgreSQL: creates cleaned table
- Clean Orders → PostgreSQL: creates cleaned table
- Clean Products → PostgreSQL: creates cleaned table
- Clean Sellers → PostgreSQL: creates cleaned table
- PostgreSQL → Cleaned Data: exports cleaned tables
- Analyst → Power BI Report: opens report
- Power BI Report → PostgreSQL: refreshes from
- Power BI Report → Sales Overview: includes pages
- Power BI Report → Seller Analysis: includes pages
- Power BI Report → Customer Analysis: includes pages
- Power BI Report → Order Analysis: includes pages
- Power BI Report → Category Analysis: includes pages
- Power BI Report → Delivery Status: includes pages
- Power BI Report → Payment Analysis: includes pages
- Power BI Report → Review & Price: includes pages
- Power BI Report → Geographic Insights: includes pages