Business Intelligence Experience?
Discussion
Hi, as we get a lot of IT and techies in here I thought I'd ask.
Looking to implement a new BI solution for a mid size business. Traditionally this would go to MS, Cognos or one of the other big vendors, but the business is wanting something more lightweight (in terms of IT resource/requirments gathering/tin/cost etc).
What are peoples experience of Tableau/Qlikview/Microstrategy/Pentaho etc?
We really like Tableau and its ability to connect to existing data and suck it up into its own column based DB (saves us building a middle Datamart) BUT we have concerns over its ability to integrate with MS Office and for bog standard reporting.
Anyone gone through a similar process?
Looking to implement a new BI solution for a mid size business. Traditionally this would go to MS, Cognos or one of the other big vendors, but the business is wanting something more lightweight (in terms of IT resource/requirments gathering/tin/cost etc).
What are peoples experience of Tableau/Qlikview/Microstrategy/Pentaho etc?
We really like Tableau and its ability to connect to existing data and suck it up into its own column based DB (saves us building a middle Datamart) BUT we have concerns over its ability to integrate with MS Office and for bog standard reporting.
Anyone gone through a similar process?
I know a few people who use Qlikview. They seem to like it, but they're not techies and have had little exposure to any other BI systems/processes.
Personally I'd try to resist anything like that without fully understanding long term support costs.
Look at what a Qlikview contractor costs today compared to a generalist MS contractor. Then think about what it'll cost in the future if the former becomes even rarer...
Personally I'd try to resist anything like that without fully understanding long term support costs.
Look at what a Qlikview contractor costs today compared to a generalist MS contractor. Then think about what it'll cost in the future if the former becomes even rarer...
I've implement Business Objects and QlikView in the past. QlikView is simply excellent. We found the best workflow was to have a database guy write the SQL to dump data into a QVD, then the BAs can write reports from them. Key is to document the metrics and KPIs first, so you know what the calculations should be.
Having said that, I saved major money just being curious with QV and pulling data in, linking on simple key fields (customer name, dates etc) and seeing what looked interesting. Found hundreds of customers not being billed within a couple of days of installing QV. It isn't that hard if you know something like excel, and some SQL - and don't mind a bit of trial and error.
Having said that, I saved major money just being curious with QV and pulling data in, linking on simple key fields (customer name, dates etc) and seeing what looked interesting. Found hundreds of customers not being billed within a couple of days of installing QV. It isn't that hard if you know something like excel, and some SQL - and don't mind a bit of trial and error.
I post from a commercial point of view and not an IT point of view. My advice would be firstly don't let IT lead these projects! My current company had £1m per year up to 2017 in our it budget for "BI/MI" and fortunately me and my colleagues have now got this canned - they delivered nothing useful in 2012/13.
I've now got an "agile analytics" guy in to help me build what I want and we're using Tableau, it's fantastic, and like the poster above I have spotted a number of "do'h" issues that have saved me many times the cost.
I've now got an "agile analytics" guy in to help me build what I want and we're using Tableau, it's fantastic, and like the poster above I have spotted a number of "do'h" issues that have saved me many times the cost.
Gassing Station | Business | Top of Page | What's New | My Stuff


