Hello, I'm Olamide Olagunju

A creative data analyst who loves working with Microsoft Excel,SQL,
Python Tableau and Power Bi. I enjoy extracting hidden insights
from data find spot patterns, and building dynamic analytics
solutions that influence business choices.

When I'm not diving into data, I'm usually reading
about new advances in the data industry.

My Projects

INTERACTIVE HR DASHBOARD

Using Power Bi, I built a comprehensive understanding of the human resources data within an organization to track of KPIs to help make informed decisions.

The HR data analysis project was able to provide valuable insights into an organization's human resources data. The important takeaways include the total number of employees, year of service, workers who should be promoted, job positions, an employee who will be let off due to business concerns, employees that live a long distance away from the office, employee evaluation and work satisfaction evaluation, and employee travel situation. These insights can be used to inform strategic decision-making, improve workforce planning, and identify areas for improvement.

PROPERTY MANANAGEMENT DASHBOARD

This dashboard focuses on real estate and property management. It looks at the following key performance indicators (KPIs): | The total number of properties is | Floor types and waterfront | The properties' locations | Conditions of the properties.

The study is intended to offer decision-makers insights into the status of the assets, allowing them to determine which ones require immediate attention and repairs.

NYC TAXI TRIP DASHBOARD

The purpose of this report is to provide an analysis of the data provided for the construction of a dashboard that will be useful for the weekly planning of NYC taxi trips. The report will focus on 2017 to 2020 data to provide insight into the average number of trips, average fare per trip, the average distance traveled per trip, expected changes in trip volume, busiest days and times of the week, and popular pick-up and drop-off locations.

AMEX KIDS TOYS DASHBOARD

This project focused on:
1. A switchable Top N to see which products are doing well and compare the selected product to the overall revenue
2. Revenue trend on a monthly basis
3. Revenue comparison across sales region
4. On one slicer select both month and year to filter the dashboard
5. a slicer for regions

PERSONAL FINANCE DASHBOARD

The dashboard is intended to help individuals track their expenses, income, and debt to create a clear picture of their financial situation. The dashboard contains several key features, including a summary of the user's income, a breakdown of their expenses, and a debt overview. The dashboard is easy to navigate and provides users with the ability to quickly access the information they need to make informed financial decisions.

CALL CENTER TRENDS DASHBOARD

PhoneNow is a call center that emphasizes open communication and data-driven decision-making. They want to understand about key performance indicators such as the number of calls answered and abandoned, response time, call duration, and overall customer satisfaction. They also want a dashboard that illustrates long-term trends in both customer and agent behavior. By analyzing this data, PhoneNow hopes to identify areas for development and implement strategies to increase the efficacy of their contact center.

SUPER BOWL COMMERCIAL DASHBOARD

In this report, we will analyze the Super Bowl commercial ads using Power BI to create a dashboard with the following KPIs: brands, cost of ads, TV views, YouTube views, funny ads and serious ads, number of years, ads by brand, ads by year, cost by brand, and cost by years.

About Me

As an experienced data analyst professional with a Google Data Analytics certificate, specializing in Excel skills for data analytics and visualization, as well as Excel skills for business, I possess a wealth of knowledge and proficiency in utilizing a range of tools, including Microsoft Power BI,Power Query, SQL, Tableau, Microsoft Excel, and Python, to effectively solve complex business problems. With my strong analytical capabilities and attention to detail, I am well-versed in analysing complex data sets, extracting insights, and create bespoke visualizations for both technical and non-technical audiences provides a comprehensive overview of trends, procedures, and outcomes and presenting them in a meaningful way to stakeholders.

I recognize the importance of prompt and efficient issue resolution and am always prepared to provide support in a timely manner. I am excited to contribute to your organization's growth by leveraging my expertise in Power BI reporting, data modeling, query optimization, data analytics optimization, and report building. My proficiency in these areas allows me to offer tailored solutions to meet your unique requirements, whether you require assistance in optimizing your data analytics processes or developing custom reports.

As a dedicated team player, I have an attention to detail and a goal-oriented mindset, ensuring that the solutions I deliver meet or exceed client expectations. If you require a skilled and efficient Power BI Analyst and Data Entry Operator, I am eager to support your needs and contribute to your organization's success. I look forward to hearing from you.

Contact

Feel free to connect with me on LinkedIn or reach out to me via Email —I'm always interested in discussing data and analytics or connecting with other professionals in the field.