<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Andy Leonard
»
Data Warehouse Development: Version 0
25 posts, Page 3 of 3
««
«
1
2
3
Data Warehouse Development: Version 0
Rate Topic
Display Mode
Topic Options
Author
Message
Koen Verbeeck
Koen Verbeeck
Posted Sunday, April 10, 2011 11:42 PM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 9:06 AM
Points: 9,367,
Visits: 6,465
Nice article, thanks Andy. I can't wait to see the rest of the series.
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1091250
David.Poole
David.Poole
Posted Monday, April 11, 2011 3:27 PM
SSCrazy
Group: General Forum Members
Last Login: Today @ 12:46 PM
Points: 2,749,
Visits: 1,406
The intent of Version 0 is to show what can be achieved. A taster with a promise of jam tomorrow. My worry is that executive thinking is "if they developed this with in no time and no resource then I can get a lot for very little outlay".
As in an earlier post there has to be careful management of expectations.
I've had a proof-of-concept backfire on me spectacularly where most of the people involved agreed that the POC had failed in almost every tangible way but mission critical functionality had found its way into the POC so it went ahead anyway.
I am also extremely wary of Excel. I think I've seen it described as a Spreadmart! On one hand the business get great utility and early pay back. On the other hand they've driven a very large truck down a very tight cul-de-sac.
LinkedIn Profile
Post #1091790
Eric M Russell
Eric M Russell
Posted Monday, April 11, 2011 3:42 PM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 2:02 PM
Points: 1,162,
Visits: 3,333
David.Poole (4/11/2011)
The intent of Version 0 is to show what can be achieved. A taster with a promise of jam tomorrow. My worry is that executive thinking is "if they developed this with in no time and no resource then I can get a lot for very little outlay".
As in an earlier post there has to be careful management of expectations.
I've had a proof-of-concept backfire on me spectacularly where most of the people involved agreed that the POC had failed in almost every tangible way but mission critical functionality had found its way into the POC so it went ahead anyway.
I am also extremely wary of Excel. I think I've seen it described as a Spreadmart! On one hand the business get great utility and early pay back. On the other hand they've driven a very large truck down a very tight cul-de-sac.
Excel is a fine business intelligence tool, so long as it's used for reporting or pivoting data from the Data Warehouse. If your team includes a business analyst who is also sharp with Excel, then the database developers can focus on the heavy lifting of creating the ETL processes and data model for the warehouse while the BA stays focussed on the client and handles all of their 1001 requests.
"Wise people understand the 10,000 things without going to each one.
They know them without having to look at each one,
and they transform all without acting on each one." - The Tao Te Ching: Verse 47
Post #1091799
Mr Quillz
Mr Quillz
Posted Tuesday, April 12, 2011 5:26 AM
Valued Member
Group: General Forum Members
Last Login: Today @ 4:09 AM
Points: 60,
Visits: 175
Good Day Andy,
Must say I think I like your work, simple and methodical!!! Version 0 is a very critical step that many Developers/Managers tend to ignore, they dive staight into the deep-end without the critical work of preparation. I'm glad you highlight it's importance.
It seems to me that you will be using the Kimball Methodology, as you mention "Data warehouses simply do not lend themselves to waterfall methodologies; they’re better suited for iterative development", to develop your DW System. Is this the case?!
Looking forward to your next Piece of Art!!!
A keen follower of your work on the Stairway to Integration Services!!!
Regards,
Aquila Hanise
BI Developer
South Africa
Post #1091977
dwilliscp
dwilliscp
Posted Tuesday, February 26, 2013 11:40 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 9:52 AM
Points: 187,
Visits: 332
Nice Article, Andy... thanks. You know the process you describe is the process you should go through to scope any project... not just DW! Look forward to reading more. Hey why not suggest that we can subscribe to any artile you write? The search on the site leaves a lot to be desired, in part becouse there is so much out here!
Post #1424201
« Prev Topic
|
Next Topic »
25 posts, Page 3 of 3
««
«
1
2
3
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
