The traditional enterprise data warehouse has been around a long time, and it isn’t going away anytime soon. However, with modern options based on Hadoop like HDInsight and PolyBase, and new analytic and data mining techniques, modern data warehouse architectures can do things that weren’t economically or technically feasible just a few years ago.

Enterprises now have the flexibility to integrate and analyse external and internal data in ways previously not possible. In this session, we will cover these new platforms through and our approach for integrating them into your existing warehouse environment. We will demonstrate how to do initial data loading and analysis using HDInsight and Power Query, and then visualizing that data using Power View and Power Map.

At completion, attendees should have a good understanding of:

• The components of the Hadoop Ecosystem
• Why and where Hadoop and Big Data technologies make most sense
• The economics of big data solutions
• How SQL Server features are complemented by big data technologies
• Which Microsoft Azure offerings can be part of a modern data warehouse architecture
• How modelling and design projects are impacted by NoSQL and Big Data solutions