It's only a Datawarehouse, How hard can it be

View previous topic View next topic Go down

It's only a Datawarehouse, How hard can it be

Post  Donviti on Tue Oct 16, 2012 3:12 pm

My boss wants a Data warehouse. I'm a Business Systems Analyst currently pumping out reports from a new Database we are migrating part of our business too via SQL and onto SSRS. I've never ever done anything remotely large as this. I'm estimating over a dozen different data sources. He'd like it done yesterday and doesn't appear to understand remotely how involved this task is. Did I mention he'd like it done yesterday? I don't want to be set up for failure, nor do I want to communicate that I feel I will fail. We aren't some pidley company either, we are publicly traded....

Tips on how to manage this situation? I hope this is the right forum. I'm currently scrambling to read up on the Matrix and am commencing chapter one of the Tool Kit book.

I sincerely apologize if this isn't the right place.

Donviti

Posts : 4
Join date : 2012-10-16

View user profile

Back to top Go down

Re: It's only a Datawarehouse, How hard can it be

Post  ngalemmo on Tue Oct 16, 2012 3:40 pm

No, this is fine.

First question to ask: What do you want a data warehouse for?
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: It's only a Datawarehouse, How hard can it be

Post  TheNJDevil on Tue Oct 16, 2012 3:59 pm

Which Toolkit book? I would suggest your boss read chapter 1 and 16 in the Data Warehouse Toolkit (2nd Ed). It's basically the condensed version of what he should read if reading the Data Warehouse Lifecycle Toolkit (2nd Ed). If those chapters get read and your boss still wants it yesterday, then start looking for a new job because you are doomed to fail.

I've had a similar problem except replace the words Data Warehouse with Dashboard. Once those chapters where read, they calmed down on the now now now aspect and we are going for small successes to prove this a viable solution and get more resources allocated.

TheNJDevil

Posts : 68
Join date : 2011-03-01

View user profile

Back to top Go down

Re: It's only a Datawarehouse, How hard can it be

Post  Donviti on Tue Oct 16, 2012 4:05 pm

Ngalemmo,

My boss, the head of IT, wants one area for all our disparate data. He wants to combine that data in a way that allows him to find customer information we can utilize to increase sales. He wants to know what he doesn't know and be able to have access to all of that in one place.

The information that I know of exists in at least 8 different places. I know there are others. We have no servers to store the data. We have no ETL in place nor have we even finished with the conversion to the new CRM application coming on line EOY 2012.


NJDevil,

That's the one I'm reading as I type. "The Data Warehouse Toolkit" Second Edition

Donviti

Posts : 4
Join date : 2012-10-16

View user profile

Back to top Go down

Re: It's only a Datawarehouse, How hard can it be

Post  Donviti on Tue Oct 16, 2012 4:06 pm

NJD,

My resume is on careerbuilder...

Donviti

Posts : 4
Join date : 2012-10-16

View user profile

Back to top Go down

Re: It's only a Datawarehouse, How hard can it be

Post  BoxesAndLines on Tue Oct 16, 2012 8:36 pm

Don't quit yet. This sounds like a great project to cut your teeth on. I would recommend hiring an expert to come in and help with the architecture. This will lay the foundation for all the work you need to do as well as highlight to your boss the amount of work needing to be done. You can do that in about a month, so the cost shouldn't be exhorbiant.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: It's only a Datawarehouse, How hard can it be

Post  Donviti on Wed Oct 17, 2012 8:05 am

Boxes,

I don't plan on quitting at all. It's a challenge for sure, we plan on bringing in someone, in the meantime I'm gathering intel and drawing up some diagrams. I love to learn and this sorta stuff is fun...sorta

Donviti

Posts : 4
Join date : 2012-10-16

View user profile

Back to top Go down

Re: It's only a Datawarehouse, How hard can it be

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


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