Johns Manville is a global manufacturer of construction materials products, with $3B annual
• To service the North American market, the company spends approximately $20MM per month
on transportation and freight related costs.
• The client had made a significant investment implementing a new Transportation Management
system (SAP TM), which was collecting substantial amount of data, however not all of it had
been utilized for useful and actionable information.
• The internal Supply Chain and Logistics department had identified numerous initiatives for
investigating and analyzing data, in search of areas to focus on improving costs and negotiating
leverage with transportation providers.
Johns Manville Client engaged Brainspire for two purposes: • Build an analytics/visualization dashboard platform to support transportation analytics • Provide coaching and mentorship to internal resources, to develop skillsets around data analytics approaches, database tools, and visualization packages. • Brainspire worked with the client to identify where and how data is stored in the source TM system and designed queries using SAP tools for extracting data. • Brainspire collaborated with other internal IT resources to define the ETL schedule for loading data from the transactional source system (SAP TM) and into an existing SQL Server DataMart. • In close collaboration with the Supply Chain and Logistics department, the team identified core KPI’s and metrics to measure department and transportation provider performance. • Brainspire resources and internal client IT analysts built multiple dashboards and visualization tools using Tableau to present data in an easily interpreted visual format.