Challenge #2 Top 10 and Bottom 10 Products by Revenue

[Rasha]

In the Sales department, I need your help getting the most sold products and the least sold products

It should be in 2 insights like these:

The used data files have been attached,

It is very simple, When you try it you will find it is fun 🙂

[Ruchita]

You can sort the data
- For Top 10 - into descending order by Revenue,
- For Bottom 10 - into ascending order by Revenue,
and then go to settings and apply Max rows constraint to 10

[LukeG]

Here is my solution with a demo:

1. Create schema and join on product id
2. Create business schema with necessary fields (optional)
3. Group data by product name and aggregate amount sold
4. Sort by amount sold
5. Limit rows to 10

https://www.youtube.com/watch?v=3cOzDDF4Lwg

[zhong]

We need to join the Sales and Products table first. The easiest way is to use Incorta JOIN Editor tool. 

Steps: 

1. Create Schema and tables (sales and products)
2. Create Join on PROD_ID within Join Editor
3. Use Incorta Analyzer to create the two insights. Drag PRUD_NAME to grouping dimension and AMOUNT_SOLD TO measure. Add AMOUNT_SOLD to PRUD_NAME’s Property setting Order By (ASC for Bottom 10, DESC for Top 10).
4. Use Setting to limit 10 rows