Data Analyst

Welcome to my Data Analyst portfolio! Here you will find an overview of my education, work experience, skills, and projects. I am passionate about leveraging data to drive business insights and decision-making.

Technical Skills

Languages
Tools
Frameworks
Platforms

Projects

Customer Mall Segmentation Analysis using K-Means Clustering

Project Description: Conducted customer segmentation analysis using K-Means clustering on mall customer data, focusing on annual income and spending scores to identify distinct customer groups. Analyzed and visualized customer segments to provide actionable insights for targeted marketing strategies and optimized tenant mixes. Hypothetically identified five customer segments, including high-spending affluents and budget-conscious shoppers. Estimated potential improvements such as a 20% increase in marketing campaign efficiency and a 15% boost in sales based on targeted strategies derived from the analysis. View Project

Skills Used: Python, Pandas, Matplotlib, K-Means Clustering, Data Analysis

Elbow Point Graph	Customer Groups

Pizza Sales Power BI Visualization

Project Description: Explored a comprehensive dataset encompassing pizza order details. Addressed key questions on total revenue, average order value, and pizza sales trends. Utilized data cleaning, transformation, and visualization techniques to derive insights and create an informative Power BI dashboard. View Project

Skills Used: Power BI, Data Cleaning, Data Transformation, Data Visualization, Data Analysis.

Executive Dashboard	Sales Performance

Electronic Store Sales Analysis using Python

Project Description: Performed data analysis on a dataset of 186,850 entries and 6 columns. Applied data cleaning and transformation techniques to extract key insights on sales performance, customer behavior, and product popularity. Visualized the results using Pandas and Matplotlib, and compiled a detailed report. Identified top-performing products and peak sales periods, which informed inventory management and marketing strategies. View Project

Skills Used: Python, Pandas, Matplotlib, Data Cleaning, Data Analysis

Quantity Ordered	Quantity Ordered with Average Price

Pizza Sales Analysis using MSSQL

Project Description: Analyzed a Pizza Sales dataset containing 48,620 rows and 12 columns using SQL. Employed data cleaning techniques to handle missing values, remove duplicates, and ensure data consistency. Utilized transformation queries to aggregate, filter, and join data, generating meaningful insights and actionable reports. Used CASE statements to categorize and group data based on specific conditions, and subqueries for in-depth analysis and to extract subsets of data. View Project

Skills Used: SQL, Data Cleaning, Data Transformation, CASE Statements, Subqueries

Work Experience

Data Management Officer (Data Analyst)

Asommat International Services Limited
March 2022 – Present
Port Harcourt

Used Excel to analyze key office metrics, such as Resource Utilization and Employee Productivity. Developed monthly reports for senior management, identifying trends in office supply usage and task completion rates. These reports supported better decision-making, leading to more efficient use of resources and improved operational workflow.
Managed over 1,500 records related to office operations and cargo tank cleaning projects, ensuring accurate filing and easy retrieval of documents. Improved Document Retrieval Time by transitioning to a centralized digital filing system, ensuring compliance with internal and external standards.
Streamlined daily office operations by monitoring Administrative Efficiency and Task Completion Rates. Coordinated schedules, managed communication, and supported the timely completion of cargo tank cleaning projects. Improved office processes by implementing Excel-based tracking systems, resulting in a 15% reduction in time spent on routine tasks and enhancing overall team productivity.

Data Analyst

Viceroy Technologies
September 2021 – October 2023
Port Harcourt

Assisted in consolidating data from various sources, contributing to a 15% improvement in data consistency for solar installation project tracking.
Supported senior analysts in conducting basic exploratory data analysis, helping identify minor inefficiencies that contributed to a 2% reduction in project material costs.
Participated in the implementation of new data entry procedures, which helped decrease data processing time by 10% for small-scale solar projects.

Soft Skills

Stakeholder Management	People Management	Business Acumen
Communication	Leadership	Integrity and Discretion

Education

Aspire Leadership Program Aspire Institute, Jan 2024 – Apr 2024
Bachelors of Engineering (Hons.) Michael Okpara University of Agriculture Umudike, Abia State, Nigeria, Nov 2014 – May 2021, CGPA: 4.07/5.00

Certificates

Data Analysis with Pandas and Python
Microsoft Power BI Desktop for Business Intelligence
MySQL for Data Analytics and Business Intelligence
Google Data Analytics Professional Certificate

Blog

I regularly share insights and updates on data analytics, tips for effective data management, and case studies on my blog. Visit to learn more about the latest trends in data analytics and my professional journey.

Contact

Feel free to reach out to me via email at miraclechukwu29@gmail.com for any inquiries or opportunities.

GitHub

Acknowledgments

Thank you for taking the time to review my portfolio. I look forward to connecting and exploring opportunities to leverage data for impactful business insights.