Data Analysis

DATA ANALYSIS · INTERACTIVE PORTFOLIO

TURNING
DATA INTO
REAL IMPACT.

From raw, messy data to clean models, meaningful analysis, interactive dashboards and real business decisions.

EXPLORE MY WORK →
RAW DATA
▦
NULLS · DUPLICATES
CLEAN
✦
POWER QUERY
MODEL
⌘
RELATIONSHIPS
ANALYZE
⌁
DAX · STATS
VISUALIZE
▥
DASHBOARDS
DECIDE
◈
BUSINESS IMPACT
0+Dashboards Created
0MZ Academy Students
0GDG GUC Students
0+Hours of Training
01LIVE ANALYTICS LAB

Touch the stack.
Watch data transform.

Choose a tool. The entire workstation changes with it — workflow, dataset, logic and output.

DATASET_01 / CUSTOMER_ORDERS
CustomerCityOrder DateAmount
ahmed cairo1/5/241,000
AHMEDCAIRO 2024/01/051000.00
saraAlex5-Jan-242,500
mohamedalexandria 01-06-24500
NULLGiza06/01/24NULL
02DATA PIPELINE EXPERIENCE

Watch raw data become a decision.

The pipeline is alive. Move through the stages and watch quality rise, errors collapse, relationships connect and insight emerge.

PIPELINE STATERAW DATA INGESTED

1,000 rows enter the system with inconsistent text, null values, duplicates and mixed formats.

70%DATA QUALITY
BUSINESS QUESTION ENGINE

Ask the data. Follow the intelligence.

SQL→PYTHON→POWER BI→INSIGHT
LIVE ANSWERCairo leads revenue contribution at 42%.

SQL aggregates regional sales, Python validates the distribution, and Power BI turns the result into a decision-ready view.

03FEATURED DASHBOARDS

From numbers to
visual decisions.

A living gallery inspired by real business reporting — finance, sales, operations and education. Hover a dashboard to bring its data layer forward.

01 / FINANCEEXECUTIVE HOTEL PERFORMANCELIVE MODEL
TOTAL REVENUE$2.48M+12.4%
GOP MARGIN38.7%+3.1%
REVPAR$184+8.6%
ACTUAL vs BUDGET · MTD / YTD · PROFITABILITY
02 / SALESSALES PERFORMANCE COMMANDLIVE MODEL
NET SALES$1.92M+16.8%
ORDERS14.8K+9.3%
CONVERSION4.7%+0.8%
74%

North

Central

South

PRODUCT · REGION · CHANNEL · CUSTOMER
03 / OPERATIONSOPERATIONS CONTROL CENTERLIVE MODEL
ON-TIME RATE96.2%+2.7%
AVG CYCLE2.4d-11%
ALERTS07WATCH
THROUGHPUT · PRODUCTIVITY · MANAGEMENT ALERTS
04 / EDUCATIONMZ ACADEMY LEARNING ANALYTICSLIVE MODEL
STUDENTS31ACTIVE
PROJECTS10+PORTFOLIO
CONTENT90hPROGRAM
EXCELSQLPYBI
ATTENDANCE · GRADES · PROJECTS · PROGRESS
04MAZIN NABIL × MZ BUSINESS

MY ANALYTICS WORK.
Built for decisions.

Seven real analytics projects designed and developed by Mazin Nabil across business, retail, healthcare, finance and real estate.

DESIGNED & DEVELOPED BYMAZIN NABILMZ BUSINESS
01 / 07COMPANY PERFORMANCE
COMPANY PERFORMANCE dashboard by Mazin Nabil
PROJECTExecutive Performance
FOCUSExecutive BI · Revenue · Profitability
STACKPOWER BI · DAX · DATA MODELING
02 / 07TOYS STORE CHAIN
TOYS STORE CHAIN dashboard by Mazin Nabil
PROJECTRetail Sales
FOCUSSales · Stores · Products · Trends
STACKPOWER BI · DAX · DATA MODELING
03 / 07CLINICAL ANALYTICS
CLINICAL ANALYTICS dashboard by Mazin Nabil
PROJECTHealthcare
FOCUSPatients · Clinical KPIs · Outcomes
STACKPOWER BI · DAX · DATA MODELING
04 / 07INVESTMENT PORTFOLIO
INVESTMENT PORTFOLIO dashboard by Mazin Nabil
PROJECTFinance
FOCUSPortfolio · Allocation · Performance
STACKPOWER BI · DAX · DATA MODELING
05 / 07REAL ESTATE SALES
REAL ESTATE SALES dashboard by Mazin Nabil
PROJECTReal Estate
FOCUSSales · Property · Region · Agents
STACKPOWER BI · DAX · DATA MODELING
06 / 07BUSINESS ANALYSIS
BUSINESS ANALYSIS dashboard by Mazin Nabil
PROJECTBusiness Intelligence
FOCUSKPIs · Trends · Operational Insight
STACKPOWER BI · DAX · DATA MODELING
07 / 07HOSPITAL PATIENT ANALYTICS
HOSPITAL PATIENT ANALYTICS dashboard by Mazin Nabil
PROJECTHealthcare
FOCUSPatient Flow · Demographics · Performance
STACKPOWER BI · DAX · DATA MODELING
07PROJECTSMULTIPLEINDUSTRIESONEANALYTICAL MINDSET
05DATA ANALYST ECOSYSTEM

One analyst.
Four connected engines.

EXCELCleaning · Formulas · Pivot Tables · Business Analysis
POWER BIData Modeling · DAX · Interactive Dashboards · Storytelling
MAZIN NABILDATA ANALYST
SQLQueries · Joins · CTEs · Window Functions · Databases
PYTHONPandas · NumPy · Analysis · Visualization · Automation