Khadijat Lamidi

Data Analyst
Lagos, NG.

About

Highly analytical Data Analyst with a proven ability to transform complex datasets into actionable insights using Excel, Power BI, and SQL. Expert in developing interactive dashboards and reports that drive data-driven decision-making and optimize business strategies. Leverages strong problem-solving and collaboration skills to uncover key trends and deliver measurable impact across diverse data environments.

Work

Independent Project
|

Data Analyst

Lagos, Lagos, Nigeria

Summary

Led the end-to-end development of an HR data analytics dashboard using Power BI to identify key drivers of employee attrition and support retention strategies.

Highlights

Cleaned and transformed extensive HR data from the IBM dataset, generating calculated columns for attrition, age bands, and salary bands to ensure data integrity and analytical readiness.

Developed an interactive Power BI dashboard, incorporating advanced DAX measures, slicers, and drill-downs to enable dynamic tracking of critical workforce trends.

Utilized Power BI's Key Influencers and Decomposition Tree Visuals to pinpoint critical drivers of employee attrition, directly informing and supporting data-driven retention strategies.

Independent Project
|

Data Analyst

Lagos, Lagos, Nigeria

Summary

Designed and implemented an interactive Excel dashboard to analyze sales performance, identify high-performing stores, and highlight top-selling categories.

Highlights

Constructed an interactive Excel dashboard leveraging PivotTables, charts, and slicers to conduct comprehensive sales analysis across diverse outlets and item categories.

Visualized key performance metrics, enabling the identification of top-performing stores and strategic allocation of resources.

Generated actionable insights, including the highest-revenue outlet and top-selling categories, to inform sales strategy and merchandising decisions.

Independent Project
|

Data Analyst

Lagos, Lagos, Nigeria

Summary

Conducted an in-depth SQL-based analysis of e-commerce data to identify customer satisfaction gaps and provide recommendations for loyalty improvements.

Highlights

Cleaned and normalized an extensive e-commerce dataset comprising over 90,000 records, ensuring data accuracy and consistency for reliable analysis.

Executed complex SQL queries to analyze critical sales patterns, customer behavior, delivery timelines, and payment trends, revealing key operational insights.

Identified crucial customer retention gaps and generated data-driven insights that directly informed and guided customer satisfaction and loyalty enhancement recommendations.

Education

AltSchool Africa
Lagos, Lagos, Nigeria

Diploma

Data Analysis

University of Lagos
Lagos, Lagos, Nigeria

Bachelor of Science

Pharmacology

Grade: First Class Honors

Languages

English

Proficient

Skills

Data Analysis & Visualization

Excel, Power BI, SQL, Data Cleaning, Data Transformation, Data Visualization, Reporting.

Problem Solving

Logical Thinking.

Collaboration & Communication

Communication, Team Work.