01Commercial analytics
Retail Revenue
Which store, category and segment mix maximizes profitable growth?
Data Analyst Portfolio · 15 case studies
Turning data into clear decisions.
I build practical analytics products that move from raw data to KPI design, interactive dashboards, decision stories and actionable recommendations. Explore the work below and inspect the same analysis through HTML, Excel, Power BI and Tableau.
⌘K
Boardroom-ready: 15 analytics products, 150 research works, 5 financial models and a real-estate technology case study — all searchable and downloadable.
15 Live Dashboards · 4 Tools · Real Business Decisions
Building analytics that drive decisions — every project live, every chart interactive.
SQLPythonPower BITableauExcelEDAData StorytellingAI Automation
Research & analytics portfolio
Decision first
Each project starts with a business question, then evidence, then the implication.
Q → I → A
Built to inspect
Download the working Excel, Power BI and Tableau versions directly from the portfolio.
4 formats
Recruiter snapshot
What the portfolio proves
A hiring manager can scan the page quickly, open the live dashboard, read the business question, and then inspect the same analytical work in common BI tools.
15 projectsCommercial, customer, operations, risk, people, growth and specialist analytics.
Decision-readyStory, KPI discipline, exploration and recommendations are built into each case study.
PDF + DOCX researchResearch manuscripts are provided as PDF and DOCX only; dashboards and financial models retain their relevant specialist formats.
Clear evidenceDirect links, preview visuals, downloadable artifacts and concise project briefs.
Featured work
Start with the four case studies named in the CV.
A fast visual route into the portfolio. Use the arrows or swipe horizontally, then open the full project library for all 15 analytics projects.
01 · CommercialRetail Revenue & ProfitabilitySQL · Python · Power BI · Tableau · Excel
05 · CustomerE-commerce Customer ChurnSQL · Python · Power BI · Tableau · Excel
07 · OperationsSupply Chain & LogisticsSQL · Python · Power BI · Tableau · Excel
06 · HealthcareHospital Operations & ReadmissionsSQL · Python · Power BI · Tableau · Excel
About the work
A portfolio built around decisions, not decoration.
The goal is simple: make complex information easier to understand, explore and act on.
How I approach analysis
I start with the business question, understand the structure of the data, define the measures that matter, then build a visual system that lets a reviewer move from headline KPI to detail without losing the story.
What you can inspect here
Each project pairs an interactive browser dashboard with source-ready BI artifacts. Recruiters can see the user-facing result and also inspect the portable Excel, Power BI and Tableau versions.
My CV
An ATS-optimised CV covering the technical stack, analytics portfolio, research and data management experience, plus additional sales and real-estate experience.
Certification · 26 July 2026
WyseFlex Global Sales Institute
The Real Estate Edition — Certificate of Excellence
Passed with Distinction. The certificate recognizes excellence in real estate, wealth creation and the discipline of selling.
01
Discover
Define the business question, stakeholders and decision context.
02
Prepare
Clean, structure and validate the fields and measures used in analysis.
03
Visualize
Build KPI-led charts, filters, pivots and clear analytical hierarchy.
04
Recommend
Translate findings into practical actions, trade-offs and next questions.
Project library
15 analytics products, arranged as a visual case-study gallery.
Use the filters or search by project name. Each analytics case study provides its HTML dashboard and relevant Excel, Power BI and Tableau deliverables. Research papers are available only as PDF and DOCX.
02Wellbeing analytics
World Happiness
Which socioeconomic segments are associated with stronger reported wellbeing?
03Risk cohort analytics
Titanic Safety
Which passenger cohorts carried the greatest survival exposure?
04Content analytics
Netflix Streaming
How is the content library evolving by format, geography and genre?
05Customer analytics
E-commerce Churn
Which customer segments show the strongest signals of preventable churn?
06Healthcare operations
Hospital Operations
Where do throughput, cost and discharge delays create operational pressure?
07Logistics analytics
Supply Chain
Which carriers and lanes put service reliability at risk?
08Risk analytics
Bank Credit Risk
Which applicant segments combine credit risk with elevated debt burden?
09People analytics
HR Attrition
Which workforce cohorts show the strongest retention warning signals?
10Growth analytics
Marketing ROI
Where should the next marketing dollar go to maximize efficient revenue?
11Performance analytics
Sports Analytics
Which player and team metrics best predict match outcomes?
12Energy analytics
Energy Utilities
Where is energy consumption being wasted across facilities?
13Guest experience analytics
Hospitality Hotels
What drives guest satisfaction and repeat bookings?
14Learning analytics
Education EdTech
Which engagement signals predict course completion?
15Customer retention analytics
Telecom Churn
Which customer segments are most likely to churn post-contract?
Research library
150 interdisciplinary research manuscripts.
Explore a structured library of 150 interdisciplinary manuscripts spanning procurement, supply chains, technology, governance, sustainability and African development. Each record includes a clear research question, method, findings, recommendations and downloadable working files. Manuscripts are designed for rigorous editorial development; journal-specific formatting, source verification, ethics declarations and peer review remain necessary before submission.
Loading research…
Financial modeling
Decision-ready models built from the portfolio case datasets.
Five auditable Excel models with scenario inputs, source-data tabs, recruiter-facing memos, presentations and downloadable outputs. Scenario assumptions are explicitly labelled illustrative rather than represented as market facts.
Real estate technology
Property intelligence with a PropTech lens.
A dedicated case study built from the supplied Hospitality Hotels dataset. It demonstrates how property operations, pricing, channel mix and guest-experience signals can be unified into an executive decision system without inventing property valuations or market data.
REAL ESTATE / PROPERTY ANALYTICS
Hospitality Property Performance Analytics
2,200 supplied stay records transformed into an interactive property-performance dashboard, executive KPI wall, Excel workbook, PowerPoint, PDF, Word memo and CSV outputs.
2,200stays
8.4%cancellation
21.6%repeat booking
43.1avg NPS
BOARD VIEW
What a property decision-maker can inspect
Revenue & pricingBooking value, ADR, stay length and property mix.
Demand qualityRepeat booking and cancellation rates by asset and channel.
ExperienceNPS, service, cleanliness and wait-time signals.
Technology pathwayCSV → Python/Pandas → KPI layer → dashboard → Excel / PPT / PDF / Word.
Integrity note: this is a property-operations proxy using an existing supplied dataset; it is not presented as direct real-estate valuation or market-price data.
Digital products
Learn from the same analytical discipline.
A direct product page for my course and digital learning offering. Selar handles digital-product and course delivery, including downloadable resources and hosted course content.
YIZ GLOBAL CONSULTSData, Analytics & Decision IntelligenceDigital learning
AVAILABLE ON SELAR
Explore my course
Access the course and learning resources through my Selar product page.
Course title, price and curriculum are intentionally not restated here beyond the source link provided, so the portfolio does not invent product details.
Skills
Tools I use to turn raw data into usable reporting.
SQLCTEs, joins, window functions, KPI-ready transformations and query logic.
PythonPandas, NumPy, exploratory analysis and repeatable data preparation.
Power BIDAX, modeling, slicers, KPI design and executive dashboard thinking.
Tableau + ExcelCalculated fields, dashboard actions, pivots, formulas and native charts.
Get in touch
Have a business problem worth exploring?
Use the form to reach out about Data Analyst, BI or analytics opportunities. You can also go straight to the CV or open any project above.