Alabi Usman Ayodeji

Intro

Every business has data, but not every business has clarity. I specialize in bridging that gap by transforming complex datasets into clear, actionable insights. With expertise in SQL, Excel, Power BI, and Python, I design interactive dashboards, uncover hidden trends, and provide recommendations that help businesses improve efficiency, optimize strategies, and drive growth.

Beyond technical skills, I bring a problem-solving mindset and the ability to communicate findings in a way that decision-makers can act on. Whether it’s analyzing healthcare operations, retail performance, or digital campaigns, my goal is simple: to turn data into decisions that make a measurable impact.

Healthcare Analysis: Readmission & Efficiency

I analyzed hospital admissions data to uncover patterns in patient readmissions and identify ways to improve healthcare efficiency. Using Excel for preprocessing and Power BI for dashboards, I explored patient demographics, diagnosis-specific trends, care durations, and survival rates across community health, hospital support, and daycare services.

Key findings revealed that elderly patients (65+ years) and cancer-related diagnoses were the main drivers of readmissions and mortality. Shorter care durations often led to premature discharges, while underutilized telehealth limited scalability of patient monitoring.

The project provided data-driven recommendations to reduce readmissions, scale telehealth services, and improve discharge planning. These insights can guide resource allocation, healthcare planning, and policy support.

Digital Marketing Campaign Analysis

I analyzed multi-channel digital marketing campaigns to evaluate ad spend efficiency, ROI, and conversion performance. Using Excel for preprocessing (Data Cleaning) and Power BI for data modeling and dashboards, I explored campaign performance across products, channels, and time periods.

Key insights revealed that Influencer and Instagram Ads delivered the best ROI and lowest cost per conversion, while Google Ads showed high spend but lower efficiency. Revenue trends highlighted strong seasonality, with December–January peaks, and a clear correlation between consistent ad spend and revenue growth.

Recommendations focused on reallocating budgets toward high-performing channels, optimizing Google Ads with A/B testing, improving conversion funnels, and leveraging seasonality to maximize ROI.

Pizza Sales Analysis

I designed a Power BI dashboard to analyze pizza sales performance across time, product type, and size. The project used Excel/CSV preprocessing, Power Query, and DAX for modeling, resulting in interactive visualizations that reveal sales patterns and revenue drivers.

Key insights showed that Classic Deluxe was the top-selling pizza, while Thai Chicken and BBQ Chicken generated the highest revenue. Large-sized pizzas contributed nearly 46% of total revenue, with peak sales occurring in the afternoon. However, high-order pizzas like Pepperoni and Hawaiian underperformed in revenue, highlighting pricing or size-related issues.

Recommendations included revising pricing strategies, upselling larger sizes through promotions, boosting marketing for top revenue pizzas, and targeting morning sales with discounts. These strategies aim to maximize revenue, balance product performance, and improve overall sales efficiency.

Layoff Trends Analysis (SQL)

I analyzed a global tech layoffs dataset using SQL, focusing on data cleaning and exploratory analysis to uncover patterns across time, industries, and geographies.

The project involved removing duplicates, standardizing fields, handling missing values, and converting date formats before performing detailed analysis with aggregations, window functions, and CTEs.

Key insights showed that 2022 and 2023 recorded the highest layoffs, with the U.S. leading globally. The Crypto and Consumer industries were among the most affected, and in some cases, companies laid off 100% of their workforce.

About

Hi, I’m Alabi Usman Ayodeji, a first class Biochemistry graduate turned certified Data Analyst. With proficiency in SQL, Excel, Power BI, and Python, I transform raw data into actionable insights that drive business and research outcomes.

Contact

• Twitter
• Linkedin
• GitHub
• Email

Elements

i = 0;

while (!deck.isInOrder()) {
    print 'Iteration ' + i;
    deck.shuffle();
    i++;
}

print 'It took ' + i + ' iterations to sort the deck.';