Harry Cook

Integrating Power BI into Planning

Siemens Healthineers - Sudbury Employee Stories - Harry Cook

Rising star apprentice given the skills and support to build their own tool, saving the company time and money. All whilst developing their own confidence and opportunity to represent their initiative from stand to finish, and beyond.

My name is Harry Cook, and I started my apprenticeship journey with Siemens Healthineers in September 2020 as a Supply Chain apprentice. I am really enjoying my current role which entails managing a selection of suppliers and ordering in-line with production demand. I have also been studying for CIPS (Chartered Institute of Procurement and Supply) qualifications.

Through reviewing the reports my department use on a day-to-day basis, I noticed a gap in our processes in that we are unable to accurately review our data/trends etc. This meant we were potentially missing out on risks or opportunities to improve metric results, vital signs that we were trending in the wrong direction with specific vendors or metrics and ultimately impacting my department/businesses performance.

I spent time learning from scratch alongside the help of Chris Roe how to effectively use this tool. I then worked to put these skills into practice and produce a Power BI planning dashboard, which is a data analytics tool accessed via your web browser. It pulls data from our current Excel daily reports, analyses the data, and provides valuable visuals which can be filtered per user/vendor/etc.

This provides a tool which is a far cry from the pre-existing graphs in the excel reports, it is much more user-friendly and easier to access. It also means all of our data is in one central location which is another example of a time/cost saving, whereby stakeholders don’t need to sort through computer files and excel tabs to find our metric data, it is all collated onto one site.

Going back to the beginning of my apprenticeship journey, I initially lacked confidence and experience in presenting, this is something I found daunting and would try to avoid. I was introduced to the apprentice presentation skills program onsite which is run by Linda Cummings, Head of Operations. Within this project I was able to present to a group of people on a specific topic and allow me to improve my presentation skills and experience. As a result of the skills this program has given me, I was able to confidently present my Power BI idea to the Leadership Team and gain their thoughts and feedback.

My next steps on this project will be to implement further reports, alongside the help of the Planning team. I will then be looking to see where we can link our data straight into SAP, eliminating the need for manual input. This will mean reports will not need to be run separately and will provide a time/cost saving to the department.