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.

The first step to creating a robust analytics program is to establish a centralized platform that can bring together data from every possible source.

Microsoft SQL logo full color
Jira logo full color
Pivotal CRM logo full color
Eloqua logo full color
Salesforce logo full color

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.