Build a Data warehouse end to end

155 pts.
Data warehouse
Data warehousing
Im asked to build a datawarehouse from end to end. I have already worked on datawarehousing projects. I need to prepare a proposal document. How do i prepare a proposal document that explains End-to-end development. Can I get a sample document? Thanks.

Answer Wiki

Thanks. We'll let you know when a new response is added.

To prepare proposal you need to have a good understanding of user need in terms of the following
1. What they want
2. How they want
3. When they want
4. Who want it
5. Why want it
Answers from all the above questions will be derived from Interviews, Tenders document, Discussion of team mebers etc.

Once the info are gathered then need to identify their budget. Most of the custommer prefer to have more function with less cost. So, first need to identify the essential deliverables. They based on time line do a reverse calaulation in terms of resources and dependecies. Always add additional 10 to 15 % percent of resource as buffer.

Then identify the tasks of DWH and estimate resource for each stage. As per my experience Data quality, Cleanising and ETL will take almost 35% of the time of the total project.

So the business understanding and Source system data is very important. Also how good is the quality of source data also add cost to proposal. So a lot of factors are involved and there is no single direct docuemtn for all projects. So you need study the requirements or expections before prepare proposal. I hope this will clarify your details. If you need more details then pls provide me the project details, so that I can advise you on it on more detail.

Discuss This Question: 4  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Jsql
    Also, what are all the possible questions I should be asking the Business Analyst to get started? Thanks, John
    155 pointsBadges:
  • Jsql
    Thanks Muthu. I have got idea of what to do. I need a sample document to understand how a proposal document should be prepared. What are the points i should be putting in etc ... Can i get one of your document for reference? Thanks.
    155 pointsBadges:
  • Dwaltr
    The best book I have seen on this is Ralph Kimball's Data Warehouse Lifecycle Toolkit. Has a CD in the back with all kinds of project templates. The first question that must be answered is what are you tracking and at what level (ok two questions). That drives everything from design to the amount of hardware you need to maintain that information. -Dave
    900 pointsBadges:
  • Ggrsm
    Create a plan which outlines what you propose to make DW/BI work explane the products that do what DW/BI will offer describe a model which outlines what your doing Describe th ETL system your using Describe the Bi applications that diliver the Data outline the maintance process required to offer DW
    10 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: