Portfolio Data Analyst
Working within the New Product Introduction (NPI) governance team as a portfolio data analyst where I:Helped develop a new PowerBI dashboard for the NPI team, integrating Python for data cleansing and automating data extraction and visualisation processes. I also used Python to improve forecasting of phase review data to provide better understanding of how the KeyedIN system is being used. Increased automation of visuals by using creative solutions. Reduced the time taken to… Show more Working within the New Product Introduction (NPI) governance team as a portfolio data analyst where I:Helped develop a new PowerBI dashboard for the NPI team, integrating Python for data cleansing and automating data extraction and visualisation processes. I also used Python to improve forecasting of phase review data to provide better understanding of how the KeyedIN system is being used. Increased automation of visuals by using creative solutions. Reduced the time taken to create one dot matrix visual by over 1000% and improved its accuracy by 8%.Collaborated with key stakeholders (project managers and portfolio manager) presenting findings to the team and suggesting improvements whilst ensuring alignment with their needs. Identified and corrected data entry errors by meeting with Project Managers, leading to the implementation of a more efficient data entry system. Explored implementing a PowerApp to compliment the PowerBI dashboard to improve the identification and visualisation of key issues raised by project managers. Engaged with various departments including Strategy, Data Engineering, Government Affairs, Project & Portfolio Management, Procurement, Account Development, and Scientific Research, to learn more about the role of the company in Britain's science and innovation sector and to gain insights into the future of this industry. Show less