Overall Sales Dashboard(2021-2025)
الوصف
قمت بتطوير Dashboard تحليلي احترافي لبيانات المبيعات (2021–2025) باستخدام Excel كأداة BI.
المشروع اعتمد على:
التقنيات المستخدمة
Power Query: لتنظيف وتحويل البيانات
Power Pivot + Data Model: لبناء علاقات بين الجداول
DAX Measures: (Sales, Target, YoY Growth, Profit Margin, Achievement…)
PivotTables & PivotCharts
Dynamic Slicers
Custom KPI Cards & Design
محتوى الداشبورد:
KPIs: Total Sales, Total Profit, Growth, Achievement
Actual vs Target
Sales Trend Over Years
Sales by Region
Sales by Store Type
Top 10 Products
Sales by Category
Customer Segmentation (Gender – Home Ownership)
Advanced Filters linked to all visuals
نوع العمل:
Dashboard Development, Data Modeling, Power Query, Power Pivot, BI Reporting
I help businesses turn raw sales data into clear, actionable insights using Microsoft Excel and Power BI. My focus is on sales reporting, interactive dashboards, KPI tracking, and performance analysis to help businesses monitor results and make better decisions. With practical experience in sales administration within the FMCG sector, I understand the importance of accurate reporting, sales performance monitoring, and business-focused analysis. I am continuously developing my skills in data analytics and business intelligence to deliver efficient, reliable, and valuable reporting solutions.