KNIME Features Demo

KNIME Analytics Platform
1

Hi Team,

We have KNIME features demo tomorrow. The participants are pre dominantly excel, VBA & PowerBi users/developers. I have the below details with me.

It would be great if you could provide some tips or features to make the presentation more effective.

Parameter VBA (Macro) KNIME
Scalability Limited Unlimited
Integration Limited Unlimited
Intuitive User Interface No Yes
Handling Big Data sets No Yes
Database Connectivity Limited Unlimited
Auditing & Troubleshooting Lack of transparency Good transparency
Advanced Analytics No Yes
Open Source No Yes

Sorry if this is not the right category, request you to move to the respective one.

Regards,
Pavan

2

From my view small real workflows and tasks someone could follow might do the trick if people are interested in how things work and maybe reluctant to try out new things.

Concerning knime and excel - you could substitute some functions and make them more effective but they also could work together.

You are aware of the free book helping people to go from excel to knime

https://www.knime.com/knimepress/download-from-excel-to-knime

And then there is this meta workflow that list a lot of things how to handle excel related questions in and with knime.

Concerning databases and big data KNIME has a lot of great functions and connectors and can handle the steering of spark and pyspark functions (I plan on releasing another meta workflow about that soon).

A good starting point in general is the official “KNIME Database Extension Guide” https://docs.knime.com/latest/db_extension_guide/index.html?u=mlauber71

KNIME can give you a small standalone database in a single file and all the tools you need

KNIME and SQLite - simple example (4.0 New DB nodes) https://hub.knime.com/mlauber71/spaces/Public/latest/sqlite_knime_40/t_001_sqlite_knime_40_db_nodes?u=mlauber71

Then there is big data. KNIME also handles that

KNIME Big Data Extensions User Guide https://docs.knime.com/latest/bigdata_extensions_user_guide/index.html?u=mlauber71

And a small example in big data

Comparison of Hive and Spark SQL https://hub.knime.com/knime/spaces/Examples/latest/10_Big_Data/02_Spark_Executor/07_SparkSQL_meets_HiveQL

4 Likes
3

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.