New data warehouse enables business users to make better decisions and positions company for growth.
“RDA has been a key partner in Pandora’s Business Intelligence program for the past few years. In addition to assisting with the day-to-day operations of our data warehouse, RDA’s team has designed and developed large-scale ETL solutions and led complex deployments of new features and modules to our platform. RDA’s team brought not only business acumen, but years of technology expertise around data and business intelligence partnership with us to achieve success in the endeavor.”
-Mark Sengamalay, Manager, Application Development
Pandora designs, manufactures and markets hand-finished and contemporary jewelry made form high-quality materials at affordable prices. With jewelry sold in more than 100 countries through approximately 9,000 points of sale, data is collected in numerous systems including point of sale, websites, and customer relationship management software.
With data from multiple systems, inconsistencies and conflicting information was common. Pandora recognized an opportunity to increase revenue and profits through making use of a data warehouse that provides clean and accurate information.
Pandora engaged RDA to design and construct a data warehouse that consolidated data from all aspects of the firm’s North American operations. Critical to its success, the warehouse standardizes Pandora’s reporting and metrics and provides more analytics and insight to its finance, sales, merchandizing, marketing and retail users.
The data warehouse tracks the entire lifecycle of items, from viewing the original wholesale costs and sales to tracking retailer performance. Furthermore, data compilation is completely automated and users no longer rely on technical personnel to gain access to data sources.
Users of Pandora’s customer data now benefit from easy access to key metrics covering profitability, response to marketing promotions, geographic demand, and customer tendencies. This data positions the company to make better decisions, leading to increases in revenue, profits and efficiency.