MZANALYTICS WORKSPACE
● SECURECAIRO HQ09:14 AMMN
ASSIGNED TO YOUSenior Management Analytics Request
P1 · HIGH PRIORITY
DUEToday · 4:00 PM
Microsoft Teams · CEO Office“Need the numbers before the 4 PM review. Show me what is driving the problem — not just a chart.”
MZ ACADEMY // INTERACTIVE EXPERIENCE

ENTER THE ANALYST SEAT

Clean the data. Find the signal. Build the insight. Make the decision.

LIVE SIMULATION MISSION SELECT
ANALYST XP000 / 700
MISSION CLOCK00:00
STREAK0×
MZ DATA LAB // MISSION COMMAND CENTER

CHOOSE YOUR ANALYST MISSION

Four industries. Four datasets. One evolving analyst career.

CAREER LEVELTRAINEE0 / 4 MISSIONS
CERTIFICATION PROGRESS // 0%
SIMULATION MODEHints enabled · standard scoring
INCOMING BRIEF // RETAIL OPERATIONS

Revenue is falling. Management needs an answer.

You have been given a dirty order dataset from four Egyptian branches. Your job is to identify the weakest branch, explain the performance gap, and recommend an action.

ROWS1,000BRANCHES4ISSUES4
CEO_REQUEST.txt ● ● ●
> BUSINESS QUESTION

"Where are we losing performance,
and what should we do next?"

> DEADLINE: NOW
> CONFIDENCE REQUIRED: HIGH
SYSTEM Simulation initialized. Awaiting mission acceptance.
DATASET_01 customer_orders.csv
QUALITY 61%
Order_IDBranchChannelRevenueDate
Resolve all four anomalies to unlock analysis.
VERSION 1.13.1 // 8-QUESTION ANALYSIS ASSIGNMENT

QUESTION 1 OF 8

Build the requested metric from the cleaned dataset.

0 / 8 COMPLETE
BUSINESS QUESTIONWhich branch generates the most revenue?
MODEL NOT BUILT
REPORT CANVAS // LIVE FROM CLEANED DATA0 clean rows
DRAG FIELDS TO BUILD THE ANALYSIS...
Complete all 8 requirements to unlock SQL.
PHASE 2 // SQL VALIDATION

Reproduce all 8 dashboard requirements in SQL.

Write and run a separate query for every KPI and chart. A single query is no longer enough.

0 / 8 QUERIES
KPI 01Select a task
Use the answer as a learning reference, then run it.
CTRL + ENTER
Choose a requirement and write its SQL.
QUERY REQUESTRank branches from highest to lowest revenue.
NOT RUN
analysis.sqlresults
SQLUTF-8Ln 1
1
Ready
No query executed
Execute the query to inspect the cleaned data.
The result must reconcile with your analysis model before you can continue.
PHASE 3 // DASHBOARD BUILD

Build the complete management dashboard.

Drag the 4 KPI cards + 4 charts onto the report canvas. Choose each chart type before dragging it. All eight validated requirements must appear on the final dashboard.

0 / 8 VISUALS
Executive Performance DashboardPAGE 1 · 16:9 · LIVE MODEL
REPORT BUILDERManagement View · cleaned model
MODEL CONNECTED
REPORT PAGE 1Executive Performance Analysis
X-AXIS / CATEGORYDROP A FIELD
Y-AXIS / VALUESDROP A FIELD
SUMMARIZATION
TOP RESULT—Build a visual
CLEAN ROWS—analysis source
GROUPS—categories
▥BUILD YOUR MANAGEMENT VISUALAssign an Axis and Value, then choose a visual.
INSIGHT ENGINEYour interpretation will appear after a valid visual is built.
FINAL DECISION

The CEO is waiting.

Which conclusion is best supported by your analysis?

DECISION ENGINE

Select the recommendation you would present to management.

MISSION COMPLETE // MZ DATA LAB

ANALYST PERFORMANCE REPORT

92/100
LEVEL: SENIOR ANALYST
DATA CLEANING 100ANALYSIS 91SQL THINKING 90BUSINESS DECISION 88
MISSION TELEMETRY // calculating performance...
MZ ACADEMY // DATA ANALYTICSI COMPLETED THE MZ DATA ANALYST CHALLENGE

Interactive portfolio experience by Mazin Nabil

DOWNLOAD MY REPORT

Add your name and explain what the data tells you. Your report includes your score, completed dashboard, and selected CEO recommendation.

Downloads a standalone HTML report. Open it to view, share, or choose Print / Save as PDF. No login required.

● Connected to MZ-DB-PRODAutosave ONRole: Data AnalystEnvironment: Production Mirror