mohamed abdelwahab mohamed elzahaby

Data Analyst

Data Analyst with hands-on experience in data cleaning, data modeling, and dashboard development using Power BI, SQL, Excel, and Python. Skilled in building Star Schema models, creating DAX measures, and transforming raw data into actionable business insights. Developed end-to-end analytics projects involving ETL, data visualization, KPI tracking, and performance analysis.

Tanta, Egypt

Projects

Olist E-Commerce Sales Dashboard

Cleaned and transformed data from 9 tables using Power Query, including merging, aggregation, and data modeling preparation. Built a Star Schema data model with

Cleaned and transformed data from 9 tables using Power Query, including merging, aggregation, and data modeling preparation. Built a Star Schema data model with Orders as the central fact table and multiple dimension tables. Created a Date Table and developed DAX measures for Revenue, Orders, Customers, Delivery Rate, Purchase Frequency, and Review Score. Resolved one-to-many relationship issues by aggregating Payments and Reviews data at the order level. Designed interactive dashboards with KPIs, Revenue Trends, Geographic Analysis, Order Status Tracking, and Top/ Bottom Performance analysis. Developed custom regional segmentation using DAX to improve sales analysis and executive reporting.

Power BIPower QueryDAX

Project link

Retail Sales Analytics Dashboard

Cleaned, transformed, and modeled sales data using Power Query and Star Schema design. Created DAX measures and KPIs including Sales, Profit, Profit Margin, Ret

Cleaned, transformed, and modeled sales data using Power Query and Star Schema design. Created DAX measures and KPIs including Sales, Profit, Profit Margin, Returns, Orders, and YoY Growth. Built a Date Table and implemented time intelligence with active and inactive relationships. Developed interactive dashboards using Power BI (Cards, Maps, Treemap, Matrix, Line & Bar Charts). Analyzed sales performance by region, store, product, and brand to identify business trends and opportunities.

Power BIPower QueryDAX

Project link

Sales Performance Dashboard

Cleaned and transformed sales data using Power Query. Designed a Star Schema data model with DAX Calendar Table. Implemented active and inactive relationships f

Cleaned and transformed sales data using Power Query. Designed a Star Schema data model with DAX Calendar Table. Implemented active and inactive relationships for time-based analysis. Created DAX measures for Sales, YTD Sales, Average Sales, and Max Sales. Built interactive Power BI dashboards with KPIs, Charts, Maps, and Drill-Down Analysis. Analyzed sales performance across products, regions, states, and cities.

Power BIPower QueryDAX

Project link

Skills

Data AnalysisBusiness IntelligenceData VisualizationReporting & InsightsExcelPower BIPythonSQLStatisticsProblem SolvingAnalytical ThinkingAttention to DetailCommunication SkillsTeamworkTime Management

Education

Bachelor of law

Tanta University

Oct 2020 - Jun 2024

Other

Links

LinkedIn CV

Contact

Open to work

Let’s connect. Choose the fastest way to reach me.

mohamedelzahaby04@gmail.com

Fastest response via email.

Email me

Phone

01224314632

Call WhatsApp