Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Self-Service vs. Managed BI Expand / Collapse
Author
Message
Posted Wednesday, July 21, 2010 9:57 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:52 PM
Points: 33,268, Visits: 15,440
Comments posted to this topic are about the item Self-Service vs. Managed BI






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #956915
Posted Wednesday, July 21, 2010 10:42 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 10:57 AM
Points: 3,323, Visits: 1,988
I think your formula one car vs house plan analogy is spot on. Sadly, it seems that the only people who get this are the ones doing the development!
Post #956924
Posted Thursday, July 22, 2010 1:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 31, 2013 3:11 AM
Points: 171, Visits: 444
Oh TOTALLY agree to both of you!

Our company has recently been taken overy by another company, creating a huge company. We're now doing the BI for it, and it's giving us a chance for a bit of both - planning the "new" solution and building to plan, whilst using the old version for learnings.

That analogy, as Kenneth said, is spot on.
Post #956975
Posted Thursday, July 22, 2010 2:17 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 4:21 AM
Points: 145, Visits: 28,764
It's not like a house where everything is planned from the start, but more like an evolving Formula-1 car that is tweaked and tuned with the user inside of it.

I like that methaphore!

However as you metioned yourself: building (great) software is hard. Why put the reponsibility at the (Powerpivot) users desk? It's hard enough for users to analyze conformed data in a (traditional) Datawarehouse let alone build a powerpivot solution.

Dirk


http://www.dwexplorer.com
@dtwegener
Post #956986
Posted Thursday, July 22, 2010 2:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 31, 2013 3:11 AM
Points: 171, Visits: 444
From my experience Dirk, the users genuinely dont know what they want.
Giving them power pivot allows them to play with the data until they get what they want. We can then build what they want.

What tends to happen now is that they'll ask for everything.
We'll then have to say no and ask them what they actually need.
They'll have a guess (it will be wrong), we'll build what they ask for and then have to go through several itterations of that.
Frustrating for both parties.
Post #956990
Posted Thursday, July 22, 2010 3:05 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 4:21 AM
Points: 145, Visits: 28,764
I can see where you're coming from and if you put it this way it makes sense to develop a BI solution by that procedure. However I still think that most business users don't have enough knowledge of Excel, PowerPivot and Database Concepts in general to be able to build a prototype. And then again even if they could, if all users build a prototype using different assumptions and definitions wouldn't it be really hard to for the BI Project Team to build a solution with all the functionality in those prototypes?

http://www.dwexplorer.com
@dtwegener
Post #957015
Posted Thursday, July 22, 2010 3:18 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 31, 2013 3:11 AM
Points: 171, Visits: 444
Oh yea - really hard, but a lot easier than months and months of itterations.
I think we're in a fairly good position in that most of our users are pretty switched on when it comes to data, and if they're not they get a business analyst in to do the digging for them.
Post #957021
Posted Thursday, July 22, 2010 6:13 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:50 PM
Points: 2,582, Visits: 3,837
Sometimes simple is all that's required. We DBA and developer folks tend to over-develop. We want to give the suers the world when all they really need is one small corner of it. Maybe Powerpivot is that one small corner.
Post #957104
Posted Thursday, July 22, 2010 6:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 28, 2014 12:01 PM
Points: 10, Visits: 39
There is definitely something to say for user managed reporting. I don't know how many 'great' projects I have created that are now gathering dust, because nobody is using it, whereas the data-based spreadsheet or quick-and-dirty report that fills a need is still in use.
The key seems to be to stay highly involved with your user, and begin with something basic. Grow and polish it as needed.
Post #957112
Posted Thursday, July 22, 2010 6:24 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 31, 2013 3:11 AM
Points: 171, Visits: 444
I think the selling point for the simple Excel and Access files is the ability to easily manipulate them.
People like to put their own mark on things.
Post #957117
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse