« IBM Data Governance Prediction- My Anxiety | Main | Data Warehouse Infrastructure- Consider all layers »
July 15, 2008
Data Warehouse can wait- Start with Data-Marts
An organization, how-much-so ever big or small it is, can wait for enterprise data warehouse. It should start with few critical Data-Marts. The reasons are:
An Enterprise Data Warehouse is a long term commitment: There are many imperatives (or foundations), which are key for a Data Warehouse. The examples of these imperatives are foundation or conformed dimensions, fine-grained granular data, comprehensive star-schemas etc...These elements need high level of readiness and investments to build these foundations. These foundations (though great for data marts as well) can be compromised for initial set of Data-marts.
Business Learning- Initial set of data-marts will provide great learning, less on the IT side and more on the business side. Here are the set of learnings from business side:
- Creating business themes
- Building Data-Mart Business Requirements
- Building Dimensional Model
- Testing of Data-Mart
- Taking business decisions around the extraction and transformation
- Generating the information out of the Data-Mart through end-user tools (like reporting and analytics application)
Examples of IT Learnings:
- Extraction, Transformation and Loading design
- Processing Load Management
- Handling Data Explosion (data goes up exponentially as you add sparse fields- where most of the records are blank)
- Change Management (end-to-end impact analysis if you make a change in the Data Mart Model)
Show-case for sponsors: A successful Data-Mart makessponsorship of a Data Warehouse much easier.
Quick-hit: A Data-mart is a quick hit and gives earlier gratification.
Non-Disruptive: It does not take away the attention of an organization from other big things.
You can refer my portal Business Intelligence and Performance Management for more details.
Posted by Rajan Gupta at July 15, 2008 3:15 PM
Comments
What a lovely day for a 4014557! SCK was here
Posted by: 4014557 at May 16, 2011 6:22 AM
Hmm it seems like your site ate my first comment (it was super long) so I guess I'll just sum it up what I submitted and say, I'm thoroughly enjoying your blog. I too am an aspiring blog blogger but I'm still new to the whole thing. Do you have any suggestions for inexperienced blog writers? I'd genuinely appreciate it.
Posted by: term life insurance at May 16, 2011 9:14 AM
My companion and I actually loved studying this blog submit, I used to be just itching to know do you commerce featured posts? I'm all the time trying to find somebody to make trades with and merely thought I might ask.
Posted by: how to pick up women at May 16, 2011 9:53 AM
Thanks for stating your thoughts. As a blogger, I'm generally in need of new and different approaches to look at a topic. I uncover great inspiration in doing this. Thank you again
Posted by: Crissy Troha at May 16, 2011 9:56 AM
Thank you for this article. Looking forward to next one.
Posted by: pandora at May 16, 2011 10:03 AM
I've recently began a weblog, the knowledge you present on this website has helped me tremendously. Thank you for all of your time & work.
Posted by: pick up women at May 16, 2011 10:32 AM
Wow, great design, check my page!
Posted by: unieważnienie ślubu at May 16, 2011 1:02 PM
My partner and I stumbled over here coming from a different web page and thought I might check things out. I like what I see so i am just following you. Look forward to looking at your web page yet again.
Posted by: dried flowers wholesale at May 16, 2011 1:31 PM
I carry on listening to the newscast lecture about getting boundless online grant applications so I have been looking around for the top site to get one. Could you advise me please, where could i get some?
Posted by: sexe video gratuit at May 16, 2011 1:59 PM
Outstanding article once again! I am looking forward for your next post=)
Posted by: garmin nuvi 1300 review at May 16, 2011 2:34 PM
Very similar to how I got started, many of my biggest wins were triggered by bad times.
Posted by: contacts for halloween at May 16, 2011 9:45 PM
Youre so cool! I dont suppose Ive read something such as this before. So nice to search out somebody by incorporating authentic applying for grants this subject. realy thanks for starting this up. this fabulous website are some things that’s needed on the net, somebody with a little bit originality. helpful problem for bringing new stuff on the web!
Posted by: sequin appliques at May 16, 2011 11:49 PM
In this grand design of things you actually secure an A+ for effort. Where you confused me personally was on the facts. You know, as the maxim goes, the devil is in the details... And that could not be much more accurate at this point. Having said that, permit me say to you just what did deliver the results. The authoring is actually pretty powerful and this is most likely why I am making the effort in order to opine. I do not really make it a regular habit of doing that. Second, even though I can certainly notice a jumps in reasoning you make, I am not necessarily convinced of just how you seem to unite your ideas which inturn make the actual conclusion. For right now I will, no doubt subscribe to your point but wish in the near future you connect the facts better.
Posted by: affordable seo for small businesses at May 17, 2011 12:59 AM
good read,found more information available on my site for anyone who is interested, i like your theme by the way
Posted by: Keith Steinback at May 17, 2011 1:23 AM
Would you head if I reference a few sentences out of your submit? I am researching for challenge for highschool. Thanks!
Posted by: Teak Furniture at May 17, 2011 1:59 AM
Random Google results can sometimes lead to excellent blogs like this. You are performing a good job, and we share plenty of opinions.
Posted by: Sun Sannes at May 17, 2011 2:52 AM
This is the suitable blog for anyone who needs to find out about this topic. You notice a lot its nearly laborious to argue with you (not that I actually would need…HaHa). You positively put a new spin on a topic thats been written about for years. Nice stuff, just great!.
Posted by: Corn at May 17, 2011 3:03 AM
I entered a very detailed response to this post but for some reason the blog ate the whole thing. You might want to think about a new provider that is more reliable.
Posted by: Furniture Manufacturer at May 17, 2011 3:42 AM
Would you be inquisitive about exchanging hyperlinks?
Posted by: eugenetillman at May 17, 2011 4:15 AM
I am writing to make you be aware of of the cool encounter our child had viewing your blog. She came to understand a good number of pieces, which included how it is like to have an amazing coaching character to have many more quite simply learn about specific grueling things. You actually surpassed my desires. Many thanks for rendering those priceless, safe, educational as well as fun thoughts on the topic to Evelyn.
Posted by: Sjelvim at May 17, 2011 4:54 AM
Nice post. I be taught one thing tougher on totally different blogs everyday. It should always be stimulating to learn content material from other writers and follow somewhat something from their store. I’d choose to make use of some with the content on my blog whether or not you don’t mind. Natually I’ll give you a link in your internet blog. Thanks for sharing.
Posted by: Cherry Blossom Painting Video at May 17, 2011 5:17 AM
you have an important weblog right here! would you prefer to make some invite posts on my blog?
Posted by: Combat Pants Blog at May 17, 2011 6:38 AM
nice man to read something like this. It set my mind to see things different. i only cant find the rss feed button so i can keep up to date with your posts. well then i have to go more often to youre site. thanks again
Posted by: Underwear at May 17, 2011 6:55 AM
Wonderful article on the many questions you answered me really great! Share this article the rest of my friends! Yours!
Posted by: Geschichten at May 17, 2011 7:43 AM
Howdy! I know this is kinda off topic however I'd figured I'd ask. Would you be interested in exchanging links or maybe guest writing a blog post or vice-versa? My site goes over a lot of the same topics as yours and I believe we could greatly benefit from each other. If you're interested feel free to shoot me an e-mail. I look forward to hearing from you! Excellent blog by the way!
Posted by: home remedies for acne at May 17, 2011 7:58 AM
Good day! This is my first comment here so I just wanted to give a quick shout out and tell you I genuinely enjoy reading through your articles. Can you suggest any other blogs/websites/forums that deal with the same subjects? Thank you!
Posted by: seo content at May 17, 2011 8:03 AM
After I initially commented I clicked the -Notify me when new comments are added- checkbox and now each time a remark is added I get 4 emails with the identical comment. Is there any means you can take away me from that service? Thanks!
Posted by: Tatami Shoes Fashion at May 17, 2011 9:16 AM
Would you be focused on exchanging links?
Posted by: NDS Roms at May 17, 2011 9:59 AM
Hey there! Someone in my Myspace group shared this site with us so I came to take a look. I'm definitely enjoying the information. I'm book-marking and will be tweeting this to my followers! Wonderful blog and wonderful style and design.
Posted by: acne no more reviews at May 17, 2011 10:54 AM
Hello there! This is kind of off topic but I need some guidance from an established blog. Is it difficult to set up your own blog? I'm not very techincal but I can figure things out pretty quick. I'm thinking about making my own but I'm not sure where to begin. Do you have any points or suggestions? With thanks
Posted by: rockwall lawn care at May 17, 2011 11:22 AM
