Bikes Stores 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.

3) Creating the Calendar table.

4) Create a lot of measures that are used to build the report (Revenue, total Transaction, total Orders, total Products sold, total Quantity stored, total Quantity sold,Average order Value, total Products sold, and total Customer).

Dashboard Try to answer the following questions:

1️⃣ What is Revenue by Month?

2️⃣ What is Revenue by state, store, and sales staff?

3️⃣ What is Revenue by category, and brand name?

4️⃣ What are Total orders by Month?

5️⃣ What are orders by state, store, and Category?

6️⃣ What is Qty sold by Month?

7️⃣ What are Qty Stored and Qty sold by store_name, and state?

8️⃣ All products and Products Sold by year

9️⃣ Top 3 Customers sold Qty

1️⃣0️⃣ Revenue by Top 10 product

1️⃣1️⃣ Discount by Top 10 product

1️⃣2️⃣ Customers by Month

1️⃣3️⃣ Customers by No.order, state, and store

1️⃣4️⃣ Customers by Year and First order year