Mohamed HagAli — Data Analyst Portfolio

4 Projects

5 Certificates

2 Countries Worked In

About Me

Business Context.
Analytics Execution.

I’m a Data Analyst and BI-focused professional with a practical foundation in operations, execution, and cross-functional problem solving.

My background in Saudi Arabia and Sudan taught me how to work close to the business itself: improve workflows, reduce waste, manage stakeholders, and deliver under pressure. Today, I bring that same mindset into data work — building dashboards, models, and reports that are clear, useful, and tied to real decisions.

I work with Power BI, SQL, Python, Excel, DAX, and data modeling to turn raw business data into structured reporting, KPI tracking, and actionable insights across sales, profitability, customer behavior, and operations.

Dashboard Design Business Reporting Data Modeling Operations Analytics

Download CV LinkedIn Power BI Portfolio Repo

📊

Analytics & BI

Power BI
DAX
Data Modeling
Data Visualization

💻

Data & Reporting

SQL
Python
Excel Advanced
Data Cleaning

📈

Business & Reporting Insight

KPI Reporting
Business Analysis
Process Optimization
Dashboard Storytelling

Power BISQLPythonDAXExcelData ModelingStar SchemaData CleaningKPI ReportingBusiness AnalysisDashboard StorytellingBusiness IntelligenceProcess OptimizationOperations Optimization

Jan 2024 — Jun 2025 Riyadh, Saudi Arabia

Tech Production Lead

Ansaf Alhulul Advertising

Led manufacturing operations and a technical team, improving delivery consistency, execution quality, and production efficiency through standardized workflows.
Designed modular execution flows and improved material usage through better planning, layout optimization, and process standardization.
Reduced waste and improved workflow efficiency through more structured production planning and nesting optimization in CorelDraw.
Oversaw the delivery of more than 200 premium commemorative awards for Dammam Airports Company (DACO) with high accuracy and deadline discipline.
Delivered branded production and advertising solutions for clients including Al-Noj, Qimat Ikhtiyar Al Oud, and other companies in the Saudi market.
Built a practical, quality-focused mindset around execution, turnaround time, stakeholder expectations, and measurable operational efficiency.

Workflow OptimizationTeam LeadershipClient DeliveryQuality Standards

Sep 2021 — Apr 2023 Khartoum, Sudan

Creative Ops & Solutions Lead

Darya Design Advertising

Delivered custom production and creative solutions for institutional and corporate clients across signage, awards, gifts, and branded event execution.
Executed commemorative awards and event products for TEDxYouth@OamkSt and TEDxSudanUST.
Designed and implemented the signage system for Al-Razi Hospital and supported décor execution for DAL Group’s Al-Dawaya Ramadan tent.
Managed technical execution for complex project requirements and translated design concepts into high-quality physical products using laser and CNC workflows.
Worked on promotional and branded production solutions for corporate clients including Abu Sefein and other business accounts.
Strengthened hands-on problem solving, delivery planning, and practical business thinking that now supports my approach to reporting and analytics.

Project ExecutionSignage SystemsClient SolutionsProcess Coordination

Featured

E-Commerce Sales - Advanced Interactive Dashboard

An advanced multi-page dashboard built on e-commerce transactional data to support performance tracking, time-based comparison, and executive reporting. The report combines KPI monitoring, time-intelligence analysis, customer and segment views, and interactive navigation to help users explore sales patterns and business performance more effectively.

YOY / MOM / QOQ analysis with structured DAX measures
Interactive navigation, bookmarks, and toggle buttons
Customer, segment, and shipping performance views
Executive-ready reporting with decision support focus

Power BIDAXExcelStar SchemaTime Intelligence

GitHub Repo Live Dashboard

Featured

Superstore Sales Analytics Dashboard

A multi-page sales analytics dashboard designed to evaluate business performance across revenue, profitability, pricing impact, customer behavior, and regional trends. The report helps users monitor KPIs, explore discount effects, compare category performance, and identify insights that support stronger commercial decisions.

Executive KPI view with year-over-year comparison
Pricing and discount impact analysis
Product, customer, and regional performance views
Structured data model with organized DAX folders

Power BIDAXData ModelingProfitabilityRegional Analysis

GitHub Repo Live Dashboard

Cafe Sales Dashboard

A business-focused reporting dashboard built to monitor sales, profit, cost, and quantity performance in a clean management-facing layout. The report supports KPI tracking, branch and category filtering, and quick visibility into monthly trends for day-to-day business review.

Core KPI cards for sales, profit, cost, and quantity
Interactive slicers by branch, category, and payment method
High-level monthly sales reporting

Power BIDashboard BasicsKPIs

GitHub Repo

E-Commerce Sales - Data Modeling & Analysis

A Power BI project focused on data preparation, normalization, star-schema modeling, calendar design, and foundational DAX measures for scalable reporting. It demonstrates the analytical groundwork required to build reliable dashboards and reusable business reporting.

Power Query transformation and structured cleaning
Fact and dimension modeling with calendar table
Foundation for scalable analytical dashboards

Power BIPower QueryStar SchemaDAX

GitHub Repo

B.S. in Information Technology and Computing

Arab Open University

Jun 2021 — Present

Diploma in Electrical, Electronic and Communications Engineering

Sudan University of Science and Technology

Oct 2014 — Aug 2018

Google

Google Data Analytics Professional Certificate

Jan 2026 View Certificate

Verified

Tharaa Training

Data Analysis & BI Training Camp

Feb 2026 View Certificate

Completed

Forage Academy

Data Labeling Online Job Simulation

Mar 2026 View Certificate

Completed

Deloitte Australia / Forage

Data Analytics Job Simulation

Mar 2026 View Certificate

Completed

Harvard University / CS50

CS50x: Introduction to Computer Science

Dec 2020 View Certificate

Verified

Let's Connect

Open to Data and BI Opportunities

I’m actively looking for roles as a Data Analyst, BI Analyst, reporting-focused analyst, or operations-focused analyst. Let’s connect.

moeali577@gmail.com +966 50 672 8490 linkedin.com/in/mohamedhajali95 github.com/MohamedHajali95/powerbi-portfolio Download CV

Mohamed HagAli

Data Analyst · BI Specialist

Open to roles in:

✅ Data Analyst
✅ BI Analyst
✅ Reporting Analyst
✅ Operations Analyst
✅ Business Analyst

Send me a message →

Mohamed
HagAli

Business Context.
Analytics Execution.