Solutions to "Just KNIME It!" Challenge 22 - Season 3

:sun_with_face: Good morning, community! A new Just KNIME It! challenge just came out. :boom: This week, let’s go extra fancy with some more complex visualizations for an e-commerce application. :key: The key here is the Generic ECharts View node – a very flexible tool to hone your dashboarding skills!

Here is the challenge. Let’s use this thread to post our solutions to it, which should be uploaded to your public KNIME Hub spaces with tag JKISeason3-22 .

:sos: Need help with tags? To add tag JKISeason3-22 to your workflow, go to the description panel in KNIME Analytics Platform, click the pencil to edit it, and you will see the option for adding tags right there. :blush: Let us know if you have any problems!

2 Likes

Well this was interesting :-).

In the end opted to follow available examples to create the relevant objects etc. for the sankey diagram. Keen to see if someone manages to wrangle that all no code!

Funnel:

Sankey with options to choose from four different column combinations:

Link to my workflow:

/Edit: After reading through @rfeigel 's comments I realised I did not filter the sankey data for purchases only :see_no_evil:so did an update :slight_smile:

4 Likes

Here’s my solution. I took the “top10 expenditures” literally and excluded prices which were not final purchases. This makes the sankey chart data pretty sparse. In interest of full disclosure I borrowed some of @MartinDDDD’s sankey workflow.

4 Likes

My solution to the challange:

For me the hardest part was the “concept”. If I got it right it could be in the data that someone is purchasing but there is no record for them to “view” or “cart” the item. So I generated that, and filtered the TOP10 customers for just the purchasing customers, etc, etc. So it was really interesting and conceptually a challanging one. :slight_smile:

5 Likes

Hi all,
Here is my solution. I enabled the specification of columns using variables, allowing the Sankey Diagram to be adapted for other data with minimal modifications.


6 Likes

Hi all,
This is my solution

My workflow has funnel chart for events of customer conversion, stacked bar chart for each user, selection table to depict Sankey Diagram.

I used to find it difficult to handle Generic ECharts View nodes, but I am excited that by using K-AI, it was so easy to make each visualisation. It is very useful!!

3 Likes

Hi all,
Here is my solution.

My solution similar to others.
Prepared prompts have been attached to the workflow.



4 Likes

Hi all,
This is my solution. I was unsure of how to handle the entries that has purchase but no view or cart, but for now, I used them as they are.


5 Likes

Added a categorization of the item prices.

4 Likes

find herewith my submission -RFM Score (1-5 )Used for rating for loyal and valuable customers.

3 Likes

Hello, this is my solution for this challenge.

First Time I used K-AI and this kind of diagrams, so thanks for this challenge.

4 Likes

:sun_with_face: Hello hello, folks! As always on Tuesdays, here’s our solution to last week’s Just KNIME It! challenge.

I can see that we all got to somewhat similar solutions! :bar_chart: Are you as excited about the Generic ECharts View node as we are? :boom: Both visualizations are so useful for businesses! And really easy to configure and create with this node.

:brain: See you tomorrow for a challenge on statistics: an area we don’t explore much but are ready to take a dive in!

4 Likes