Data Platform Migration | Starschema

Data Platform Migration

Practice Area

  • Data Engineering

Business Impact

  • Reduced license and hardware costs
  • More efficient reporting process

Challenges

  • Slow data platform performance
  • Hard deadline implement a new data platform

Technologies

Oracle, HVR, Talend, Tableau, Greenplum

Summary

When large organizations merge or divest, then new entity has business transformation thrust upon it. Our client, a power generation manufacturer, divested from a larger organization to become a brand-new company. With the looming deadline of a cut-over from the existing data platform, the client engaged Starschema to validate and test the existing technology stack and determine the best way to move forward.

Challenge

The client had an existing, on-premises data platform for handling commercial data but was suffering from slow report loading, sometimes longer than 60 minutes, frustrating the primary data consumers, the sales and marketing teams. The performance issues drove some groups to turn to shadow IT solutions, building their own, parallel data platform. As part of the divestiture, the client wished to take the opportunity to look at migrating its data platform to the cloud. Part of the technology evaluation included the feasibility of migrating the stack components to the cloud.

Solution

Starschema data engineers completed a full design review of the existing technology stack which included Oracle ERP as the system of record, HVR for data replication, Greenplum as the database, Talend for ETL, and Tableau for data visualization. This design review included a detailed review of code and configuration for the various technologies used as well as reviewing data governance.Our experts designed a cloud-based architecture incorporating the existing technology on-premises components. After a lengthy testing phase and a Proof of Concept (PoC), the Starchema team optimized the components of the existing data platform to increase performance, validating the technology stack for post-divestiture operations.

Results

With a successful migration of the Oracle ERP source system to Oracle cloud and the other data platform components to an AWS environment, the client has benefited from reduced hardware, license, and maintenance costs. The new, cloud-based data platform renders reports several times faster than the on-premises version.

Customer Segmentation at an Energy Company

Our client, a retail gas and electricity provider, operates a call center to facilitate customer requests and to offer complementary services, such as equipment maintenance.

Using Data to Improve Global Supply Chains

Over 60% of the world’s global seaborne trade is shipped using intermodal freight containers, and the ports that manage them serve as central points for supply chains – over 90% of global trade is conducted through ports.

Optimizing Data Visualization

Great visualizations can make data come alive, leading to better insights and decisions. Data consumers of every kind rely on dashboards to perform their work, but they have a common complaint, slow loading times.

Palette Insight

Palette Insight provides actionable intelligence about your Tableau deployment to help you maximize the benefits of Tableau Server.

SCROLL

This website uses cookies

To provide you with the best possible experience on our website, we may use cookies, as described here. By clicking accept, closing this banner, or continuing to browse our websites, you consent to the use of such cookies.

I agree