Data cleaning & transformation
Removes duplicates, fills missing values, standardizes text, and reshapes data for analysis.
BEFORE WE BEGIN...
Every great story starts with a connection.
Mohammad Hassan
Data Analyst
Interactive data visualization experience
DATA ANALYST
Turning Raw Data Into Meaningful Decisions
9,994
Records in dataset
5,009
Orders in dataset
25,123
Units in dataset
4
Regions in dataset
Dataset metrics — Superstore Sales
0+
Projects built
0+
Years learning
0%
Passion
0∞
Possibilities
Dashboard signal
Excel analysis
workbook view
Total sales
₹5.82M
Orders
5,009
Units
25,123
Process
From signal to strategy.
Raw DataDecision
Raw Data
Signals × sensors × CRM × web events
Transform
Cleansing, shaping, impact scoring
Analyze
Forecasting, anomaly detection, cohorts
Visualize
Narrative dashboards and live models
Insight
Patterns, risk, opportunity, velocity
Decision
Operational action and strategic moves
Workflow
The data workflow behind this portfolio.
This portfolio demonstrates the analytics workflow I use on data: import, clean, transform, analyze, and visualize.
Workflow stepsData flow
Import data
Clean & transform
Visualize results
Structured querying (SQL)
Extracts meaningful insight from relational data using CTEs, joins, and window functions.
Dashboard design
Builds interactive Excel dashboards that turn analysis into clear, filterable reports.
Dataset overview
The data behind the dashboard.
Superstore Sales dataset
9,994
Records in dataset
5,009
Orders in dataset
25,123
Units in dataset
4
Regions in dataset
Learning path
Analytics journey.
2022
Analytics foundation
Started learning Excel, Power Query, and SQL for data analysis.
Signal
2023
Dashboard development
Built interactive dashboards from the Superstore dataset.
Signal
2024
Certificates earned
Completed Excel and Power BI certifications on Coursera and Microsoft Learn.
Signal
2025
Portfolio development
Built this interactive cinematic portfolio to showcase analytical work.
Signal
Skill galaxy
A practical orbit around data analytics.
DataAnalytics
Explore the orbit
Capabilities over credentials.
Select a node to pause the orbit and see how that skill is used in a real analytical workflow.
Live projects
Projects that keep moving.
Verified project
Sales Analytics Dashboard
An Excel dashboard built from the Superstore dataset with regional, category, and revenue analysis.
Dashboard previewExcel workbook
₹5,820,182
Total sales
5,009
Transactions
Category selector
₹0K
All sales
Delhi · Mumbai · Bengaluru
Case studies
The thinking behind the dashboard.
BUSINESS PROBLEM
The project README defines the need for a centralized, interactive view of sales performance, transactions, quantity, regions, categories, customer segments, shipping modes, cities, and monthly trends.
DATA
The supplied Superstore workbook contains 9,994 rows with order dates, shipping modes, customer segments, regions, cities, categories, product details, price per unit, and quantity.
TRANSFORMATION
Prepared the raw sales table for Excel Tables, Pivot Tables, Pivot Charts, KPI cards, slicers, and dynamic filtering.
ANALYSIS
The dashboard compares ship-mode sales, region-wise activity, monthly quantity ordered, top cities, category sales, and customer-segment quantity.
INSIGHT
Verified workbook findings: total sales ₹5,820,182.28; West leads regional sales at ₹1,832,991.01; Technology leads category sales at ₹2,180,373.25; Consumer leads segment sales at ₹2,923,455.62; New York City is the top city at ₹654,439.40.
IMPACT
Outcome: a reusable Excel dashboard that turns the Superstore table into filterable KPI reporting and business-focused visual analysis. No business uplift is claimed.
Dashboard preview
Repository
The workbook, source data, README, and dashboard implementation are documented in the project repository.
Open GitHub repositoryAnalyst profile
The person behind the signal.
Analytical profile
Mohammad Hassan
Data Analyst
Data is not just numbers. It’s a story waiting to be understood.
Skills
Excel
Power Query
SQL
Power BI
Tools
Pivot tables
Power Pivot
Scenario models
M language
Merge queries
Focus areas
Data cleaning & transformation
Structured querying (SQL)
Dashboard design
Career / learning path
Portfolio timeline2022
Analytics foundation
2023
Dashboard development
2024
Certificates earned
2025
Portfolio development
Experience
A timeline of the work and direction.
Active milestone
Desktop Support Engineer
Active
Role supplied by Mohammad Hassan. Experience details can be expanded when the specific dates and responsibilities are provided.
Relevant skills
Technical support
Problem solving
Connected project
Sales Analytics Dashboard
Selected from the portfolio project configuration.
Certificates
Proof points, presented clearly.
No certificates added yet.
Certificate records will appear here once a title, issuer, date, and optional credential link are added to the certificate configuration.
Carousel navigation will activate when certificates are added.
Contact
LET'S TURN DATA INTO OPPORTUNITIES.
$ connect --analyst
01
YOU02
INBOX03
MOHAMMAD HASSANI'll respond to your message soon.