How smumbi5144/jcars_logistics_bi works
JCars Logistics is a Power BI business-intelligence solution that turns raw vehicle-sale transactions into management reporting. Its documented workflow is to clean and standardize the flat-file data, reshape it into a sales star schema, define DAX measures, and present interactive report pages for performance, revenue, logistics, and customers. The graph preserves the report’s distinct analytical areas and documented interactions. No source excerpts were provided, so implementation details beyond the README are represented at the documented directory level; edges cite the README.
Main entry points: dashboard DAX Measures · Jcars_data.csv Vehicle Sales CSV
Components 14
Data Preparation
- Vehicle Sales CSV
data/Jcars_data.csv - Power Query Cleaning
dashboard - Currency Standardization
dashboard
Analytics Model
- Sales Star Schema
dashboard - FactSales
dashboard - Eight Dimensions
dashboard - DAX Measures
dashboard
Interactive Report
- Slicers and Drilldown
dashboard - Executive Dashboard
dashboard - Vehicle and Branch
dashboard - SalesRep and Leads
dashboard - Revenue and Logistics
dashboard - Top Customers
dashboard
Other components
- Management
Connections 22
- Vehicle Sales CSV → Power Query Cleaning: cleans
README.md - Power Query Cleaning → Currency Standardization: standardizes
README.md - Currency Standardization → Sales Star Schema: prepares data
README.md - Sales Star Schema → FactSales: defines
README.md - Sales Star Schema → Eight Dimensions: defines
README.md - FactSales → Eight Dimensions: relates to
README.md - FactSales → DAX Measures: measures
README.md - Slicers and Drilldown → Executive Dashboard: filters
README.md - Slicers and Drilldown → Vehicle and Branch: drills down
README.md - Slicers and Drilldown → SalesRep and Leads: cross-filters
README.md - Slicers and Drilldown → Revenue and Logistics: cross-filters
README.md - Slicers and Drilldown → Top Customers: cross-filters
README.md - DAX Measures → Executive Dashboard: provides KPIs
README.md - DAX Measures → Vehicle and Branch: provides measures
README.md - DAX Measures → SalesRep and Leads: provides measures
README.md - DAX Measures → Revenue and Logistics: provides measures
README.md - DAX Measures → Top Customers: provides measures
README.md - Executive Dashboard → Management: supports decisions
README.md - Vehicle and Branch → Management: supports decisions
README.md - SalesRep and Leads → Management: supports decisions
README.md - Revenue and Logistics → Management: supports decisions
README.md - Top Customers → Management: supports decisions
README.md