data lakes and warehouses – software
Global software company builds enterprise data warehouse
Overview
Done right, data analytics can inform everything.
From from marketing and sales to customer support and product development, analytics drives more strategic decision-making along the way. The first step to creating a robust analytics program is to establish a centralized platform that can bring together data from every possible source.
One of our clients, a global software company, recently asked for One Six Solutions’ help building a data warehouse solution that would consolidate data coming in from numerous locations and fuel its analytics initiatives. Here’s what happened.
Our Solution
Condensing analytics data on a global scale
Our client operated on a large, worldwide scale and needed a data warehouse solution to match that global footprint. One Six Solutions developers set to work building an enterprise data warehouse that could support the company’s business analytics aspirations. We helped our client design and develop the right solution for their needs using SQL Server 2012, as well as assisted with business analysis processes.
The One Six team worked alongside the organization’s senior business intelligence leadership to define application integration requirements and key project metrics.
Integration was a major priority for our client. They needed to condense as much data as possible to drive analytics goals. Our team used SSIS for ETL to integrate data from various applications, including:
- JIRA
- Salesforce
- Pivotal CRM
- Eloqua
Microsoft SQL Server Reporting Services 2012, PowerPivot, PowerView and Tabular Analysis Services were used to develop data visualizations and reports that could be shared with and presented to nonanalytical decision-makers.
The Results
As a result of this project, our client can now capture valuable data in near real time.
For instance, the management team and the product support business units are able to analyze and track product bugs and errors as they appear. In addition, the marketing and sales departments have the insight needed to increase upselling and cross-selling opportunities with customers and prospects.
