Download PDF
CloverDX > Case Studies > Building a Data Warehouse, Delivering Business Insight Quickly
CloverDX Logo

Building a Data Warehouse, Delivering Business Insight Quickly

Technology Category
  • Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries
  • Retail
Applicable Functions
  • Business Operation
Services
  • Data Science Services
The 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 The 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.
The 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.
Operational Impact
  • With CloverETL, MyPublisher no longer has to develop programs or do constant, repetitive work.
  • The data team can get from an idea to a solution in a couple of days, changing graphs and load data as needed.
Quantitative Benefit
  • The data warehouse was fully-operational and being used for daily business needs within six months.

Related Case Studies.

Contact us

Let's talk!

* Required
* Required
* Required
* Invalid email address
By submitting this form, you agree that IoT ONE may contact you with insights and marketing messaging.
No thanks, I don't want to receive any marketing emails from IoT ONE.
Submit

Thank you for your message!
We will contact you soon.