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.

Karen Lopez is Sr. Project Manager and Architect atInfoAdvisors. As a Microsoft MVP, Karen is a frequent speaker at conferences and user groups. She has 20+ years of experience in project and data management on large, multi-project programs. She specializes in the practical application of data management principles. Karen is also the ListMistress and moderator of the InfoAdvisors Discussion Groups at www.infoadvisors.com. Karen wants you to Love Your Data.  She also tweets at https://twitter.com/datachick

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