Portfolio Detail

Mobile Sales Analysis

Power BI Report

Mobile Sales Analysis

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

Skills & Tools Used:

Power BI

Share this Project:

Get In Touch

Contact our team

    name

    email

    number

    Pre-estimated budget

    Message

    locations

    Office Address

    16 Upper Woburn Place, London, Greater London, WC1H 0AF, United Kingdom

    call

    Telephone number

    +44 204 534 7858
    Loader