Recommended Free Tools
iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
David Samuel’s JCars Logistics case study uses Power BI to clean vehicle-sales data and explore revenue, profit, units sold, returns, and customer ratings. Its findings—such as Toyota leading revenue and April leading monthly revenue and profit—are results reported by the project, not independently verified company performance.
What the JCars Logistics Power BI project analyzes
The project describes importing a raw facts table into Power BI, cleaning the data, defining business measures, and building visuals for sales and operations. Its questions include which regions and sales representatives generate revenue, how revenue and profit change by month, and how vehicle types and makes compare.
The reported measures include total logistics cost, total profit, total revenue, and total unit cost. Visuals examine revenue by county and sales representative, monthly revenue and profit, manual versus automatic cars, car-type performance, and customer ratings by make.
How the project handles data-quality problems
The author describes mixed currencies, inconsistent date formats, varying capitalization, invalid dates, and irregular numeric entries. Cleaning includes converting invalid dates to nulls and addressing fields such as customer age, units sold, discount, customer rating, and review count.
#1 Best Overall
One example is a date such as 2026-13-04, which cannot represent a valid calendar date because there is no thirteenth month. Samuel writes: “The errors represented invalid dates such as 2026-13-04. Since we do not have a 13th month, Power BI detects such as errors.” Turning invalid dates into nulls prevents them from being treated as valid time values, but it also means records with missing dates may not contribute reliably to time-based analysis.
Mixed currencies are especially consequential for financial comparisons: revenue totals are not directly comparable unless the currencies and conversion approach are made consistent. The project description identifies the issue, but does not establish a validated currency-conversion method or an independently verified financial baseline.
Rank #2
What findings does the project report?
These are findings attributed to Samuel’s project, not an audit of JCars Logistics or evidence of its current company-wide results.
The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →- Kakamega led regional revenue.
- Toyota generated the highest revenue among car makes.
- Automatic cars generated higher returns than manual cars.
- April had the highest revenue and profit.
- Dealers and government were important customers.
- Honda had among the highest return counts and a low average rating.
These observations answer different business questions and should not be collapsed into a single ranking. Revenue indicates sales value, while profit accounts for costs; units sold show volume, and returns and ratings can flag customer-experience issues. Geography and month add context to each measure.
Why public JCars figures do not all match
Other publicly described JCars analyses report different dataset scopes and results. The available material does not reconcile those differences, so their figures should not be combined with Samuel’s findings or treated as a common verified baseline.
| Public analysis | What it reports | How to interpret it |
|---|---|---|
| David Samuel’s DEV Community project | Qualitative findings about county revenue, car make and type, monthly performance, customer groups, returns, and ratings; no named independently sourced company statistic is established. | Attribute the findings to this project; they are not verified company-wide performance. |
| Separate Wambui case study, described by iTechGuides in 2026 | 276 transaction records and 32 columns; a five-page report, data cleaning, and a star-schema model. | These describe a separate case study, not necessarily Samuel’s dataset. The analysis cautions that financial findings depend on questionable or missing source values and assumptions. |
| Young Odhiambo public LinkedIn profile excerpt | 254 orders, 417 vehicles sold, KSh 1.38 billion revenue, and a 21% gross margin; publication year is not established in the excerpt. | These figures are from another dashboard and are not reconciled with the other JCars analyses. |
Before comparing headline totals across projects, establish whether they use the same dataset version and record grain, cleaning rules, currency-conversion assumptions, measure definitions, and validation. Without those details, different counts or totals may reflect different inputs and methods rather than a change in business performance.
Rank #4
How to read the vehicle and regional comparisons
Use several measures together when evaluating a make, vehicle type, or region:
- Revenue and profit: Revenue shows sales value; profit indicates what remains after the costs included in the measure. A revenue leader is not automatically the profit leader.
- Units sold: Volume helps distinguish high-value sales from a large number of lower-value sales.
- Returns and ratings: Return counts and customer ratings add a customer-outcome perspective that sales totals alone miss.
- Geography and time: County and monthly views show where and when activity occurred, but comparisons depend on consistent dates and coverage.
The case study’s reported Toyota revenue lead, automatic-car returns, and Honda return and rating observations are useful prompts for further analysis, not enough on their own to establish overall performance. A sound comparison needs consistent definitions, a stated period, and confidence that the underlying values have been cleaned and validated.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.What the case study can—and cannot—establish
The project demonstrates a Power BI workflow for preparing vehicle-sales data and presenting business questions through measures and visuals. Its data-quality discussion is a reminder that dashboard outputs inherit limitations from their inputs: invalid dates affect trends, inconsistent numeric entries affect calculations, and mixed currencies affect financial totals.
Because the matching article does not establish a verified company statistic or reconcile its figures with other public JCars analyses, its findings should be cited as project-reported results. They can illustrate how to explore vehicle sales, but should not be presented as audited or current financial facts about the business.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
