Framed my own set of questions for finding KPIs
-
Find the profit margin for different productslines?
-
Calculate avg time for orders placed and orders shipped
-
Find the creditlimit, amount paid and count no of orders places for each customer
-
Find the customers who have exhausted their creditlimit
-
Calculate the % for total_amt exceeding creditlimit
-
Find the top 3 products sold in each productline
-
Find the top 3 cities from each country where customers are ordering the most and see their creditlimit
-
Find the avg order value of order placed
-
Find vendors and how many quantity they have in stock
-
Find Customers who have made payment the same day when they have ordered products
-
Count the status of all the orders placed
-
Count the productname ordered by each office
-
Total order amount of each office
-
Find the count of products in stock for each product vendor along with productline.