MY DATA ANALYTICS PORTFOLIO

Hi there! Welcome to my online portfolio. I am passionate about scrum and data analysis, eager and ready to use my experiences and skills in SQL,Python, Excel, Power BI and Tableau to produce meaningful and insightful contributions in the Tech community.

RCM Analysis

Accounts Receivable in Healthcare

A neglect of A/R is a major cause of revenue leakage in healthcare and as such the need for AR management and follow up. The goal of A/R analysis is to increase revenue collection for the clinic by ensuring services rendered are paid for accurately and promptly. For this project, I took on the role of a junior revenue cycle consultant to a dermatology clinic. My goal was to understand the current status of their Accounts Receivables and provide recommendations that addresses the possible issues.

Healthcare Denials Management

Claim Denials are pain point, and the overall aim of denial management is to identify and mitigate potential denials. Appeals and resubmission of claims cost practice money that could have been reinvested into the practice. In this project, I worked as the revenue cycle analyst to a small clinic and was charged with the responsibility of identifying current issues behind denials whilst also suggesting ways to reduce and possibly prevent future occurrence of same.

SQL Projects

Hospital Medical Appointments Analysis

A Healthcare Appointments Analytics project that delves into the intricacies of medical appointments whilst exploring the factors influencing patient attendance.

Healthcare Management Investigation

My write up for Healthcare Management Investigation performed in MySQL. This analysis was performed to evaluate how cost can be saved while still keeping the beds open. Read the full details.

Nashville Housing - A Data Cleaning project in SQL

Real world data are often messy data and insights drawn from a messy data can lead to poor business decisions. In this project, I used SQL Server to clean up a dirty Nashville housing data

Who is Credit-Worthy - A World Bank Data Analysis

As the global recession hits many countries, they are seeking to get more funding from IDA, a World Bank group. IDA wants to gain insights into their loans and payments in a bid to ascertain who owes the least amount of money in this region. I used SQL to find out who is credit worthy.

Tableau Projects

Massachussets Education Overview

Over the years in the United States, Massachusetts workforce has been known to be the state with the highest record of college degree holders. However, very recently, there has been a drastic drop in the percentage of high school graduates proceeding to earn a college degree, and this has become an alarming issue for the state Education sector. In this project I was eager to analyze the provided dataset to suggests ways for statewide improvement.

2021-2022 NBA Season Analysis

In this project, I evaluated the NBA 2021-2022 season data of about 30 teams and I used Tableau to make visual insights on how certain parameters have contributed to the wins of some teams and players.

Excel Projects

DoorDash Marketing Analysis

My final write up for DoorDash Marketing Analysis. This marketing analysis was performed in Excel to help DoorDash improve and optimize their strategies for better customer retention and sales. Check out the full details

Power BI Projects

Adventure Works cycles Report

A Power Bi dashboard showing company performance (sales, customers and products performance) to stakeholders of the fictitious, multinational manufacturing company named Adventure Works Cycle.

Supply Chain Analytics

This dashboard is for a supply chain company and it showcases sales by country, region, market etc. The aim here is to create a business report that gives an overview of the business while helping stakeholders answer some basic questions.

Python Projects

A mining analysis in Python

This analysis was to provide predictions on the amount of impurities (in this case % silica concentrate) in the end of the mining process. These predictions will empower engineers with early information needed to act in advance to reduce impurities if need be.

R Projects

HR Employee Attrition Using R

Here is a simple HR Employee Analytics using R to track employee attrition based on some important factors and a list of recommendations to support employee retention

Tolulope Akinmoju