EleganceTech Hub
|Intern
Osogbo, osun, Nigeria
Trainee
Intern
Osogbo, osun, Nigeria
Trainee
Data Analyst (Project Lead)
Remote, , Nigeria
Summary
Led a comprehensive end-to-end data analysis project, applying a full spectrum of skills in data cleaning, transformation, analysis, and visualization to deliver actionable insights and user-friendly reports.
Highlights
Engineered robust data cleaning and preprocessing workflows using Excel and Power Query, ensuring data accuracy and consistency by removing duplicates, standardizing formats, and correcting data types.
Utilized advanced Excel functions (IF, SUMIFS, XLOOKUP, VLOOKUP) and Pivot Tables to efficiently explore and summarize complex datasets, revealing critical trends and patterns.
Developed and executed precise SQL queries to extract, transform, and load datasets into databases, enabling deep dives into data to uncover specific business insights.
Leveraged Python (Anaconda) for comprehensive dataset inspection and preliminary analysis, validating data integrity and preparing data for advanced modeling and reporting.
Designed and deployed an interactive Power BI dashboard, integrating data from multiple sources to visualize key performance indicators and trends, enhancing stakeholder decision-making.
Orchestrated a seamless end-to-end data analysis workflow, combining Excel, SQL, Python, and Power BI to transform raw data into comprehensive, actionable reports and presentations.
Courses
Scientific Research Methods
Statistical Analysis
Data Collection Techniques
Fluent
Microsoft Excel, SQL (MySQL), Python (Anaconda), Power BI, Power Query.
Data Cleaning, Data Structuring, Data Transformation, Duplicate Removal, Missing Data Handling, Inconsistent Data Resolution, Date Formatting, Data Type Correction.
TRIM, FIND, UNIQUE, SUM, AVERAGE, MIN, MAX, LARGE, UPPER, LOWER, RIGHT, LEFT, MID, IF, SUMIFS, AVERAGEIF, XLOOKUP, VLOOKUP, HLOOKUP, Calculated Columns, Automated Data Processes, Pivot Tables, Dashboards, Conditional Formatting.
SELECT, WHERE, Data Loading, Querying Datasets, Database Operations.
Dataset Loading, Dataset Inspection (.info()), Data Cleaning (Python), Data Exploration (Python), Anaconda.
Data Connection (Excel, SQL, Python), Data Cleaning (Power BI), Data Transformation (Power BI), Calculated Columns (Power BI), Measures (Power BI), Interactive Dashboards, KPI Tracking, Performance Monitoring, Visual Reports Design, User-Friendly Reports.
Detail-Oriented, Analytical Thinking, Problem-Solving, Data Visualization, Insight Generation, Accuracy, Reporting.