The AMB Data Warehouse: A Case Study

In this presentation to my local PASS chapter, I show one of the leading analytic platforms in the Real Estate industry, AMB Property Corporation’s data warehouse.  I give the attendees a tour of the infrastructure, explaining the challenges faced and the ways I solved them.  I discuss how I achieved near-real-time data latency while integrating 6 source systems (Yardi, CTI, MRI, FAS, MDS and Dyna).  I demo the cubes that drove heavy user adoption, and also an innovative custom application called MyData that gave users useful information on data quality, data latency and business rules applied to the source data.  The presentation is a good example of how one organization achieved success using BI.