Improving Decision Making And Increasing Productivity With Product Reporting Analytics
Spellman is the world's leading independent supplier of precision DC high voltage power supplies, X-Ray generators and Monoblock® X-Ray sources for medical, industrial and scientific applications. They work with customers to create customized supplies to best suit each individual company’s needs. They are headquartered in New York with locations internationally.
CHALLENGES
Spellman was looking to better manage the investments made in in-stock inventory across all manufacturing, distribution, and servicing locations around the world. The senior management did not have a dynamic global view and inventory trends across months. Procurement leaders were looking for accurate forecasting and the supply chain group was looking to track on-time delivery.
Spellman had an ERP system to manage inventory, however, there was no dynamic reporting and analytical system. Managing the business expectations was not possible using manual and static reporting. The best approach was for Spellman to consolidate the data, improve data quality issues, apply various regional cost calculation computations, and create the global view in USD. Overall, Spellman was looking to enable a dynamic, self-service reporting.
OUR SOLUTION
◽️ Motifworks helped Spellman build a data platform in Azure. Motifworks created a global view of inventory data across all locations using Azure Synapse Analytics.
◽️ The Azure platform and Data Factory could ingest data and apply various scrubbing and cleansing routines to create a certified data view.
◽️ By using Azure Analysis Services, Motifworks created various aggregates and hierarchical structures needed for dynamic view across time and other dimensions.
◽️ Finally, Power BI was used as visualization and information delivery portal where stakeholders across the organization were able to create and consume reports seamlessly.
◽️ The inventory warehouse paved the foundation for the data platform for other business functions.
◽️ The Azure platform allowed the flexibility to scale the solution without upfront investments. This solution was time saving, cost effective, and valuable.
I was impressed with their ability to gain an understanding of our business logic. They are thorough and asked good, pointed, questions about our content and business objectives.
–Joseph Terrano, Director of ERP Systems
Company Name
SPELLMAN
Type of Business
Manufacturing Electrical Equipment
Location
New York, USA
RESULTS
The solution provided dynamic self-service reporting and enabled information at everyone’s fingertip.
