My Portfolio
Welcome to my portfolio. Here you'll find a selection of my work. Explore my projects to learn more about what I do.
FIFA 22 Analysis
Python, A/B Testing, Correlation, Hypothesis Testing
There are several attributes among FIFA players that can be used to determine their ratings. Some of these attributes include their speed, accuracy in passing, number of goals scored, number of assists, number of goals saved, dribbling techniques, and a number of others.
For this analysis, focus was on the players' preferred playing foot. An A/B testing was carried out to find out whether a player who plays predominantly with their left foot were higher rated and better paid than players who predominantly play with their right foot.
Fuel Economy Analysis
MS Excel, t-test, Confidence Interval
Our world is fast experiencing the need to adopt more environment-friendly and cost-effective alternatives to the available fuel types for our vehicles. Some of these fuel types include the E85, the Natural Gas (CNG) and the Electricity.
This analysis was able to tell which of these fuel types was most cost effective, using t-test to establish the statistical significance of the differences in the average annual fuel cost as well as the average Miles Per Gallon (MPG) for these vehicles. For these tests, confidence intervals were also determined.
Playstore Dashboard Summary
Tableau, Dashboard, Storytelling, Insights, KPIs
Competition is one of the most essential aspects that can build or hinder the growth of a business, depending on how well the situation is managed. One way for businesses to ensure they are ahead of the competition is in managing the reviews and feedback from customers.
This project made use of data from Google playstore present a dashboard, tell the story about some insights derived regarding the categories, genres and apps with the most installs, highest revenue, and sentiment polarity.
Playstore SQL Video
PostgreSQL, Finding Insights
Competition is one of the most essential aspects that can build or hinder the growth of a business, depending on how well the situation is managed. One way for businesses to ensure they are ahead of the competition is in managing the reviews and feedback from customers.
This project made use of data from Google playstore to find some insights about the app installs, reviews and ratings using SQL. Some of the insights revealed which apps have the highest rating, the number of installs and reviews for those apps, the app with the highest number of reviews, the total amount of revenue generated, the genre with the most published apps, etc...
Call Center Trends
Tableau, Dashboard, Storytelling, Insight Finding
Customer is King! To be in business is to be customer-focused, and if the call center rating is closer to the south than the north, the why has to be investigated.
This project is a visualization on Tableau, showing the trends of a call center. The visuals include the overall customer satisfaction rating, the length of calls, speed of answer, the topics covered, and the statistics by each call center agent. The dashboard was accompanied by a story board telling about the insights from the data.
Car Rental Business Model
MS Excel, What-If-Analysis, Modeling, XLOOKUP, Pivot-Table
Businesses have to keep their options open to be able thrive in the competitive market of today. It is essential to build a business model where there is room for dynamic strategies which are focused on the business goals and objectives.
For this project, what-if-scenarios were modeled to find ways for the car rental business to minimize cost and maximize revenue. Depending on the objective of the company, the strategies can be combined to provide a minimum of 4% increase in annual profit.
