Reham Alhojori | Data Analysis Portfolio

Profile

Turning data into decisions.

I enjoy turning data into valuable insights, displaying results clearly, and supporting better decision-making.

Core strengths

Data cleaning & organization
Excel formulas & PivotTables
Dashboard design
Business-focused insights

Tools

Microsoft ExcelAnalysis, formulas, PivotTables, dashboards

Power BIInteractive dashboards & visual reports

AI productivity toolsAutomation & workflow improvement

Approach

A simple process. Clear outcomes.

My workflow keeps the analysis practical and focused on what the data can tell us.

Understand

Clarify the business question and the available fields.

Prepare

Clean, format, and organize the raw data.

Explore

Use formulas, PivotTables, and comparisons to find patterns.

Visualize

Build a dashboard with meaningful KPIs and charts.

Communicate

Summarize the most useful insights and next steps.

Project 01

Heritage Sales Dashboard

EXCELSALES ANALYSIS

94.9M SRTotal sales

56.8M SRTotal profit (~60% margin)

473,430Products sold

Best city: Yanbu
Best product: Saif Ardah, 111,442 units sold
Top branch profit: 18M, far above others (4M–13M)
Buyers: 54% male, 46% female
Top region: Western (31.2M), more than double Southern (21.1M)
Lowest region: Eastern (10.6M)
Performance concentrated in a few top branches, products & regions

Project 02

Finance Dashboard

POWER BIFINANCIAL ANALYSIS

2.02MPeak profit, Dec 2014

0.5M–2.0MMonthly profit range

Profit is highly volatile month-to-month, yet rises from 2013 into late 2014
Lowest points: Nov 2013 and Nov 2014
Top product: Paseo, led by Enterprise (10.0K) & Small Business (7.8K)
Strongest segment: Enterprise. Weakest: Channel Partners
Profit concentrated in North America & Europe
Small Business & Enterprise drive most sales across products

Project 03

Real Estate Dashboard

POWER BIPROPERTY ANALYSIS

325M SARTotal price sum

3,711KListings

City split fairly even: Dammam 28.3%, Jeddah 25.7%, Riyadh 24.1%, Khobar 23.9%
Highest-priced area: Al-Rabwa, avg 0.42M
Lowest-priced area: Al-Naseem, avg only 8K
Price and age filters let users narrow results by budget & build year
Coverage spans Riyadh, Jeddah, and the Dammam/Khobar area

Project 04

IBM HR Attrition Dashboard

POWER BIHR ANALYSIS

1,470Total employees

237Total attrition

16%Attrition rate

37Average age

Overall attrition: 16% of employees left the company
Department: Sales has the highest attrition rate at 20%, followed by HR at 19%, while R&D is lower at 13%
Age: attrition is more concentrated among younger employees, particularly early-career age groups
Years at company: attrition is generally higher among employees in their early years with the company, then tends to decline with longer tenure
Monthly income: higher attrition is more noticeable among employees in the lower income ranges

Project 05

Superstore Dashboard

POWER BIFINANCIAL ANALYSIS

2.30MTotal sales

286.40KTotal profit

12.47%Profit margin

Sales and profit generally increased over time, but not consistently aligned
Profit margin rose from 2016 to 2018, then declined in 2019
Lower discounts tend to go with higher profit margins
Chairs: high sales but a low 8% margin
Chairs in the West: lowest margin (3.96%) alongside the highest average discount (20%)

Skills

Tools & skills I use to build dashboards.

ExcelFormulasPivotTables, Charts

Power BIDashboardsVisualizations, KPIs

Data preparationCleaningFormatting, Data organization

AnalysisComparisonsTrends, Insights