September 20, 2011 at 8:14 am
Does anyone have experience of DSDM Atern? How generic is it? and why cant I find much/ anything about it with relation to Business Intelligence?
September 20, 2011 at 8:16 am
Any reason why you ask this on a sql server forum which has a great BI suite?
Assuming you already tried googling for the product and found nothing. That says a lot about popularity and community use (or maybe very new to market).
September 20, 2011 at 8:17 am
wildh (9/20/2011)
Does anyone have experience of DSDM Atern? How generic is it? and why cant I find much/ anything about it with relation to Business Intelligence?
never used that methodology, but have being doing Agile BI for a number of years using a mixture of SCRUM and Kanban , depending on the project/client.
September 20, 2011 at 8:23 am
steveb. (9/20/2011)
wildh (9/20/2011)
Does anyone have experience of DSDM Atern? How generic is it? and why cant I find much/ anything about it with relation to Business Intelligence?never used that methodology, but have being doing Agile BI for a number of years using a mixture of SCRUM and Kanban , depending on the project/client.
How does that work?
September 20, 2011 at 8:26 am
Ninja's_RGR'us (9/20/2011)
steveb. (9/20/2011)
wildh (9/20/2011)
Does anyone have experience of DSDM Atern? How generic is it? and why cant I find much/ anything about it with relation to Business Intelligence?never used that methodology, but have being doing Agile BI for a number of years using a mixture of SCRUM and Kanban , depending on the project/client.
How does that work?
as in how effective is it?
or how do we do we use it to manage projects?
September 20, 2011 at 8:37 am
steveb. (9/20/2011)
Ninja's_RGR'us (9/20/2011)
steveb. (9/20/2011)
wildh (9/20/2011)
Does anyone have experience of DSDM Atern? How generic is it? and why cant I find much/ anything about it with relation to Business Intelligence?never used that methodology, but have being doing Agile BI for a number of years using a mixture of SCRUM and Kanban , depending on the project/client.
How does that work?
as in how effective is it?
or how do we do we use it to manage projects?
Yes!
Both actually.
September 20, 2011 at 8:45 am
Ninja's_RGR'us (9/20/2011)
steveb. (9/20/2011)
Ninja's_RGR'us (9/20/2011)
steveb. (9/20/2011)
wildh (9/20/2011)
Does anyone have experience of DSDM Atern? How generic is it? and why cant I find much/ anything about it with relation to Business Intelligence?never used that methodology, but have being doing Agile BI for a number of years using a mixture of SCRUM and Kanban , depending on the project/client.
How does that work?
as in how effective is it?
or how do we do we use it to manage projects?
Yes!
Both actually.
I find it very effective and it gives the Client sponsor great visibilty over the project and they seem to love the burn-down charts and the ability to track progress down to indivdual tasks and people
as for how we do it, we generally use scrum in the way you would for any project. Where we start of by defining the stories..
eg. "as an Analyst i want to see year on year sales for all our stores"
and then we break down the stories into tasks to accomplish them and then assign the tasks the amount of hours that they should take based upon experience.
Tasks will be as granular as possbile and try to include everything we do, even implied tasks such as 'setup backups' or 'create a database' will get hours assigned to them so they are not overlooked
typically a task might be, "create a SSIS package to load X dimension" and we know this should take about 3 hours or so. Also i typically add the same amount of time again for testing.
overall it is a farily typical approach for scrum, we also have daily stand-ups and a visible task board and burn-down.
September 20, 2011 at 9:01 am
Ninja's_RGR'us (9/20/2011)
steveb. (9/20/2011)
Ninja's_RGR'us (9/20/2011)
steveb. (9/20/2011)
wildh (9/20/2011)
Does anyone have experience of DSDM Atern? How generic is it? and why cant I find much/ anything about it with relation to Business Intelligence?never used that methodology, but have being doing Agile BI for a number of years using a mixture of SCRUM and Kanban , depending on the project/client.
How does that work?
as in how effective is it?
or how do we do we use it to manage projects?
Yes!
Both actually.
😀 You made my day - Thank you! 😉
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.September 20, 2011 at 9:08 am
September 21, 2011 at 1:33 am
Been looking at DSDM Atern a bit more and it's more of a project management technique than project management technique, but many of the principals are common, so I guess I’ll have to look at that and scrum.
I may kick myself for potentially changing the direction of this thread, but, setveb mentioned “Also i typically add the same amount of time again for testing”! Testing? How do you test your SSIS packages?
At the moment I have a long laborious technique of creating SQL Scripts the use ‘Exec master..xp_cmdshell 'DTExec..’ then loads of sql checks, an update script to amend package vaiables and more DTExec’s etc. It does the job, but it takes ages and I feel there should be a better way; I just don’t know what it is. Any suggestions would be well recieved.
September 30, 2011 at 3:58 am
Are you familiar with Scott Ambler's website, worth a look if you want to find out more about Agile data.
I ran an Agile BI project and it seemed to work well. Good old fashioned post it notes on walls. The hard part is making sure you don't lose sight of an overall architecture, but if you are slotting in a new dimension or enhancing a report etc it's straight forward.
Having moved to a company that doesn't do Agile, or arguably any project management I would definitely support Agile techniques. Remember to take the bits you like and work well for you.
September 30, 2011 at 5:04 am
Just been looking at http://www.agiledata.org, good find, thanks for pointing it out.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply