data lakes and warehouses – software

Global software company builds enterprise data warehouse

Salesforce logo white with transparent background

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.

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

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.

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

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.