This repository contains a PDF report and PowerBI template titled "Sales Data Analysis" which provides a comprehensive analysis of sales data using Power BI. The report includes various visualizations, trends, and insights into sales performance across different categories, sub-categories, and regions.
- Sales by Category: Breakdown of sales figures across major product categories, including Technology, Office Supplies, and Furniture.
- Sales by Sub-Category: Detailed analysis of sales performance within sub-categories such as Phones, Chairs, and Machines.
- Sales by Ship Mode: Analysis of sales distribution across different shipping methods including Standard, First Class, and Second Day delivery.
- Monthly Sales YoY: Year-over-year comparison of monthly sales figures for the years 2019 and 2020.
- Monthly Profit YoY: Year-over-year comparison of monthly profit figures for the years 2019 and 2020.
- Sales by Segment: Breakdown of sales by customer segments such as Consumer, Corporate, and Home Office.
- Sales by Payment Method: Analysis of sales distribution based on payment methods like COD, Online, and Cards.
- Regional Sales Analysis: Summary of sales figures across different geographical regions (Central, East, South, West).
- Download the Report: Click here to download and view the full report.
- Explore the Visualizations: Use the insights and visualizations provided in the report to understand sales trends and performance metrics.
- Use Cases: The analysis can be used to inform business strategies, optimize sales processes, and enhance decision-making.
- Power BI: Utilized for creating interactive dashboards and visualizations.
- DAX Queries: Employed to create custom columns and tables, enhancing the depth of data analysis.