My first Publication Agile-Data-Warehouse-Design-eBook | Page 2

business  intelligence  (DW/BI)  requirements  and  turning  them  into  high  performance  dimensional  models  in  the  most  
direct  way:  by  modelstorming  (data  modeling  +  brainstorming)  with  BI  stakeholders.
Agile Data Warehouse Design is a step-by-step guide for capturing data warehousing/
business intelligence (DW/BI) requirements and turning them into high performance dimensional models in the
most direct way: by modelstorming (data modeling + brainstorming) with BI stakeholders.
This
This  book  describes  BEAM✲,  an  agile  approach  to  dimensional  modeling,  for  improving  communication  between  
data   warehouse   designers,   BI   stakeholders   and   the   whole   DW/BI   development   team.   BEAM✲   provides   tools            
This book
describes
BEAM✲, DW/BI  
an agile designers  
approach and  
to dimensional
improving
communication
and   techniques  
that  
will   encourage  
developers   modeling,
to   move   for
away  
from   their  
keyboards   and        
between data
warehouse
designers,
stakeholders with  
and their  
the whole
DW/BI development
BEAM✲ thinks              
entity   relationship  
based  
tools   and  
model   BI interactively  
colleagues.  
The   result   team.
is   everyone  
provides tools and techniques that will encourage DW/BI designers and developers to move away from their
keyboards and entity relationship based tools and model interactively with their colleagues. The result is
solutions.   Business   stakeholders   feel   ownership   of   the   data   warehouse   they   have   created,   and   can   already              
everyone thinks dimensionally from the outset! Developers understand how to efficiently implement dimensional
imagine  how  they  will  use  it  to  answer  their  business  questions.
modeling solutions. Business stakeholders feel ownership of the data warehouse they have created, and can
already imagine how they will use it to answer their business questions.
dimensionally   from   the   outset!   Developers   understand   how   to   efficiently   implement   dimensional   modeling              
Within  this  book,  you  will  learn:
Within this book, you will learn:


✲    Agile dimensional modeling using Business Event Analysis & Modeling (BEAM✲)
✲ Agile dimensional modeling using Business Event Analysis & Modeling (BEAM✲)


✲    Modelstorming: data modeling that is quicker, more inclusive, more productive, and frankly more fun!
✲ Modelstorming: data modeling that is quicker, more inclusive, more productive, and frankly more fun!


✲    Telling dimensional data stories using the 7Ws (who,  what,  when,  where,  how  many,  why and how)
✲ Telling dimensional data stories using the 7Ws (who, what, when, where, how many, why and how)


✲    Modeling by example not abstraction;; using data story themes, not crow’s feet, to describe detail
✲ Modeling by example not abstraction; using data story themes, not crow’s feet, to describe detail


✲    Storyboarding the data warehouse to discover conformed dimensions and plan iterative development
✲ Storyboarding the data warehouse to discover conformed dimensions and plan iterative development


✲    Visual modeling: sketching timelines, charts and grids to model complex process measurement – simply
✲ Visual modeling: sketching timelines, charts and grids to model complex process measurement – simply


✲    Agile design documentation: enhancing star schemas with BEAM✲  dimensional shorthand notation
✲ Agile design documentation: enhancing star schemas with BEAM✲ dimensional shorthand notation


✲    Solving difficult DW/BI performance and usability problems with proven dimensional design patterns
✲ Solving difficult DW/BI performance and usability problems with proven dimensional design patterns
Lawrence Corr   is   a   data   warehouse   designer   and   educator.  As   Principal   of   DecisionOne      
is to  
a data
warehouse
designer their  
and educator.
As Principal designs,  
of DecisionOne
Lawrence
Consulting,  
he   helps   Corr
clients  
review  
and   simplify  
data   warehouse  
and   advises              
helps
organizations
to review He  
and regularly  
simplify their
data warehouse
designs, and
vendors   Consulting,
on   visual   he
data  
modeling  
techniques.  
teaches  
agile   dimensional  
modeling    
advises on visual data modeling techniques. He regularly holds agile modeling workshops
courses  worldwide  and  has  taught  dimensional  DW/BI  skills  to  thousands  of  students.

worldwide and has taught dimensional DW/BI skills to thousands of business/IT professionals.
Jim Stagnitto  is  a  data  warehouse  and  master  data  management  architect  specializing  in  the        
Jim financial  
Stagnitto
is a data
and service  
master data
management
architect
specializing
in data        
healthcare,  
services,  
and   warehouse
information  
industries.  
He   is  
the   founder  
of   the  
the
healthcare,
financial
services,
and
information
service
industries.
He
is
the
founder
of
the
warehousing  and  data  mining  consulting  firm  Llumino.  

data warehousing and data mining consulting firm Llumino.
 BEAM ✲
decisionone.co.uk
modelstorming.com