{"id":8972,"date":"2024-08-03T14:38:50","date_gmt":"2024-08-03T12:38:50","guid":{"rendered":"https:\/\/www.datamart.de\/microsoft\/"},"modified":"2025-03-28T14:36:36","modified_gmt":"2025-03-28T13:36:36","slug":"microsoft","status":"publish","type":"page","link":"https:\/\/www.datamart.de\/en\/microsoft\/","title":{"rendered":"Microsoft"},"content":{"rendered":"

Your Microsoft Solutions Partner<\/h2><\/div>

At DATA MART Consulting, we have always been pioneers in the implementation of modern data platforms. Long before the introduction of Microsoft SQL Server 7 in 1999 with SSAS (codenamed \u2018PLATO\u2019), we were already successfully implementing relational data warehouses (DWH) and OLAP databases. Today, we continue on this path with the latest Microsoft technologies such as Microsoft Fabric and support companies in the development of powerful, cloud-based data solutions. Our expertise in data engineering, data science and business intelligence ensures optimal integration into the Microsoft cloud environment.<\/p>\n

One advantage for our customers is our internal training program, which ensures that our team is always working with the latest Microsoft technologies. This knowledge flows directly into our projects and enables us to develop innovative, future-proof solutions with real added value. <\/p>\n<\/div>

\"Microsoft<\/span><\/div><\/div><\/div><\/div><\/div>

Due to the current dominance of Microsoft as an analytical data platform, we have a large number of projects that are built on this basis. Most of our latest projects are based on Microsoft Fabric, Azure and Power BI, with a focus on centralized semantic models.<\/span><\/p>\n

Microsoft has set significant standards with on-premises technologies such as SSAS (multidimensional and tabular), the OLAP query language MDX, relational databases, the ETL tool SSIS and the reporting solution SSRS. Most new and further developments are now taking place in the cloud. <\/p>\n

We therefore offer a wide range of Microsoft technologies – both in the cloud and, thanks to our many years of experience, still on-premises:<\/p>\n<\/div>

    \n
  • Microsoft Fabric\n
      \n
    • Power BI<\/li>\n
    • Data Engineering<\/li>\n
    • Data Factory<\/li>\n
    • OneLake<\/li>\n
    • Data Warehouse<\/li>\n
    • Databases<\/li>\n
    • Real-Time Intelligence<\/li>\n
    • Data Science<\/li>\n<\/ul>\n<\/li>\n
    • Azure Synapse Analytics\n
        \n
      • Synapse Pipelines (bases on Azure Data Factory)<\/li>\n
      • Azure Data Lake Storage (ADLS)<\/li>\n
      • On-Demand Serverless SQL<\/li>\n
      • Dedicated SQL Pools<\/li>\n
      • Spark-Pools<\/li>\n
      • Power BI-Integration<\/li>\n
      • Synapse Studio<\/li>\n
      • Azure Machine Learning<\/li>\n
      • Python & R support<\/li>\n<\/ul>\n<\/li>\n
      • Purview\n
          \n
        • Data Governance (Data Map, Unified Catalog, Data Policy, Data Sharing)<\/li>\n
        • Data Security (Information Protection, Insider Risk Management)<\/li>\n
        • Risk & Compliance (Audit, Data Lifecycle Management)<\/li>\n<\/ul>\n<\/li>\n
        • Azure DevOps<\/li>\n
            \n
          • Repos<\/li>\n
          • CI\/CD (Continuous Integration\/Continuous Deployment)-Pipelines<\/li>\n
          • Boards<\/li>\n
          • Test Plans<\/li>\n
          • Artifacts<\/li>\n<\/ul>\n
          • MS SQL Server (On-Premises)<\/li>\n
              \n
            • SQL Server RDBMS<\/li>\n
            • Polybase<\/li>\n
            • MS SSAS (Analysis Services multidimensional)<\/li>\n
            • MS SSAS (Analysis Services tabular)<\/li>\n
            • MS SSIS (Integration Services)<\/li>\n
            • MS SSRS (Reporting Services)<\/li>\n
            • Power BI<\/li>\n<\/ul>\n<\/ul>\n<\/div><\/div><\/div>
              \"Microsoft<\/span><\/div><\/div><\/div><\/div><\/div><\/div>

              You can rely on our expertise<\/h2><\/div><\/div><\/div><\/div><\/div>
              \"DATA<\/span><\/div><\/div><\/div><\/div>

              We have successfully demonstrated our expertise in the scalability and performance of these technologies in projects with enormous data volumes (over 20 billion rows) and a large number of users (over 1,000). As pioneers, we implemented the first productive data warehouse in Germany with \u2018Massive Parallel Processing\u2019 in the Microsoft Analytics Platform System (APS, formerly PDW).<\/p>\n

              Our current data warehouse and data lakehouse implementations are predominantly based on Microsoft Fabric and centralized semantic models. These technologies integrate seamlessly into the existing customer infrastructure, whether for scheduling, monitoring, metadata management or data quality – both in the cloud and on-premises. <\/p>\n

              Our BI front end solutions adapt to the requirements and preferences of users and include systems such as Microsoft, Bissantz, Cubeware, Cognos, Tableau, Pyramid, Yellowfin, SAP BO and many more. With the DATA MART Consulting methodology, we ensure that all key figures and deviation types are provided in a central metadata model (cloud or on-premises). This enables us to guarantee consistency, standardization and high data quality, regardless of the front end used.<\/p>\n<\/div><\/div><\/div><\/div><\/div>

              Let’s get started!<\/h2><\/div>

              The experienced consulting team at DATA MART Consulting is not only available for new projects, but also carries out “health checks” on existing systems. We help you to introduce additions or bring projects that have already begun to a successful conclusion. <\/p>\n

              Experience Microsoft Excellence with DATA MART Consulting – your bridge to efficient management with data<\/b><\/p>\n<\/div><\/div><\/div><\/div><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":8659,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"100-width.php","meta":{"footnotes":""},"class_list":["post-8972","page","type-page","status-publish","has-post-thumbnail","hentry"],"yoast_head":"\nMicrosoft Solutions Partner: Data Warehouse & BI expertise<\/title>\n<meta name=\"description\" content=\"Microsoft Solutions Partner. Specialized in Data Warehouse & BI projects with technologies such as SQL Server, SSAS, Power BI & Azure Cloud, Synapse and MS fabric.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.datamart.de\/en\/microsoft\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Solutions Partner: Data Warehouse & BI expertise\" \/>\n<meta property=\"og:description\" content=\"Microsoft Solutions Partner. Specialized in Data Warehouse & BI projects with technologies such as SQL Server, SSAS, Power BI & Azure Cloud, Synapse and MS fabric.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.datamart.de\/en\/microsoft\/\" \/>\n<meta property=\"og:site_name\" content=\"DATA MART Consulting GmbH\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-28T13:36:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.datamart.de\/wp-content\/uploads\/2024\/07\/f1339378231f101c76b95beefa249972.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/microsoft\\\/\",\"url\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/microsoft\\\/\",\"name\":\"Microsoft Solutions Partner: Data Warehouse & BI expertise\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/microsoft\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/microsoft\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.datamart.de\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/f1339378231f101c76b95beefa249972.jpg\",\"datePublished\":\"2024-08-03T12:38:50+00:00\",\"dateModified\":\"2025-03-28T13:36:36+00:00\",\"description\":\"Microsoft Solutions Partner. Specialized in Data Warehouse & BI projects with technologies such as SQL Server, SSAS, Power BI & Azure Cloud, Synapse and MS fabric.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/microsoft\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.datamart.de\\\/en\\\/microsoft\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/microsoft\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.datamart.de\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/f1339378231f101c76b95beefa249972.jpg\",\"contentUrl\":\"https:\\\/\\\/www.datamart.de\\\/wp-content\\\/uploads\\\/2024\\\/07\\\/f1339378231f101c76b95beefa249972.jpg\",\"width\":1920,\"height\":1080,\"caption\":\"DATA MART Consulting\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/microsoft\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/\",\"name\":\"DATA MART Consulting GmbH\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.datamart.de\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Solutions Partner: Data Warehouse & BI expertise","description":"Microsoft Solutions Partner. Specialized in Data Warehouse & BI projects with technologies such as SQL Server, SSAS, Power BI & Azure Cloud, Synapse and MS fabric.","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":"https:\/\/www.datamart.de\/en\/microsoft\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft Solutions Partner: Data Warehouse & BI expertise","og_description":"Microsoft Solutions Partner. Specialized in Data Warehouse & BI projects with technologies such as SQL Server, SSAS, Power BI & Azure Cloud, Synapse and MS fabric.","og_url":"https:\/\/www.datamart.de\/en\/microsoft\/","og_site_name":"DATA MART Consulting GmbH","article_modified_time":"2025-03-28T13:36:36+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/www.datamart.de\/wp-content\/uploads\/2024\/07\/f1339378231f101c76b95beefa249972.jpg","type":"image\/jpeg"}],"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.datamart.de\/en\/microsoft\/","url":"https:\/\/www.datamart.de\/en\/microsoft\/","name":"Microsoft Solutions Partner: Data Warehouse & BI expertise","isPartOf":{"@id":"https:\/\/www.datamart.de\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datamart.de\/en\/microsoft\/#primaryimage"},"image":{"@id":"https:\/\/www.datamart.de\/en\/microsoft\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datamart.de\/wp-content\/uploads\/2024\/07\/f1339378231f101c76b95beefa249972.jpg","datePublished":"2024-08-03T12:38:50+00:00","dateModified":"2025-03-28T13:36:36+00:00","description":"Microsoft Solutions Partner. Specialized in Data Warehouse & BI projects with technologies such as SQL Server, SSAS, Power BI & Azure Cloud, Synapse and MS fabric.","breadcrumb":{"@id":"https:\/\/www.datamart.de\/en\/microsoft\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.datamart.de\/en\/microsoft\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datamart.de\/en\/microsoft\/#primaryimage","url":"https:\/\/www.datamart.de\/wp-content\/uploads\/2024\/07\/f1339378231f101c76b95beefa249972.jpg","contentUrl":"https:\/\/www.datamart.de\/wp-content\/uploads\/2024\/07\/f1339378231f101c76b95beefa249972.jpg","width":1920,"height":1080,"caption":"DATA MART Consulting"},{"@type":"BreadcrumbList","@id":"https:\/\/www.datamart.de\/en\/microsoft\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/www.datamart.de\/en\/"},{"@type":"ListItem","position":2,"name":"Microsoft"}]},{"@type":"WebSite","@id":"https:\/\/www.datamart.de\/en\/#website","url":"https:\/\/www.datamart.de\/en\/","name":"DATA MART Consulting GmbH","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.datamart.de\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.datamart.de\/en\/wp-json\/wp\/v2\/pages\/8972","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.datamart.de\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.datamart.de\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.datamart.de\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.datamart.de\/en\/wp-json\/wp\/v2\/comments?post=8972"}],"version-history":[{"count":28,"href":"https:\/\/www.datamart.de\/en\/wp-json\/wp\/v2\/pages\/8972\/revisions"}],"predecessor-version":[{"id":10224,"href":"https:\/\/www.datamart.de\/en\/wp-json\/wp\/v2\/pages\/8972\/revisions\/10224"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.datamart.de\/en\/wp-json\/wp\/v2\/media\/8659"}],"wp:attachment":[{"href":"https:\/\/www.datamart.de\/en\/wp-json\/wp\/v2\/media?parent=8972"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}