Millicent Leechi | Data Analyst

Millicent Leechi

Data Analyst

Based in Port-Harcourt, Nigeria

About

I am a dedicated and analytical professional with a background in nursing and a passion for data analytics. With a Bachelor of Science in Nursing and a diploma in Data Analytics, I have developed a unique skill set that combines healthcare expertise with data-driven decision-making. Through my training, I have gained proficiency in various data analysis tools, including Excel, SQL, PowerBI and Tableau. My experience includes internships where I collected, cleaned, and data to identify trends and provide actionable insights that drive business improvements. I am particularly adept at creating visualizations and reports that communicate complex data in an accessible manner, supporting stakeholders in making informed decisions.

Skills

Projects

Pizza Jungle Sales 2014

Shows the Dashboard for the Pizza jungle sales 2014, showing the total revenue generated, best month of the year, the best quarter of the year, the best pizza type of the year 2014, the topmost and bestselling branch, and the top order number. This will aid stakeholders in decision making process.

Wattpad bestseller novels 2009-2019

Shows a dashboard of the wattpad bestseller novels year 2009-2019, indicating total sales, best year's worth, best genre, book with the best review, bottom user rating and top author. This dashboard aids novelists, and wattpad directors in better decision making, for better user experience.

Milly&Co Automobile sales 1996-2019

A data visualization done, to enhance stakeholders in proper decision making concerning automobiles purchase from manufacturers. This dashboard indicates total sales made, year 1996-2019,best fuel type, best engine size, best year of sale, best car model, best car type and best transmission type.

Megastores Sales 2014 in PowerBI

Analysis done on Megastores sales using PowerBI to show some KPIs; total revenue for 2014, sales rep of the year, best product category, best region, and count of shipping. This aids Stakeholders in taking better informed decisions for enhanced productive sales for the subsequent years to come.

Forbes' Billionaires list 2021 in PowerBI

A dashboard created during analysis of Forbes' billionaires in the year 2021, using PowerBI, indicating the top billionaire, top billionaire country of origin, top residence city, youngest billionaire. It also indicated their various sources of income and networth.

World Universities Annual Report 1900-2021

Analysis of the World universities. From the analysis, I found out that Harvard university leads as the top university both in national & international ranking with awards as one of the best throughout the years 1900-2021, followed by Stanford University with the least ranking being Emory University

Megastores Sales 2014 in Tableau

Analysis done on megastores using Tableau, I deduced from this analysis the total sum of revenue generated throughout the year 2014 ($435,036.16K), the total quantity of products sold (20,592). I was also able to find out the bestselling region (North), the top (NewYork), and top product.

Forbes' Billionaires list 2021 in Tableau

Replicated analysis on the Forbes' billionaire list 2021, Using Tableau, indicating the richest billionaire (Jeff Bezos), the total number of billionaire children (4,622), top billionaire country (China, with 873,606 residency), major marital status (Married), and top source of income (Real estate).

Fendi Sales Report Dashboard

A Dashboard, showing the Fendi sales report between the years 2014 & 2016. SQL was used to clean and analyze the existing data, and imported into Excel for enablement of data visualization, to share with stakeholders on the report of sales of existing products within the given time interval.

Global Superstores Sales Report Dashboard 2011-2015

Global Superstore Is a Global Online Retailer Based In New York, Boasting A Broad Product Catalogue and Aiming to Be a One-stop-shop For Its Customers. Global The Superstore’s Clientele, Hailing From 147 Different Countries, United States as the most profitable country with a profit of $93,507.

Experience

March 2024 - August 2024

Data Analyst Intern

I collected, cleaned, and analyzed datasets, identifying trends to optimize business processes. Also, I created visual dashboards and reports using SQL and Tableau for stakeholders. I was also able to utilize Excel to generate actionable insights, leading to improved decision-making processes.

Education

July 2023 - April 2024

Diploma in Data Analytics

My journey into the world of data analytics began with a diploma program that equipped me with essential skills and knowledge to interpret complex datasets and derive actionable insights. The program spanned from July 2023 to April 2024 and was designed to provide a comprehensive foundation in data analysis, statistical methods, and visualization techniques. Key Areas of Focus: 1. Data Collection and Cleaning: • Learned methodologies for sourcing data from various platforms and ensuring its accuracy and completeness. • Developed skills in data preprocessing, including handling missing values, outlier detection, and data transformation to prepare datasets for analysis. 2. Statistical Analysis: • Gained proficiency in statistical methods, enabling me to understand data distributions.