Challenge #2 Top 10 and Bottom 10 Products by Revenue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-04-2022 02:23 PM
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 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-05-2022 08:58 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-02-2023 04:08 PM
Here is my solution with a demo:
- Create schema and join on product id
- Create business schema with necessary fields (optional)
- Group data by product name and aggregate amount sold
- Sort by amount sold
- Limit rows to 10
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-27-2023 11:07 AM
We need to join the Sales and Products table first. The easiest way is to use Incorta JOIN Editor tool.
Steps:
- Create Schema and tables (sales and products)
- Create Join on PROD_ID within Join Editor
- 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).
- Use Setting to limit 10 rows