Business Intelligence Experience?
Business Intelligence Experience?
Author
Discussion

MoelyCrio

Original Poster:

2,502 posts

213 months

Tuesday 5th November 2013
quotequote all
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?

LooneyTunes

9,536 posts

189 months

Tuesday 5th November 2013
quotequote all
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...

mr_spock

3,376 posts

246 months

Tuesday 5th November 2013
quotequote all
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.

0a

24,160 posts

225 months

Saturday 9th November 2013
quotequote all
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.