Data Transformation and Visualization in Engineering using 3 Key Solution Products

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

CLIENT SUCCESS STORY

Company Highlights

Region: USA

Sector: Industrials

Industry: Capital Goods

Division: Operations

Solution Technologies: Matillion, Microsoft Power BI,
Power Automate, Azure, Snowflake

Solution Products: Matillion, Microsoft Power BI, Snowflake

Solution Service Type: Project

 

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

Our engineering client has been manufacturing shotshell reloaders under the current brand since 1955. They used the data transformation capabilities of Matillion combined with the superior visualizations of Power BI to create dashboards to measure efficiency, delivery, margins, and safety data of their products. External data sources for payroll and plant safety data loaded directly to Azure BLOB storage using Power Automate.

 

C H A L L E N G E

They needed one set of dashboards to help them better measure the effectiveness and profitability of their manufacturing process.
Pomerol Partners provided a set of dashboards that measure margin, delivery, sales, effectiveness as well as safety data to provide a clear picture of their operations. Before these dashboards were built, this company had to rely on spreadsheets, flat files, and disparate data sources to attempt to understand
their day-to-day metrics. The metrics were always out of date due to the difficult process to compile them.

 

S O L U T I O N

Pomerol Partners built a clear and concise set of dashboard visualizations to help our engineering client better understand current position and profitability. The Power BI dashboards were supported by Matillion and its inherit ability to move, clean, transform, and provision the data needed for accurate reporting. External data sources from ADP and plant safety providers were integrated loaded to Azure BLOB storage using Microsoft Power
Automate. Power Automate was also used to convert legacy files to usable formats. The data was then transformed and provisioned to Snowflake by Matillion.

 

R E S U L T

Feedback from management team extremely positive. Dashboards are being used on a daily basis by the CEO and other members of leadership team. Due to positive reception, Pomerol Partners will be expanding the project to build inventory metrics dashboards

 

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.