17. Januar 2019 - 9:00 bis 17:00
Teilen Sie es auf:

SQLSatLinz - Workshop - Modern Data Warehouse (Tillmann Eitelberg, Gabi Münster, Oliver Engels) | Tabakfabrik Linz | Donnerstag, 17. Januar 2019

In this Pre-con we dive into the world of Modern Data Warehouse on the Microsoft Platform and discuss a more or less fully automated way using PowerShell or .NET.
We start with the Ingest Part using Azure Data Factory, Stream Analytics and other services that Azure offer to store structured, unstructured and semi-structured data into the Azure Data Lake. With services like Azure Data Lake Analytics, Azure Data Bricks or Polybase we show how you can perform scalable analytics and achieve cleansed and transformed data. On top of that with the Azure SQL Data Warehouse we will build a central hub to combine this data with already existing structured data. At the end together with Azure Analysis Services and Power BI, we create operational reports and analytical dashboard to derive insights from the data.
All in the cloud, all automated. All in the cloud? Not really. We will also discuss how new features of SQL 2019 can extend the Modern DWH and what a hybrid scenario can look like.