An agile approach to data warehouse development.
Data is clearly an important aspect of software-based systems, a fact that the information technology (IT) industry has understood for decades, yet many agile development teams are still struggling to involve data professionals within their projects. Until now.
In this workshop participants learn how to take an agile approach to data activities on an agile project, exploring how approaches such as agile data modeling, database refactoring, and database testing fit together to enable agile database development. The workshop also overviews how to take an agile approach to datawarehouse development, data administration, and data management (including Master Data Management (MDM)).
• Agile developers wanting to improve their approach to database development
• Existing database administrators (DBAs) wanting to gain fundamental agile database skills
• Existing data architects or data managers wanting to gain a better understanding of how data activities fit into a disciplined agile delivery project
• Learn how to take an agile approach to database development
• Discover strategies to significantly reduce database development effort as compared with traditional approaches
• Learn how to improve data quality in a safe and proven manner
• See how disciplined agile teams and enterprise data teams can work together in an effective manner
• The Agile Data (AD) method
• Challenges with an agile approach to data
• Data activities through the agile lifecycle
• Agile data architecture
• Agile data modeling
• Database refactoring
• Database testing
• Continuous database integration
• Database encapsulation strategies
• Agile strategies for data warehousing(DW)/business intelligence (BI)
• Agile enterprise data administration and management
• Where to go from here
Length: One day – 7 hours of classroom time plus breaks.
Approach: For each major topic in the agenda there will be instruction followed by group work.
Prerequisites: A basic understanding of Disciplined Agile (DA) and Agile Model Driven Development (AMDD) is very useful. See DA 101: The Disciplined Agile Experience Workshop and DA 102: Introduction to Agile Model Driven Development (AMDD) respectively.
Class size: Ideally 7 to 10, although up to 20 if the room allows.
Classroom requirements: For the students a table layout is preferred. Ideally there should be tables of 4-6 people with sufficient space between them so that students can easily move about the room. Each group will need at least a flip chart but better yet a whiteboard (or a section of whiteboard in the case of a training room with whiteboard-covered walls). For the instructor a screen, projector, and writing space (whiteboards or flipcharts).
This workshop is typically delivered as an addition to DA 101: The Disciplined Agile Experience Workshop so as to give students a greater understanding of agile database techniques.
© 2015 Scott Ambler + Associates