Our company is looking to replace our current BI Reporting infrastructure which consists of using BIRT & Pentaho's Spoon. We've found a third party plugin that allows BIRT reports to run in Pentaho's ETL and has lasted us for 7 years.
We are now trying to replace this solution with a more scalable one that fulfils our company's main requirements:
- Dynamic Emailing (Users will only receive their own data from a report)
- Report Scheduler: Schedule times to send reports to users in email
- ETL Capabilities
- Dashboards for Management
We are also currently utilizing Microsoft PowerBI for Management Dashboards but we want to explore possible solutions.
Currently, I am using SAP BO Enterprise and running on Oracle.
I'm looking for a much less expensive solution. It's not enough to use MS SQL instead of Oracle.
I'm still profiling the SAP BOE implementation, but would like to head towards a DWH implementation that users can report off. Various users have mentioned in passing: PowerBI, Qlik, Tableau.
At this point, the only solid knowledge I have is that management want to get rid of SAP and Oracle.
Our HR workforce analytics and process management team have been using Tableau desktop for over a year and found a great deal of benefit from its various features. Our teams deal with a lot of MS Excel and Access files but also have to push data out of key HRIS systems like Workday into Tableau since there is no existing driver connection currently. Now that we are pursuing Tableau server so managers can utilize the dynamic reporting our IT department is concerned since they've invested heavily into Business Objects (with limited use in the company) and we now have to justify going with Tableau Server vs. using Business Objects. Our HR team requires very quick turn around on reports and metrics with strong reporting visualization. Our workforce analytics handles a lot of predictive analytics/forecasting. Ideally we hoped using Tableau would actually free up IT resources to other larger priorities instead of managing change requests on reports consistently. In our opinion based on all of this, including low cost for implementation (under $60k incl. hardware) and low annual maintenance (under $10k) for 30 licenses that Tableau seems to be the clear route to go but I'd like to get some input from others.
So I'd like to ask users out there who are familiar with both systems to provide feedback on what they think a better option might be and any pros/cons when matching up the two systems. Thanks!