Hello -- are there any other FP&A people here? :)

Hi all,

Apologies in advance if this is against KNIME community rules – I don’t know if there are any too as I just started. I’m new to the platform and my background is in FP&A.

I just want to know if there are of similar FP&A background and how are you finding KNIME integration and your role? To what extent has it automated the repetitive Excel/etc tasks?

@Ana914 welcome to the KNIME forum

Not sure if “FP&A” is some sort of Shibboleth - if you could explain further what you are looking for it will be easier to find relevant people :slight_smile:

In general KNIME is very well suited to automate some Excel tasks. There are usually events where you might find Excel and automation related topics.

This event might feature some talks about that and maybe offer connections to likeminded people:

The accompanying data talk board typically would feature participants with their company and profession (if they are willing to share that) and the possibility to contact them:

1 Like

Hi. Not from that field. Anyhow this might give you an idea:
https://www.knime.com/finance-data-analysis

Welcome to the community!

3 Likes

Hello @Ana914,

From experience I find many users are using and finding KNIME to be helpful with repetitive data task. Regarding Excel there is even a book From Excel to KNIME (free of charge) you might find useful in your transition/evaluation:
https://www.knime.com/knimepress/download-from-excel-to-knime

And this is the right place to ask such questions so no apologies needed. Welcome to Community!

Br,
Ivan

1 Like

Hello Ana…
I’ve used to work in accounting area around 15 year, since that work closing with Excel. During this time I could using VBA (Macro) from Excel and some features from Microsoft Acess in order avoid repetitive tasks. Those feature could attempt all my need, but when I met Alteryx and afterwards KNIME I could realize that some automation that I’d spend a lot of hours or days creating macros in excel or in Access at KNIME I can do it faster and more reliable (I preffer KNIME than alteryx :slight_smile: ).

So if have you just start, go slowly step by step, start with easy things…maybe change a xlookup or vlookup you do in Excel for a joinner in KNIME…or a balance sheet you need to filter (using a filter row in KNIME) and export for more than one excel sheet by accounts groups (you can export for several excel sheets at the same time)…or some file you export from ERP and need to delete some columns than save (you can do it using filter columns)…

Just to summarize, start with easy task and don’t give up, at the beggining you will “waste” time but in the future you will saving your time :slight_smile:

2 Likes