Marion Body Works is an independent, family owned and operated manufacturer of cost competitive, specialized equipment located in Marion, Wisconsin. Marion Body Works manufacturers rescue and fire apparatus, commercial van bodies, truck cabs, military platforms and custom engineered vehicles.
Marion Body Works critical business information was fragmented around the company, stored on separate computers using inconsistent software and file types, making it time intensive to compile comprehensive reports. If one data point changed while the report was being compiled, the whole process had to restart. The process cost too much time in labor and external contractors, which resulted in reports that were often riddled with errors. They were also spending a significant amount of time and money pulling together data from different departments to measure monthly progress towards their annual goals.
Baker Tilly’s team exemplifies great talent and leadership and delivers everything from strategy to the personal touch. The team understands the importance of asking the right questions in order to design and implement solutions to help answer tough business questions. Baker Tilly’s solution allowed us to make more value-added decisions with readily available data.VP of IT and Information Systems, Marion Body Works
Baker Tilly Digital designed an ideal data warehouse modeled around the client’s business processes, regardless of what software those processes ran on. The new system focused on streamlining the financial information, including sales, costs and transactions, which would provide useful information for other departments. We then identified what financial data would be required for monthly report automation and several metrics from the monthly report that could easily be checked to ensure there was no loss of information during the extract, transform and load (ETL) process from the enterprise resource planning (ERP) system to the initial automated report. Baker Tilly Digital implemented solutions to:
The new system allowed managers to compile automated, accurate reports from multiple data sources daily, saving staff time and additional work. The executive team had access to updated reports to view progress toward its financial goals daily, without tying up extra manpower. For the monthly reports, once the numbers from the executive report were confirmed with past Marion reports, Baker Tilly Digital made those data points available in a self-service business intelligence (BI) tool which enabled the IT staff at Marion to drive sets of data into their Business Management Platform. These departments were also able to drill down in the data to see the underlying drivers, empowering them to improve the metrics tracked by the Executive team.