This company is an industrial equipment supplier with employees across the US and Canada. They manufacture and distribute large service equipment for the marine, oil and gas, transportation and construction and lift markets.
Over the past few years, this company acquired multiple companies, creating a mix of data sources with different granularity that was relatively unorganized. Because of this, they were looking to upgrade and simplify their on-premises data environment for their sales data.
Baker Tilly Digital designed an ideal data warehouse that integrated all the company’s data into one uniform structure and place. We restructured their data using the Kimball method so that the company could easily scale as their data grew. With the data in a much more usable place, using Power BI we were then able to completely rebuild and enhance existing reporting with new KPIs and measures to help them better understand what the data is telling them. With the new and improved data warehouse, they are now set up to scale effectively and can continue to further enhance their reporting needs.
Baker Tilly Digital was able to implement this solution by doing the following: