Data Analyst & Power BI Developer | Retail Analytics Specialist
I specialize in converting complex retail and e-commerce transactional data into high-impact, interactive dashboards. By leveraging advanced data modeling, ETL processes, and user-centric design, I help retail businesses monitor sales performance, track regional trends, and understand customer purchasing behaviors to drive growth and profitability.
Featured Project: Retail Sales Dashboard
This project showcases a dynamic Retail Sales Dashboard designed in Microsoft Power BI to deliver comprehensive, real-time insights into retail performance across various dimensions.
Multi-Dimensional Analysis:
Sales by Category: Built horizontal bar charts analyzing Sum of Total Revenue by Product Category to identify top-performing product lines (such as Electronics, Home Appliances, and Sports).
Payment Method Distribution: Created a precise pie chart showing Sum of Total Revenue by Payment Method (Credit Card, PayPal, Debit Card) to help understand customer payment preferences.
Geographical Insights: Integrated an interactive map visual (Sum of Total Revenue by Region) to track sales distribution across international markets (North America, Europe, etc.).
Granular Product Performance: Designed a detailed data matrix table displaying Product Name, Sum of Items Sold, and Sum of Total Revenue for in-depth product-level auditing.
Professional Layout & ETL: Structured the data background for optimal performance and adopted a dark-themed, corporate visual identity that balances aesthetics with functional readability.
Technical Skills Applied
Tools: Microsoft Power BI, Power Query, Excel
Domain Expertise: Retail Analytics, Sales Forecasting, Revenue Analysis, Geospatial Data Mapping, Dashboard UI/UX Design