As a product owner, he/she want to generate a report of individual product sales (aggregated on a monthly basis at the product code level) for Croma India customer for FY=2021 so that he/she can track individual product sales and run further product analytics on it in excel. The report should have the following fields,
- Month
- Product Name
- Variant
- Sold Quantity
- Gross Price Per Item
- Gross Price Total
Generate a yearly report for Croma India where there are two columns
- Fiscal Year
- Total Gross Sales amount In that year from Croma
As a product owner, he/she need an aggregate monthly gross sales report for Croma India customer so that they can track how much sales this particular customer is generating for AtliQ and manage our relationships accordingly. The report should have the following fields,
- Month
- Total gross sales amount to Croma India in this month
The data has 2 fact tables as post_invoice_sale and pre_invoice_sale. So that product owner wants to get the net sale after deductable % from discount.
The 5th requirement : Get top 10 customer by % over total global of net sales ( Attached image of chart )
Project owner ask me to generate the report to show top 10 customers who contribute each percentage of revenue on the total global revenue
The 6th requirement :#Get TOP 5 customer revenue by each region and fiscal year in 2021 (attached pie chart )
Project owner wants to pull out the top customers revenue by each region and need to be ranking by Decending revenue. Then , create the pie chat to show specific contribution of customers in each region.
The 7th requirement : Get TOP 3 products in each division by their sold quantity in a given financial year (attached pie chart )
Product owner wants to get the report with top 3 product and be filtered out by each division with the sold quantity in the particular financial year.
The 8th requirement : Retrieve the top 2 markets in every region by their gross sales amount in FY=2021
Product owner wants to get the top 2 markets in each region by gross sale. This time, they forcus on gross sale and FY is 2021