Data Analyst · Power BI Developer

I turn raw data into dashboards decision-makers actually use.

From messy transaction logs to executive-ready Power BI reports — I design, model, and build analytics for rewards programs, retail, healthcare, banking, and operations.

Nada MohamedFreelance Data Analyst

95+Dashboards delivered

9+Industries covered

16Sample dashboards on this page

100%Dummy data — zero client information

About me

Profile

I'm Nada Mohamed Abd ElRasoul, a data analyst who specializes in transforming raw data into interactive dashboards and actionable insights that support business decision-making.

I handle the full pipeline: cleaning and modeling the data with Power Query and SQL, building the measures in DAX, and designing report layouts that stakeholders can read at a glance.

Toolbox

Power BIDAXPower Query SQLPostgreSQLExcelTableauLooker StudioPower Automate PythonPandasNumPyMatplotlib Data Cleaning & Transformation Data Modeling Data Visualization

🔒

A note on confidentiality: I've delivered 95+ dashboards; the samples below show only the design. All names, IDs, phone numbers, brands, and figures are dummy values (XXXXX, 01XXXXXXXXX, 1-2-3, Product A/B/C). The layouts mirror the real deliverables — the data does not.

Dashboard portfolio

16 samples of 95+ builds

◔

DashboardReal-time insights and performance overview

Total Revenue$23.27M ▲ 5.19K%

Total Visits305K ▼ -77%

Avg. Time on Page16 ▲ 243.9%

Conversation Rate28 ▼ -3.77

✈ User Engagement

Measure of User Interactions with Campaign

Count of Order DateSum of Total Amount

Sales by Sales Rep

Rep 1 · 492M (40.7%)

Rep 2 · 216M (17.8%)

Rep 3 · 138M (11.5%)

Rep 4 · 129M (10.7%)

Rep 5 · 92M (7.6%)

Rep 6

Rep 7

📣 Top Campaigns

Most visited contents overview

Name	Sales Rep	Sales Amount	Quantity	Net price	Status	Year	Quarter	Month
Campaign A	Rep 1	162,000	360	2,700	Completed	2029	Qtr 2	April
Campaign A	Rep 6	81,000	180	1,350	Completed	2029	Qtr 2	April
Campaign A	Rep 5	675,000	1,500	13,500	Completed	2029	Qtr 2	April
Total		1,208,421,000	3,843,720	23,270,100

🏷 Top Keywords

Critical search terms performance overview

ID	Sales Rep	Sum of Total Amount
6	Rep 1	492,217,500
3	Rep 2	215,556,000
2	Rep 7	138,309,750
Total		1,208,421,000

Sales & Marketing Dashboard — Campaigns & Reps

Real-time commercial overview: revenue, visits, time-on-page, and conversion KPIs with trend deltas, engagement vs order-value correlation, sales-rep contribution donut, top campaigns table, and keyword performance — all rep and campaign names are placeholders.

POWER BIDAXEXCEL

GlobeTrendsGlobal Rewards Platform

01-Jan-2030 Overview

25New Enrollments

210Active System Scanners

115Participants Spending Points

3,500.00Earning Value "Units"

4,200.00Spending Value "Units"

Earning Transaction Logs

TransID	User	ContactNo	Product Class	Points	Value	Time
1	XXXXX	01XXXXXXXXX	Product A	140.00	14.00	12:35
2	XXXXX	01XXXXXXXXX	Product B	140.00	14.00	13:13
3	XXXXX	01XXXXXXXXX	Product C	140.00	14.00	08:14
4	XXXXX	01XXXXXXXXX	Product D	140.00	14.00	16:35
5	XXXXX	01XXXXXXXXX	Product E	140.00	14.00	16:35
Total				32,015	3,201.50

Scanning Activity Breakdown

Scanner Type AType B

Spending Details

TransID	Cardholder ID	ContactNo	Points	Value	Branch
1	1	01XXXXXXXXX	460.00	46.00	Online Branch 1
2	2	01XXXXXXXXX	100.00	10.00	Online Branch 1
3	3	01XXXXXXXXX	350.00	35.00	Offline Branch A
4	4	01XXXXXXXXX	400.00	40.00	Offline Branch A
5	5	01XXXXXXXXX	330.00	33.00	Online Branch 1
Total			44,955	4,495.50

Performance by Product Class

Product Cat. 1736

Product Cat. 2711

Product Cat. 3580

Product Cat. 4207

Product Cat. 5135

Product Cat. 6126

Product Cat. 7124

Location Metrics

Location Partner 1Partner 2Partner 3Partner 4Partner 5

Rewards Platform — Daily Operations Page

"Prior day" operations snapshot for a scan-to-earn rewards platform: new enrollments, active scanners, earning and spending value, transaction logs, scanner-type breakdown, product-class performance, and partner-location metrics.

POWER BIDAXSQL

ScanRiseScan-to-Earn Analytics

Product: All ⌄

Partner: All ⌄

Branch: All ⌄

Contact No: All ⌄

3,463,397Earning Value "Units"

33,500Welcome Points Value

21,671Active Users "Earners"

1,542,073No.of Generated Codes

194,488No.of Scanned Codes

8.97Avg Scans / User

17.81Avg Value / Scan

159.82Avg Value / User

Scanner & Value Insights by Product

Product A1,413,080

Product B659,637

Product C335,961

Product D134,675

Product E130,788

Product F113,214

Product G93,072

Scanned Codes by District · District: All ⌄

Scanned Codes by City · City: All ⌄

City 1City 2City 3City 4City 5…

Earning Transaction Details

TransID	User ID	Name	ContactNo	Points	Value	Product	Date
1	1	XXXXX	01XXXXXXXXX	100.00	10.00	Product A	05-Feb-30
2	2	XXXXX	01XXXXXXXXX	120.00	12.00	Product B	22-Mar-30
3	3	XXXXX	01XXXXXXXXX	40.00	4.00	Product C	22-Mar-30
4	4	XXXXX	01XXXXXXXXX	90.00	9.00	Product D	22-Mar-30
Total				34,968,970	3,496,897

No. of Scans — Type A vs B

Type A (81%)Type B (19%)

ScanRise — Scan-to-Earn Earning Analytics

Scan-to-earn analytics: value earned from scanned products, welcome points, active earners, generated vs scanned codes, per-user averages — with scan geography by district and city, and product-level scanner insights.

POWER BIAZURE MAPSDAXSQL

PointPerksPoints & Partner Network

Partner Name: All ⌄

Branch Name: All ⌄

Contact No: All ⌄

2,790,470Spent Value "Units"

12,488Points Spenders

8.97Avg TRX / User

69.17Avg Value / TRX

223.45Avg Value / User

Spending Rate Trend

Monthly % spent vs earned

JanMarMayJulSepNov

Spending Details

TransID	User ID	ContactNo	Name	Points	Value	Branch	Time
1	1	01XXXXXXXXX	XXXXX	460.00	46.00	Partner 1 (Online)	23:30
2	2	01XXXXXXXXX	XXXXX	300.00	30.00	Partner 2 (Online)	23:28
3	3	01XXXXXXXXX	XXXXX	110.00	11.00	Partner 2 (Online)	20:19
4	4	01XXXXXXXXX	XXXXX	400.00	40.00	Partner 3 (Online)	17:38
5	5	01XXXXXXXXX	XXXXX	200.00	20.00	Partner 2 (Online)	15:08
Total				27,904,699	2,790,469

Spending Rate

0.00%100.00%

Branches by Spent Value & Spenders

Partner 1 (Online)788,849

Partner 3 (Online)298,212

Partner 2 (Online)272,973

Branch 470,932

Branch 569,555

Branch 664,514

Partners by Spent Value & Spenders

Partner 1Partner 2Partner 3Partner 4Partner 5Partner 6Partner 7

PointPerks — Points Spending Analytics

Points-spending analytics for a partner network: spent value, spender counts, per-user averages, monthly spending-rate trend, a spending-rate gauge, and partner/branch league tables with combined bar-line visuals.

POWER BIDAXSQL

MemberHubMembership Analytics

City: All ⌄

Contact No: All ⌄

31,811Total Registrations

16,229,030.70Current Points Balance

1,622,903.10Sum of Value Balance

Entry Date01/01/2029 — 01/01/2030 ●━━━━━━━━━━━━●

User Current Status

User ID	Name	ContactNo	Points	Value	Entry Date
1	XXXXX	01XXXXXXXXX	330.00	33.00	21-May-30
2	XXXXX	01XXXXXXXXX	60.00	6.00	21-May-30
3	XXXXX	01XXXXXXXXX	260.00	26.00	21-May-30
4	XXXXX	01XXXXXXXXX	830.00	83.00	21-May-30
5	XXXXX	01XXXXXXXXX	230.00	23.00	21-May-30
6	XXXXX	01XXXXXXXXX	90.00	9.00	21-May-30

Monthly New Registrations

JanFebMarAprMayJunJulAugSepOctNovDec

Users Breakdown: Earners vs Spenders vs Total

SpendersEarnersTotal Users

City-wise Registrations

(Blank)City 1City 2City 3

MemberHub — Members & Registrations

Membership analytics: total registrations, live points balance and value liability, per-member status table, monthly registration trend, earner/spender segmentation, and city-wise registration distribution.

POWER BIDAXSQL

crave.food experiences you crave

76.59KTotal Universe

676.07KOverall Balance

1022 1.33%Active Users

2438Earning TRXs

90.86KTotal Spend in JD

11.01KEarned Points Value

37.27Avg Spend / Customer

2.39Purchase Frequency

491 48.04%Spenders (Post Nov)

1936 79.4%Spending TRXs (Post Nov)

55.37K 60.9%Spent Points Value (Post Nov)

28.60Avg Spend (Post Nov)

3.94Spend Frequency (Post Nov)

112.76Avg Spent Value / User

Earners vs Spenders by Channel

EarnersSpenders · DeliveryDine InApp

Cardholders by Tier

Tier 1Tier 2Tier 3

Spending Rate (Since Inception)

Breakage Rate

Restaurant Group — Tiers, Channels & Breakage

Executive one-pager for a multi-brand restaurant group: member universe and balances, earning and spending KPIs since inception vs post-relaunch, tier distribution, channel analysis across dine-in / delivery / app, and spending-rate and breakage-rate gauges.

POWER BIDAXSQL

Aurex — EarningBullion Rewards

Product: All ⌄

Merchant: All ⌄

Branch: All ⌄

Year: All ⌄

Quarter: All ⌄

Card Type: All ⌄

567.03Earned Amount

56,703Earned Points

14Earners

99Earning TRXs

5.73Avg Value / TRX

40.50Avg Value / Customer

7.07Avg TRX / Customer

Merchants by Earned Value

Merchant 1491

Merchant 255

Merchant 315

Merchant 46

Branches by Earned Value

Branch 1 (HQ)Branch 2Branch 3Branch 4

Earning Amount Trend

May · 402June · 165

Member Ledger

ID	Name	ContactNo	Points	Amount
1	XXXXX	01XXXXXXXXX	9,200	92.00
2	XXXXX	01XXXXXXXXX	7,603	76.03
3	XXXXX	01XXXXXXXXX	5,000	50.00
4	XXXXX	01XXXXXXXXX	3,000	30.00
Total			56,703	567.03

Earned Products

Total products earned by members

Product 5g32

Product 2.5g18

Product 1g13

Product X8

Coin 17

Product 50g6

Product 10g5

Coin 0.52

Precious-Metals Retailer — Points & Products

Earning analytics for a gold & bullion retailer: earned amount and points, earner counts and per-customer averages, merchant and branch value splits, a monthly amount trend, product mix across ingots and coins, and a dummy member ledger.

POWER BIDAXEXCEL

World Cup CampaignFlags & Vouchers Raffle

2,293Codes Used

1,422Total Winners

2,293Flags Awarded

1,927Received Vouchers

Won Flags vs Voucher Requests

Flags 50%Vouchers 50%

Weekly Performance by Day

Thu · 711Wed · 695Tue · 480Mon · 377Sun · 30

City-wise Winner Distribution

City 1City 2City 3City 4City 5…

Awarded Flags Leaderboard

Countries ranked by total flags awarded

Country 11,440

Country 227

Country 326

Country 424

Country 523

Country 622

Daily Campaign Activity

Codes issued vs winners recorded each day

Codes issuedWinners · Day 1 → Day 5

World Cup Raffle Campaign — Live Campaign Health

Real-time dashboard for a flags & vouchers raffle campaign: codes used, winners, flags awarded, and vouchers received, with weekly and daily activity trends, a flag-country leaderboard, and city-wise winner distribution — plus winners, customers, raffles, and merchant-performance pages.

POWER BIDAXPOWER QUERY

لوحة تحليل مبيعات الشاحناتتحليل أداء المبيعات حسب الفروع ونوع الشاحنة

7.598Kاجمالي مبيعات الكاشير

5.068Kاجمالي التحصيل من الشبكة

2.53K ر.ساجمالي التحصيل من الكاش

--إجمالي العجز

نسبة عدد عمليات البيع لكل عامل من إجمالي العمليات

عامل 1 · 16.67%عامل 2 · 16.67%عامل 3 · 8.33%عامل 4عامل 5…

نسبة مساهمة كل عامل من إجمالي المبيعات

عامل 1 (53.9%)عامل 2عامل 3عامل 5

قيمة المصروفات طبقا لنوعها والفرع

فرع 1فرع 2فرع 3فرع 4فرع 5 · رواتبوقودصيانةأدوات

Truck Sales Analysis — Arabic RTL Dashboard

Fully right-to-left Arabic report for a mobile truck-sales operation: cashier sales, network vs cash collections, deficit tracking, per-worker sales contribution and share of transactions, and expense breakdown by type across five branches. All worker and branch names are dummy placeholders.

POWER BIDAXRTL DESIGN

Fleet OperationsDelivery & Logistics Analytics

1,248Active Vehicles

96.2%On-time Delivery

3.4MKM This Month

18,420Deliveries Completed

214Open Tickets

Deliveries per Day

MonTueWedThuFriSatSun

Top Routes by Volume

Route 14,120

Route 23,305

Route 32,660

Route 41,884

Route 51,290

Route 6735

Vehicle Status

ActiveIdleMaintenance

Driver Log

ID	Driver	ContactNo	Trips	On-time %	KM
1	XXXXX	01XXXXXXXXX	112	98.4%	8,420
2	XXXXX	01XXXXXXXXX	104	97.1%	7,960
3	XXXXX	01XXXXXXXXX	98	95.8%	7,310
4	XXXXX	01XXXXXXXXX	91	95.2%	6,884

Fleet & Delivery Operations — Logistics Analytics

Operations control view for a delivery fleet: active vehicles, on-time rate, distance covered, daily delivery trend, top routes by volume, vehicle status split, and a per-driver performance log with masked identities.

POWER BIDAXSQL

FreshMartRetail Sales & Inventory Analytics

4.82MNet Sales

128KBaskets

37.66Avg Basket Value

22.4%Promo Share of Sales

3.1%Shrinkage Rate

Sales by Month

JanFebMarAprMayJunJulAugSepOctNovDec

Top Categories by Sales

Category 11.21M

Category 2902K

Category 3710K

Category 4522K

Category 5368K

Category 6241K

Payment Methods

CardCashWallet

Supermarket Chain — Sales & Category Performance

Commercial dashboard for a grocery retail chain: net sales, basket count and average value, promo contribution and shrinkage, monthly sales seasonality, category league table, and payment-method mix — filterable by store and period.

POWER BIDAXPOWER QUERY

People AnalyticsHR, Attendance & Workforce

1,032Employees

94.1%Attendance Rate

6.8%Turnover (12M)

41Open Positions

3.2Avg Overtime hrs / week

Attendance Trend

Present %Absence %

Headcount by Department

Dept 1284

Dept 2221

Dept 3174

Dept 4130

Dept 595

Dept 664

Employee Satisfaction

Employee Directory

ID	Name	ContactNo	Department	Attendance	Overtime
1	XXXXX	01XXXXXXXXX	Dept 1	98.2%	2.1h
2	XXXXX	01XXXXXXXXX	Dept 2	96.7%	4.0h
3	XXXXX	01XXXXXXXXX	Dept 1	95.4%	1.5h
4	XXXXX	01XXXXXXXXX	Dept 3	94.9%	3.2h

People Analytics — HR, Attendance & Workforce

Workforce dashboard: headcount, attendance and turnover rates, open positions, overtime load, present-vs-absent trend, department headcount league, a satisfaction gauge, and an employee directory with masked identities.

POWER BIDAXEXCEL

World Cup Campaign — WinnersFlags & Vouchers Raffle

966Total codes used

584Total Winners

962Flags Won

859Vouchers Won

SourceSelect all · CodeUse · ManualAward

Won Flags vs Voucher Requests

Flags 52.8%Vouchers 47.2%

Gender Distribution of Winners

MaleFemale

City-wise Winner Distribution

City 1830

City 2761

City 3314

City 4133

City 570

Awarded Flags Leaderboard

Countries ranked by flags awarded

Country 1591

Country 214

Country 314

Country 412

Country 511

Winners Detail

code	phone	first_name	age	gender
CODE-0001	01XXXXXXXXX	XXXXX	40	Female
CODE-0002	01XXXXXXXXX	XXXXX	25	Female
CODE-0003	01XXXXXXXXX	XXXXX	26	Female
CODE-0004	01XXXXXXXXX	XXXXX	33	Male

Raffle Campaign — Winners Deep-Dive Page

Second page of the raffle campaign report: codes used, winners, flags and vouchers won by source, flags-vs-vouchers split, gender and city distribution of winners, a country leaderboard, and a winners detail table with fully masked identities.

POWER BIDAXPOWER QUERY

Call Center Performance Comparison2029 vs 2030 · Calls, Orders & Complaints

574,311Total Calls

26,606Total Orders

19,821Total Complaints

Call Volume by Direction

Inbound vs Outbound · 2029 / 2030

Inbound128,407

106,495

Outbound123,735

54,011

In/Out150,728

10,935

Daily Call Volume

Calls by day of the month

InboundIn/OutOutbound · Jan → May

Complaints by Type

Type 1Type 2Type 3Type 4Type 5

Daily Complaint Volume

20292030

Daily Order Volume

20302029

Call Center Performance — Year-over-Year Comparison

Operational comparison across two years: call volume by direction, daily call trends across three lines, complaint-type breakdown, and daily complaint and order volumes — with slicers for queue, direction, complaint type, city, and period.

POWER BIDAXPOWER QUERY

blush.Makeup Sales Performance — top products, revenue impact & demand patterns

15KTotal Quantity

9KSold Quantity

238.07KTotal Sales

49.28KTotal Cost

188.78KProfit

Sold vs Available Quantity

How efficiently stock converts into sales

Available 62.7%Sold 37.3%

Inventory

Inventory	Total Qty	Qty Share	Sold Qty	Sales Share
Group 1	3,625	16.32%	1,492	16.46%
Product A	434	2.64%	241	1.80%
Product B	404	0.95%	87	0.89%
Product C	359	0.21%	19	0.28%
Total	15,380	100%	9,140	100%

Top 10 Categories by Sales Volume

Category 1Category 2Category 3…Category 10 · sold qtytotal sales

Branch Sales Volume Performance

Branch 12,433

Branch 22,327

Branch 31,492

Branch 41,308

Branch 5720

Branch 6578

Cosmetics Brand — Makeup Sales Performance

Elegant rose-gold commercial report: quantity, sales, cost, and profit KPIs, sold-vs-available conversion donut, a drillable inventory matrix with quantity and sales shares, top-10 category dual-axis chart, and branch sales league — all products and branches anonymized.

POWER BIDAXEXCEL

TerraBuild MaterialsContractor Rewards · Project / Campaign

Spent Amount3.17M

Total Customers213

Reward Users156

Non Users57

Total Topup3.45M

Customers Balance2.18M

Reward Transactions3,898

AVG Spend Amount288

Avg TRX / Customer25

Spent Amount by Month

Jan 29Feb 29…Nov 30Dec 30

Most Recent Tier

Select all

Tier 1

Tier 2

Tier 3

Tier VIP

Tier Super

Building-Materials Producer — Contractor Rewards & Top-Ups

B2B rewards tracking with a bold block-card design: spent amount, customer and reward-user counts, balances and top-ups, average spend and transaction frequency, a two-year monthly spend comparison, and tier segmentation — switchable between project and campaign views.

POWER BIDAXEXCEL

What clients say

Khamsat reviews

Mohammed T.عميل — خمسات

شكرا جزيلا بشمهندسة ندى، الله يكثر من امثالك، انجاز في وقت قياسي والعمل اكثر من رائع، اتمنى لك كل التوفيق.

★★★★★

Mgeed S.عميل — خمسات

ندى حقيقي مميزة ومتجاوبة بشكل سريع ومتجاوبة لأي تعديل احتاجه. شكرا ندى واكيد مش حتكون آخر مرة اتعامل معاك بإذن الله.

★★★★★

Amr A.عميل — خمسات

عن تجربة، انصح وبقوة بالتعامل مع الاستاذة ندى، سريعة في الرد، شغل متقن واكثر من رائع، عملت المطلوب واكثر. شكرا وبارك الله فيك، واكيد راح اتعامل مرة ثالثة ان شاء الله.

★★★★★

Basheer A.عميل — خمسات

"إذا أردت التعامل مع الأفضل في مجال تحليل البيانات، فلا تبحث بعيدًا عن المهندسة ندى. إنها مثال حقيقي للإبداع والاحترافية، تمتلك رؤية تحليلية عميقة وقدرة مذهلة على تحويل البيانات إلى قرارات استراتيجية. تعاملها الراقي، دقتها الفائقة، وسرعتها في الإنجاز تجعلها أحد أفضل المختصين الذين تعاملت معهم على الإطلاق."

★★★★★

Basheer A.عميل — خمسات · تعامل متكرر

للمرة الثانية على التوالي: "المهندسة ندى محترفة للغاية في تحليل البيانات، واهتمامها بالتفاصيل ودقتها في العمل جعلت التعاون معها تجربة رائعة. أنصح بشدة بالتعامل معها لأي شخص يحتاج إلى خدمة عالية الجودة."

★★★★★

سناء ا.عميلة — خمسات

تعاملت معها وكانت التجربة أكثر من رائعة! شخصية في غاية اللطف والذوق، متعاونة جدًا، وتتقبل الملاحظات والتعديلات بكل رحابة صدر واهتمام بالتفاصيل. سريعة في الإنجاز، دقيقة في العمل، وتجاوبها مستمر ويعكس احترافية عالية. بصراحة من أفضل التجارب، وأنصح بالتعامل معها بكل ثقة.

★★★★★

Get in touch

For project inquiries, questions, or collaborations, you can reach me through any of these:

✉ nadamghrabia@gmail.com Upwork ↗ Khamsat ↗ Resume ↗ Instagram ↗ TikTok ↗