The AMB Data Warehouse - A Case Study

Speaker: Mark Gschwind, VP of Business Information Architecture at AMB Property Corporation Mark will tell us how data is managed for one of the largest Industrial REITs in the world. AMB serves approximately 2,600 customers in 48 markets in 15 countries with a portfolio of 156 million square feet. The data warehouse at AMB: • Consolidates 4 GL systems, one forecasting system and 2 MDM systems • Has near-real time latency for both fact tables and slowly-changing dimension tables • Produces facts as well as dimension • Has a Data Quality system that pushes out data validity checks to users via email • Utilizes Analysis Services and Business Objects front ends
You will learn:

  • How AMB created a near-real-time data environment for a DW and OLAP platform that integrates 4 ERP's and one forecasting system.

  • How Mark and his team approached the challenges of DW data quality with a unique application that pushes out alerts to users.

  • How AMB leverages SQL Server 2008 R2 Master Data Services to enforce workflow, data quality and SOX compliance.

  • About the data environment of the real estate industry which is not transactionally intensive, but is highly time-changeable.

Mark Gschwind is Vice President of Business Information Architecture at
AMB Property Corp, one of the largest Industrial REITs in the world. He oversees a team working on data warehousing, OLAP and an ERP migration. He has authored three enterprise data warehouses and over 80 OLAP cubes for 46 clients in a wide range of industries. He has certifications in SQL Server and Oracle Essbase.

Join or login to comment.

  • Shiva P.

    This was a great presentation by Mark and its good to understand that, how companies like AMB accomplish of what they think.

    October 8, 2010

  • Shiva P.

    It was great presentation my Mark.

    October 8, 2010

  • Scott E. T.

    Mark did a great job explaining his approach to the challenges he faces at AMB. I had three important takeaways, which I'm in the process of thinking through and adapting to my project. I got a real spark from automated post ETL data quality validation, master data handling, and pushed-to-user exception handling. I appreciate his transparency in sharing a lot of his hard won experience with the group. Fantastic value! Enjoyed every minute and can't wait for next months meeting.

    October 8, 2010

52 went

Our Sponsors

People in this
Meetup are also in:

Create a Meetup Group and meet new people

Get started Learn more

Meetup has allowed me to meet people I wouldn't have met naturally - they're totally different than me.

Allison, started Women's Adventure Travel

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy