Our client is a global software company who needed a way to consolidate data and develop an analytics platform to support decision making for their product engineering, customer support, marketing and sales organizations.
The One Six Solutions team assisted our client with business analysis, Data Warehouse design and development to build an Enterprise Data Warehouse. One Six Solutions worked with the organization’s Business Intelligence senior leadership to define application integration requirements and the key metrics to support the functional groups.
The solution was built upon the SQL Server 2012 platform utilizing SSIS for ETL to integrate JIRA issue data, Pivotal CRM support data and SalesForce.com CRM data. Integration processes to provide near real-time marketing list generation were developed to integrate SalesForce.com data with Eloqua Campaign Management software via API calls. Reports and data visualizations were developed using Microsoft SQL Server Reporting Services 2012, PowerPivot and PowerView against a Tabular Analysis Services environment. Excel Services 2013 was also used to provide an analytical environment to the support group.
The project enabled the client’s management team and the product support organizations to analyze and track product bugs and fixes over time. Additionally, it provided the marketing organization a mechanism to cross-sell and up-sell capabilities to customers and prospects by providing targeted email marketing.