El Mahdi Oukira

During my internship as a Data Analyst at Marocmétrie, I was responsible for processing and analyzing data collected from a representative sample of Moroccan households using specialized audience measurement devices known as audimeters. My key responsibilities included:

• Data Processing and Cleaning: Utilized Python and SQL to process and clean large XML datasets collected from audimeters, ensuring data accuracy and consistency.
• Profile Development: Employed data mining techniques to extract relevant information and create comprehensive viewer profiles, facilitating detailed audience analysis.
• Data Organization and Visualization: Leveraged Microsoft Excel and Tableau to organize data into structured formats and develop interactive dashboards, enhancing data readability and visualization.
• Reporting and Presentation: Prepared detailed reports and delivered presentations using Microsoft PowerPoint, summarizing key insights and trends to inform decision-making processes.

This experience honed my skills in data analysis, data visualization, and reporting, enabling me to contribute effectively to data-driven decision-making processes.