Resource Center Business Intelligence Case Study: Building a Carve-Out’s Analytics Core

Business Intelligence Case Study: Building a Carve-Out’s Analytics Core

facebook sharing button Share
twitter sharing button Tweet
linkedin sharing button Share
email sharing button Email

25 Year Anniversary

one bird vs. many sitting on power lines to represent a carve-out business intelligence case study

CLIENT PROFILE

Our New York-based client is a sports and active nutrition company that had been recently sold by a well-known, global corporation to a private equity firm specializing in the consumer, services, and industrial sectors. The newly independent business provided market-leading products in the $16 billion functional snacking industry, including popular protein powders and meal replacement and ready-to-eat protein bars.

BUSINESS CHALLENGE 

Carving an independent company out of a larger entity is rife with complexity. To gain robust experience and a proven methodology for separating new businesses from larger organizations, the client had already hired Auxis to:

Blue arrow icon

Operate the carve-out’s Separation Management Office (SMO).

Blue arrow icon

Separate the client’s IT infrastructure from the selling corporation. That included migration of all related users and certain business applications to a new infrastructure environment, as well as implementing technologies and security protections that would enable the client to operate as a standalone organization.

Blue arrow icon

Address Finance & Accounting gaps at the new organization by outsourcing back office Accounts Payable (AP), General Accounting, and Master Data operations to the Auxis Global Delivery Center in Costa Rica.

Blue arrow icon

Implement a NetSuite ERP system and all necessary integrations.

But the carve-out faced another significant challenge: separating and merging historical data belonging to the new company to enable future analytics and reporting.

As a division of the seller, the client relied on analytics provided through Microsoft Power BI dashboards to measure performance and maintain business visibility. Historical data that flowed into the platform from several different applications was vital to making strategic decisions about the present and the future – enabling the organization to track performance over time, identify areas of improvement, and predict future trends.

However, separating that critical data presented significant difficulties:

Blue arrow icon

The client wanted to retain analytical data stretching back over 5 years to enable strategic comparisons and inform business decisions. But identifying and separating data often proves difficult and time-consuming during a carve-out. In this case, data was spread across the seller’s data warehouse; multiple Power BI dashboards covering financials, sales performance, trade promotions, shipping/delivery, and more; and dozens of operational and financial reports.

Blue arrow icon

Data was tailored to the seller’s systems, applications, and formatting. For successful post-separation analysis, the seller’s data models and reports needed to be harmonized and integrated with the new formats, dashboards, and data sources at the new company.

SOLUTION & APPROACH

Pleased with the success of its other carve-out partnerships, the client hired Auxis to enable monthly operational reporting using Power BI and analytics by:

Blue arrow icon

Helping separate the new company’s historical data from the seller’s applications, visualizations, and reports.

Blue arrow icon

Creating a Power BI environment in Microsoft Azure with familiar services and configurations.

Blue arrow icon

Migrating existing data, configurations, and dashboards to the new environment.

Blue arrow icon

Harmonizing new and historical data.

Blue arrow icon

Implementing and thoroughly testing connectors between the Power BI platform and the new NetSuite ERP system and other new data sources at the new company.

Blue arrow icon

Training users to access the new analytics environment.

Key solution steps included:

Number 1

Analyzing existing data structures and architecture.

To properly design and validate a future-state solution, Auxis began with a deep dive into the seller’s pre-separation environment. The Auxis team aimed to gain a clear understanding of how every legacy data source was run and configured, including an IBM AS/400-based order management and warehousing system, a TIM trade promotion management system, and an Oracle E-Business Suite (EBS) financial system.

Auxis also performed a thorough analysis of how existing data was extracted, summarized, and processed - examining the seller’s terminologies, data fields, data elements, data relationships, classification of products and customers, and more.

Number 2

Harmonizing data to ensure a consistent story.

With a deep understanding of legacy data, Auxis focused on harmonizing new and historical data in the client’s Power BI environment. Harmonization resolves issues stemming from inconsistent and disparate data sources, such as variations in data types, file types, naming conventions, or missing fields.

The Auxis team mapped data from new company systems like NetSuite and an Exceedra trade promotion management system into the existing data warehouse models - performing field-by-field comparisons to ensure new and legacy data told the same story in the same way.

Discrepancies were fixed with client input, ensuring analytics delivered the richest insights into business performance.

Number 3

Microsoft Power BI migration.

To ensure the smoothest transition, Auxis devised a plan to reuse and rebuild as much of the seller’s Power BI architecture as possible. 

The client wanted to keep Power BI operations and reports the same to minimize time getting up to speed. So, the platform was recreated “like for like,” with Auxis seamlessly “lifting and shifting” existing data, configurations, and dashboards into the new Azure cloud service and infrastructure that Auxis implemented at the new company.

Auxis implemented Azure Data Factory pipelines to connect the new systems to Power BI. It also used NetSuite’s Tactical Connect tool to extract data from a third-party sales broker and logistics provider.

Tactical Connect provides an easy way to automatically export data in the proper format for easy reporting and analysis.

Finally, the Auxis team performed thorough testing to ensure data flowed seamlessly into the dashboards at the new company and identify any remaining discrepancies.

RESULTS

Although it can be daunting, mapping past and future comparisons after a carve-out is not an insurmountable challenge with the right expertise and support. The Auxis team’s successful analytics buildout enables our client to continue using historical data to inform strategic business decisions as an independent organization.

electronic component with magnifying glass icon

The new company hit the ground running with a data-driven culture, using deep insights and visibility into business performance to make decisions and steer direction with confidence.

Monitor with angular brackets icon

With zero downtime accessing existing reports, business operations ran without disruption at the cutover to the new environment.

sheet with data icon

The Auxis team’s painstaking harmonization process enabled a seamless merger of new and historical data in Power BI dashboards and reports.

bar graph with increasing trend icon

With 100% of the client’s five-year historical data successfully migrated to the new environment, the client can customize analysis to guide innovation and strategy – for instance, comparing the performance of similar products, looking at monthly or yearly sales, tracking the success of new product launches, and more.

3/8/23 11:12 AM

Enjoying our content? Follow us on LinkedIn and stay updated!

Related Posts