Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

What's the best organizational structure to support BI

+2
BoxesAndLines
Jeff Smith
6 posters

Go down

What's the best organizational structure to support BI Empty What's the best organizational structure to support BI

Post  Jeff Smith Thu Feb 03, 2011 11:49 am

What have people found as the most effective organizational structure for BI?

I'm not a big fan of IT departments. Their focus seems to be on transactional systems and tend not to understand BI systems. I'm in a line of business and we've had the freedom to create a DW that is focused on the users. There is a ton of collaboration between creating reports and creating the database structure to support it. I guess this is where I think an IT department is weakest - when responding to a request for a report, when figuring out how to create the report, it helps to have a very good understanding of the reporting software and the database software. The wall between the 2 functions in IT seems too rigid.

I like the way IT can manage a project and they certainly bring a level of discipline that keeps things on the straight and narrow. But sometimes, strengths can also be a weakness. Sometimes procedures serve to keep processes from failing but at the price of excellence.

The IT department wants my database, my baby, my masterpiece. And I'm not so sure.

Jeff Smith

Posts : 471
Join date : 2009-02-03

Back to top Go down

What's the best organizational structure to support BI Empty Re: What's the best organizational structure to support BI

Post  BoxesAndLines Thu Feb 03, 2011 2:31 pm

Resistance is futile. You're a victim of your own success. Ideally, if you are running a BI tool, you can still manage the metadata and reporting layers. The whole idea is self service. Leave the database and ETL to the IT team. Since you designed the database I'm sure you will be able to exert influence there as well. I always review my dimensional model(s) with the report developers on the business side of the house.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

What's the best organizational structure to support BI Empty How about, "Director of Business Intelligence"

Post  Jeff Smith Fri Feb 04, 2011 12:27 pm

I could over see the design and keep doing the type of reporting that I want to do. Make IT do what they are good at.

Now, if someone can just teach them what a star schema is.

Jeff Smith

Posts : 471
Join date : 2009-02-03

Back to top Go down

What's the best organizational structure to support BI Empty Re: What's the best organizational structure to support BI

Post  chrishiggins1 Sat Jul 02, 2011 12:54 am

BoxesAndLines wrote:Resistance is futile. You're a victim of your own success. Ideally, if you are running a BI tool, you can still manage the metadata and reporting layers. The whole idea is self service. Leave the database and ETL to the IT team. Since you designed the database I'm sure you will be able to exert influence there as well. I always review my dimensional model(s) with the report developers on the business side of the house.

I am also an IT student and I totally agree with your statements and I think this the best what one can do, it really helps in the business. It would be an add on if we add a DW to these things.

chrishiggins1

Posts : 1
Join date : 2011-07-01

Back to top Go down

What's the best organizational structure to support BI Empty Re: What's the best organizational structure to support BI

Post  nirma1230 Thu Aug 11, 2011 3:59 am

i am visiting on first time to this forum and i join today, but i really like it and i find it very help full, hope that you will keep it up and we will make the forum beautiful

businessideas.pk/

nirma1230

Posts : 1
Join date : 2011-08-11

Back to top Go down

What's the best organizational structure to support BI Empty Re: What's the best organizational structure to support BI

Post  SharisMiller Fri Sep 23, 2011 3:34 am

I would like to know some thing more about this.
SharisMiller
SharisMiller

Posts : 1
Join date : 2011-09-23
Age : 43
Location : 4883 Proctor Rd Castro Valley, CA 94546-1452

Back to top Go down

What's the best organizational structure to support BI Empty Re: What's the best organizational structure to support BI

Post  Jeff Smith Thu Oct 13, 2011 6:03 pm

Just a quick update on this topic. I've managed to stay independent of IT. I am promoting the concept of a Business Intelligence Competency Center. My group is the de facto BICC but it needs to be made the official BICC. A BICC basically is in charge of the presentation area of the DW, designs and build cubes and reports, and all things BI. The logic behind the BICC is that it leverages BI instruments that have been successfully implemented to expand the capability across the company.

Jeff Smith

Posts : 471
Join date : 2009-02-03

Back to top Go down

What's the best organizational structure to support BI Empty Re: What's the best organizational structure to support BI

Post  parishilton Fri Jan 27, 2012 12:29 pm

Hi Jeff,
may I ask how you are handling change control? We have several objects from the transactional system, the datawarehouse, relational frameworks, cubes and ultimately reports. All of which need to be change control. We're struggling to find a way to ensure we evaluate the impact of changes and attribute changes to business requirements. Well to be honest, we aren't doing it at all. We're a team of two , but spreading out in terms of report developers and we'd really like to get a handle on this now. Any recommendations gratefully received (and stories of what hasn't gone so well!)

Thanks

P

parishilton

Posts : 3
Join date : 2011-12-21

Back to top Go down

What's the best organizational structure to support BI Empty Re: What's the best organizational structure to support BI

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum