Hello everyone,
I currently work at a company where we use Qlikview as our Bussiness Intelligence tool. Two persons within the company have been appointed to create reports and dashboards in R.
I have started working at this company six months ago, and the tool which I use for data analysis is R. In R, I perform numerical simulations, machine learning, and I do some data mining. However, currently I do not have enough 'data freedom', i.e. I cannot extract data from our systems, only from pre-specified Qlikview reports.
My superiors agree that in my function, I should be able to access all the data that I want, and I should be able to extract this data independently, such that I do not have to wait >48 hours before I have the data I need. We have two options:
- Use Qlikview for this data extraction
- Use an application that queries directly on our ERP system. This new software has been specifically developed for this ERP system.
Due to my background in programming (Java, R, VBA, Matlab) I do not expect any issues in learning to program in Qlikview. However, one or two other users with less programming experience will also want to be able to export data outside of the pre-specified reports. This new application provides a GUI that makes it easy for inexperienced users to merge tables. However, I cannot determine if Qlikview is suited for what we need. Therefore, my question:
Do you think that Qlikview is also suited for simple data extraction, or would we be better of by keeping Qlikview as our BI tool and using new software that has been developed specifically for data extraction out of our ERP systems?
I hope some users with experience in this field can advise me on which direction would best suit my needs.
Kind regards and thanks in advance,
Flo
