Case Study

"You have really helped us get clarity around our complex requirements so everyone knows exactly what we're talking about and how that fits into the big picture."

Key stakeholder, EV start-up

Enhance the granularity and usability of dashboards used by an EV start-up to report out vehicle requirements.

Read the case study

Outcomes

Workbook opening time

8 minutes

6 seconds

Dashboard refresh

20 minutes

50 seconds

Slicing (filtering) data

20 minutes

8 seconds

Excel formulas

89,300

Engagement cost

$15k

An EV start-up needed to enhance the granularity and usability of dashboards used to report out vehicle requirements. A booster sprint supported by QR_'s Special Projects software development team rebuilt the dashboards on a robust, scalable, and efficient Excel-based data architecture.

Excel data model and DAX

Calculation efficiency — up to 100x performance boost on roll-up calculations using DAX rather than Excel formulas and Power Query transformations
Scalability — the Excel data model stores data in memory rather than spreadsheet cells and is not limited by size
Increased granularity — reporting dashboards became 5x more granular, showing the full depth of the vehicle requirements' hierarchical structure
Separation of concerns — relationships between data tables allowed smaller, manageable tables with simpler calculations to replace a single slow complex table

Power Pivot dashboards

Direct integration between the Excel data model and tables, charts, and slicers, letting users drill into hierarchical data by grouping and ungrouping
Data caching so dashboards filter on the fly without waiting for slow refreshes — users can quickly get the right view for their reporting needs

Reach out to start a conversation

Every business faces unique challenges, and we're here to listen, not presume. Share your contact details, and one of our experts will reach out to discuss your specific needs. No spam, just tailored solutions.