Jacob Byrne Email & Phone Number

London, Gb

London, England, United Kingdom

Remote - London

During my internship at Expedia Group, I worked in the Capital Allocation Analytics team within the Marketing Optimization organisation.The main aim of my internship project was to create and plan for the implementation a new way of measuring Customer Lifetime Value (CLV), which gave me the chance to:- Use SQL for querying large databases efficiently, including working with existing queries and creating my own- Use R and Python for more detailed analysis and… Show more During my internship at Expedia Group, I worked in the Capital Allocation Analytics team within the Marketing Optimization organisation.The main aim of my internship project was to create and plan for the implementation a new way of measuring Customer Lifetime Value (CLV), which gave me the chance to:- Use SQL for querying large databases efficiently, including working with existing queries and creating my own- Use R and Python for more detailed analysis and visualisation of CLV - Analyse how the implementation of the new CLV measure would affect different areas of the EG business, including changing incentives for business decisions- Create a live Tableau dashboard that provides updates on CLV and new customers on a weekly basis- Present my findings to a variety of audiences, with different objectives, from summarising my project, to giving my recommendations on how to implement the new CLV measure- Collaborate with stakeholders to help them understand our current CLV measures at a more granular level Show less