Tableau Saves Blastrac Thousands of Dollars with Simplified Information Sharing
Blastrac, a self-proclaimed global leader in portable surface preparation technologies and equipment (e.g., shot blasting, grinding, polishing, scarifying, scraping, milling, and cutting equipment), depended on the creation and distribution of reports across the organization to make business decisions. However, the company did not have a consistent reporting method in place and, consequently, preparation of reports for the company’s various needs (sales data, working capital, inventory, purchase analysis, etc.) was tedious. Blastrac’s analysts each spent nearly one whole day per week (a total of 20 to 30 hours) extracting data from the multiple enterprise resource planning (ERP) systems, loading it into several Excel spreadsheets, creating filtering capabilities, and establishing predefined pivot tables.
Not only were these massive spreadsheets often inaccurate and consistently hard to understand, but also they were virtually useless for the sales team, which couldn’t work with the complex format. In addition, each consumer of the reports had different needs.
Blastrac Vice President and CIO Dan Murray began looking for a solution to the company’s reporting troubles. He quickly ruled out the rollout of a single ERP system, a multimillion-dollar proposition. He also eliminated the possibility of an enterprisewide business intelligence (BI) platform deployment because of cost—quotes from five different vendors ranged from $130,000 to over $500,000. What Murray needed was a solution that was affordable, could deploy quickly without disrupting current systems, and was able to represent data consistently regardless of the multiple currencies Blastrac operates in.
The Solution and the Results
Working with IT services consultant firm Interworks, Inc., out of Oklahoma, Murray and team finessed the data sources. Murray then deployed two data visualization tools from Tableau Software: Tableau Desktop, a visual data analysis solution that allowed Blastrac analysts to quickly and easily create intuitive and visually compelling reports, and Tableau Reader, a free application that enabled everyone across the company to directly interact with the reports, filtering, sorting, extracting, and printing data as it fit their needs—and at a total cost of less than one-third the lowest competing BI quote.
With only one hour per week now required to create reports—a 95 percent increase in productivity—and updates to these reports happening automatically through Tableau, Murray and his team are able to proactively identify major business events reflected in company data—such as an exceptionally large sale—instead of reacting to incoming questions from employees as they had been forced to do previously.
Prior to deploying Tableau, I spent countless hours customizing and creating new reports based on individual requests, which was not efficient or productive for me,” said Murray. “With Tableau, we create one report for each business area, and, with very little training, they can explore the data themselves. By deploying Tableau, I not only saved thousands of dollars and endless months of deployment, but I’m also now able to create a product that is infinitely more valuable for people across the organization.
1. How did Blastrac achieve significant cost saving in reporting and information sharing?
2. What were the challenge, the proposed solution, and the obtained results?