{"id":65,"date":"2021-01-18T18:00:02","date_gmt":"2021-01-18T17:00:02","guid":{"rendered":"http:\/\/blog.dataengineer.at\/?p=65"},"modified":"2021-01-18T23:45:11","modified_gmt":"2021-01-18T22:45:11","slug":"der-burger-hebt-ab-in-die-cloud","status":"publish","type":"post","link":"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/","title":{"rendered":"Der &#8222;Burger&#8220; hebt ab in die Cloud!"},"content":{"rendered":"<p>Seit \u00fcber 10 Jahren hat sich der &#8222;Microsoft BI Stack&#8220; als integrierte, stabile und g\u00fcnstige Bussines Intelligence L\u00f6sung etabliert und wird in zahllosen Unternehmen eingesetzt.<\/p>\n\n\n\n<p>After 15 years of almost unchanged technology, it is time to think about a renewal, the cloud is waiting with modernity, scalability and cost savings.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Inhalt<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69f5983a3feca\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69f5983a3feca\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#Wie_bekomme_ich_mein_%E2%80%9EMS_BI%E2%80%9C_in_die_Cloud\" >Wie bekomme ich mein &#8222;MS BI&#8220; in die Cloud?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#Der_Burger\" >The burger<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#Die_Tools\" >The tools<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#Warum_denn_uberhaupt_in_die_Cloud\" >Why in the cloud at all?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#Eine_gute_und_eine_schlechte_Nachricht\" >Good news and bad news<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#Lift_Shift\" >Lift &amp; Shift<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#Datenbank_SQL\" >Database (SQL)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#ETL_SSIS\" >ETL (SSIS)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#Analyse_Cube_SSAS\" >Analysis Cube (SSAS)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#Reporting_SSRS\" >Reporting (SSRS)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#Azure_Cloud_BI\" >Azure Cloud BI<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#Losungen\" >Solutions<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#Migration_mit_on-prem_Technologien\" >Migration with on-prem technologies<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#Bestehender_ETL_mit_modernem_Analyse-Reporting\" >Existing ETL with modern analysis reporting<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#Nachhaltige_Cloud-Losung\" >Sustainable cloud solution<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#Projektszenario\" >Project scenario<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#Aufwand\" >Effort<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#Projekt_in_zwei_Phasen\" >Project in two phases<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#Conclusio\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Wie_bekomme_ich_mein_%E2%80%9EMS_BI%E2%80%9C_in_die_Cloud\"><\/span>Wie bekomme ich mein &#8222;MS BI&#8220; in die Cloud?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>It is obvious, Microsoft BI in the Microsoft Cloud, that should be the easiest.<\/p>\n\n\n\n<figure class=\"wp-block-pullquote\"><blockquote><p>How does it work and what does that have to do with a burger that takes off?<\/p><\/blockquote><\/figure>\n\n\n\n<p>We want to explain that here ...<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Der_Burger\"><\/span>The burger<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>It is an sweet nickname for the structure of all integrated services that can be used for the MS BI overall solution.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"831\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/MS_BI_Stack_Burger-1024x831.png\" alt=\"\" class=\"wp-image-209\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/MS_BI_Stack_Burger-1024x831.png 1024w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/MS_BI_Stack_Burger-300x243.png 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/MS_BI_Stack_Burger-768x623.png 768w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/MS_BI_Stack_Burger-16x12.png 16w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/MS_BI_Stack_Burger-600x487.png 600w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/MS_BI_Stack_Burger-945x767.png 945w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/MS_BI_Stack_Burger.png 1086w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>MS BI Stack<\/figcaption><\/figure>\n\n\n\n<p>The main components that are mostly used:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>MS SQL Server (MSSQL): The database server<\/li><li>Integration Services (SSIS): The ETL tool for loading and transformation<\/li><li>Analysis Services (SSAS): The analysis cube as the basis of reporting<\/li><\/ul>\n\n\n\n<p>Additionally as a reporting tool<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Reporting Services (SSRS)<br>oder<\/li><li>Excel<\/li><\/ul>\n\n\n\n<p>Sometimes also<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Master Data Services (MDS): For data quality and master data maintenance<\/li><\/ul>\n\n\n\n<p>And all these components are an integral part of the MS SQL Server, automatically available and can also be used with the licenses.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Die_Tools\"><\/span>The tools<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The development tools, also Microsoft:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Visual Studio (VS)<\/li><li>SQL Management Studio (SSMS)<\/li><li>The languages T-SQL and MDX<\/li><\/ul>\n\n\n\n<p>Not only are all components integrated, the development was graphical and with very little code, even then, progressive and very flexible.<\/p>\n\n\n\n<p>The ETL processes with many possibilities<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"416\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSIS_web.jpg\" alt=\"\" class=\"wp-image-221\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSIS_web.jpg 800w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSIS_web-300x156.jpg 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSIS_web-768x399.jpg 768w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSIS_web-16x8.jpg 16w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSIS_web-600x312.jpg 600w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/figure>\n\n\n\n<p>The analysis cube with data model, dimension mapping and measures.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"925\" height=\"495\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSAS_DataModel.png\" alt=\"\" class=\"wp-image-222\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSAS_DataModel.png 925w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSAS_DataModel-300x161.png 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSAS_DataModel-768x411.png 768w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSAS_DataModel-16x9.png 16w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSAS_DataModel-600x321.png 600w\" sizes=\"auto, (max-width: 925px) 100vw, 925px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"482\" height=\"254\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSAS.jpg\" alt=\"\" class=\"wp-image-223\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSAS.jpg 482w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSAS-300x158.jpg 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/SSAS-16x8.jpg 16w\" sizes=\"auto, (max-width: 482px) 100vw, 482px\" \/><\/figure>\n\n\n\n<p>So all in all an innovative overall solution with which you can implement even complex projects efficiently, very cheaply and quickly with little programming.<br>It's just getting a little old.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Warum_denn_uberhaupt_in_die_Cloud\"><\/span>Why in the cloud at all?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>Costs<\/strong><br>Not only the acquisition costs of the hardware, but also the operation (updates, rent, energy, personnel) can cause high costs that are not applicable in the cloud.<\/p>\n\n\n\n<p><strong>Scaling<\/strong><br>The hardware does not have to be dimensioned for the peak load, but can be adapted at any time as required, which also has a direct effect on the costs.<\/p>\n\n\n\n<p><strong>Availability<\/strong><br>Redundante Systeme, automatische Replikation, mehrere Geo-Zonen, automatische Failover und Backups erlauben einen ausfallsicheren Betrieb.<\/p>\n\n\n\n<p><strong>Innovation<\/strong><br>Ger\u00fcstet f\u00fcr neue Anforderungen wie &#8222;Streaming&#8220;, &#8222;Data Sience&#8220;, &#8222;Datalake&#8220;, ob als Erweiterung der Systemlandschaft oder als Experiment und Wissensaufbau f\u00fcr kurze Zeit.<\/p>\n\n\n\n<p><strong>Agility<\/strong><br>The overall architecture can be expanded and adapted at any time, new technologies can be tried out very easily, which allows a quick reaction to new market situations.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Eine_gute_und_eine_schlechte_Nachricht\"><\/span>Good news and bad news<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><strong>The good news:<\/strong><\/p>\n\n\n\n<p>A BI solution can be set up and operated entirely in the Azure cloud.<\/p>\n\n\n\n<p><strong>The bad news:<\/strong><\/p>\n\n\n\n<p>Of the four classic components, there is only one in the cloud!<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"30\" height=\"30\" class=\"wp-image-231\" style=\"width: 30px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Check30x30.png\" alt=\"Check\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Check30x30.png 30w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Check30x30-12x12.png 12w\" sizes=\"auto, (max-width: 30px) 100vw, 30px\" \/>MSSQL (database)<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"30\" height=\"30\" class=\"wp-image-232\" style=\"width: 30px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/No_Check30x30.png\" alt=\"No Check\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/No_Check30x30.png 30w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/No_Check30x30-12x12.png 12w\" sizes=\"auto, (max-width: 30px) 100vw, 30px\" \/> SSIS (loading \/ transformation)<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"30\" height=\"30\" class=\"wp-image-232\" style=\"width: 30px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/No_Check30x30.png\" alt=\"No Check\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/No_Check30x30.png 30w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/No_Check30x30-12x12.png 12w\" sizes=\"auto, (max-width: 30px) 100vw, 30px\" \/> SSAS Multidimensional (analysis cube)<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"30\" height=\"30\" class=\"wp-image-232\" style=\"width: 30px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/No_Check30x30.png\" alt=\"No Check\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/No_Check30x30.png 30w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/No_Check30x30-12x12.png 12w\" sizes=\"auto, (max-width: 30px) 100vw, 30px\" \/> SSRS (reporting)<\/p>\n\n\n\n<p><strong>The not so bad news:<\/strong><\/p>\n\n\n\n<p>The existing technology can also be operated in the cloud:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Lift_Shift\"><\/span>Lift &amp; Shift<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-pullquote\"><blockquote><p>Now the burger takes off and lands in the cloud.<\/p><\/blockquote><\/figure>\n\n\n\n<p>So that all the laborious developments and processes that have been stable for a long time do not have to be recreated, there is a migration scenario in which the technologies are retained - the on-premise solution is operated in the cloud.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Datenbank_SQL\"><\/span>Database (SQL)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><strong>Azure SQL Managed Instance<\/strong><br>It is a very special database service in the cloud that is almost identical to an on-prem SQL Server 2019, a VM hosted by Azure.<br>Es k\u00f6nnen damit die gewohnten Dienste genutzt werden wie &#8222;SQL Server Agent&#8220;, &#8222;SSISDB&#8220;, &#8222;Linked Server&#8220;.<br>Nicht zu verwechseln mit &#8222;Azure SQL Server&#8220;, der ein &#8222;echtes&#8220; Cloud-Service ist.<\/p>\n\n\n\n<p><strong>Azure SQL Server<\/strong><br>If the special on-prem features are not necessary, the intended service is the better choice with more real cloud features and is future-proof.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"ETL_SSIS\"><\/span>ETL (SSIS)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-pullquote\"><blockquote><p>The existing packages can be kept.<\/p><\/blockquote><\/figure>\n\n\n\n<p>They can be in an SSISDB (Managed Instance) or on an Azure BLOB Storage.<br>Ausgef\u00fchrt werden die Pakete allerdings auf einem Service der &#8222;Azure Data Factory&#8220;, daf\u00fcr gibt es eine eigens verf\u00fcgbare &#8222;Azure SSIS Integration Runtime&#8220;.<\/p>\n\n\n\n<p>Es wird entweder nur die &#8222;Integration Runtime&#8220; als Laufzeitumgebung gen\u00fctzt und die Steuerung wie bisher \u00fcber den &#8222;SQL Server Agent&#8220; betrieben oder man nutzt die &#8222;Data Factory&#8220; zur Orchestrierung.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Analyse_Cube_SSAS\"><\/span>Analysis Cube (SSAS)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-pullquote\"><blockquote><p>The multidimensional model does not exist in the cloud!<\/p><\/blockquote><\/figure>\n\n\n\n<p>Hier gibt es nur &#8222;Tabular&#8220;.<\/p>\n\n\n\n<p>Das bedeutet, wenn das Modell nicht schon zuvor &#8222;Tabular&#8220; war, einen kompletten Neuaufbau eines Modells, mit all seinen Unterschieden und auch die Berechnungen (MDX) m\u00fcssen neu, bzw. anders gel\u00f6st werden (DAX).<\/p>\n\n\n\n<p>Das Tabuar Modell l\u00e4uft dann auf einem &#8222;Azure Analysis Services&#8220; (AAS) oder eventuell auf Power BI Premium, was im Prinzip technologisch gleich ist.<\/p>\n\n\n\n<p>If the multidimensional model is to be retained in any case, there is only the alternative with a virtual machine in Azure, which runs just like on-prem SSAS on an SQL server, which is accordingly integrated into the Azure vnet.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Reporting_SSRS\"><\/span>Reporting (SSRS)<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<figure class=\"wp-block-pullquote\"><blockquote><p>SSRS does not exist in the cloud.<\/p><\/blockquote><\/figure>\n\n\n\n<p>Das moderne Reporting hei\u00dft &#8222;Power BI&#8220; und kann direkt an das AAS-Modell andocken, weitere Quellen integrieren oder \u00fcberhaupt das Modell ebenfalls Teil von Power BI sein (&#8222;Power BI Premium&#8220;).<\/p>\n\n\n\n<p>If the very outdated SSRS is still to be operated, only one virtual machine in Azure can do it.<\/p>\n\n\n\n<p>Excel als Frontend kommt zwar in Frage, entspricht aber auch nicht mehr einem modernen Reporting und kann im Bedarfsfall auch aus Power BI heraus verwendet werden (&#8222;Analyze in Excel&#8220;).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Azure_Cloud_BI\"><\/span>Azure Cloud BI<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-pullquote\"><blockquote><p>Why aren't the same services just in the cloud?<\/p><\/blockquote><\/figure>\n\n\n\n<p>Cloud services have completely different criteria and thus also different technologies and features.<br>A real cloud solution looks completely different, but it has all the advantages mentioned, which is why you want to migrate to the cloud.<\/p>\n\n\n\n<p>Here is an exemplary architecture:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"428\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Azure_BI_PBI-1024x428.jpg\" alt=\"\" class=\"wp-image-289\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Azure_BI_PBI-1024x428.jpg 1024w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Azure_BI_PBI-300x125.jpg 300w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Azure_BI_PBI-768x321.jpg 768w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Azure_BI_PBI-1536x642.jpg 1536w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Azure_BI_PBI-16x7.jpg 16w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Azure_BI_PBI-600x251.jpg 600w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Azure_BI_PBI-945x395.jpg 945w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Azure_BI_PBI.jpg 1547w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Azure BI mit Azure SQL und Power BI Premium<\/figcaption><\/figure>\n\n\n\n<p>This reference architecture has these essential components:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Ingestion (staging): data delivery in a BLOB storage or directly in an SQL database.<\/li><li>Data warehouse: Azure SQL Server<\/li><li>Loading processes \/ transformations: Azure Data Factory<\/li><li>Analysis model: Azure Analysis Services or integrated with Power BI Premium<\/li><li>Reporting: Power BI<\/li><\/ul>\n\n\n\n<p>Essentially, the layers and processes are almost the same as on-premise, only the technology is different.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Losungen\"><\/span>Solutions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-pullquote\"><blockquote><p>What solutions are there now?<\/p><\/blockquote><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Migration_mit_on-prem_Technologien\"><\/span>Migration with on-prem technologies<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>If everything is to be retained in the same way as possible, the technologies must also be retained and operated in the cloud.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Database (MSSQL): Azure SQL Managed Instance<\/li><li>ETL (SSIS): Existing SSIS packages on Azure SQL MI with Azure Data Factory Integration Runtime<\/li><li>Analysis Cube (SSAS): If there is no tabular model, only the operation of SSAS (including SQL server) on an Azure VM remains<\/li><li>Reporting (SSRS): Can also only be implemented as an Azure VM.<\/li><\/ul>\n\n\n\n<p><strong>Pros:<\/strong><\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-298\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif\" alt=\"Plus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  low effort \/ cost<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-298\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif\" alt=\"Plus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  known existing technology<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-298\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif\" alt=\"Plus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  Skillset for further development and operation remains almost the same<\/p>\n\n\n\n<p><strong>Cons:<\/strong><\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-299\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif\" alt=\"Minus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  SSIS will be around longer, but it is not a cloud technology!<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-299\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif\" alt=\"Minus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  SSAS multidimensional is mature and popular, but at some point it will be superseded by tabular<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-299\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif\" alt=\"Minus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  SSRS was already outdated 10 years ago and no longer meets the requirements (neither in development nor with the end user)<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-299\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif\" alt=\"Minus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  Slowly through DB access<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-299\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif\" alt=\"Minus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  Operation with VMs in the vNet and gateways becomes more complicated and more maintenance-intensive in the cloud<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-299\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif\" alt=\"Minus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  Scaling is only possible to a very limited extent<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-299\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif\" alt=\"Minus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  Ev. License costs for multiple SQL servers<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-299\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif\" alt=\"Minus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  CI \/ CD development and deployment hardly possible<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Bestehender_ETL_mit_modernem_Analyse-Reporting\"><\/span>Existing ETL with modern analysis reporting<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The database and structure are taken over, the SSIS packages for the ETL remain essentially the same. <\/p>\n\n\n\n<p>For reporting, a new tabular model is designed from the relational database and operated on Azure; this serves as a database for Power BI as a reporting tool.<\/p>\n\n\n\n<p>(If necessary, a drill down to the relational database can also be considered)<br>(As an alternative to AAS, Power BI Premium could also be used)<\/p>\n\n\n\n<p><strong>Pros<\/strong>:<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-298\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif\" alt=\"Plus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  low effort \/ cost<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-298\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif\" alt=\"Plus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  known existing technology<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-298\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif\" alt=\"Plus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  Fast performance through in-memory (AAS)<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-298\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif\" alt=\"Plus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  Tabular is optimized for analysis queries<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-298\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif\" alt=\"Plus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  Skillset for further development and operation remains the same for ETL<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-298\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif\" alt=\"Plus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  Operation can be largely scaled<\/p>\n\n\n\n<p><strong>Cons<\/strong>:<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-299\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif\" alt=\"Minus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  SSIS will be around longer, but it is not a cloud technology!<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-299\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif\" alt=\"Minus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  Additional effort for analysis model and new reporting<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-299\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif\" alt=\"Minus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  New skills for Tabular, DAX, Power BI (doesn't have to be a disadvantage)<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-299\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif\" alt=\"Minus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  CI \/ CD development and deployment very limited<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Nachhaltige_Cloud-Losung\"><\/span>Sustainable cloud solution<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Complete cloud solution with the Azure services provided.<\/p>\n\n\n\n<p>Future integration of other architectures (data lake, data science, streaming, etc.).<\/p>\n\n\n\n<p><strong>Pros<\/strong>:<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-298\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif\" alt=\"Plus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  Sustainable modern cloud solution<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-298\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif\" alt=\"Plus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  Fast performance through in-memory<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-298\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif\" alt=\"Plus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  Tabular is optimized for analysis queries<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-298\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif\" alt=\"Plus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  Zukunftssicher f\u00fcr Erweiterungen: Data Lake, Data Science, Streaming, Lambda-Architektur<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-298\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif\" alt=\"Plus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  Integrated security between all Azure services (DB, AAS, ADF, PBI)<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-298\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif\" alt=\"Plus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  CI \/ CD development and deployment via integrated Azure DevOps and GIT<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-298\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif\" alt=\"Plus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/plus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  Flexible and cost-saving operation through scaling<\/p>\n\n\n\n<p><strong>Cons<\/strong>:<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-299\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif\" alt=\"Minus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  Higher migration effort<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-299\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif\" alt=\"Minus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  Additional effort for new technologies except for the database<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-299\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif\" alt=\"Minus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  Greater effort if complex logic is in SSIS and not in DB<\/p>\n\n\n\n<p><img loading=\"lazy\" decoding=\"async\" width=\"32\" height=\"32\" class=\"wp-image-299\" style=\"width: 32px;\" src=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif\" alt=\"Minus\" srcset=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32.gif 32w, http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/minus-32-12x12.gif 12w\" sizes=\"auto, (max-width: 32px) 100vw, 32px\" \/>  New skills for ADF, Tabular, DAX, Power BI (doesn't have to be a disadvantage)<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Projektszenario\"><\/span>Project scenario<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Aufwand\"><\/span>Effort<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>If a sustainable and flexible cloud solution is sought, it can take longer for a migration to be completed.<\/p>\n\n\n\n<p><strong>Database<\/strong><br>Usually not a big problem, because it is again an SQL database and T-SQL is also available.<\/p>\n\n\n\n<p><strong>ETL:<\/strong><br>In particular, the conversion of the ETL can go quickly if the packages are very simple, but become quite complex if there is a lot of logic in SSIS, and there is a completely new tool, the ADF.<\/p>\n\n\n\n<p><strong>Cube:<\/strong><br>Das Analysemodell ist meist nicht so kritisch, allerdings gibt es einige Aspekte bei &#8222;multidimensional&#8220; die es in &#8222;Tabular&#8220; nicht gibt, sehr viele und koplexe MDX-Berechnungen k\u00f6nnen es auch erschweren und grunds\u00e4tzlich ist die Denkweise in &#8222;Tabular&#8220; anders, bietet aber auch neue Vorteile.<\/p>\n\n\n\n<p><strong>Reporting:<\/strong><br>A renewal makes sense anyway, Power BI is a modern, high-performance tool that meets today's key user requirements.<br>The reports are completely redesigned, but their content is also assessed, interactive reporting and self-service work differently. <br>Es ist ein h\u00e4ufiger &#8222;Fehler&#8220;, die bisherigen Reports einfach nachzubauen, besser ist es, nicht die bestehenden Reports zu analysieren, sondern zu erheben was die Fachanwender genau ben\u00f6tigen an Funktion und Inhalt und daraus das Modell und Reports abzuleiten.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Projekt_in_zwei_Phasen\"><\/span>Project in two phases<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In order to get into the cloud and into operation more quickly, it is conceivable to migrate to two parts, whereby the first part can go into operation much earlier.<\/p>\n\n\n\n<p>First, the database and ETL are migrated with the existing SSIS.<br>Neu erstellt wird nur das Tabular-Modell und die Power BI Reports.<\/p>\n\n\n\n<p>In a second phase, while operations are already running, the possibly more complex ETL can be converted; the business layers can remain unchanged.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusio\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In conclusion, it can be said that a simple migration from MS BI solutions to the cloud does not exist, but only makes limited sense, because in order to use the advantages and aspects of the cloud and expand them in the future, other concepts, technologies and tools are needed, so it is also a different, a new solution.<\/p>\n\n\n\n<p>The migration to the cloud with proven on-premise technologies makes perfect sense, but not in terms of technology or future expansion, but only from short to medium-term cost and time considerations.<\/p>\n\n\n\n<figure class=\"wp-block-pullquote\"><blockquote><p>Share your experience with a comment below!<\/p><\/blockquote><\/figure>","protected":false},"excerpt":{"rendered":"<p>Seit \u00fcber 10 Jahren hat sich der &#8222;Microsoft BI Stack&#8220; als integrierte, stabile und g\u00fcnstige Bussines Intelligence L\u00f6sung etabliert und wird in zahlosen Unternehmen eingesetzt.<\/p>\n<p>Time for a renewal, the cloud is waiting with modernity, scalability and cost savings.<\/p>","protected":false},"author":1,"featured_media":202,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[5,55,6,3,4,7],"tags":[56,57,31,40,53,54,23,22,24],"class_list":["post-65","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure","category-business-intelligence-bi","category-datentransformation-etl","category-power-bi","category-sql-datenbanken","category-tabular-analysis-services","tag-bi","tag-business-intelligence","tag-etl","tag-migration","tag-ms-bi","tag-sql-server","tag-ssas","tag-ssis","tag-ssrs"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Der &quot;Burger&quot; hebt ab in die Cloud! - Data.Engineer BLOG<\/title>\n<meta name=\"description\" content=\"Seit \u00fcber 10 Jahren hat sich der &quot;Microsoft BI Stack&quot; als integrierte, stabile und g\u00fcnstige Bussines Intelligence L\u00f6sung etabliert und wird in zahlosen Unternehmen eingesetzt.Zeit f\u00fcr eine Erneuerung, es wartet die Cloud mit Modernit\u00e4t, Skalierbarkeit und Kosteneinsparung.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Der &quot;Burger&quot; hebt ab in die Cloud! - Data.Engineer BLOG\" \/>\n<meta property=\"og:description\" content=\"Seit \u00fcber 10 Jahren hat sich der &quot;Microsoft BI Stack&quot; als integrierte, stabile und g\u00fcnstige Bussines Intelligence L\u00f6sung etabliert und wird in zahlosen Unternehmen eingesetzt.Zeit f\u00fcr eine Erneuerung, es wartet die Cloud mit Modernit\u00e4t, Skalierbarkeit und Kosteneinsparung.\" \/>\n<meta property=\"og:url\" content=\"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/\" \/>\n<meta property=\"og:site_name\" content=\"Data.Engineer BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-18T17:00:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-18T22:45:11+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Wie-bekomme-ich-mein-MS-BI-in-die-Cloud.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"360\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"data.engineer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"data.engineer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"16 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/der-burger-hebt-ab-in-die-cloud\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/der-burger-hebt-ab-in-die-cloud\\\/\"},\"author\":{\"name\":\"data.engineer\",\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/#\\\/schema\\\/person\\\/fe307e617b3de204775ffd3d9d8dc04a\"},\"headline\":\"Der &#8222;Burger&#8220; hebt ab in die Cloud!\",\"datePublished\":\"2021-01-18T17:00:02+00:00\",\"dateModified\":\"2021-01-18T22:45:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/der-burger-hebt-ab-in-die-cloud\\\/\"},\"wordCount\":1854,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/#\\\/schema\\\/person\\\/fe307e617b3de204775ffd3d9d8dc04a\"},\"image\":{\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/der-burger-hebt-ab-in-die-cloud\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/blog.dataengineer.at\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/Wie-bekomme-ich-mein-MS-BI-in-die-Cloud.jpg\",\"keywords\":[\"bi\",\"business intelligence\",\"etl\",\"migration\",\"ms bi\",\"sql server\",\"ssas\",\"ssis\",\"ssrs\"],\"articleSection\":[\"Azure\",\"Business Intelligence (BI)\",\"Datentransformation (ETL)\",\"Power BI\",\"SQL Datenbanken\",\"Tabular \\\/ Analysis Services\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/der-burger-hebt-ab-in-die-cloud\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/der-burger-hebt-ab-in-die-cloud\\\/\",\"url\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/der-burger-hebt-ab-in-die-cloud\\\/\",\"name\":\"Der \\\"Burger\\\" hebt ab in die Cloud! - Data.Engineer BLOG\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/der-burger-hebt-ab-in-die-cloud\\\/#primaryimage\"},\"image\":{\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/der-burger-hebt-ab-in-die-cloud\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/blog.dataengineer.at\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/Wie-bekomme-ich-mein-MS-BI-in-die-Cloud.jpg\",\"datePublished\":\"2021-01-18T17:00:02+00:00\",\"dateModified\":\"2021-01-18T22:45:11+00:00\",\"description\":\"Seit \u00fcber 10 Jahren hat sich der \\\"Microsoft BI Stack\\\" als integrierte, stabile und g\u00fcnstige Bussines Intelligence L\u00f6sung etabliert und wird in zahlosen Unternehmen eingesetzt.Zeit f\u00fcr eine Erneuerung, es wartet die Cloud mit Modernit\u00e4t, Skalierbarkeit und Kosteneinsparung.\",\"breadcrumb\":{\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/der-burger-hebt-ab-in-die-cloud\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/der-burger-hebt-ab-in-die-cloud\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/der-burger-hebt-ab-in-die-cloud\\\/#primaryimage\",\"url\":\"http:\\\/\\\/blog.dataengineer.at\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/Wie-bekomme-ich-mein-MS-BI-in-die-Cloud.jpg\",\"contentUrl\":\"http:\\\/\\\/blog.dataengineer.at\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/Wie-bekomme-ich-mein-MS-BI-in-die-Cloud.jpg\",\"width\":640,\"height\":360},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/der-burger-hebt-ab-in-die-cloud\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"http:\\\/\\\/blog.dataengineer.at\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Der &#8220;Burger&#8221; hebt ab in die Cloud!\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/#website\",\"url\":\"http:\\\/\\\/blog.dataengineer.at\\\/\",\"name\":\"Data.Engineer BLOG\",\"description\":\"All about data...\",\"publisher\":{\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/#\\\/schema\\\/person\\\/fe307e617b3de204775ffd3d9d8dc04a\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/blog.dataengineer.at\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/#\\\/schema\\\/person\\\/fe307e617b3de204775ffd3d9d8dc04a\",\"name\":\"data.engineer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/Oliver_Cartoon3_240x320-1-150x150.jpg\",\"url\":\"http:\\\/\\\/blog.dataengineer.at\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/Oliver_Cartoon3_240x320-1-150x150.jpg\",\"contentUrl\":\"http:\\\/\\\/blog.dataengineer.at\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/Oliver_Cartoon3_240x320-1-150x150.jpg\",\"caption\":\"data.engineer\"},\"logo\":{\"@id\":\"http:\\\/\\\/blog.dataengineer.at\\\/wp-content\\\/uploads\\\/2020\\\/12\\\/Oliver_Cartoon3_240x320-1-150x150.jpg\"},\"sameAs\":[\"http:\\\/\\\/dataengineer.at\"],\"url\":\"http:\\\/\\\/blog.dataengineer.at\\\/en\\\/author\\\/data-engineer\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Der \"Burger\" hebt ab in die Cloud! - Data.Engineer BLOG","description":"Seit \u00fcber 10 Jahren hat sich der \"Microsoft BI Stack\" als integrierte, stabile und g\u00fcnstige Bussines Intelligence L\u00f6sung etabliert und wird in zahlosen Unternehmen eingesetzt.Zeit f\u00fcr eine Erneuerung, es wartet die Cloud mit Modernit\u00e4t, Skalierbarkeit und Kosteneinsparung.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/","og_locale":"en_US","og_type":"article","og_title":"Der \"Burger\" hebt ab in die Cloud! - Data.Engineer BLOG","og_description":"Seit \u00fcber 10 Jahren hat sich der \"Microsoft BI Stack\" als integrierte, stabile und g\u00fcnstige Bussines Intelligence L\u00f6sung etabliert und wird in zahlosen Unternehmen eingesetzt.Zeit f\u00fcr eine Erneuerung, es wartet die Cloud mit Modernit\u00e4t, Skalierbarkeit und Kosteneinsparung.","og_url":"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/","og_site_name":"Data.Engineer BLOG","article_published_time":"2021-01-18T17:00:02+00:00","article_modified_time":"2021-01-18T22:45:11+00:00","og_image":[{"width":640,"height":360,"url":"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Wie-bekomme-ich-mein-MS-BI-in-die-Cloud.jpg","type":"image\/jpeg"}],"author":"data.engineer","twitter_card":"summary_large_image","twitter_misc":{"Written by":"data.engineer","Est. reading time":"16 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#article","isPartOf":{"@id":"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/"},"author":{"name":"data.engineer","@id":"http:\/\/blog.dataengineer.at\/#\/schema\/person\/fe307e617b3de204775ffd3d9d8dc04a"},"headline":"Der &#8222;Burger&#8220; hebt ab in die Cloud!","datePublished":"2021-01-18T17:00:02+00:00","dateModified":"2021-01-18T22:45:11+00:00","mainEntityOfPage":{"@id":"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/"},"wordCount":1854,"commentCount":0,"publisher":{"@id":"http:\/\/blog.dataengineer.at\/#\/schema\/person\/fe307e617b3de204775ffd3d9d8dc04a"},"image":{"@id":"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#primaryimage"},"thumbnailUrl":"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Wie-bekomme-ich-mein-MS-BI-in-die-Cloud.jpg","keywords":["bi","business intelligence","etl","migration","ms bi","sql server","ssas","ssis","ssrs"],"articleSection":["Azure","Business Intelligence (BI)","Datentransformation (ETL)","Power BI","SQL Datenbanken","Tabular \/ Analysis Services"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/","url":"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/","name":"Der \"Burger\" hebt ab in die Cloud! - Data.Engineer BLOG","isPartOf":{"@id":"http:\/\/blog.dataengineer.at\/#website"},"primaryImageOfPage":{"@id":"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#primaryimage"},"image":{"@id":"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#primaryimage"},"thumbnailUrl":"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Wie-bekomme-ich-mein-MS-BI-in-die-Cloud.jpg","datePublished":"2021-01-18T17:00:02+00:00","dateModified":"2021-01-18T22:45:11+00:00","description":"Seit \u00fcber 10 Jahren hat sich der \"Microsoft BI Stack\" als integrierte, stabile und g\u00fcnstige Bussines Intelligence L\u00f6sung etabliert und wird in zahlosen Unternehmen eingesetzt.Zeit f\u00fcr eine Erneuerung, es wartet die Cloud mit Modernit\u00e4t, Skalierbarkeit und Kosteneinsparung.","breadcrumb":{"@id":"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#primaryimage","url":"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Wie-bekomme-ich-mein-MS-BI-in-die-Cloud.jpg","contentUrl":"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Wie-bekomme-ich-mein-MS-BI-in-die-Cloud.jpg","width":640,"height":360},{"@type":"BreadcrumbList","@id":"http:\/\/blog.dataengineer.at\/en\/der-burger-hebt-ab-in-die-cloud\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"http:\/\/blog.dataengineer.at\/"},{"@type":"ListItem","position":2,"name":"Der &#8220;Burger&#8221; hebt ab in die Cloud!"}]},{"@type":"WebSite","@id":"http:\/\/blog.dataengineer.at\/#website","url":"http:\/\/blog.dataengineer.at\/","name":"Data.Engineer BLOG","description":"All about data...","publisher":{"@id":"http:\/\/blog.dataengineer.at\/#\/schema\/person\/fe307e617b3de204775ffd3d9d8dc04a"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/blog.dataengineer.at\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"http:\/\/blog.dataengineer.at\/#\/schema\/person\/fe307e617b3de204775ffd3d9d8dc04a","name":"data.engineer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Oliver_Cartoon3_240x320-1-150x150.jpg","url":"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Oliver_Cartoon3_240x320-1-150x150.jpg","contentUrl":"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Oliver_Cartoon3_240x320-1-150x150.jpg","caption":"data.engineer"},"logo":{"@id":"http:\/\/blog.dataengineer.at\/wp-content\/uploads\/2020\/12\/Oliver_Cartoon3_240x320-1-150x150.jpg"},"sameAs":["http:\/\/dataengineer.at"],"url":"http:\/\/blog.dataengineer.at\/en\/author\/data-engineer\/"}]}},"post_mailing_queue_ids":[],"_links":{"self":[{"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/posts\/65","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/comments?post=65"}],"version-history":[{"count":102,"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/posts\/65\/revisions"}],"predecessor-version":[{"id":430,"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/posts\/65\/revisions\/430"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/media\/202"}],"wp:attachment":[{"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/media?parent=65"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/categories?post=65"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.dataengineer.at\/en\/wp-json\/wp\/v2\/tags?post=65"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}