data lakes and warehouses – software
Global software company builds enterprise data warehouse
Overview
Done right, data analytics can inform everything.
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, 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
Leveraged SQL Server as the Data Warehouse solution with integrated data across the enterprise
SQL Server delivered pixel perfect reports on a scheduled basis to business stakeholders inbox
Tableau provided the OLAP structure to support ad-hoc slicing and dicing of the data
PowerView enabled an Excel like user friendly interface to enterprise data sets
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.