×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Getting started with Data Warehousing

Getting started with Data Warehousing

Getting started with Data Warehousing

(OP)
I am starting to look into Data Warehousing and determining if it will indeed work for my company (or rather if it is needed). I have read a number of articles online, but was wondering if anybody here had any great suggestions for what to read or where to start.

Thanks in advance,
Willie Bodger

RE: Getting started with Data Warehousing

I can't think of any literature right off hand with the theme of selling the concept of a data warehouse to a company, although I am sure something is out there.  I think data warehousing is mature enough that most articles I see are geared towards those already decided.

This is a good website to get some information on data warehousing:
http://kimballgroup.com/

Also, the Kimball book "The Data Warehouse Toolkit" will come in handy if and when you decide to plan a data warehouse (and if you are using dimensional modeling).

In my opinion, a data warehouse is needed if your company has multiple systems, it's difficult to get a single version of the truth, and IT spends a lot of time making reports for users instead of providing a mechanism for the users to create their own analysis.

RE: Getting started with Data Warehousing

(OP)
Thanks for the link and book suggestion. I'm not really looking for something to persuade the higher-ups, really looking for info to get me started on setting up a proof of concept for them. Something to show them what we can do with a data warehouse to consolidate data from 5-6 different systems.

Again, thank you for your help.

Willie

RE: Getting started with Data Warehousing

The book I mentioned deals mostly with data modeling -- how to design your data stores for particular subject matter types.  As far as consolidation is concerned, you might also be interested in ETL techniques.  For that, I would recommend "The Data Warehouse ETL Toolkit."  

RE: Getting started with Data Warehousing

(OP)
Great, I will have a look at those, thank you so much for your time!

Willie

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close