Abdelrhman Ahmed

I’m a Junior Data Analyst with a Commerce background and a strong interest in turning raw data into meaningful business insights. I build dashboards and analytical solutions that support better decision-making, combining business-focused KPIs with clean, reliable data.

In my Power BI projects, I’ve delivered end-to-end analytics: designing interactive dashboards, creating DAX measures, and shaping data models to answer real questions. For SupplyChainAnalytics, I built a two-page Power BI dashboard across 100K SKUs, 5 suppliers, 3 shipping carriers, and 5 locations, including KPI tracking for revenue, costs, gross margin, shipping performance, supplier efficiency, and product quality. I also developed 20+ SQL queries using aggregations, filtering, subqueries, and window functions, and implemented Row-Level Security (RLS) to control data access by supplier.

I’ve also built marketing and product performance views to help teams move faster with clearer insight. My MarketingPerformanceDashboard supports multi-dimensional KPI tracking (e.g., 576K budget, 152K spend, 3M profit, 958 qualified leads, ROI 18.21, conversion rate 0.41) with DAX measures and a dynamic model for campaign, channel, device type, and geographic region. In FoodMarket Analysis, I designed a profitability dashboard across 1.76M revenue and 1.05M profit, with 59.67% profit margin visibility and return tracking.

Beyond dashboarding, I strengthen the data pipeline through Python-based analysis and data validation. For GrocerySales Analysis, I performed exploratory data analysis (EDA) using Python and YData Profiling and supported enterprise-scaled reporting by building robust data models and drill-down visualizations. Alongside this, I bring customer and accuracy discipline from customer service and income auditing experience.