{"id":195,"date":"2006-08-25T09:35:36","date_gmt":"2006-08-25T16:35:36","guid":{"rendered":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/2006\/08\/25\/overview-of-business-intelligence-dw\/"},"modified":"2006-08-25T09:35:36","modified_gmt":"2006-08-25T16:35:36","slug":"overview-of-business-intelligence-dw","status":"publish","type":"post","link":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/2006\/08\/25\/overview-of-business-intelligence-dw\/","title":{"rendered":"Overview of Business Intelligence \/ DW"},"content":{"rendered":"

Back in May Dan Morgan<\/a> was kind enough to invite me to do a guest lecture at the University of Washington<\/a> about “Data Warehousing Basics.”&nbsp; After having emailed these slides as a decent overview to a few customers lately, I realized they’d probably be useful online.&nbsp; 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.&nbsp; My employer, Pentaho<\/a>, was generous enough to allow me time to build this presentation for the students at UW for which they, and I are grateful.&nbsp; THANK YOU!<\/em><\/strong><\/p>\n

<\/object><\/p>\n

The online version: Univerisity of Washington Guest Lecture May 9<\/a>
\nThe PDF of the presentation:&nbsp; University_of_Washington_Guest_Lecture_May_9.pdf<\/a><\/p>\n

My cliffs notes:
\n&nbsp;- 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.&nbsp; Make him your BEST BEST friend.
\n&nbsp;- Facts are “What” \/ Dimensions are “How”&nbsp; Good graphics that drive the point home:
\n
\nand
\n<\/p>\n

Thanks to Matt Casters<\/a> for leeting me pillage some of his graphics and slides.<\/p>\n","protected":false},"excerpt":{"rendered":"

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.”&nbsp; After having emailed these slides as a decent overview to a few customers lately, I realized they’d probably be useful online.&nbsp; It is obviously a little light on content (their […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts\/195"}],"collection":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/comments?post=195"}],"version-history":[{"count":0,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts\/195\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/media?parent=195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/categories?post=195"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/tags?post=195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}