Introduction: The project was undertaken as part of the Deloitte InsightStudio team, which combines design thinking, agile methodology, and cutting-edge technology to create custom technology solutions for clients. The goal was to automate reporting on advertising spend and perform statistical analysis to rationalize spending across regions and media markets for a major auto manufacturer.
Scope and Role: As product manager, I led a team of five to develop a data model, create a usable MVP, and collaborate with the client to set the project direction. The project began as a proof of concept, which was later expanded to include more data migration and a revamp of the client's use of databases.
Approach and Challenges: The project involved consolidating data from dozens of various spreadsheets and incorporating data from non-relational databases. The team used data modeling and regression analysis to compare the effectiveness of different types of marketing spend.
Results and Outcomes: The project led to significant improvements in data management and efficiency in consolidating data. The team also created a proof of concept for a data visualization capability using SAP BusinessObjects. The project positioned the client for digital transformation and strong data management practices in their marketing department.
Communications and Collaboration: I communicated and collaborated with team members and stakeholders through daily stand-ups, weekly status reports, and regular meetings with the client. We used tools such as Slack, email, and SharePoint for communication and collaboration.
Lessons Learned: Through this project, I gained experience in large-scale data management, product management, data modeling, data visualization, agile methodologies, and design thinking. These skills can be applied to other projects and contexts.