Arptechnology Professional Training Institute
|DATA ANALYST INTERN
Lagos, Lagos State, Nigeria
Summary
Currently serving as a Data Analyst Intern, responsible for cleaning, transforming, and analyzing large datasets to develop interactive dashboards and generate actionable insights for training case studies.
Highlights
Optimized data integrity by cleaning and transforming complex datasets in Excel, resolving missing values, duplicates, and inconsistencies to ensure analysis readiness.
Identified critical performance trends and metrics by analyzing structured datasets using advanced Excel functions like Pivot Tables, XLOOKUP, and Slicers, enhancing data-driven evaluations.
Designed and implemented interactive Power BI dashboards to visualize key performance indicators (KPIs), significantly improving data visibility and comprehension for training case studies.
Translated complex data into clear, actionable insights through compelling visual reports, effectively communicating findings to non-technical stakeholders.
Processed and analyzed extensive datasets, totaling over 9,000,000 records, utilizing Pivot Tables and XLOOKUP to accurately evaluate performance trends and inform strategic recommendations.