Skip to content

Miickka/portfolio

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

29 Commits
 
 
 
 
 
 

Repository files navigation

Journalist turned data analyst with a background in digital communication and marketing

Skills: Digital Communication (community Management, Social Listening, Digital Marketing), Data Analysis (Python, SQL, R, Power BI, Tableau), Graphic Design (Adobe InDesign, Photoshop, Illustrator, Canva), Web Content Management (HTML/CSS, WordPress, SEO), Video Editing (Adobe Premiere Pro), AI Tools (Content automation, analysis, and optimization via AI)

Work Experience

Head of digital communication @ nile (November 2021 - Present) Digital Strategy: Since 2021, as a Digital Relations Manager, I have increased my agency's LinkedIn page followers by over 110% (from 1,583 to more than 3,330) through a 100% organic strategy. Between June 2023 and February 2025, I generated over 165,000 impressions and increased the engagement rate from 5% to 11.8%, by optimizing content based on the algorithm and fostering active community interaction. I also manage 10 other pages for our coalitions and clients, including France for One Health (43,430 impressions in the last 12 months and over 300 new followers since December 2024) and A-Grippe-Toi, created in October 2024, which has already reached 37,656 impressions and 857 reactions with 729 followers. I also manage the agency's X (Twitter) and Facebook pages.

Data Analysis: Analyzing the performance of digital campaigns, identifying improvement opportunities, and transforming data into strategic insights. Developing data analysis reports to facilitate strategic decision-making.

Website Management: Managing the agency's website and creating/managing 9 websites for our coalitions and clients. Links :

Newsletter: Managing and designing regular newsletters for a database of 8,000 contacts. Processing event participant data, analyzing campaign performance, and continuously optimizing engagement and impact.

Content Creation: Designing visuals, layouts, and logos.

Journalist @ Radio CBN (August 2018 - July 2020)

Journalist @ Radio BandNews FM (December 2012 - July 2018)


Projects

Python

Datacamp Professional Certificate Case study: Pens and Printers

Check the repository

In this pratical exam, I must act as a Data Analyst and perform an analysis for "Pens and Printers" and analyse 15 000 rows of data in order to answer the business question. It is expected a Written Report and a video presentation up to 10 minutes long. The analysis of sales data from Pens and Printers shows that the Email method is the most efficient, generating 53% of total revenue and engaging 50% of customers, while the Call method lags with only 17% revenue contribution. The Email + Call method has shown growth potential, with the highest revenue per customer (RPC) at $183.63. The company should prioritize Email marketing, reduce resources allocated to Call strategies, and regularly monitor the RPC metric.

Google Data Analytics Professional Certificate Case study: How does a bike-share navigate speedy success?

Check the repository

In this case study, I am a junior data analyst working for a fictional company, Cyclistic, based in Chicago (USA). I was assigned with the question to answer: How do annual members and casual riders use Cyclistic bikes differently? After downloading the previous 12 months of data*, I merged everything into a single .csv file containing more than 6 million rows. In order to answer the business question, I've followed the data analysis process: Ask, Prepare, Process, Analyze, Share, and Act. The analysis revealed that annual members accounted for 63.5% of rides, with casual riders making up 35.5%. Casual riders averaged 21 minutes per ride, while annual members averaged 12 minutes. A seasonal trend showed peak usage in summer, with casual ridership tripling during this time. Annual members rode consistently year-round, suggesting commuting use. Casual members rode more on weekends, while annual members favored weekdays. Recommendations include promoting summer memberships, offering seasonal discounts, and targeting casual riders with loyalty programs and email campaigns.

Python for Journalists

Scrap data - Check the repository Clean data - Check the repository Analysis - Check the reposiroty

The course Python for Journalists offered by European Journalism Centre is meant for journalists looking to learn the most common uses of Python for data journalism. In this module, we used Beautiful soup to scrap data and Pandas to both clean and annalyze the dataset.

SQL (mySQL Workbench)

Measuring the performance of a LinkedIn's page

Check the repository

The main objective of this script is to analyze the data from a company’s LinkedIn page from June 2023 to June 2023. All data present here was exported directed from LinkedIn platform, resulting in 6 different tables. The company's name was ommited for security reasons.

List of French deputies in the field of health

Check the repository

Data on all the members of the National Assembly in 2024 before the dissolution by Emmanuel Macron on June 9, 2024. The aim was to explore the data provided by the National Assembly to better target parliamentarians in the field of health.

Data cleaning and analysis using MySQL (Layoffs)

Check the repository

This script is the result of an online course by @AlexTheAnalyst in which I could explore the data of layoffs around the world in the recent pas years. I had the opportunity to first clean the dataset (removing the duplicates, standardiinge the data, checking for Null values or blank values, and removing any columns or rows). After that, I started an exploratory analysis.

Education

  • Exam PL-300: Microsoft Power BI Data Analyst (En cours)
  • Datacamp Professional Certificate | Datacamp (2024)
  • Google Data Analytics Professional Certificate | Google (2024)
  • Master degree in Digital Communication and Data Analysis | Sorbonne Nouvelle Université - Paris III (2022)
  • Master degree in Communication | Federal University of Minas Gerais (2019)
  • Bachelor degree in Journalism | Federal University of Ouro Preto (2013)

Releases

No releases published

Packages

 
 
 

Contributors