Home About & Skills Projects Services Education & Training Contact
Junior Data Analyst

Antonuo Nasr

Power BI SQL Server Excel Python

Turning raw data into clear, decision-ready insights.

Antonuo Nasr, Data Analyst
Dashboards for e-commerce, retail & pricing — 17,049+ orders analyzed
About

A Junior Data Analyst who turns messy data into dashboards you can act on.

I'm a Junior Data Analyst. I take raw, messy data — spreadsheets, exports, databases — and turn it into clear reports that show what's happening in your business and what to do next. I work with Power BI, SQL Server, Excel and Python, and I care about the whole path: from the first untidy file to the final chart on your screen.

In practice, I build interactive Power BI and Excel dashboards around the KPIs you really track, clean and prepare inconsistent data with Power Query, SQL and Python so the numbers can be trusted, and design normalized SQL Server databases with T-SQL queries that keep reporting accurate as your data grows. On top of that, I do customer, pricing and sales analysis that points to a next step instead of only describing the past.

My work so far spans e-commerce customer behavior (17,000+ orders analyzed on a normalized SQL Server schema), pricing and discount strategy (1,351 Amazon products — where the data showed that deep discounts don't lift ratings), and retail and regional sales reporting built in both Power BI and Excel. The projects below are a selection, and more is available on request.

I'm a junior analyst, and I work like one who wants to earn the next project: I ask which decision the data needs to support before building anything, explain every number in plain language, and keep you updated at each step. You get focused attention and a dashboard you can actually use — not a pile of charts.

01Understand the question
02Clean & model the data
03Build the dashboard
04Hand over & explain
E-commerce analytics
Pricing & discounts
Retail & sales
Customer segmentation
Trend analysis
BI reporting
17,049+e-commerce orders analyzed
1,351Amazon products analyzed
70+T-SQL queries written
4core tools: Power BI, SQL, Excel, Python
Tools & skills

Tools I use to turn raw data into insight

Visualization & reporting

Power BI
DAX
Excel — PivotTables & PivotCharts
Data visualization

Data preparation

Power Query (ETL)
Data cleaning & validation
Python — pandas, openpyxl

Databases & modeling

SQL Server / T-SQL
Relational database design
Data modeling
Selected work

Dashboards, built end to end

A selection of my work across Power BI, Excel and SQL Server — from Amazon pricing and ratings to e-commerce customer behavior and regional and retail sales reporting. More projects available on request.

e-commerce-behavior-dashboard.pbix
E-commerce dashboard — sales by city and category E-commerce dashboard page 2 — customer-to-city flow, discounts by category, rating vs satisfaction, quantity by customer and sales by category
Team project · DEPI graduation project

E-Commerce Customer Behavior Analysis Dashboard

A multi-page Power BI dashboard analyzing customer behavior for an e-commerce platform in the Turkish market. Normalized a flat dataset into a relational schema and wrote 70+ T-SQL queries across 18 categories before building the interactive dashboards — tracking sales by region and category, delivery performance, and customer satisfaction. Built as a four-person DEPI graduation team with Kholoud Mohamed, John Hany and Hager Ahmed.

17,049+ orders analyzed
5,000+ customers
70+ T-SQL queries
21.8M+ total order value
SQL Server T-SQL Power BI DAX Data Modeling
Open full project Full presentation, read-only
sales-dashboard.xlsx
Personal Excel sales dashboard with charts and slicers
Solo project

Personal Excel Sales Dashboard

A fully interactive one-page Excel dashboard built from order-level data — dynamic filters for product, month, region, category and salesperson feed live KPI cards and charts.

$1.15M+ total sales
200 orders
29.82% profit margin
Excel PivotTables Slicers
Open full project Read-only view
sales-dashboard.pbix
Power BI order-level sales dashboard
Solo project

Power BI Sales Dashboard — Order-Level Analysis

An order-level sales analytics dashboard tracking order status, territory performance and product subcategory sales across multiple markets.

1,465 orders
23,603 order line items
$34.15M total amount
Power BI DAX
View full report Full report (PDF)
mini-project-2.pbix
Solo project · Mini-Project 2

Superstore Executive Sales Dashboard

An interactive Power BI executive dashboard built to monitor sales, profitability and product performance across the Superstore dataset. It combines KPI tracking, year-over-year growth, category profitability, top products, geographic sales analysis and detailed sub-category performance in a decision-focused report.

$2.90M total sales
$360K total profit
12.41% profit margin
55.12% YoY growth
Power BI DAX Data Visualization KPI Analysis
View full report Full report (PDF)
superstore-dashboard.xlsx
Superstore Excel dashboard with slicers and charts
Solo project

Mini-Project 1 — Superstore Retail Analysis

Cleaned and restructured the Sample Superstore dataset in Power Query, then built five PivotTables, Pivot Charts and interactive slicers into a one-page retail performance dashboard.

$2.3M total sales
$286K total profit
West top region
Excel Power Query PivotTables
Open full project Read-only view
Services

Data analysis services

Practical help at every stage — from tidying a messy spreadsheet to delivering a dashboard your team opens every morning.

Dashboard design & development

Interactive Power BI and Excel dashboards built around the KPIs and questions that matter to your business.

Data cleaning & preparation

Turning messy, inconsistent spreadsheets into clean, analysis-ready datasets with Power Query, SQL and Python.

Database design & SQL querying

Structuring normalized relational databases and writing efficient T-SQL queries so reporting stays accurate as data grows.

E-commerce & customer analytics

Customer behavior, pricing and discount analysis for online stores — who's buying, what they're buying, which discounts pay off, and where satisfaction drops.

Sales & performance reporting

Recurring reports that track the KPIs that matter — by region, product, salesperson or period — without manual rebuilding.

Ad-hoc data analysis

Quick-turnaround analysis and insight reporting when you need a clear answer, not a multi-week engagement.

Have a dataset and a question?

Send me a short description — I'll tell you honestly how I can help.

Start a conversation
Background

Education & training

Last academic year
Database course — Grade: Excellent
Studied databases and finished the course with an Excellent grade.
Since Jul 2026
DEPI Data Analysis Track
Digital Egypt Pioneers Initiative
Intensive hands-on training across Excel, Power BI and SQL Server — the program behind most of the dashboards in this portfolio.
Jul 2026
NTI Summer Training
National Telecommunication Institute — Completed
Freelancing fundamentals, project planning and pricing strategy; designed a tiered Power BI service offering for freelance clients.
Contact

Let's talk about your data.

Whether you are hiring a Junior Data Analyst or need help turning business data into a clear report, I'd like to hear about it. I'm based in Egypt and open to entry-level Data Analyst roles, internships and freelance analytics projects.

Entry-level rolesInternshipsFreelance projects