Trimble owns servers that customers buy / lease from them. They also own server performance diagnostic tools that regularly record statistics about the servers.
These statistics are stored as raw data, and Trimble had no easy way to assemble these statistics and share them with customers.
They have multiple server types including SLQ Servers, Oracle, MongoDB, and MySQL Servers.
Trimble has a finance team that tracks how their customers are billed for the servers. A large and overwhelming financial report is produced once a month, but this report is not intuitive or easy to interpret.
Brainspire was engaged to plan, design, and create a process for the server statistics data and billing data to be utilized to create interactive, intuitive, and automated reports on schedule.
Brainspire determined that an ETL process that would extract data from its sources and load it into a data mart would work best for Trimble.
Using the Microsoft BI stack, Brainspire created a process from beginning to end that used the following technologies:
SSIS to extract and transform data from the various data sources and load it into a central data mart.