Oluwapelumi-Portfolio

๐Ÿ‘‹ Hello, Iโ€™m Oluwapelumi

๐Ÿ“Œ About Me

Iโ€™m a Data Analyst dedicated to turning raw data into actionable insights. I specialize in Excel, Power BI and SQL to analyze, visualize and communicate data-driven solutions.

Skills and Tools
Microsoft Excel (Advanced formulas, Pivot Tables, Data Analysis)
Power BI (Dashboard creation, DAX, Data modeling)
SQL (MYSQL; Data querying, Joins, Aggregations and Subqueries)
Data Cleaning & Preparation
Data Visualization & Reporting

๐Ÿ’ผ Projects

1. Hospital Patient & Revenue Analysis

Tools Used: Microsoft Excel

Comprehensive analysis of hospital operations examining patient health metrics and financial performance across 2,000 patients and 8,000 claims to identify improvement opportunities in patient care and revenue optimization.

Key Insights:

Skills Demonstrated: Healthcare analytics, Financial analysis, KPI tracking, Advanced Excel formulas, Pivot tables, Dashboard design

View Project โ†’

2. Police Department Crime Analysis

Tools Used: Microsoft Excel

Comprehensive crime analysis examining 60,000 criminal incidents to identify patterns, hotspots, and trends supporting data-driven decision-making for law enforcement resource allocation and crime prevention strategies.

Key Insights:

Skills Demonstrated: Crime data analysis, Pattern recognition, Time series analysis, Heatmap creation, Geographic analysis, Demographic profiling

View Project โ†’

3. Healthcare Patient Management Dashboard

Tools Used: Power BI

Interactive Power BI dashboard analyzing patient visit patterns, treatment pathways, and healthcare operations across 62,561 patient visits to optimize hospital operations and improve patient care delivery.

Key Insights:

Skills Demonstrated: Power BI development, DAX calculations, Interactive dashboards, Healthcare analytics, Treatment pathway analysis, Insurance utilization tracking

View Project โ†’

4. Retail Sales SQL Analysis

Tools Used: MySQL

Analysis of 50,000 retail sales transactions to identify revenue trends, top products, and customer behaviour.

View Project โ†’

๐Ÿ“ซ Letโ€™s Connect

โญFeel free to explore my projects and reach out if youโ€™d like to collaborate or discuss data!

Portfolio last updated: April 2026