"Are you Struggling to Stay on Top of Your Finances? Get My Budget Tracker & Take Charge Today!"
Database Querying With SQL: I leverage SQL to query databases, extract meaningful data, and perform comprehensive data analysis to support business decision-making
Dashboard Creation: Designing and maintaining interactive dashboards that track KPIs, offering real-time insights to help organizations achieve their goals.
Data Preparation: Cleaning, transforming, and managing data to ensure its accuracy and reliability, using Power Query and SQL.
Reporting: Developing comprehensive reports and presentations to effectively communicate findings and influence decision-making.
In this data-driven retail analytics project, I analyzed Adidas US sales performance using Power BI, uncovering key insights across products, channels, and regions to support strategic decision-making.
For this project, I Analyzed and optimized digital marketing ad campaigns for FreshCart, an online grocery store, to maximize return on investment (ROI), enhance customer acquisition, and drive business growth.
This project involved analyzing a Sales Store dataset provided by my tutor during the Women Techsters Bootcamp. Using Power BI Desktop, I performed data cleaning, exploration, analysis, and visualization to uncover key metrics and meaningful insights for stakeholders.
Tools Used - Power BI
Click Here to Read More About this Sales Store Analysis Project
This case study explored a dataset for a fictitious software company, Atlas Labs, with a focus on importing, analyzing, and visualizing Human Resources (HR) data in Power BI. The primary goal was to monitor key employee metrics and understand factors influencing employee attrition. This project strengthened my skills in Power BI report development, DAX calculations, and data visualization.
Tools Used - Power BI
In this Data Analysis project, I investigated reasons for customer churn for, a telecom company Databel, using Excel. This hands-on case study allowed me to analyze why customers are churning and how to reduce it effectively.
Tools Used - Microsoft Excel
Click Here To Read More About This Customer Churn Analysis Project
The manager at Samuel's Christmas Gift Co tasked me with preparing the dataset for their end-of-year data analysis report.
The manager of Samuel's Gift & Co gave me these steps to follow below
1. Identify and remove repeated data entries so as to help in preserving unique data.
2. Inspect the "Gift_Item" column for irregularities in the texts. Implement a transformation to ensure all gift item names are written normally.
3. Investigate the dataset for any excess spaces in column values.
4. Generate a new column that combines the child's name and age, separated by a hyphen (e.g., "James - 11").
Data Analyst Trainer @ Bizmarrow Technologies Ltd | February 2025 - Present
As a Data Trainer at Bizmarrow Technologies Ltd, I equip aspiring data analysts with the technical skills and knowledge needed to excel in the field. I provide hands-on training in Excel, Power BI, and SQL, guiding students through data manipulation, visualization, and analysis to help them develop a strong foundation in data analytics.
My role involves designing structured lessons, delivering interactive sessions, and mentoring students to ensure they gain practical experience in solving real-world data problems.
I empower students to confidently use data-driven insights to make informed business decisions by fostering a learning environment focused on critical thinking and problem-solving.
Data Analyst Intern(Simulation) Podha Partnered With Meriskill | Sept 2014 - October 2024
Conducted hands-on data analysis, and visualization.
Developed insightful dashboards and reports using Power BI.
Collaborated with teams to ensure data accuracy and seamless data flow.
Systematic Investigation of Blacks With Stroke (SIBS-GENOMICS) | January 2019 – February 2023
Data Officer/Research Assistant
As a Data Officer, I managed patient data entry and collection for stroke research projects using Redcap, ensuring timely and accurate reporting. I also collaborated with research teams and handled incomplete data requests for analysis, providing key insights to improve research outcomes.
Stroke Investigative Research and Education Network (SIREN) | Jan 2016 – Dec 2018
Data Officer/Research Assistant
In this role, I collected and managed control group data for medical research, ensuring consistency across data sets. I played a key role in following up with stroke patients, maintaining a 90%+ follow-up rate, and contributed to summarizing research results for publication.
Designed By Me Chimdinma Lois Melikam
