Power BI Dashboard Reveals KSh 1.35B Revenue and Key Gaps for JCARS Logistics Kenya
A data analyst built a Power BI dashboard to assess the business performance of JCARS Logistics, a Kenyan vehicle importer and distributor. The analysis, based on a cleaned star-schema dataset, shows total revenue of KSh 1.35 billion from 466 units sold, with a gross profit of KSh 515.45 million and a 30% gross margin. Rift Valley led all regions in unit sales, while top sales representatives Aisha Mohammed, Grace Njeri, and Brian Otieno drove a disproportionate share of volume. Key challenges identified include heavy reliance on Toyota vehicles, underperformance in major urban markets like Nairobi, data entry gaps flagged by an 'Unknown' region entry, and operational risk from dependence on a small number of sales staff.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.
Discussion (0)
Log in to join the discussion and vote.
Log in