Recommended expert
Oluwatobi Daodu
Data Analyst Intern
Experience
Jan 2024 - May 2024
5 monthsData Analyst Intern
Ingryd
- Assisted in data collection, cleaning, and preprocessing using Excel, handling datasets with over 100,000 entries to ensure readiness for analysis.
- Utilized advanced Excel functions (e.g., VLOOKUP, PivotTables, Macros) to perform complex data analysis and reporting, reducing manual processing time by 40%.
- Developed a dynamic dashboard using Excel to visualize key metrics and performances.
- Created detailed documentation of data analysis processes and findings, ensuring knowledge transfer and process transparency for future projects.
- Collaborated with business stakeholders to understand their data needs and provide analytical solutions, leading to a 20% increase in employee performance scores.
- Created five KPIs to identify employee performance levels.
- Ensured data integrity and accuracy by performing regular data quality checks, achieving a 99.9% data accuracy rate.
- Completed a simulation involving creating data visualizations for Tata Consultancy Services.
- Prepared questions for a meeting with client senior leadership.
- Created visuals for data analysis to help executives with effective decision-making.
Jan 2022 - Present
4 years 1 monthData Analyst
Toltom Global Services
- Conducted in-depth analysis of a dataset containing over 78,000 rows of COVID-19 data using Microsoft SQL to assess the virus's spread across various countries, improving decision-making processes by 30%.
- Calculated monthly and annual averages for confirmed cases, deaths, and recoveries using SQL.
- Presented insights and key findings through PowerPoint to effectively communicate results.
- Shared detailed insights and conclusions based on the analysis performed.
- Documented the entire analytical process and findings in a comprehensive Microsoft Word report.
- Developed a dynamic Power BI dashboard to visualize key metrics and trends in NREGA analysis.
- Provided detailed visualizations on employment distribution across states and budget allocations.
- Cleaned and pre-processed a dataset of 750 rows using Microsoft Excel, followed by data transformation in Power Query to ensure readiness for analysis.
- Presented data-driven insights derived solely from the thorough analysis conducted.
Online Food Store Analysis
- Worked closely with team members to analyze the relationship between demographic and location factors and online food ordering behaviour using Python.
- Cleansed and processed 5,000 rows using Pandas in Python to prepare data for analysis, resulting in a 25% reduction in data processing time.
- Conducted exploratory data analysis to uncover patterns and trends within the dataset.
- Visualized and summarized the relationships between customer feedback, delivery time, and income using Python’s data visualization libraries.
Sales Analysis
- Conducted in-depth analysis of a dataset containing over 2,000 rows using Microsoft Power BI.
- Created measures using DAX formulas to express KPI metrics during analysis.
- Created a dynamic dashboard for visualization to communicate findings.
- Presented data-driven insights derived solely from the thorough analysis conducted.
Summary
Detail-oriented Data Analyst with 4+ years of experience in data interpretation, statistical analysis, and data visualization. Proficient in SQL, Power BI and Excel with a proven track record of using data insights to drive strategic decision-making and improve operational efficiency. Skilled in transforming complex data sets into actionable business intelligence. Seeking to leverage analytical expertise in a dynamic environment to support data-driven decision-making and business growth.
Skills
Technical Skills
- Postgresql
- Microsoft Sql
- Microsoft Power Bi
- Microsoft Powerpoint
- Office Suite (Microsoft Word, Microsoft Excel)
Soft Skills
- Clear And Concise Verbal And Written Communication.
- Ability To Work Effectively In Cross-functional Teams.
- Strong Analytical And Troubleshooting Skills.
- Agile Methodologies, Project Planning, Time Management.
- Experience Leading Projects Or Mentoring Team Members.
- Ability To Quickly Learn New Tools And Technologies.
- Ability To Think Strategically And Make Data-driven Decisions.
Languages
English
AdvancedYoruba
AdvancedEducation
Federal University of Agriculture Abeokuta
B.Agric · Plant Physiology and Crop Production · Abeokuta, Nigeria
Certifications & licenses
Data Science
Ingryd Academy
Empowering Business With Effective Insights
Forage (Tata Group)
Microsoft Power Up Program
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Similar Freelancers
Discover other experts with similar qualifications and experience