Join a community of the most creative Business Intelligence Professionals
Join a community of the most creative Business Intelligence Professionals
Project Summary: This interactive Power BI report analyzes 2024 mobile phone sales data for a multinational retailer, covering customer demographics, product specifications, and transactional insights across multiple regions. Key Objectives: - Identify top-selling brands and models by country, city, and channel. - Analyze customer behavior by age group, gender, and purchase preferences. - Understand the impact of storage size, color, and operating system on sales. - Monitor revenue trends and unit sales on a monthly basis. - Evaluate performance across online, partner, and in-store sales channels. Core Features: Executive Summary Dashboard: Highlights total revenue, units sold, average selling price, and monthly trends. Regional Insights: Revenue and volume breakdown by country and city using map and bar visuals. Product Performance: Top-selling brands/models with filters by location and time. Customer Profile Analytics: Age and gender distributions for each brand and model. Sales Channel & Payment Analysis: Comparison of revenue and volume across online, partner, and in-store channels, with payment method breakdown. Trend Analysis: Month-over-month revenue and unit sales with seasonal patterns. Outlier Detection: Identification of unusual values in pricing or purchasing behavior. Tools & Skills Used: Power BI (Data Modeling, DAX, Interactive Visuals) Power Query (Data Cleaning & Transformation) Data storytelling and business insight generation
Contact our team
16 Upper Woburn Place, London, Greater London, WC1H 0AF, United Kingdom