Victor Oluniyi
Portfolio

I'm a Data Analyst and Business Intelligence Analyst skilled in Excel, Power BI, Tableau, SQL and Python @VictorOluniyi

Investigating User's Engagement Drop

In this case study, a Corporate Social Network notices a sudden drop in user engagement over the past month. I conducted a thorough analysis of the available data using SQL (Structured Query Language), the project seeks to uncover the underlying factors contributing to this drop and provide actionable insights to mitigate and reverse the trend.

Data Cleaning in SQL

In this project, I take the initial unprocessed housing data and perform a series of transformations in PostgreSQL, with the ultimate goal of enhancing its usability for analytical purposes.

Sales Exploratory Analysis in SQL

In this project, I performed customer analysis, product analysis, sales analysis to understand sales trends, customer behavior, and the performance of different products and branches. This was used to identify areas for improvement in the business, such as increasing customer satisfaction and optimizing sales strategies

Data Analysis with Tableau

In this project, I performed an in-depth data analysis and visualization, and develop a dashboard to help make data-driven decisions to increase the company's sales and revenue to complete the project.

Sales Performance Dashboard with Tableau

In this Project, I designed a dashboard with Tableau to understand sales trend. This dashboard is effective at displaying the sales trend, allowing the stakeholders to understand the data and make informed decisions. The dashboard could increase revenue by at least 7% in the next quarter. I also added some recommendations that could help stakeholders take informed decisions

Personal Finance Tracker with Excel

In this project, I created a Finance Tracker Dashboard using microsoft excel. Personal Finance Tracker lets you to see all your money in one place by automatically updating your checking, credit card, loan, investment, and other account finance data. This dashboard can help you track your monthly budget by income and expenses, avoid of late fee, improve money saving, meet your financial objectives.

Unicorn Companies Analysis

In this project, I carried out a research and analysis on unicorn companies around the world. This analysis can provide valuable insights into successful business models, innovative strategies, and emerging trends, aiding entrepreneurs and investors in identifying potential opportunities and making informed decisions.

Real Estate and Property Management Analysis

This project is about real estate industry and property management. I investigated the number of properties in various locations, different types of floors, waterfront, and location. The analysis examines the status of the properties in order for decision makers to determine which properties require immediate attention and repair.