How faisalkhan-7/supplier-reporting-insights-olist-data- works
This is a BigQuery- and Power BI-based supplier scorecard built on Olist marketplace data. The workflow loads CSVs into BigQuery, cleans them into SQL views, and imports governed data into a Power BI report for category managers. The report covers supplier ranking, assortment performance, and product-listing quality. The graph reflects the README’s documented architecture and capabilities; source excerpts were not available to verify implementation details beyond those statements.
Main entry points: Supplier Performance Report.pbix Power BI report · load_to_bigquery.sh BigQuery loader · data cleaning 01.sql Cleaning views · data Olist CSVs
Components 9
Source Data
- Olist CSVs
warehouse/data
Warehouse
- BigQuery loader
warehouse/load_to_bigquery.sh - BigQuery raw tables
- Cleaning views
sql/data cleaning 01.sql
Reporting
- Power BI report
power-bi/Supplier Performance Report.pbix - Supplier scorecard
power-bi/Supplier Performance Report.pbix - Assortment analysis
power-bi/Supplier Performance Report.pbix - Product data quality
power-bi/Supplier Performance Report.pbix
Other components
- Category manager
Connections 8
- Olist CSVs → BigQuery loader: loads from
README.md - BigQuery loader → BigQuery raw tables: loads tables
README.md - BigQuery raw tables → Cleaning views: cleans into views
README.md - Cleaning views → Power BI report: imports data
README.md - Power BI report → Supplier scorecard: presents
README.md - Power BI report → Assortment analysis: presents
README.md - Power BI report → Product data quality: presents
README.md - Category manager → Power BI report: uses
README.md