mini-project-PowerBI

TITLE:
Sales data analysis using Power BI Sales_Data

FINDINGS:
Task 1:
   i. Round the 'Price' column in the Product dataset to the nearest integer for simplicity.
  ii. Split the 'Customer' column in the Customer table into two columns: 'FirstName' and 'LastName'.
Task 2:
   i. Convert all entries in the 'Category' column in the Product table to uppercase.
  ii. Replace all occurrences of 'unemployment' with 'Unemployed' in the 'Profession' column of the Customer table.
Task 3 :
   i. Ensure all columns in the datasets have appropriate data types, e.g., 'Date' column as Date type, 'Price' as Decimal type.
  ii. Identify and replace any inconsistent values in the 'Size' column of the Product dataset to ensure uniformity (e.g., replace "medium" with "Medium").
Task 4:
   i. Create relationships between the tables using 'CustomerID' and 'ProductID' as keys.
  ii. Clean the data by removing any duplicate entries in the Customer and Product tables.
Task 5:
Sales by Category:
   i. Create a chart showing total sales (TotalPrice) by product category.
  ii. Customize colors, refine the title, and add data labels for exact sales amounts.
Sales Percentage by Category:
   i. Create a chart showing the percentage share of sales (Price) for each product category.
  ii. Keep the chart compact and easy to understand.