{"id":4745,"date":"2025-12-22T10:00:40","date_gmt":"2025-12-22T09:00:40","guid":{"rendered":"https:\/\/data4success.de\/?p=4745"},"modified":"2025-11-27T08:09:40","modified_gmt":"2025-11-27T07:09:40","slug":"data-warehouse-in-microsoft-fabric-modern-analysis-with-familiar-sql","status":"publish","type":"post","link":"https:\/\/data4success.de\/en\/data-warehouse-in-microsoft-fabric-modern-analysis-with-familiar-sql\/","title":{"rendered":"Data Warehouse in Microsoft Fabric - modern analyses with familiar SQL"},"content":{"rendered":"<div data-elementor-type=\"wp-post\" data-elementor-id=\"4745\" class=\"elementor elementor-4745\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-880faf9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"880faf9\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2c061e7\" data-id=\"2c061e7\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-16046e3 elementor-widget elementor-widget-text-editor\" data-id=\"16046e3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p data-start=\"427\" data-end=\"776\">Many companies in the SME sector have been relying on traditional <strong data-start=\"494\" data-end=\"513\">Data warehouses<\/strong>, to extract their ERP data from <strong data-start=\"537\" data-end=\"585\">Dynamics NAV, Navision or Business Central<\/strong> evaluate. The advantage: structured tables, clear models and fast queries with SQL. The disadvantage: these systems are often cumbersome, expensive and require complex ETL processes.<\/p><p data-start=\"778\" data-end=\"963\">With the <strong data-start=\"786\" data-end=\"824\">Data Warehouse in Microsoft Fabric<\/strong> Microsoft is launching a modern solution that combines both worlds: <strong data-start=\"905\" data-end=\"929\">Cloud scalability<\/strong> and <strong data-start=\"934\" data-end=\"960\">Classic SQL analysis<\/strong>.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-496831f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"496831f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9e11008\" data-id=\"9e11008\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0287e33 elementor-widget elementor-widget-text-editor\" data-id=\"0287e33\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3 data-start=\"965\" data-end=\"1016\">What makes the Fabric Data Warehouse special?<\/h3><ul data-start=\"1017\" data-end=\"1525\"><li data-start=\"1017\" data-end=\"1125\"><p data-start=\"1019\" data-end=\"1125\"><strong data-start=\"1019\" data-end=\"1045\">Serverless architecture<\/strong>No more managing your own servers, resources are scaled automatically.<\/p><\/li><li data-start=\"1126\" data-end=\"1268\"><p data-start=\"1128\" data-end=\"1268\"><strong data-start=\"1128\" data-end=\"1163\">Direct integration with OneLake<\/strong>All data stored in OneLake can be used immediately in the warehouse - without copies.<\/p><\/li><li data-start=\"1269\" data-end=\"1406\"><p data-start=\"1271\" data-end=\"1406\"><strong data-start=\"1271\" data-end=\"1296\">Familiar SQL language<\/strong>Developers and analysts can continue to work with SQL as they are used to from classic systems.<\/p><\/li><li data-start=\"1407\" data-end=\"1525\"><p data-start=\"1409\" data-end=\"1525\"><strong data-start=\"1409\" data-end=\"1444\">Seamless connection to Power BI<\/strong>Reports access the warehouse directly, without additional interfaces.<\/p><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e33bc6b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e33bc6b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-86d0dd7\" data-id=\"86d0dd7\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8be9b80 elementor-widget elementor-widget-text-editor\" data-id=\"8be9b80\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3 data-start=\"1527\" data-end=\"1594\">Why is this exciting for NAV, Navision and Business Central?<\/h3><p data-start=\"1595\" data-end=\"1767\">ERP systems contain huge amounts of structured data: Bookings, orders, article master data, stock movements.<br data-start=\"1710\" data-end=\"1713\" \/>With the Data Warehouse in Fabric, companies can:<\/p><ul data-start=\"1768\" data-end=\"2026\"><li data-start=\"1768\" data-end=\"1821\"><p data-start=\"1770\" data-end=\"1821\">This data <strong data-start=\"1782\" data-end=\"1797\">in real time<\/strong> from OneLake.<\/p><\/li><li data-start=\"1822\" data-end=\"1916\"><p data-start=\"1824\" data-end=\"1916\"><strong data-start=\"1824\" data-end=\"1841\">Complex KPIs<\/strong> (e.g. contribution margins, cash flow calculations) directly in SQL.<\/p><\/li><li data-start=\"1917\" data-end=\"2026\"><p data-start=\"1919\" data-end=\"2026\">Combine data from NAV or Business Central with other sources (e.g. CRM or production systems).<\/p><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-915904e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"915904e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-dc6c46a\" data-id=\"dc6c46a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-721dd78 elementor-widget elementor-widget-text-editor\" data-id=\"721dd78\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3 data-start=\"2028\" data-end=\"2061\">Advantages for SMEs<\/h3><ul data-start=\"2062\" data-end=\"2474\"><li data-start=\"2062\" data-end=\"2143\"><p data-start=\"2064\" data-end=\"2143\"><strong data-start=\"2064\" data-end=\"2087\">Simple administration<\/strong>Less IT effort, as Fabric takes over the hosting.<\/p><\/li><li data-start=\"2144\" data-end=\"2246\"><p data-start=\"2146\" data-end=\"2246\"><strong data-start=\"2146\" data-end=\"2165\">Cost efficiency<\/strong>Billing is based on usage - no fixed license costs for database servers.<\/p><\/li><li data-start=\"2247\" data-end=\"2352\"><p data-start=\"2249\" data-end=\"2352\"><strong data-start=\"2249\" data-end=\"2265\">Flexibility<\/strong>Reports can be adapted quickly without the need for months-long projects.<\/p><\/li><li data-start=\"2353\" data-end=\"2474\"><p data-start=\"2355\" data-end=\"2474\"><strong data-start=\"2355\" data-end=\"2377\">Future security<\/strong>Fabric combines classic SQL queries with modern scenarios such as AI and machine learning.<\/p><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-65a431b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"65a431b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-37eba50\" data-id=\"37eba50\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-92a5e1c elementor-widget elementor-widget-text-editor\" data-id=\"92a5e1c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p data-start=\"2487\" data-end=\"2649\">The <strong data-start=\"2491\" data-end=\"2529\">Data Warehouse in Microsoft Fabric<\/strong> is the bridge between the familiar world of classic SQL analyses and the flexibility of modern cloud platforms.<\/p><p data-start=\"2651\" data-end=\"2859\">For companies with <strong data-start=\"2671\" data-end=\"2719\">Dynamics NAV, Navision or Business Central<\/strong> This means familiar queries, less IT work - and the ability to use their ERP data even more efficiently for decision-making.<\/p><p data-start=\"2651\" data-end=\"2859\"><strong>Do you have any questions or would you like to find out more about our methods?<\/strong> <a href=\"https:\/\/data4success.de\/en\/contact\/\">Get in touch with us<\/a> - We show you how you can use your data for sustainable success.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"<p>Viele Unternehmen im Mittelstand setzen seit Jahren auf klassische Data Warehouses, um ihre ERP-Daten aus Dynamics NAV, Navision oder Business Central auszuwerten. Der Vorteil: strukturierte Tabellen, klare Modelle und schnelle Abfragen mit SQL. Der Nachteil: Oft sind diese Systeme schwerf\u00e4llig, teuer und erfordern komplexe ETL-Prozesse. Mit dem Data Warehouse in Microsoft Fabric bringt Microsoft eine [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":4752,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4745","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/4745","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/comments?post=4745"}],"version-history":[{"count":8,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/4745\/revisions"}],"predecessor-version":[{"id":4795,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/posts\/4745\/revisions\/4795"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/media\/4752"}],"wp:attachment":[{"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/media?parent=4745"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/categories?post=4745"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data4success.de\/en\/wp-json\/wp\/v2\/tags?post=4745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}