How ayoadenuga/customer-sales-analytics works
This repository is a customer-sales analytics project: raw CSV data is prepared and analyzed in SQL, customer segmentation is produced, and a Power BI model and interactive dashboard present the results for business insights. The README documents this workflow and the dashboard’s KPI, customer, product, geographic, and trend capabilities. The tree contains one SQL file and one Power BI file, so those capabilities are represented at those existing paths; no source excerpts were available to verify finer-grained implementation details.
Main entry points: 01_analysis.sql Sales analysis · Customers-Sales-Analytics.pbix Power BI model · analytics_project_raw_data.csv Raw sales data
Components 9
Data preparation
- Raw sales data
data/analytics_project_raw_data.csv - Clean and validate
sql/01_analysis.sql
Sales analysis
- Sales analysis
sql/01_analysis.sql - Customer segmentation
sql/01_analysis.sql - Sales dimensions
sql/01_analysis.sql
Power BI reporting
- Power BI model
powerbi/Customers-Sales-Analytics.pbix - Interactive dashboard
powerbi/Customers-Sales-Analytics.pbix - Business insights
powerbi/Customers-Sales-Analytics.pbix
Other components
- Business user
Connections 9
- Raw sales data → Clean and validate: prepares
README.md - Clean and validate → Sales analysis: feeds
README.md - Sales analysis → Customer segmentation: segments customers
README.md - Sales analysis → Sales dimensions: analyzes dimensions
README.md - Customer segmentation → Power BI model: feeds model
README.md - Sales dimensions → Power BI model: feeds model
README.md - Power BI model → Interactive dashboard: supports
README.md - Interactive dashboard → Business insights: surfaces
README.md - Business user → Interactive dashboard: explores
README.md