Data Transformation and Visualization in Retail using 3 Key Solution Products

Case Studies
Todd Bailey - Principal Consultant, Ricky Romanek - Senior Consultant

CLIENT SUCCESS STORY

Company Highlights

Region: USA

Sector: Retail

Industry: Online Retail

Division: Operations

Solution Technologies: Matillion, Microsoft Power BI, Snowflake

Solution Products: Matillion, Microsoft Power BI, Snowflake

Solution Service Type: Project

 

I N T R O D U C T I O N

This online retailer with over 3 million customers used the combination of Matillion, Snowflake, and Power BI to create a daily view of their operations measuring orders, gross margin, cost of goods sold, advertising effectiveness, and other retail metrics. Retail metrics can now quickly be compared to plan and previous years.

 

C H A L L E N G E

Our client needed to be able to determine their current sales position against the yearly plan. They also needed to understand current cost of goods sold, order cancellation rate, sales by distribution channels, and year to date performance compared to the previous year. Pomerol Partners built dashboards that delivers all the metrics to the executive team, updated three times daily. This retailer now can adjust business operations based on accurate and near real-time data.

 

S O L U T I O N

Pomerol Partners built clear and accurate Power BI dashboards giving the client the ability to review sales metrics near real-time. The dashboards are supported by Matillion with its inherit ability to move, clean, transform, and provision the data needed for accurate reporting. The data is provisioned to a Snowflake data warehouse.

The combination of Power BI, Matillion, and Snowflake provides Stauer with an enterprise scalable product at an extremely low cost.

 

R E S U L T

Feedback from management team extremely positive. Dashboards are being used daily by the management team to better run operations. Pomerol Partners continues to work with this client to expand reporting capabilities in other areas of their business.

 

A B O U T  P O M E R O L

Pomerol Partners creates and delivers meaningful data-driven business solutions and services. We’ve been operating in Data Analytics and Intelligence Reporting for over 9 years and our Partners have a cumulative 100 years in global experience. In 2013, Pomerol spun out of Deutsche Bank after a range of successful BI projects were delivered saving the bank over $3m. Ever since then we’ve been partnering with our clients (executives, managers, analysts, etc.) across all business verticals to optimize the intersect between changing business demands, technological progress and sustainable business growth.

Our consultants have helped hundreds of organizations, of all sizes and in all industries worldwide, make money. How do we do this? Leveraging your data to increase revenue, automate processes, decrease costs and understand your insights. Pomerol delivers value that helps you grow and change with better data-driven decisions and solutions that empower you as an Elite Qlik Partner as well as a Gold Data Platform, Silver Data Analytics and Silver Cloud Platform Microsoft Partner.  Our professional consultants, that reside in three countries (United States, United Kingdom and Portugal), are experts that will partner with you for the technical as well as business-oriented solutions. Working with the same team in all capacities ensures you always know where we stand with our work and commitment to you.

Pomerol offers a comprehensive range of Power BI training options. For those new to Power BI, Dashboard-in-a-Day will provide give you the knowledge and confidence to build your own dashboards. For those looking to take their Power BI skills to the next level our advanced DAX and M courses will teach you the fundamentals of these two languages and to how to use them to build complex solutions. We also offer bespoke training workshops that can be tailored to your specific training needs.