CloverDX Case Studies Building a Data Warehouse, Delivering Business Insight Quickly

Edit This Case Study Record

	Building a Data Warehouse, Delivering Business Insight Quickly CloverDX

Building a Data Warehouse, Delivering Business Insight Quickly

CloverDX

Technology Category	Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries	Retail
Applicable Functions	Business Operation
Services	Data Science Services
Challenge	MyPublisher, a leading online retailer of personalized Photo Applications, was facing a challenge in managing its retail and marketing data. The company wanted to tie this data closely with web traffic and email data to capture customer activity. However, the primary challenge for the data warehouse team was to bring together disparate sources of data in the company. Before the introduction of a data warehouse, MyPublisher was not using a data warehouse at all – ad hoc reports and a number of systems were used instead. This made it difficult for the company to gain a deeper insight into business activity, and do so on a recurring basis. Read More
About Customer	Based in New York, MyPublisher is a leading online retailer of personalized Photo Applications to enable consumers to creatively customize, share, print, and preserve digital photographs. Serving an active community of more than 5 million registered customers, MyPublisher prints, manufactures and ships every product it sells. Every year it prints and ships more than 120 million photos. The company uses CloverETL to pull manufacturing and retail data, such as order information, customer information, and email information into a data warehouse. The data warehouse team is charged with delivering the data regularly, in a meaningful way. Read More
Solution	To address the challenge, MyPublisher introduced a data warehouse and selected CloverETL as their ETL tool. CloverETL enables MyPublisher by bringing multiple data sources together seamlessly, as well as allowing them to include unclean or legacy data in the mix. Instead of spending valuable time writing scripts and utilities, MyPublisher can accomplish their goals with a number of CloverETL graphs and a minimal amount of coding. The CloverETL Server has also helped integrate all the company’s data processes. MyPublisher runs transformations from the Server, using its scheduling and monitoring automation, with the Designer as the visual front end. It took 3 to 4 months for the team to develop the first beta version, and within six months, the date warehouse was fully-operational and being used for daily business needs. Read More Log in to view content
Contents

Technology Category

Platform as a Service (PaaS) - Data Management Platforms

Applicable Industries

Retail

Applicable Functions

Business Operation

Services

Data Science Services

Challenge

MyPublisher, a leading online retailer of personalized Photo Applications, was facing a challenge in managing its retail and marketing data. The company wanted to tie this data closely with web traffic and email data to capture customer activity. However, the primary challenge for the data warehouse team was to bring together disparate sources of data in the company. Before the introduction of a data warehouse, MyPublisher was not using a data warehouse at all – ad hoc reports and a number of systems were used instead. This made it difficult for the company to gain a deeper insight into business activity, and do so on a recurring basis.

About Customer

Based in New York, MyPublisher is a leading online retailer of personalized Photo Applications to enable consumers to creatively customize, share, print, and preserve digital photographs. Serving an active community of more than 5 million registered customers, MyPublisher prints, manufactures and ships every product it sells. Every year it prints and ships more than 120 million photos. The company uses CloverETL to pull manufacturing and retail data, such as order information, customer information, and email information into a data warehouse. The data warehouse team is charged with delivering the data regularly, in a meaningful way.

Solution

To address the challenge, MyPublisher introduced a data warehouse and selected CloverETL as their ETL tool. CloverETL enables MyPublisher by bringing multiple data sources together seamlessly, as well as allowing them to include unclean or legacy data in the mix. Instead of spending valuable time writing scripts and utilities, MyPublisher can accomplish their goals with a number of CloverETL graphs and a minimal amount of coding. The CloverETL Server has also helped integrate all the company’s data processes. MyPublisher runs transformations from the Server, using its scheduling and monitoring automation, with the Designer as the visual front end. It took 3 to 4 months for the team to develop the first beta version, and within six months, the date warehouse was fully-operational and being used for daily business needs.

Impact #1	With CloverETL, MyPublisher no longer has to develop programs or do constant, repetitive work.
Impact #2	The data team can get from an idea to a solution in a couple of days, changing graphs and load data as needed.

Impact #1

With CloverETL, MyPublisher no longer has to develop programs or do constant, repetitive work.

Impact #2

The data team can get from an idea to a solution in a couple of days, changing graphs and load data as needed.

Benefit #1	The data warehouse was fully-operational and being used for daily business needs within six months.

Benefit #1

The data warehouse was fully-operational and being used for daily business needs within six months.

Download PDF Version

Overview

Building a Data Warehouse, Delivering Business Insight Quickly

Operational Impact

Quantitative Benefit