How a Single Corrupt CSV Became a Full Power BI Dashboard for a Kenyan Auto Firm

JCars Logistics, a Kenyan vehicle import and delivery company, needed a business intelligence report built from a single raw CSV file containing 34 columns of sales data. An analyst auditing the data uncovered critical errors, most notably a broken Revenue column where figures had been calculated against the total dataset rather than individual row quantities. Additional problems included non-unique Order IDs in five inconsistent formats, price entries inflated by a factor of ten for vehicles like the Toyota Land Cruiser, and 18 orders showing delivery dates earlier than their order dates. Significant missing values across fields such as Discount, Logistics Cost, and Customer Rating also required documented handling policies rather than silent fixes. Each issue was addressed transparently — outliers were flagged rather than deleted, currency was standardised to Kenya Shillings, and a corrected revenue formula was substituted — before the cleaned data was used to build the final Power BI solution.