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.
Solution
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.
SSRS to create a dashboard that pulls data from the tabular model. The dashboard is automatically emailed out once a week.
Excel PivotTables and PivotCharts to create more detailed reports for users to understand the dashboard metrics better.
Benefits
Trimble’s customers now have usable and beneficial tools at their disposal to see where their money is going.
The server performance metrics report allows Trimble to monitor patterns in their servers’ performance so that they may spot issues or anticipate future problems.
The server performance report is completely automated and hands-off, therefore not eating up valuable employees’ time.
