Gym Products Analysis

Project Main Steps

1) After importing data into Power Query, and cleaning and transforming the data (ETL) using the Power Query Editor.

2) Create relationships between tables.

2) Creating the Calendar table.

3) Create a lot of measures that are used to build the report (total sales, total Profit, total Returns, total Orders, total Customers, total Quantity, and Average Order Value).

Dashboard Try to answer the following questions:

1️⃣ What are total sales and Profit by Month?

2️⃣ What are total sales by Subcategory, total sales by Category, and total sales by Country?

3️⃣ What are total orders and Ly Orders by Month name?

4️⃣ What are orders by Country, orders by Annual Revenue, and orders by Category?

5️⃣ What is the order Value by BusinessType?

6️⃣ What are orders by No.orders?

7️⃣ What are Customers by month, Total Customers by Year and first order Year, and Total Customers by Country?

8️⃣ What are Customer Returns by Month name, Orders Returns by Month name, and Returns by Country?

9️⃣ Top 5 Customer Returns

1️⃣0️⃣ Top 5 Products Returns