Paul Clement

• Developing and implementing cross-title measurement strategies • Organizing, cleaning, and analyzing large-scale media datasets • Interpreting results from multi-touch attribution and marketing mix models • Visualizing ad spend data to support decision-making • Collaborating with internal teams and external agencies to enhance measurement • Ensuring data integrity, taxonomy setup, and platform alignment • Supporting ad hoc analytics projects and maintaining process documentation • A/B testing analysis of audience and targeting performance

I help businesses turn raw data into powerful, easy-to-understand dashboards and reports. From startups to growing companies, I bring clarity to data using tools like Excel, Power BI, SQL, and Python. What I Do: Excel & Google Sheets: Data cleaning, automation with formulas/macros (VBA), pivot tables, and custom dashboards. Power BI: Build interactive dashboards, connect multiple data sources (Excel, SQL, APIs), and publish reports to the Power BI Service. SQL & Python: Write optimized queries, automate ETL workflows, and perform in-depth data analysis and visualization. PowerPoint: Create compelling data presentations, branded templates, and interactive slides for meetings and pitches. I work closely with clients to understand their needs and build solutions that are both visually engaging and strategically useful. Whether it's sales performance, financial trends, or operational KPIs—I design dashboards that help teams make smarter, data-driven decisions.

● Collecting necessary data from various sources, such as databases, CSV files... ● Ensuring the data is complete, accurate, and up to date. Handling missing values, duplicates, and errors. Transforming the data if necessary to make it usable. Converting the data into a suitable format for analysis and visualization ● Conducting data analyses and providing initial recommendations that could increase campaign results to the marketing team. ● Participate in the creation of excel models to measure the carbon footprint of multi-media marketing campaigns (Defining KPIs, identifying data sources) ● Creating data visualizations and managing dashboards for reporting, improving decision-making speed. ● Translating complex data insights into clear and accessible presentations for internal teams (sales and planning) and clients, ensuring informed decision-making and effective campaign strategies. ● Performing audience segmentation and analysis using a proprietary panel and industry-standard tools such as Nielsen, Kantar, YouGov and Médiamétrie, enabling deeper insights into consumer behavior and optimizing targeting strategies. ● Creation of automated Excel templates with reports and data organization (formulas + VBA). ● CCS Panel expert/M1

● Developing interactive visualizations and dashboards, streamlining reporting processes and reducing time spent on data analysis. ● Leader in the migration of data tools to ensure a seamless transition and maintain data integrity. ● Automated data output processes, which improved efficiency and accuracy, saving approximately 10 hours per week (using data from a panel of respondents in a proprietary Dentsu study on socio-demographic and media consumption questions). ● Conducted qualitative and quantitative studies, providing insights that informed strategic marketing decisions. ● Translating complex data insights into clear and accessible presentations for internal teams (sales and planning) and clients, ensuring informed decision-making and effective campaign strategies. ● Performing audience segmentation and analysis using a proprietary panel and industry-standard tools such as Nielsen, Kantar, and Médiamétrie, enabling deeper insights into consumer behavior and optimizing targeting strategies.

● Use of excel for data analysis and visualization, creating reports that helped track key performance indicators. ● Conducted social listening to gather insights on market trends and consumer sentiment, influencing campaign strategies. (Talkwalker, kolsquare) ● Developed and presented data visualizations that supported marketing recommendations.

Dans le cadre d'une bourse aux projets : Création d'un portfolio (respectant les critères des Awwwards) visant à augmenter la visibilité de DeVinci Junior auprès des ETI

Stage

Job saisonnier

Le double diplôme Digital Marketing & Data Analytics, filière commune à l’EMLV (École de Management Léonard de Vinci) et l’IIM forme des professionnels formés aux spécificités du numérique, des nouveaux modes de consommation et des stratégies cross canal intégrant les spécificités du digital. Le double diplôme permet d’acquérir les bases techniques du web et de devenir un manager capable de comprendre et d’analyser toutes les problématiques, à la fois stratégiques et techniques. Les diplômés travaillent dans le secteur du marketing digital quel que soit le secteur de l’économie ou intègrent des services marketing spécialisés dans l’analyse des data.