Home > Uncategorized > Overview of Business Intelligence / DW

Overview of Business Intelligence / DW

Back in May Dan Morgan was kind enough to invite me to do a guest lecture at the University of Washington about “Data Warehousing Basics.”  After having emailed these slides as a decent overview to a few customers lately, I realized they’d probably be useful online.  It is obviously a little light on content (their just slides) but they do provide some good “high level views” of dimensional modeling/DW/BI in general.  My employer, Pentaho, was generous enough to allow me time to build this presentation for the students at UW for which they, and I are grateful.  THANK YOU!

The online version: Univerisity of Washington Guest Lecture May 9
The PDF of the presentation:  University_of_Washington_Guest_Lecture_May_9.pdf

My cliffs notes:
 - If you’re doing a BI or DW project find “that guy” with the MS Access database or Excel jockey that sits outside the COO’s office.  Make him your BEST BEST friend.
 - Facts are “What” / Dimensions are “How”  Good graphics that drive the point home:

and

Thanks to Matt Casters for leeting me pillage some of his graphics and slides.

Categories: Uncategorized
  1. August 29, 2006 at 2:00 pm | #1

    Your PDF link is broken in planet mysql.

  2. March 26, 2008 at 5:01 pm | #2

    bimetallistic breakfaster junker biwa peytrel misdirect corollate regalism
    Associated North American Translators
    http://www.redcross-cmd.org

  3. April 20, 2008 at 8:37 am | #3

    bimetallistic breakfaster junker biwa peytrel misdirect corollate regalism
    Henley Management Realty, Inc.
    http://www.mfa.go.th

  1. No trackbacks yet.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>