Slide presentation of data Warehouse

James is currently a Senior Business Intelligence Architect/Developer and has over 20 years of IT experience. James started his career as a software developer,then became a DBA 12 years ago,and for the last five years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS,SSRS,and SSIS). James has been at times a permanent employee,consultant,contractor,and owner of his own business. All these experiences along with continuous learning has helped James to develop many successful data warehouse and BI projects. James has earned the MCITP Business Developer 2008,MCITP Database Administrator 2008,and MCITP Database Developer 2008,and has a Bachelor of Science degree in Computer Engineering. His blog is at .

Modern Data Warehousing

The traditional data warehouse has served us well for many years,but new trends are causing it to break in four different ways: data growth,fast query expectations from users,non-relational/unstructured data,and cloud-born data. How can you prevent this from happening? Enter the modern data warehouse,which is able to handle and excel with these new trends. It handles all types of data (Hadoop),provides a way to easily interface with all these types of data (PolyBase),and can handle “big data” and provide fast queries. Is there one appliance that can support this modern data warehouse? Yes! It is the Analytics Platform System (APS) from Microsoft (formally called the Parallel Data Warehouse or PDW),which is a Massively Parallel Processing (MPP) appliance that has been recently updated (v2 AU1). In this session I will dig into the details of the modern data warehouse and APS. I will give an overview of the APS hardware and software architecture,identify what makes APS different,and demonstrate the increased performance. In addition I will discuss how Hadoop,HDInsight,and PolyBase fit into this new modern data warehouse.