Most carpooling operators can tell you how many rides they ran last month. Far fewer can tell you, in the same breath, what share of the offered seats were actually filled, what the platform kept after driver payout, and how much CO2 the shared trips avoided. Those three numbers live in different exports, and stitching them together by hand is what makes monthly reporting miserable.
The Carpooling Platforms Dashboard in Power BI puts them in one model. It ships with 500 sample ride records across 6 platforms, 7 cities, 5 ride types and 21 columns, wired into a semantic model carrying 80+ DAX measures and a generated Date table. Five report pages, three scorecard tables, 24 KPI cards, a hidden Details drillthrough and two tooltip pages come pre-built – you repoint one query at your own export and refresh.
A note before we start: every figure in the screenshots below is sample data generated for the template. The platform names are invented and nothing comes from a live service. The model also holds ride-level operating fields only – no rider or driver names, phone numbers or addresses – and that is deliberate. Keep personal identifiers in your source system and report on aggregates here.
Key Features of the Carpooling Platforms Dashboard in Power BI
- A semantic model, not a worksheet. A single Data table of 21 columns joins a generated Date table through one active relationship, so every month, quarter and year filter behaves the same way across all five pages.
- 80+ DAX measures written for carpooling.
Seat Fill Rate %,Full Occupancy %,Platform Take Rate %,Payout Ratio %,Net Margin %,EV Ride Share %,CO2 Saved Per Ride,CO2 Saved Per Km,Car Trips Avoided,Revenue Per SeatandRevenue Per Kmare defined once and reused everywhere. - Month-on-month comparison built into the model. A matching set of
... MoM %measures resolves the latest month present in your data and the month before it, then drives both the report header line and the coloured chip on every KPI card. - SVG KPI cards. Each card is a measure that returns SVG: the value, a green or red MoM chip, and a 12-month sparkline that respects whatever slicers are active.
- Synced slicers. Date Range, Platform, Region and Ride Type follow you between pages; each page adds a fifth of its own – Ride Status, Plan, Vehicle Type, Rider Segment or Booking Channel.
- A Details drillthrough page. Right-click a platform, city or ride type and land on the ride rows behind it. The page is hidden from navigation so it never clutters the report.
- Two tooltip pages. Hovering a column or line point opens a small report page rather than a bare value list.
- Scorecards with measure-driven bars and stars. The platform, city and vehicle tables render their bars from measures such as
Total Fare Revenue Bar (Platform), and the rating column comes fromAvg Rider Rating Stars.
Dashboard Pages Explanation
Carpooling Platforms Overview
The opening page is the one you leave on a screen. Four KPI cards hold Total Rides, Fare Revenue, CO2 Saved (KG) and Rider Rating, each with its month-on-month chip and sparkline. Rides & Fare Revenue by Month puts ride counts as columns and fare revenue as a line on a secondary axis, so a month where volume grew but revenue did not is immediately visible. Rides by Platform ranks the six platforms in the sample, and Rides by Ride Type splits demand across daily commute, airport transfer, event, intercity and corporate shuttle.
Ride Trends
This page separates real growth from booking noise. Total Rides, Completed Rides, Completion Rate, Cancellation Rate and Fare Revenue sit across the top; Completed Rides vs Completion Rate by Month plots the two together so a rising bar with a falling line stands out. Fare Revenue by Quarter gives the coarser view, Rides by Status splits completed, cancelled and no-show, and Rides by Booking Channel shows how much traffic arrives through the mobile app, the corporate portal, the web and partner API.
Platform Performance
The unit economics page. Fare Revenue, Driver Payout, Net Revenue, Net Margin and Take Rate head the layout, and Fare Revenue vs Driver Payout by Platform pairs the two bars per platform so the gap – the money the platform actually keeps – is the thing you read. Fare Revenue by Subscription Plan breaks the total across Free, Plus, Premium and Corporate riders, and the Platform Economics Scorecard lays every platform out with revenue, payout, net revenue, margin and a star rating in one table.
City & Region
Where demand actually sits. Total Rides, Fare Revenue, Revenue / Ride, Avg Wait (min) and Seats Booked run along the top. Fare Revenue & Avg Wait Time by City overlays a wait-time line on revenue columns, which is how you spot a city that earns well while riders queue – the case for adding drivers rather than marketing. The City Demand Scorecard adds seat fill and average wait per city, while Rides by Region and Rides by Rider Segment cut the same rides by geography and by professional, corporate, student and senior riders.
Sustainability & Occupancy
The impact-reporting page, and the one most carpooling schemes are asked for. CO2 Saved (KG), Distance (KM), Seat Fill Rate, Full Occupancy and EV Ride Share head the page above a CO2 Saved by Month area chart and a CO2 Saved by Ride Type donut – which usually shows intercity trips dominating, because distance drives avoided emissions more than ride count does. The Vehicle Type Sustainability Scorecard compares SUV, electric, sedan, van and hatchback rides on CO2 saved, distance, seats per ride, seat fill and full-occupancy share, and Seats Booked by Plan closes it out.
The pages you do not see in navigation
A sixth page links out to the wider NGT Power BI catalogue. Behind it sit three hidden pages: a Details drillthrough that lists the ride rows behind any selection, and two tooltip pages that render on hover. If you are new to these, Microsoft’s own documentation on drillthrough in Power BI Desktop is the clearest reference.
Carpooling Platforms Dashboard in Power BI vs. Tableau vs. Paid Mobility SaaS – Feature Comparison
| This template (Power BI) | Tableau / Qlik build | Paid mobility SaaS | |
|---|---|---|---|
| Cost | One-off template price | Roughly 70+ per user per month for Tableau Creator | Typically 200-1,000+ per month |
| Platform | Power BI Desktop (free) or Power BI Service | Tableau Desktop or Qlik Sense | Vendor web app |
| Setup time | Minutes – repoint the Data query and refresh | Days of modelling and sheet building | Weeks of onboarding plus a data feed |
| Real-time team collaboration | Yes, once published to a workspace | Yes, with a Server or Cloud licence | Yes |
| Mobile access | Power BI mobile app | Vendor mobile app | Vendor mobile app |
| Customizable fields | Full – edit any measure in the model | Full, but built from scratch | Limited to vendor options |
| Share with link | Yes, via the Power BI Service | Yes, with a server licence | Yes |
| Year-1 cost at 5 users | Template price plus licensing you already hold | 4,000+ | 2,400-12,000+ |
| Carpool metrics on day one | Seat fill, full occupancy, take rate, CO2 per ride | You write every measure | Only if the vendor tracks them |
| Where the data lives | Your machine or your tenant | Your machine or server | The vendor’s cloud |
Who Should Use This Template
It suits an operations or BI analyst at a carpooling or ride-sharing platform who already pulls rides into Excel or CSV and wants the modelling done. It suits a corporate mobility manager running an employee shuttle who has to defend the programme at budget time with occupancy and CO2 numbers. It suits a sustainability lead who needs avoided-emissions figures in a format that can be produced the same way every quarter. And it suits consultants, trainers and students who learn faster from a finished model than from a blank canvas – the DAX is plain and readable throughout.
It is not the right tool if you need live dispatch or GPS tracking, a rider or driver CRM, or an automatic feed from a ride-hailing API. This is a reporting layer over completed rides.
Real-World Use Cases
The weekly cancellation review. An operations lead opens Ride Trends, filters to the last quarter, and reads Completion Rate directly against Completed Rides. When one month dips she right-clicks the bar, drills through to the ride rows, and hands the city manager a list instead of an opinion.
The corporate shuttle business case. A mobility manager at a several-hundred-person employer needs to show the scheme is worth funding. Sustainability & Occupancy gives CO2 saved, seat fill rate and the share of rides running at full occupancy; City & Region shows which office sites actually use it. The report goes to a Power BI workspace so HR reads it without asking for a PDF.
The monthly finance pack. A finance analyst lives on Platform Performance. Take rate, payout ratio and net margin per platform already exist as measures, so the monthly pack becomes a slicer change and an export rather than a rebuilt pivot table.
Advantages of the Carpooling Platforms Dashboard in Power BI
- The metric definitions are settled. Seat fill rate, full occupancy and take rate are notoriously easy to define three different ways in one company. Here they exist once, in the model, and every visual inherits them.
- Comparisons are automatic. Because the MoM measures resolve the latest month from the data rather than from a hard-coded date, the report stays correct as rows are added.
- It scales past the sample. 500 rows is the demo; the measures use standard aggregations and
DIVIDE, so the Power BI import engine handles hundreds of thousands of rides without a rewrite. - Drillthrough beats exporting. The Details page answers “which rides are these?” in two clicks, which removes most of the ad-hoc export requests an analyst gets.
- It is yours to edit. No locked visuals, no vendor lock-in, no per-seat fee for a second reader.
Opportunities for Improvement
Being straight about the limits: the file is an import model with a manual refresh, so someone has to press refresh or configure a scheduled refresh in the Service – there is no live connection to a ride-hailing API out of the box. There is no map visual; city analysis is done through bars and a scorecard rather than geography, which keeps the file light but means you cannot see routes. The sample covers 12 months, so year-over-year measures are not included – add them once you have two years of history. And the sustainability figures depend entirely on how your source calculates the CO2 Saved column; the model sums what you give it and does not impose an emissions methodology.
Best Practices
- Walk the sample before replacing it. Ten minutes clicking through the five pages with the demo data tells you what each measure is meant to say.
- Match column names exactly. Keep Ride ID, Ride Date, Platform, City, Region, Ride Type, Vehicle Type, Booking Channel, Subscription Plan, Rider Segment, Ride Status, Seats Offered, Seats Booked, Trip Distance, Wait Time, Fare Revenue, Discount Amount, Driver Payout, Operating Cost, CO2 Saved and Rider Rating, and nothing breaks.
- Check the header line after every refresh. It names the latest month in your data and the month it compares against. If that reads wrong, the date column is the culprit, not the measures.
- Strip personal data at the source. Export rides as aggregated operating rows. There is no reason for names or phone numbers to reach a reporting model, and their absence makes the file far easier to share.
- Publish rather than email. Pushing to a workspace ends the “which version is current” problem and lets you set a refresh schedule.
- Add measures instead of editing visuals. If you need a new KPI, copy an existing card measure and swap the underlying measure – the SVG formatting comes along with it.
Explore Relevant Templates
- Carpooling Platforms Dashboard in Power BI – the template covered in this post.
- Carpooling Platforms Dashboard in Excel – the same five pages for teams without Power BI Desktop.
- School Transportation Services Dashboard in Power BI – routes, fleet and student ridership.
- Railway Tech Startups Dashboard in Power BI – the rail side of the same mobility market.
- Airline Loyalty Programs Dashboard in Power BI – travel-side loyalty and revenue analysis.
- Transportation Services Dashboard in Google Sheets – a lighter browser-based companion to share with colleagues who do not run BI tools.
Frequently Asked Questions
What do I need to open the file?
Power BI Desktop, which Microsoft provides free. A paid licence is only needed if you want to publish and share through the Power BI Service.
Are the numbers in the screenshots real?
No. All 500 ride records are sample data generated for the template, and the platform names are invented. Nothing in the file comes from a live carpooling service.
Does the model contain rider or driver personal data?
No. The Data table holds operating fields only – date, platform, city, region, seats, distance, wait time, money and a rating. No names, contact details or locations of individuals, and we would not recommend adding them.
How hard is it to use my own data?
Open Transform Data, change the source of the Data query to your file or database, keep the 21 column names, then close and apply. Every visual on all five pages refills from the same model.
Can I add or change the KPIs?
Yes. Every measure lives in the Data table as readable DAX and can be edited, duplicated or deleted. The KPI cards are themselves measures returning SVG, so a new card is a copy with a different measure inside.
Will it handle more than 500 rides?
Yes. The sample is small so the file downloads quickly. The measures use standard aggregations, so the model scales to hundreds of thousands of rows.
What is actually in the download?
A single zip with the .pbix report, the sample Data.xlsx source file, and a PDF user manual covering the pages, slicers and how to repoint the query.
About the Author
Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.
Conclusion
Carpooling reporting fails in a predictable way: ride counts live in one export, money in another, and sustainability numbers get assembled by hand the week before a board meeting. The Carpooling Platforms Dashboard in Power BI collapses those into one semantic model with the definitions already agreed, five pages that answer distinct questions, and month-on-month comparison that maintains itself as data arrives. Replace the sample rides with your own, refresh, and the reporting problem becomes a five-minute job.
Get the Carpooling Platforms Dashboard in Power BI on NextGenTemplates – instant download, lifetime access. Prefer spreadsheets? The Excel version covers the same ground.
For step-by-step Power BI and Excel tutorials, subscribe at youtube.com/@PKAnExcelExpert.
