Lead project
New Moon0% lit
Data Analysis · Business Intelligence
Mohammed Ashraf Hassan
I turn messy business data into Power BI dashboards that tell owners and managers exactly where the money is going.
End-to-end BI projects
5
Records modelled
300K+
Dimension tables designed
10
Core analytics tools
7
Bridging messy raw files and actionable business insights.
01 · Waxing Crescent · 10% litI'm a Data & BI Analyst who builds the reporting layer that business owners, sales managers, and stakeholders actually use to make decisions. My work starts where most reports fail: with the raw file. I clean it, model it into a proper star schema, define the KPIs that matter, and then design a dashboard that answers a question in one glance instead of five clicks.
My background is in Electronics & Communication Engineering, which trained me to break messy systems into measurable parts — the same instinct I now apply to sales, operations, and pricing data. Through the DEPI Junior Data Analysis Track I built three full analytics projects end to end, covering retail performance, flight pricing, and store sales.
I'm straightforward to work with: I ask what decision you need to make, then build the shortest path to it. No 40-page decks, no vanity charts.
Clear KPI definitions agreed before a single chart is built
Star-schema models so numbers never double-count
Reports designed for one-glance answers on desktop and mobile
Documented work you can hand to the next person
The tech stack and analytical methods behind my dashboards.
02 · Waxing Crescent · 35% litAnalysis & Insight
- Data Analysis
- KPI Definition
- Trend & Variance Analysis
- Root-Cause Breakdown
Visualization & Reporting
- Power BI
- Data Visualization
- Dashboard Design
- Executive Reporting
Data Preparation
- Data Cleaning
- Power Query
- Excel
- Star-Schema Data Modelling
Querying
- SQL
- Joins & Aggregations
- DAX Measures
Experience
03 · Waxing Gibbous · 65% litFreelance Data & BI Analyst — Independent
Present- Build Power BI dashboards and clean, modelled datasets for business owners and sales teams.
- Take projects from raw CSV to a decision-ready report, including KPI definitions and documentation.
Junior Data Analysis Track — Trainee — Digital Egypt Pioneers Initiative (DEPI)
Training Programme- Completed a structured analytics track covering SQL, Excel, Power Query, data modelling, and Power BI.
- Delivered the Retail Performance & Operations Dashboard as the capstone project, guided by Eng. Moataz Badran with advisory support from Hassan Ashraf.
Education
04 · Waxing Gibbous · 90% litB.Sc. Electronics & Communication Engineering
Institute of Aviation Engineering and Technology (IAET)
Engineering degree with a strong quantitative and systems-analysis core.
Junior Data Analysis Track
Digital Egypt Pioneers Initiative (DEPI)
Applied training in SQL, Excel, Power Query, data modelling, and Power BI.
Selected builds, from messy raw files to executive decisions.
05 · Full Moon · 100% litExplore interactive Power BI reports, underlying star schemas, and data pipelines. Click any project to view full-size dashboards and implementation details.
Lead project
Superstore Executive Intelligence Portal
Developed an interactive Power BI Executive Portal to track financial health, product profitability, and customer risks. Built: A multi-page dashboard featuring automated alert cards, regional financial tracking, category/shipping drill-downs, and a comprehensive slicer filter panel. Found: Discounts over 20% destroy profit margins; the Tables sub-category loses -$18K despite high revenue; and certain high-volume accounts like Sean Miller generate negative net profits.
Lead project
HR Analytics & Workforce Insights Dashboard
An interactive Power BI HR Analytics dashboard providing executive oversight into workforce demographics, employee attrition, sentiment, and performance metrics. Built to empower data-driven HR decisions and talent management.
Flight Tracking DB
Super Store Sales Analysis
Looked through my work, or worked with me?
Write a review