advertisement

Agile Bi Dw

50 %
50 %
advertisement
Information about Agile Bi Dw

Published on May 30, 2008

Author: danielfagerstrom

Source: slideshare.net

Description

Lightening talk at Agila Sverige 2008
advertisement

Agile BI/DW Daniel Fagerström www.danielfagerstrom.com

Just follow the book ? Yes, but … What are the user stories? Agile DB practices? Agile operations?

Yes, but …

What are the user stories?

Agile DB practices?

Agile operations?

Dimension model Customer name city Store name region Product name class Date year month ReceiptLine amount

Architecture Customer registry Product registry Org. registry Transactions Raw data Staging Dimension model Marts OLAP Cube Reporting Applications ETL

Backlog Start with the most important: Star Dimension Attributes in the dimension ETL – start with simpler tasks: One time load Subset data

Start with the most important:

Star

Dimension

Attributes in the dimension

ETL – start with simpler tasks:

One time load

Subset data

Breadth or depth Breadth Simplified load of the most important dimension models  Early feedback, earlier build of dependent systems Depth Complete load of one dimension at a time  Early deployment of usable sub systems

Breadth

Simplified load of the most important dimension models

 Early feedback, earlier build of dependent systems

Depth

Complete load of one dimension at a time

 Early deployment of usable sub systems

Agile DB Practices Agile DB refactoring Scott Ambler Change scripts for everything Common code owner ship Everybody can change the models DB projects in MS VS DB professional Don’t become a bottle neck Broad contact area between team members and operations and source data specialists

Agile DB refactoring

Scott Ambler

Change scripts for everything

Common code owner ship

Everybody can change the models

DB projects in MS VS DB professional

Don’t become a bottle neck

Broad contact area between team members and operations and source data specialists

Agile DB Practices Course architecture Agile modeling Just in time design Agile documentation

Course architecture

Agile modeling

Just in time design

Agile documentation

Agile DB Practices Subset data Your own DB and development sandbox Staged deployment: dev  test  prod Continuous deployment TDD?

Subset data

Your own DB and development sandbox

Staged deployment: dev  test  prod

Continuous deployment

TDD?

Agile Operations Involve operations from day one Operations part of the project Deploy at demo/production server often Start source data deliveries ASAP

Involve operations from day one

Operations part of the project

Deploy at demo/production server often

Start source data deliveries ASAP

Conclusion Some mental barrier for DB/DW/BI-developers Transparent Steerable Works great! Happy customers!

Some mental barrier for DB/DW/BI-developers

Transparent

Steerable

Works great!

Happy customers!

More at my blog: www.danielfagerstrom.com

Add a comment

Related pages

DW/BI Modeling Best Practices - Agile Data Home Page

This article summarizes "best practices" for the development of a data warehouse (DW) or business intelligence (BI) solution. These best practices ...
Read more

Agile BI: TDWI - The Data Warehousing Institute

Agile BI. Agile BI "Etablierung eines Standards für Agile BI in der deutschen BI-Community" des TDWI Germany e.V. Betrachtet man die Konferenzbeiträge ...
Read more

Beware of Scrum Fanatics On DW/BI Projects — Enterprise ...

You may be wondering what in the world are “Scrum Fanatics?” And why should you beware of them? And what is Scrum anyway? Scrum is an agile software ...
Read more

Agile DW/BI Testing -- Just Get Started! - TDWI

Page 3 of 3. Agile DW/BI Testing -- Just Get Started! July 9, 2013; By Lynn Winterboer and Ken Collier [Editor's note: Lynn Winterboer and Ken Collier are ...
Read more

Agile Business Intelligence (BI) - TDWI | Advancing all ...

Agile Business Intelligence (BI) Agile business intelligence addresses a broad need to enable flexibility by accelerating the time it takes to deliver ...
Read more

Productivity issues for Agile in BI/DW - Process

Agile in a BI/DW environment faces a unique set of challenges. Today I cover difficulties posed by technology and process.
Read more

Agile in BI & DW - YouTube

Want to watch this again later? Sign in to add this video to a playlist. The world today runs on data and informatics. Everyday millions of ...
Read more

BI und DWH - Willkommen bei Robotron!

Agile BI/DW-Entwicklung; V-Modell XT, angereichert mit Konzepten des Data Warehouse Lifecycle Toolkit nach Kimball; Gremienmitwirkung ...
Read more

Agile DW/BI Testing - Winterboer Agile Analytics

Agile DW/BI Testing — Just Get Started! by Ken Collier and Lynn Winterboer. This article was first published in TDWI BI This Week on July 9, 2013
Read more