Business Intelligence

SQH03 How Modern Is Your Data Warehouse?


8:00am - 9:15am

Level: Introductory to Intermediate

Stacia Varga

Microsoft Data Platform MVP

Consultant, Educator, and Author

What's all the fuss about the modern data warehouse? Is a data warehouse even necessary anymore? After all, the Microsoft data platform provides a variety of technologies for data analysis that are easier to implement and manage. Or are they? In this session, we review the role of the traditional data warehouse, explore the newer technologies available in the Microsoft data platform, and discuss whether they replace or reinforce your data warehouse architecture.

You will learn:

  • The differences and similarities between traditional and modern analytics
  • How lambda and kappa architectures affect ETL
  • The implications for working with PolyBase, SQL Server Machine Learning Services, and Azure technologies, such as HDInsight, Azure Machine Learning, and Azure Data Lake Analytics