Manufacturer Optimises Supply Chain Analytics With Azure Machine Learning Client Snapshot Profile This global manufacturer of batteries and portable lighting products had well-established, but manual, ocean freight shipping processes in place and was unable to nimbly respond to pricing spikes, increased scheduling lead-time and port backups caused by the COVID-19 pandemic. Client Situation The company was impacted by shipping and supply chain challenges during the pandemic resulting in stockouts at retail. Manual processes gave limited visibility to how the company could effectively predict future ocean freight cost increases . Work Performed Protiviti introduced Microsoft Azure machine learning solutions and provided predictive analytics training that gave the client control over its data and built 63 lane-specific, low-error predictive models that provided insights into future ocean freight cost trends and risks used for network optimisation. Outcome/Benefits The client significantly improved its ability to adapt to rapid changes in both processes and cost analyses. It also now has a robust data governance plan in place. This machine learning-based solution is considered the first of its kind in the industry. Pandemic-driven price spikes highlighted long-standing challengesWhen the COVID-19 pandemic struck in 2020, this global manufacturer of primary batteries and portable lighting products was among the many organisations impacted by shipping and supply chain challenges. Compounding the issue was the fact this client was using an Excel spreadsheet approach as its primary shipping cost analysis tool. While ocean freight costs and lead times had been steady prior to COVID, the pandemic drove increases in costs, which leapt up to 10 times prior charges, lead times, which jumped from three days to more than 15 days, significant port backups and complications with inland transportation . The client realised its previous method of tracking costs was not sustainable considering these rapid industry changes, had an immediate need to improve the accuracy of its ocean freight forecasting to understand the impacts to its business. This was not unusual for any consumer goods company; ocean freight had been so steady over so many years that this sudden increase impacted everyone.Initial assessmentAn initial analysis involved manually processing a considerable amount of data around hundreds of components including destination ports, types and sizes of shipping containers, etc., all Excel-based. Protiviti leveraged the Microsoft Azure platform to perform an initial cleaning and sterilising of all the data, with a goal of ensuring that every source and destination combination would be at a high level of accuracy. This would enable the client to operate with the confidence that its 30, 60, 90 day and beyond forecasts would be accurate as possible.Protiviti used Python within Azure to accomplish the bulk of the data ingestion, data cleansing, filtering and built preliminary models. Once a predictive model had been developed for each shipping lane, the team leveraged Microsoft Auto Machine Learning (ML), which allows for hyperparameter tuning, in which the Auto ML tool reviews algorithms and parameters within those algorithms to identify the best configurations for each model to maximise predictability. This was eye-opening as it enabled rapid automated analysis.Partnering with Protiviti to analyse the data, the client worked to standardise the nomenclature of its data. During that process, the company realised that data governance could be applied to other downstream processes to better define its shipping lanes while simultaneously improving container and unit definitions. This enabled the forecasting team to inform the downstream teams as to how to improve/cleanse their data for regular consumption and other data science activities.Introducing machine learning modelsFor this client, the immediate solution was to focus on its data and to build machine learning models that would look at data points to predict what costs would be going forward. Challenges going into the model building included:Not all data was availableUncertainty around which data should be consideredUncertainty around whether the models would predict any usable information towards reducing costsSignificant training required to support a new platform and data science methodologiesSupported by Protiviti’s predictive analytics experts, the client team built models around particular shipping lanes (for example, Shanghai to Los Angeles, which accounts for 50% of this company’s shipping). Using their own data plus industry-standard indices, they developed hypotheses on the components that could impact costs. There was much exploration into the data, as it had not been looked at in this way before. Each model was built and then trained to be more accurate with each iteration. The goal: no surprises while improving expense management and visibility. Transforming pricing predictive models using data science methodologies with Microsoft allowed this client to effectively manage data and respond to rapidly changing market conditions. Interactive training and hands-on model buildingOne of the additional challenges along the way was getting the client team familiar and comfortable with the Microsoft Azure platform, specifically the ML studio. At the client’s request, Protiviti and Microsoft shared best practices for maximising the platform while teaching the client team new data science methodologies. Considerable time was devoted to interactive training exercises where test models were built and evaluated as the team members learned what could be done differently to improve performance results. The secret to success was the hands-on model building and learning. Part of the data science process and methodology is being able to take some of those test models and understand what the models were saying from a predictability standpoint and why some models were more successful than others, then go back and massage the data again to improve results.A pioneer in the consumer goods industryThe ability to quickly respond to a shift in macro-economic business conditions highlights the power of their data programme. This problem that surfaced during and after the pandemic for everyone who ships goods – the deafferenting behavior is the ability to respond faster than competitors. The client team wanted to use their data more intelligently and introduce more modern methodologies to more accurately predict future ocean freight costs. This proved to be a game-changer as this company now regularly incorporates the building of machine learning-based models and predictive analytics, along with industry indices, to improve cost predictions. In doing so, this company aims to become a cost predictions leader in both the consumer goods and shipping industries.Moving from a rigid, manual approach to a more flexible and agile machine learning-based approach was a significant step for the organisation. Transforming its pricing predictive models using data science processes and methodologies allowed it to both manage data more effectively and respond nimbly to rapidly changing market conditions.Protiviti has become a strategic partner for this client. Our predictive analytics team was able to teach critical aspects of data science methodologies, explaining the “why” behind each step of the model building process. Working meetings became brainstorming sessions where teams review test results and learn how analytics contributed to the test’s conclusions, helping grow advanced analytics capabilities. This new way of doing business is now an established part of the client’s daily operations.Impact by the Numbers: 63Lane-specific models developed 30% or lessErrors found in those lane-specific models 64%Percentage of CH Robinson spend represented in the models Topics IT Management, Applications and Transformation Data, Analytics and Business Intelligence Digital Transformation We recommend these resources Pro Document Consent Microsoft Consulting Solutions As the 2023 Microsoft Compliance and Privacy Trailblazer recognised by the Microsoft Intelligent Security Association, Protiviti provides innovative solutions built on a core foundation of security, data and modernisation. Pro Briefcase Emerging Technologies Protiviti’s cloud services and Emerging Technologies team help organisations embrace new technologies to support business strategies, optimise business processes, and mine data to bring new solutions to market and gain a competitive advantage. Pro System Security Technology Consulting Services Whether you are looking to automate, modernise, or embark on an end-to-end transformation journey, our technology consulting solutions can help. Our services range from strategy, design, and development through implementation, risk management, and managed services. Featured insights BLOGS Building a Business Case for Copilot for Microsoft 365 – A Game-Changer for Business Efficiency With the rapid rise in artificial intelligence (AI) tools, companies are updating technologies and processes as quickly as budgets allow. Industries are transforming rapidly as the drivers for economic growth are evolving. BLOGS Improving Financial Services’ Efficiency with Copilot for Microsoft 365 In an era of rapid technological advancement, businesses are increasingly turning to artificial intelligence (AI) to enhance productivity, streamline processes and improve decision-making. One such tool making waves in the financial services sector... BLOGS Unlocking Agile Insights: Building Automated Burndown Charts with Microsoft DevOps Analytics View and Power BI In the fast-paced world of software development, staying ahead of the curve requires more than just coding prowess. Agile methodologies have emerged to provide a structured framework for teams to navigate the ever-changing landscape. BLOGS Building an Accessibility Culture with Copilot for Microsoft 365 Organisations across the U.S. recognise the criticality of accessibility for both consumers and employees. This concern dates to the early 2000s, when several well-known brands were targeted by lawsuits that ultimately changed how e-commerce works.... BLOGS Cloud synergy: Microsoft Azure and its relationship to Microsoft 365 As organisations increasingly embrace cloud-based technologies to enhance productivity and efficiency, understanding the dynamic relationship between Microsoft Azure and Microsoft 365 becomes crucial for maximising their potential. With the power of... BLOGS Microsoft SharePoint Premium simplifies content management and governance Content management involves the creation, organisation, storage and distribution of digital content within an organisation, ranging from documents and images to videos and web pages. One of the biggest problems businesses face with content management... BLOGS 9 common errors to avoid while implementing security in Microsoft Dynamics 365 Finance and Operations Microsoft Dynamics 365 Finance and Operations (D365FO) is a comprehensive ERP solution that empowers businesses to optimise financial management and operational efficiency. With its integrated approach, powerful analytics, scalability and continuous... BLOGS Navigating the GenAI course with Microsoft Copilot Generative artificial intelligence (GenAI) is a hot topic these days, and not just in the IT world. The statistics indicate off-the-charts interest in GenAI’s capabilities, with AI spending predicted to more than double to $300 billion by 2026.... BLOGS Azure DevOps: 3 tips to organise work items using standard functionality To effectively manage software development projects, it’s crucial to organise work items efficiently. Proper organisation not only boosts productivity but also enhances collaboration among team members. Microsoft Azure DevOps (ADO) is a powerful... BLOGS Capabilities, limitations of Microsoft’s native SoD tool Segregation of duties (SoD) is a well-known term among auditors and anyone who has ever been audited. SoD is the understanding that no user should have access to two conflicting business functions that would allow a user to commit fraud or error (e.g... BLOGS Creating Read-Only Roles for Microsoft Dynamics 365 Finance and Supply Chain Management In today’s fast-paced business landscape, organisations rely heavily on robust enterprise resource planning (ERP) systems like Microsoft Dynamics 365 Finance and Supply Chain Management to streamline operations and drive growth. However, granting... BLOGS Migrating Security from Microsoft Dynamics 365 Finance and Supply Chain Management This blog post was authored byJulia Artzi - Consultant, Sarah Guthrie - Senior Consultant, Enterprise Application Solutions onThe Technology Insights Blog. MicrosoftDynamics 365 Finance and Supply Chain Management (D365 F&SCM... Button Button Featured client stories Global Hospitality Company Achieves Efficiencies with Microsoft and Nintex A global hospitality company needed to transition their highly manual process for RFPs to one that was more automated. The need to update their processes was driven by the changes required to address the Covid-19 pandemic, which created a dynamic... Global Retailer Goes Digital: Revitalising Store Operations and Enhancing Community Commitment Protiviti leveraged Microsoft Power BI to help this client transform its operational analytics. We built a user interface that generates analytics every 15 minutes and is easy to use with little training required. From staffing and sales targets to... Intelligent Document Retrieval System, Powered by Responsible AI, Helps Reduce Air Pollution Empower your engineers with responsible AI for efficient air pollution reduction. Our AI solution saves time, money, and reduces manual labor. Global Health Services Company Modernises Data and Applications with Microsoft A global health services company needed to execute on its corporate promise to deliver affordability and convenience to its patients. However, the company discovered that there was a disconnect between that promise and intended delivery. Further... Button Button