This project uses the Retail Sales dataset to analyze sales performance, identify trends, and understand product demand across different regions and time periods. The goal is to uncover key insights related to sales volume, revenue, and product performance.

• Source: Retail Sales dataset (can be obtained from sources like Kaggle or company data). (https://www.kaggle.com/datasets/pavitpreetsingh/relience-sales-data)

1. Power BI: Install Power BI Desktop from Power BI Downloads.
2. Dataset: Download the Retail Sales dataset from a reliable source (e.g., Kaggle).
3. Import Dataset: Import the dataset into Power BI.
4. Data Analysis: Use Power BI to create reports and dashboards, analyzing sales by product, region, and customer behavior.

• Cost Comparison Across Categories:
  The total cost for fruits is lower compared to categories like office supplies and household, which have significantly higher costs.

• Profit Distribution Across Regions:
  Both Sub-Saharan Africa and Europe contribute to more than 50% of the total profit, while North America has the lowest profit contribution among all regions.

• Total Profit and Total Revenue:
  In this case, Total Profit and Total Revenue are the same, indicating that there are no expenses or costs subtracted from the total revenue, which is uncommon in a typical business scenario.

• Total Profit by Item Category:
  The highest total profit comes from Cosmetic and Household items, while Meat has the lowest total profit among all item categories.

• Cost Optimization:
  Focus on reducing costs in the office supplies and household categories to improve overall profit margins. Consider negotiating supplier prices or exploring cheaper alternatives without compromising quality.

• Profit Maximization in Europe and Sub-Saharan Africa:
  Since Sub-Saharan Africa and Europe contribute heavily to the total profit, consider expanding efforts in these regions to further capitalize on their profitable performance. Increase marketing and sales campaigns to boost revenues.

• Review and Adjust Expenses:
  Investigate why Total Profit and Total Revenue are the same, as it might indicate an error or an unusual business structure where no operating costs are considered. Ensure accurate tracking of expenses to maintain profitability.

• Focus on High-Profit Items:
  Given that Cosmetic and Household items generate the highest profit, focus on expanding the product offerings in these categories. Consider bundling these items together or running promotions to increase their sales.