SA SHINA AWOPEJU
Get in touch
Home About Case Studies Résumé Contact
fx

Turning data into business decisions, not just dashboards.

I help organisations improve revenue, reduce inefficiencies, and make smarter decisions by turning complex data into clear, actionable insights.

View case studies Download résumé
A1 Open to work
Portrait of Shina Awopeju
Shina Awopeju
Business & Data Analyst
Leicester, United Kingdom
B2
£0K
Annual cost savings from process optimization
C2
0%
Improvement in operational efficiency
D2
0%
Faster reporting through Power BI dashboards
E2
0%
Revenue increase through performance insights
F2
0%
Reduction in process inefficiencies
About & Approach

Business thinking, backed by technical depth.

I am a Business and Data Analyst with over four years of experience delivering data-driven solutions that improve performance, reduce inefficiencies, and support strategic decision-making.

My work sits at the intersection of data, operations, and business strategy, where I translate complex datasets into clear, actionable insights that drive measurable outcomes.

I have partnered with cross-functional teams across finance, operations, and sales to analyze large datasets, reconcile hundreds of accounts, and implement controls that reduced discrepancies by 25%. Through executive dashboards and reporting frameworks built in Excel and Power BI, I have enabled leadership to make faster, more informed decisions — contributing to a 15% increase in annual revenue.

"What should the business do next?" — the question every analysis has to answer.

  • Strong balance of business understanding and technical expertise
  • Proven track record of delivering measurable impact across projects
  • Ability to communicate insights clearly to technical and non-technical stakeholders alike
  • Experience across healthcare, IT, retail, and operational environments

How I work

01

Problem definition

Clarifying business objectives and identifying the right questions to solve.

02

Data analysis

Structuring, cleaning, and analyzing data to uncover meaningful patterns.

03

Insight generation

Translating findings into clear, business-relevant insights.

04

Actionable recommendations

Delivering practical solutions that drive measurable results.

Tools & working style
Analytics & BI

Excel (advanced formulas, PivotTables, Power Query), Power BI, SQL

Process mapping

Lucidchart, draw.io

Agile delivery

Jira, Trello, Azure DevOps

Documentation

Confluence, Slack, Zoom, TeamViewer

Analytics Case Studies

Turning data into business impact.

Each case study follows the same structure — business context, analysis, key insight, and impact — because that's what leadership actually needs to act.

ExcelB2

Optimizing Revenue & Demand — Uber UK Ride Analysis

Problem
Limited visibility into ride demand patterns, revenue drivers, and operational bottlenecks.
Approach
Analyzed ride data in Excel to identify demand trends, customer behavior, and revenue distribution.
Impact
Actionable insights to improve pricing strategy, driver allocation, and operational efficiency.
View full case study PostgreSQL · Excel
ExcelB3

Driving Revenue Growth Through Sales Intelligence — BikeGear Solutions

Problem
Limited visibility into regional sales performance and product profitability.
Approach
Built an Excel-based dashboard analyzing revenue, product categories, and regional trends.
Impact
Identified improvement areas to optimize pricing and operational strategy.
View full case study Excel · Dashboards
ExcelB4

Revenue & Performance Analysis — Data Commerce Solutions

Problem
Limited visibility into regional performance and product profitability made informed decisions difficult.
Approach
Built an Excel dashboard with Power Query and Pivot Tables to analyze revenue, category and customer segment trends.
Impact
Enabled identification of profit gaps and data-driven decisions on pricing and growth strategy.
View full case study Power Query
Power BIC2

Driving Operational Transformation Through Pharmacy Performance Intelligence

Problem
Fragmented operational data limited visibility into delivery performance, inventory, and financial outcomes.
Approach
Developed a Power BI dashboard integrating operational, financial, and delivery data into one reporting system.
Impact
Real-time operations monitoring and improved decision-making across key performance areas.
View full case study Healthcare
Power BIC3

Transforming Hospital Performance Through Financial & Operational Intelligence

Problem
Limited visibility into financial performance and service profitability across departments.
Approach
Analyzed multi-year hospital transaction data and built a Power BI dashboard for performance tracking.
Impact
Data-driven insights to improve resource allocation and financial planning.
View full case study Healthcare
Power BIC4

Enhancing Revenue Visibility & Operational Decision-Making — Trich Healthcare

Problem
Lack of structured insight into revenue performance, patient demographics, and payment patterns.
Approach
Built an integrated Power BI dashboard combining patient, financial, and operational data.
Impact
Improved visibility into financial drivers, enabling better decision-making and revenue optimization.
View full case study Healthcare
Power BIC5

Optimizing Hospital Operations & Financial Performance — PureLife Hospital

Problem
Complex operational and financial structure made it difficult to track performance across departments.
Approach
Developed a Power BI dashboard consolidating clinical, operational, and financial data.
Impact
Improved performance tracking and data-driven resource allocation.
View full case study Healthcare
SQLD2

Revenue Optimization & Demand Insights — Instacart SQL Analysis

Problem
Fragmented sales data limited visibility into category performance, demand patterns, and unsold inventory.
Approach
Queried and analyzed transactional data with SQL to uncover category performance and demand fluctuations.
Impact
Structured insights supporting smarter inventory decisions and revenue optimization.
View full case study Retail
SQL + Power BID3

Transforming Safety, Risk & Sustainability Through Data Intelligence

Problem
Data existed across systems, but leadership couldn't see where risk was increasing or if compliance was working.
Approach
Built an end-to-end SQL + Power BI solution connecting safety, compliance, and sustainability data into one decision system.
Impact
Shifted decisions from reactive to proactive across sites.
View full case study HSQE
Business CaseE2

Electronic Health Records Implementation — Meridian Hospital

Problem
Fragmented paper-based records driving a £4.2M annual loss and rising medication errors.
Approach
Structured, change-led BA approach: discovery, stakeholder engagement, requirements, solution evaluation, delivery planning, benefits realization.
Impact
Roadmap for a fully integrated EHR system reducing risk and administrative load.
View full case study Healthcare
Business CaseE3

HR Transformation — Global HCM Platform Business Case

Problem
Fragmented regional HR systems across 75,000+ employees on five continents, with rising compliance risk and cost.
Approach
Full business case: as-is process maps, gap analysis, options appraisal, financial model (NPV $15.6M, ROI ~75%), 24-month roadmap.
Impact
$20.95M projected benefits vs $20.68M investment; $11.4M annual run-rate savings from Year 3.
View full case study FMCG
BRDF2

Barrel & Brew Digital Transformation

Problem
Manual brewing logs and spreadsheet-based inventory causing delays, inconsistent quality, and rising costs.
Approach
Structured BA approach guiding the transition to an integrated Brewery Management System (BMS).
Impact
Clear requirements baseline enabling the business to scale operations without adding overtime.
View full case study Manufacturing
Résumé

Four+ years, translated into outcomes.

Business and Data Analyst with 4+ years of experience delivering data-driven insights that improve performance, optimize processes, and support strategic decision-making. Skilled in Power BI, Excel, and CRM analytics, with a track record of translating complex data into actionable insights that drive efficiency and revenue growth.

Credential
Issuer
Business Analytics
10Alytics
Data Analytics
Aptlearn
B.Eng. Computer Engineering
Ekiti State University
G1

Full résumé

Complete work history, project details, and quantified impact — one PDF download.

Download résumé
Contact

Let's turn data into business value.

If you're looking to improve business performance, gain clearer insight from your data, or build data-driven solutions that support decision-making, I'd be glad to connect.

Business Analysis Data Analysis Dashboard Development Process Improvement
Start a conversation
Emailshinacawopeju@gmail.com
LinkedIn/in/shinacawopeju
GitHub/shinacawopeju
LocationLeicester, United Kingdom