This project presents a comprehensive analysis of the global shipment of specific products, categorized by various levels such as category and subcategory. The dataset offers detailed information on sole distributors, countries, regions, and product segments. Using the PowerBI tool, key performance metrics, and trends are analyzed and visualized across eight distinct reports. The insights gained from this analysis can inform decision- making guides to stakeholders in taking necessary actions for business growth. The aim is to extract actionable insights from the dataset, thereby enhancing business development and driving growth. .
⦁ Power BI ⦁ Power Query ⦁ Dax Query
- Highest Sales by Sole Distributor:
- Identify the sole distributor who has achieved the highest sales.
- Analyze the sales data to find the region with the highest sales.
- Impact of Discounts on Sales:
- Assess whether discounts have a significant impact on sales figures.
- Highest Sales Volume by Category/Sub-category: *Determine which category or sub-category has the highest sales volume.
- Highest Profit-Making Region: *Identify the region that generates the highest profit.
Report 1 : offers comprehensive details that can be thoroughly analyzed using the available data slicers. This self-explanatory report is designed to provide a variety of insightful analyses from the given data.
Report 2 : illustrates the sales distribution across various countries and regions, providing a clear overview of the areas with the highest sales.
Reports 3 : These reports, generated based on various parameters within the orders dataset, break down data to highlight the highest values. By analyzing different aspects of the data they offer in-depth insights into key metrics and trends.
Report 4 : features a geographical bubble chart detailing returned products along with their corresponding regions. This visualization helps in understanding the distribution of product returns across different geographical areas. Another report provides detailed insights on returned shipments. This report uses a donut chart to illustrate data points such as order IDs, total sales, and market information, offering a clear visual representation for easy analysis.
Report 5 : This report was designed to display the total number of returned items, utilizing data slicers to generate detailed information on returns within each region, including the count of returned items.
Report 6 : This report includes a waterfall chart alongside a line and stacked column report. It clearly illustrates the profit by category and subcategory, providing a detailed and comparative view of financial performance.
Report 7 : This report features a matrix view of the global sales distribution, IT provides detailed breakdown by sole distributor, country, category, subcategory, and segment. This comprehensive matrix allows for in depth analysis and comparison, highlighting the performance and sales patterns across different regions and sectors.
Report 8 : This Q&A report includes a series of built-in questions created by the application. Based on these questions, the report provides the corresponding outputs. This automated approach allows for quick and insightful answers to common inquiries, enhancing the user's understanding and making the data more accessible.
