Rental One, located in Colleyville, Texas, is a premier equipment rental company, who provides their customers locally and state-wide with a broad selection of the best construction equipment and the most personalized service possible. By way of 11 retail locations, customers from a wide range of markets can take advantage of Rental One’s vast industry experience, and will benefit from partnering with an organization who promises to deliver exceptional solutions.
While the organization has evolved and grown ten-fold since it began as a family-run business over 6 decades ago, its commitment to excellence and belief that good work relies on dependability, integrity, honesty and teamwork, has never wavered. Rental One continues to support its customer’s projects regardless of equipment, supply, or service need.
Rental One maintained an enormous Excel spreadsheet with millions of rows across multiple sheets that tracked key performance indicators (KPIs) for financial data company-wide for both retail store managers and executives. This Excel spreadsheet had lived within the organization for countless years, and housed all the data responsible for supporting key decisions.
On a weekly basis, Rental One would export data from their ERP to their existing Excel spreadsheet, and while this process was partially automated, the majority of content was added manually. As the number of variables and quantity of content increased, the spreadsheet continued to accumulate data, expand, and become more cumbersome. At month’s end, additional consolidations were prepared to provide an executive review of the business performance.
What the Excel spreadsheet fundamentally lacked as it grew, was reliability. Rental One noticed that their long-time running Excel-based process continued to produce incorrect results, and different users reached different conclusions based on how the spreadsheet was interpreted and which data stacks they ran. Rental One had reached a point where as it stood, their Excel-based system was grinding to a halt and impacting multiple facets of the business. To rectify this problem, which was snowballing out of control, Steve Glaeser, Senior Systems Analyst at Rental One, was tasked with reverse-engineering the spreadsheet and re-creating it using a Business Intelligence (BI) platform.
Rental One’s Excel-based processes were not nearly efficient or scalable enough, and they required a Business Intelligence platform that could negate Excel’s shortcomings, unlock and consolidate data from their ERP, simplify ad-hoc queries, and automatically produce correct, consistent results for everyone in the organization. Adding complexity to their search, Rental One felt they needed to implement a BI solution that wouldn’t compromise the integrity of their data, and would perform amply in scenarios of greater intricacy such as when dealing with large quantities of data prep steps. This was pivotal, as they required a solution with the ability to automate ETL processes that were traditionally performed manually in Excel; an innate capability of Dundas BI.
As the search for the ideal solution intensified, and the pool narrowed to 20 vendors (including Tableau, Sisense, Qlik, and Microsoft), Dundas stood out from the competition for a myriad of reasons. Primarily for its long-standing leadership in the data visualization space, and for its ability to fulfil Rental One’s key requirements specifically in regards to advanced data prep, but also for its commitment to enable and ensure the success of Rental One. Dundas’ Professional Services team exhibited a dedication to coach and guide Rental One that was unmatched by its competition.
It’s for these reasons that Dundas BI was chosen by Rental One as the BI solution to replace their Excel-based processes.
Why Rental One Chose Dundas BI
Using Data Cubes within Dundas BI, Rental One was able to define how their data would be broken up into measures and hierarchies, regardless of its original source. Multiple transformations were used at this level to perform data cleansing, join data from different sources and ensure the data used for analysis was precise, error-free and automated. Dundas BI’s advanced data prep capabilities allowed Rental One to be more proactive, and focus on the data they needed, and from there, easily enrich it.
With Dundas BI, Rental One acquired the ability to retrieve data directly from its sources on regular intervals. This meant they could display their data in real-time on their dashboards, providing users with unfettered access to stored information and empowering them to track KPIs down to the minute.
When Rental One began their search for a BI platform, it was imperative they found one that could implement user-dependent filtering, and display data only to users with particular attributes. Using Dundas BI’s security hierarchies, Rental One was able to set specific user privileges at the data model level, to ensure that store managers and executives can only access the data they should be privy to no matter which dashboard they access.
Dundas BI features advanced interactivity and intuitive data discovery operations via simple point-and-click or drag-and-drop actions. This made it easier for Rental One to refine available data for use, interact with multi-dimensional hierarchies, setup contextual metrics to support period-over-period analysis, and analyze data faster.
"It’s Excel on steroids for an ERP report that runs over 500 physical printed pages"
Senior Systems Analyst
Excel works until it doesn’t, and for Rental One, it simply stopped working. This paved the way for the acquisition of a Business Intelligence solution that would make millions of rows of data highly accessible across the entire organization, and allow store managers and executives to make key decisions based on accurate information.
What can Dundas do for you?
No one knows your business better than you do.
Tell us what you’re trying to achieve and we’ll make sure you get there.