Case Studies  

Visualizing Data for Industrial Operations – Part 1

Todd Bailey - Principal Consultant, Umar Ali - Data Consultant, Connor Reffell - Senior Consultant

03 June 2022

The initiative was to create dashboards to measure efficiency, delivery, margins, and safety data.

CLIENT SUCCESS STORY

Company Highlights

Region: USA

Sector: Industrials

Industry: Capital Goods

Division: Operations

Solution Technologies: Matillion, Microsoft, Snowflake

Solution Products: Matillion, Microsoft Power BI, Snowflake

Solution Service Type: Project

 

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

In this client success story, we review how Pomerol is helping a leading U.S.-based contract manufacturer by leveraging the data transformation capabilities of Matillion combined with the superior visualizations of Power BI. The initiative was to create dashboards to measure efficiency, delivery, margins, and safety data.

 

C H A L L E N G E S

This employee-owned company 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.

 

S O L U T I O N

Pomerol Partners built a clear and concise set of dashboard visualizations to help this client better understand current position and profitability. Here are a few examples of what we are currently working on:

  • Togglable “Run and Setup” button for Run Efficiency with -Total Earned Hours is based off Month_Year Data
  • Bottom 10 Suppliers MTD (More than 3 POs – which counts the PO’s instead of a distinct count
  • YTD and MTD Margin by Division / Customer
  • Top 10 Suppliers by Spend MTD ranked by late PO%
  • Supplier Delivery %
  • Supplier Delivery % by Plant
  • YTD and MTD Sales by Division / Customer. Created a custom run rate formula for working days
  • Tabs include TCIR, Customer Delivery, Efficiency, Margins, Supplier Delivery, Sales
  • Scatter plot for Supplier Delivery % by Plant comparing Total POs to Late POs

The Power BI dashboards were supported by Matillion and its inherit ability to move, clean, transform, and provision the data needed for accurate reporting.

 

R E S U L T

This has not been put into production yet. Stay tuned for Part 2, coming in July.

 

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.

 

 

 

 


MORE INSIGHT