<img src="https://secure.leadforensics.com/133892.png" alt="" style="display:none;">

In the first post of this blog series on my experiences of working with Power BI, I wanted to share a real-life story of a customer in the manufacturing sector.

Introducing the BI bottleneck

We recently worked with a customer that manufactures plastic products. They had difficulty monitoring their labour utilisation and wanted to improve their reporting in this area.

To stay competitive and innovative, the company undertook an initiative to better serve its business users by improving its BI. Using Power BI, they were able to eliminate a bottleneck in the finance department.

The company chose to implement Dynamics 365 Customer Engagement. Part of the reason they selected this solution was because of the excellent reporting capabilities provided by the Microsoft platform.

Disparate data was causing production delays, prone to manual errors and lack of real-time information

Previously, the finance department had to manage multiple data extracts from several systems and then manually create excel reports.

This was a strenuous and onerous task for the team which involved manual manipulation of the data. The amount of time required to pull the report together meant that the service team struggled to have timely access to this key management information.

The knock-on effect of this was that workload was not been efficiently balanced, resulting in delays to production. The manual element of this task also meant that the report was prone to error.

Performing the task in Excel meant they were missing the capabilities to transform and merge data easily from multiple sources in a trusted and repeatable way. Therefore, they could provide only a fraction of the data that users needed.impact of disparate systems

Key managers didn’t trust the reports as various Excel workbooks had different interpretations of the same data and it was difficult to find the most up-to-date version. This led to unproductive and time-consuming report creation and challenges around local variations of report.

Keeping track of report alterations and making sure users were working with current data was nearly impossible.

The solution…

They approached Columbus for assistance in building a solution to address this key business issue.

After some quick analysis of the task at hand by our Technical Solutions Architect Martyn Bostock, we designed a solution using the features of Power BI to ingest data into a standardized model. I spent a day working with the provided requirement and we consolidated the data into the common data service.

Once that was done, the task of creating the labour utilisation report was very simple.

Microsoft Power BI gives the service team unprecedented insight into their resources, how they’re allocated and how that affects planned jobs. This report refreshes eight times a day so they have access to real-time information on the utilisation of their employees.

They now use detailed dashboards and customisable reports in Power BI to better understand the data behind resource allocation.

Benefits of BI for manufacturingPhoto by NESA by Makers

What the solution helped achieve

Just creating this single report saved them 15 hours each month and there are other reports due to be built in the pipeline. If one report saved them 15 hours each month, you can only imagine how much time the finance team will be saving once we are done with the other reports.

Following a two-day training session, they plan to use the same data model to securely enable self-service reporting for the wider business. The finance team can now concentrate on their daily task without intrusion from people asking them to build the labour utilisation report.

Discover the power of real-time analytics with Power BI

If you have similar problems and you’d like to know how Columbus could help you with your analytics needs, reach out to us today.

Contact us

Topics

Discuss this post

Recommended posts

The hype around the rise of generative AI technologies makes huge promises about the potential of the technology. Yet it would be fair to say the majority of organisations are only experimenting with the technology or using it in isolated use cases.
If you organise your data and use AI strategically, you can make better decisions faster. You can for example improve your market understanding and forecasting, optimise your maintenance or reduce food waste. Choose what is most important for you!
Demand forecasters do the impossible — predict what products and services customers want in the future. Their forecasts inform decision-making about production and inventory levels, pricing, budgeting, hiring and more. "While crystal balls remain imaginary, machine learning (ML) methods can give global supply chain leaders the support they need in the real world to create more accurate forecasts." The goal is to produce exactly the amount of product to meet demand. No more. No less. Demand forecasting is used to anticipate the demand with enough time to manufacture the right stock to get as close to this reality as possible. The cost is high if you don’t get it right. Your customers will go to your competitors if you don’t have what they need. Unfortunately, capacity, demand and cost aren’t always known parameters. Variations in demand, supplies, transportation, lead times and more create uncertainties. Ultimately demand uncertainties greatly influence supply chain performance with widespread effects on production scheduling, inventory planning and transportation. On the heels of the global pandemic, supply chain disruptions and a pending economic downturn, many demand forecasters wish for a crystal ball. While crystal balls remain imaginary, machine learning (ML) methods can give global supply chain leaders the support they need in the real world to create more accurate forecasts.
If you have identified possible AI use cases for your business, the next step will be to test if they are possible to implement and if they will create great value. While there is a lot of momentum and excitement about using AI to propel your business, the reality is only 54% of AI projects are deployed. How do you ensure you’re one of the businesses that does unlock the new opportunities AI promises? Your success with AI begins by discovering AI use cases that work for your business. In the first blog of our Columbus AI blog series, we shared five areas where organisations should focus their efforts to generate ideas for AI implementations based on our experience. After generating some ideas for AI use cases that could potentially benefit your company from the first step of the Columbus AI Innovation Lab, the next step is to test which AI use cases could be operationalised by evaluating them. Columbus AI Innovation Lab
Only half of the companies starting an AI pilot project are actually executing it. The key is to choose an idea that will benefit your business. Read more about how! In 2022, 27% of chief information officers confirmed they deployed artificial intelligence (AI), according to a Gartner AI survey. Even though businesses across all industries are turning to AI and machine learning, prepare your organisation before jumping on the AI bandwagon by considering a few factors. Ask yourself: Is AI necessary for achieving the project requirements or is there another way? Does your team have the skills to support AI and machine learning? How will AI impact your current operations if you adopt it? How will you integrate AI with existing systems? What are the data, security and infrastructure requirements of AI and machine learning? The Gartner AI survey found only 54% of projects made it from the pilot phase to production. After significant investment in AI, why aren’t companies deploying it? We found the problem begins when companies define a use case. Too often, companies are not identifying AI use cases that benefit their businesses and end-users will adopt. The question is then, how should companies unlock the value and new opportunities AI promises? It starts with a systematic approach for each stage of the AI life cycle. We developed the Columbus AI Innovation Lab, a comprehensive method to address and account for all challenges when adding AI to your business operations and bring stakeholders into the process at the right time to help you operationalise AI.
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down