{"id":101934,"date":"2025-01-07T10:28:47","date_gmt":"2025-01-07T15:28:47","guid":{"rendered":"https:\/\/sisn.com\/azure-data-lake\/"},"modified":"2026-01-22T23:18:08","modified_gmt":"2026-01-23T04:18:08","slug":"azure-data-lake","status":"publish","type":"page","link":"https:\/\/sisn.com\/en-gb\/azure-data-lake\/","title":{"rendered":"Azure Data Lake"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"101934\" class=\"elementor elementor-101934 elementor-99227\" data-elementor-post-type=\"page\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5a3082d e-con-full e-flex e-con e-parent\" data-id=\"5a3082d\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;slideshow&quot;,&quot;background_slideshow_gallery&quot;:[{&quot;id&quot;:96984,&quot;url&quot;:&quot;https:\\\/\\\/sisn.com\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/aboutsis.jpg&quot;}],&quot;background_slideshow_loop&quot;:&quot;yes&quot;,&quot;background_slideshow_slide_duration&quot;:5000,&quot;background_slideshow_slide_transition&quot;:&quot;fade&quot;,&quot;background_slideshow_transition_duration&quot;:500}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ca1eeff elementor-hidden-desktop elementor-hidden-tablet elementor-hidden-mobile elementor-widget elementor-widget-spacer\" data-id=\"ca1eeff\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-4faff73 e-con-full e-flex e-con e-child\" data-id=\"4faff73\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;slideshow&quot;,&quot;background_slideshow_gallery&quot;:[{&quot;id&quot;:97350,&quot;url&quot;:&quot;https:\\\/\\\/sisn.com\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/ERP-Services-for-Construction.jpg&quot;}],&quot;background_slideshow_loop&quot;:&quot;yes&quot;,&quot;background_slideshow_slide_duration&quot;:5000,&quot;background_slideshow_slide_transition&quot;:&quot;fade&quot;,&quot;background_slideshow_transition_duration&quot;:500}\">\n\t\t<div class=\"elementor-element elementor-element-f98c4c6 e-con-full e-flex e-con e-child\" data-id=\"f98c4c6\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-0d17dd7 e-con-full e-flex e-con e-child\" data-id=\"0d17dd7\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8e1c783 elementor-widget-tablet__width-inherit elementor-widget elementor-widget-text-editor\" data-id=\"8e1c783\" 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<h1>Azure Data Lake<\/h1>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d3d7ca9 elementor-widget__width-initial elementor-widget elementor-widget-text-editor\" data-id=\"d3d7ca9\" 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 class=\"vc_custom_heading vc_do_custom_heading vc_custom_1670443205795\">A No-Limits Data Lake To Power Intelligent Action<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-755cff9 e-flex e-con-boxed e-con e-parent\" data-id=\"755cff9\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b7f76b5 elementor-widget__width-initial elementor-widget elementor-widget-heading\" data-id=\"b7f76b5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">SIS provides extensive Data Lake services to our Microsoft Dynamics 365 Finance and CRM clients. Our BI team works with our clients to develop cloud road maps or to extract data from D365 Finance.<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3915eb8 e-con-full e-flex e-con e-parent\" data-id=\"3915eb8\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t<div class=\"elementor-element elementor-element-f7750bb e-flex e-con-boxed e-con e-child\" data-id=\"f7750bb\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-ceb8c33 e-con-full e-flex e-con e-child\" data-id=\"ceb8c33\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c32af7f content-align-right the7-hover-visibility-disabled preserve-img-ratio-cover transform-overlay-yes exceeding-frame-yes elementor-widget elementor-widget-the7-image-widget\" data-id=\"c32af7f\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;hover_visibility&quot;:&quot;disabled&quot;}\" data-widget_type=\"the7-image-widget.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"the7-image-container\"><div class=\"the7-image-wrapper the7-elementor-widget the7-transform-container\"><div class=\"post-thumbnail-rollover layzr-bg img-css-resize-wrapper\"><img fetchpriority=\"high\" width=\"800\" height=\"544\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#039;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#039;%20viewBox%3D&#039;0%200%20800%20544&#039;%2F%3E\" class=\"attachment-full size-full preload-me aspect lazy lazy-load\" alt=\"\" sizes=\"(max-width: 800px) 100vw, 800px\" style=\"--ratio: 800 \/ 544;\" data-src=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/data-lake-for-specialty-contractor-microsoft-software.jpeg\" loading=\"eager\" data-srcset=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/data-lake-for-specialty-contractor-microsoft-software.jpeg 800w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/data-lake-for-specialty-contractor-microsoft-software-300x204.jpeg 300w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/data-lake-for-specialty-contractor-microsoft-software-768x522.jpeg 768w\" \/><\/div><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3051f47 e-con-full e-flex e-con e-child\" data-id=\"3051f47\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b741306 elementor-widget elementor-widget-heading\" data-id=\"b741306\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">What is a Data Lake?<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-190e47d elementor-widget elementor-widget-text-editor\" data-id=\"190e47d\" 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>Azure Data Lake Analytics is an on-demand analytics job service that simplifies big data with no infrastructure to manage.<\/p><p>A Data Lake is a storehouse for large amounts of raw data. Data Lake stores can scale to terabytes or petabytes of data. This data usually comes from various heterogeneous sources as structured, semi-structured, or unstructured. The purpose of a Data Lake is to store data in its original state which is different from a traditional data warehouse. Traditional data warehouses transform data at the time of consumption.<\/p><p>A total Data Lake solution consists of storage and processing both. Data Lake storage is designed for infinite scalability, fault tolerance, and high-throughput consumption of data in any shape or size.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6d7ca5e e-flex e-con-boxed e-con e-child\" data-id=\"6d7ca5e\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-d5ef9b9 e-con-full e-flex e-con e-child\" data-id=\"d5ef9b9\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7f7dbb8 content-align-right the7-hover-visibility-disabled preserve-img-ratio-cover transform-overlay-yes exceeding-frame-yes elementor-widget elementor-widget-the7-image-widget\" data-id=\"7f7dbb8\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;hover_visibility&quot;:&quot;disabled&quot;}\" data-widget_type=\"the7-image-widget.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"the7-image-container\"><div class=\"the7-image-wrapper the7-elementor-widget the7-transform-container\"><a class=\"post-thumbnail-rollover layzr-bg img-css-resize-wrapper\" href=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/microsoft-data-lake-for-construction.jpeg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"microsoft-data-lake-for-construction\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6OTkyMzQsInVybCI6Imh0dHBzOlwvXC9zaXNuLmNvbVwvd3AtY29udGVudFwvdXBsb2Fkc1wvMjAyNVwvMDFcL21pY3Jvc29mdC1kYXRhLWxha2UtZm9yLWNvbnN0cnVjdGlvbi5qcGVnIn0%3D\"><img width=\"1084\" height=\"660\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#039;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#039;%20viewBox%3D&#039;0%200%201084%20660&#039;%2F%3E\" class=\"attachment-full size-full preload-me aspect lazy lazy-load\" alt=\"\" sizes=\"(max-width: 1084px) 100vw, 1084px\" style=\"--ratio: 1084 \/ 660;\" data-src=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/microsoft-data-lake-for-construction.jpeg\" loading=\"eager\" data-srcset=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/microsoft-data-lake-for-construction.jpeg 1084w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/microsoft-data-lake-for-construction-300x183.jpeg 300w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/microsoft-data-lake-for-construction-1024x623.jpeg 1024w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/microsoft-data-lake-for-construction-768x468.jpeg 768w\" \/><\/a><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-2a6e210 e-con-full e-flex e-con e-child\" data-id=\"2a6e210\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5663658 elementor-widget elementor-widget-heading\" data-id=\"5663658\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Below are key Data Lake cases:<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f34ee69 elementor-widget elementor-widget-text-editor\" data-id=\"f34ee69\" 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<ul><li><p>Analytics<\/p><\/li><li><p>Reporting<\/p><\/li><li><p>On-premise data transfer<\/p><\/li><li><p>Cloud and IoT data transfer<\/p><\/li><li><p>Big data processing<\/p><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a1fe6a1 elementor-widget elementor-widget-heading\" data-id=\"a1fe6a1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Data Lake Advantages:<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-db50d23 elementor-widget elementor-widget-text-editor\" data-id=\"db50d23\" 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<ul><li><p>Raw data is not discarded<\/p><\/li><li><p>Users can access data and create queries<\/p><\/li><li><p>Many times, the process is faster than current ETL tools<\/p><\/li><li><p>Can store unstructured and semi-structured data<\/p><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3fd6108 e-flex e-con-boxed e-con e-child\" data-id=\"3fd6108\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-27bd8e5 e-con-full e-flex e-con e-child\" data-id=\"27bd8e5\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6112bcf content-align-right the7-hover-visibility-disabled preserve-img-ratio-cover transform-overlay-yes exceeding-frame-yes elementor-widget elementor-widget-the7-image-widget\" data-id=\"6112bcf\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;hover_visibility&quot;:&quot;disabled&quot;}\" data-widget_type=\"the7-image-widget.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"the7-image-container\"><div class=\"the7-image-wrapper the7-elementor-widget the7-transform-container\"><div class=\"post-thumbnail-rollover layzr-bg img-css-resize-wrapper\"><img width=\"800\" height=\"571\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#039;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#039;%20viewBox%3D&#039;0%200%20800%20571&#039;%2F%3E\" class=\"attachment-full size-full preload-me aspect lazy lazy-load\" alt=\"\" sizes=\"(max-width: 800px) 100vw, 800px\" style=\"--ratio: 800 \/ 571;\" data-src=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/microsoft-data-lake-for-construction-reporting.jpeg\" loading=\"eager\" data-srcset=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/microsoft-data-lake-for-construction-reporting.jpeg 800w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/microsoft-data-lake-for-construction-reporting-300x214.jpeg 300w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/microsoft-data-lake-for-construction-reporting-768x548.jpeg 768w\" \/><\/div><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-27ab68c e-con-full e-flex e-con e-child\" data-id=\"27ab68c\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5cac143 elementor-widget elementor-widget-heading\" data-id=\"5cac143\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">When to use a Data Lake<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e32d813 elementor-widget elementor-widget-text-editor\" data-id=\"e32d813\" 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 Lake usage includes\u00a0data analytics, machine learning, and data exploration.<\/p><p>A Data Lake also performs as the data source for a data warehouse. Raw data is consumed into the Data Lake and transformed into a format that is structured and able to be queried. Generally, this process uses an\u00a0ELT\u00a0(extract-load-transform) pipeline, where data is consumed and then transformed. Relational source data can go straight into the data warehouse, through an ELT process, bypassing the Data Lake.<\/p><p>Data Lake stores are also used for event streaming and IoT scenarios. This is because they can process volumes of relational and non-relational data without schema definition or transformation. Data Lake stores are optimized for massive throughput and can handle large amounts of small writes at low latency.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-91bcfc8 e-flex e-con-boxed e-con e-child\" data-id=\"91bcfc8\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-9c8fd71 e-con-full e-flex e-con e-child\" data-id=\"9c8fd71\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1349563 content-align-right the7-hover-visibility-disabled preserve-img-ratio-cover transform-overlay-yes exceeding-frame-yes elementor-widget elementor-widget-the7-image-widget\" data-id=\"1349563\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;hover_visibility&quot;:&quot;disabled&quot;}\" data-widget_type=\"the7-image-widget.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"the7-image-container\"><div class=\"the7-image-wrapper the7-elementor-widget the7-transform-container\"><a class=\"post-thumbnail-rollover layzr-bg img-css-resize-wrapper\" href=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/MicrosoftTeams-image-10.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"MicrosoftTeams-image-10\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6OTkyMzgsInVybCI6Imh0dHBzOlwvXC9zaXNuLmNvbVwvd3AtY29udGVudFwvdXBsb2Fkc1wvMjAyNVwvMDFcL01pY3Jvc29mdFRlYW1zLWltYWdlLTEwLnBuZyJ9\"><img width=\"1112\" height=\"633\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#039;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#039;%20viewBox%3D&#039;0%200%201112%20633&#039;%2F%3E\" class=\"attachment-full size-full preload-me aspect lazy lazy-load\" alt=\"\" sizes=\"(max-width: 1112px) 100vw, 1112px\" style=\"--ratio: 1112 \/ 633;\" data-src=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/MicrosoftTeams-image-10.png\" loading=\"eager\" data-srcset=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/MicrosoftTeams-image-10.png 1112w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/MicrosoftTeams-image-10-300x171.png 300w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/MicrosoftTeams-image-10-1024x583.png 1024w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/MicrosoftTeams-image-10-768x437.png 768w\" \/><\/a><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-920bc03 e-con-full e-flex e-con e-child\" data-id=\"920bc03\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-630473c elementor-widget elementor-widget-heading\" data-id=\"630473c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Data Lake Considerations<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a62f7ea elementor-widget elementor-widget-text-editor\" data-id=\"a62f7ea\" 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<ul><li><p>Schema or descriptive metadata is necessary<\/p><\/li><li><p>Semantic consistency across the data is important<\/p><\/li><li><p>Governance is necessary for access control and privacy issues<\/p><\/li><li><p>Considerations need to be made for relational data<\/p><\/li><li><p>Visualization tools are necessary to provide integrated or holistic views across the organization<\/p><\/li><li><p>Governance is necessary to ensure the Data Lake does not become a dumping ground for data that is never actually analyzed or mined for insights<\/p><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-5c66f54 e-flex e-con-boxed e-con e-child\" data-id=\"5c66f54\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0930e64 elementor-widget__width-initial elementor-widget elementor-widget-heading\" data-id=\"0930e64\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What SIS Can Do for our D365 Clients:<\/h3>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-57155e2 e-flex e-con-boxed e-con e-child\" data-id=\"57155e2\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e36ada6 elementor-widget elementor-widget-text-editor\" data-id=\"e36ada6\" 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>If a client has their own Azure data warehouse, SIS can integrate into that data warehouse.<\/p><p>If a client has Azure and no data warehouse but wants to move into Azure, SIS can build a<br \/>Data warehouse and report platform in Azure.<\/p><p>If a client has their own Azure data warehouse \u2013 and wants SIS IP integrated, SIS can install the IP into their Data Lake.<\/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\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f13c29f e-flex e-con-boxed e-con e-child\" data-id=\"f13c29f\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-51071b7 e-con-full e-flex e-con e-child\" data-id=\"51071b7\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4acbadd content-align-right the7-hover-visibility-disabled preserve-img-ratio-cover transform-overlay-yes exceeding-frame-yes elementor-widget elementor-widget-the7-image-widget\" data-id=\"4acbadd\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;hover_visibility&quot;:&quot;disabled&quot;}\" data-widget_type=\"the7-image-widget.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"the7-image-container\"><div class=\"the7-image-wrapper the7-elementor-widget the7-transform-container\"><div class=\"post-thumbnail-rollover layzr-bg img-css-resize-wrapper\"><img width=\"800\" height=\"533\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D&#039;http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg&#039;%20viewBox%3D&#039;0%200%20800%20533&#039;%2F%3E\" class=\"attachment-full size-full preload-me aspect lazy lazy-load\" alt=\"\" sizes=\"(max-width: 800px) 100vw, 800px\" style=\"--ratio: 800 \/ 533;\" data-src=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/dreamstime_s_205477260.jpeg\" loading=\"eager\" data-srcset=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/dreamstime_s_205477260.jpeg 800w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/dreamstime_s_205477260-300x200.jpeg 300w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/dreamstime_s_205477260-768x512.jpeg 768w\" \/><\/div><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3fa5a44 e-con-full e-flex e-con e-child\" data-id=\"3fa5a44\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3bb3de9 elementor-widget elementor-widget-heading\" data-id=\"3bb3de9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Data Lake &amp; Dynamics 365 Finance<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c6db458 elementor-widget elementor-widget-text-editor\" data-id=\"c6db458\" 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>As an SIS Dynamics 365 Finance or CE client, it is natural to want to harness your ERP data for operational and analytical reporting.\u00a0 The Data Lake architecture will help that and allow an affordable architecture to do it.\u00a0 Azure has all the tools to bring other data into the lake.\u00a0 Be it on-premise or in the cloud, and to secure your data.\u00a0 It will allow you to retire BYOD (Bring Your Own Data).\u00a0 And can be a central hub for a downstream data mart or enterprise data warehouse.\u00a0 With export to Data Lake many other use cases can be built up for:<\/p><ul><li><p>Operational Reporting<\/p><\/li><li><p>Analytics<\/p><\/li><li><p>Data Mashup<\/p><\/li><li><p>Cost effective repository of structured and nonstructured data<\/p><\/li><li><p>Decision enablement<\/p><\/li><li><p>Data and a platform for machine learning<\/p><\/li><li><p>Modern Data Warehouse<\/p><\/li><li><p>Separation of Storage and Computer<\/p><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Azure Data Lake A No-Limits Data Lake To Power Intelligent Action SIS provides extensive Data Lake services to our Microsoft Dynamics 365 Finance and CRM clients. Our BI team works with our clients to develop cloud road maps or to extract data from D365 Finance. What is a Data Lake? Azure Data Lake Analytics is&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":5,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"footnotes":""},"class_list":["post-101934","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.5 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Azure Data Lake | Construction ERP<\/title>\n<meta name=\"description\" content=\"SIS is the leading provider of Microsoft Dynamics 365 Enterprise Resource Planning (ERP), Project Management, and accounting solutions for contractors and professional service companies.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sisn.com\/en-gb\/azure-data-lake\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Azure Data Lake\" \/>\n<meta property=\"og:description\" content=\"SIS is the leading provider of Microsoft Dynamics 365 Enterprise Resource Planning (ERP), Project Management, and accounting solutions for contractors and professional service companies.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sisn.com\/en-gb\/azure-data-lake\/\" \/>\n<meta property=\"og:site_name\" content=\"Construction ERP\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-23T04:18:08+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sisn.com\\\/en-gb\\\/azure-data-lake\\\/\",\"url\":\"https:\\\/\\\/sisn.com\\\/en-gb\\\/azure-data-lake\\\/\",\"name\":\"Azure Data Lake | Construction ERP\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/#website\"},\"datePublished\":\"2025-01-07T15:28:47+00:00\",\"dateModified\":\"2026-01-23T04:18:08+00:00\",\"description\":\"SIS is the leading provider of Microsoft Dynamics 365 Enterprise Resource Planning (ERP), Project Management, and accounting solutions for contractors and professional service companies.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/en-gb\\\/azure-data-lake\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sisn.com\\\/en-gb\\\/azure-data-lake\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sisn.com\\\/en-gb\\\/azure-data-lake\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sisn.com\\\/en-gb\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Azure Data Lake\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sisn.com\\\/#website\",\"url\":\"https:\\\/\\\/sisn.com\\\/\",\"name\":\"Construction ERP with Microsoft & SIS\",\"description\":\"End-to-end project accounting built on Microsoft Dynamics 365\",\"publisher\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/#organization\"},\"alternateName\":\"SIS\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sisn.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/sisn.com\\\/#organization\",\"name\":\"SIS\",\"url\":\"https:\\\/\\\/sisn.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/sisn.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/sisn.com\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/500x500-sis-white-background-and-border-1.jpg\",\"contentUrl\":\"https:\\\/\\\/sisn.com\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/500x500-sis-white-background-and-border-1.jpg\",\"width\":500,\"height\":500,\"caption\":\"SIS\"},\"image\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/793109\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Azure Data Lake | Construction ERP","description":"SIS is the leading provider of Microsoft Dynamics 365 Enterprise Resource Planning (ERP), Project Management, and accounting solutions for contractors and professional service companies.","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:\/\/sisn.com\/en-gb\/azure-data-lake\/","og_locale":"en_GB","og_type":"article","og_title":"Azure Data Lake","og_description":"SIS is the leading provider of Microsoft Dynamics 365 Enterprise Resource Planning (ERP), Project Management, and accounting solutions for contractors and professional service companies.","og_url":"https:\/\/sisn.com\/en-gb\/azure-data-lake\/","og_site_name":"Construction ERP","article_modified_time":"2026-01-23T04:18:08+00:00","twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/sisn.com\/en-gb\/azure-data-lake\/","url":"https:\/\/sisn.com\/en-gb\/azure-data-lake\/","name":"Azure Data Lake | Construction ERP","isPartOf":{"@id":"https:\/\/sisn.com\/#website"},"datePublished":"2025-01-07T15:28:47+00:00","dateModified":"2026-01-23T04:18:08+00:00","description":"SIS is the leading provider of Microsoft Dynamics 365 Enterprise Resource Planning (ERP), Project Management, and accounting solutions for contractors and professional service companies.","breadcrumb":{"@id":"https:\/\/sisn.com\/en-gb\/azure-data-lake\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sisn.com\/en-gb\/azure-data-lake\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/sisn.com\/en-gb\/azure-data-lake\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sisn.com\/en-gb\/"},{"@type":"ListItem","position":2,"name":"Azure Data Lake"}]},{"@type":"WebSite","@id":"https:\/\/sisn.com\/#website","url":"https:\/\/sisn.com\/","name":"Construction ERP with Microsoft & SIS","description":"End-to-end project accounting built on Microsoft Dynamics 365","publisher":{"@id":"https:\/\/sisn.com\/#organization"},"alternateName":"SIS","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sisn.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/sisn.com\/#organization","name":"SIS","url":"https:\/\/sisn.com\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/sisn.com\/#\/schema\/logo\/image\/","url":"https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/500x500-sis-white-background-and-border-1.jpg","contentUrl":"https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/500x500-sis-white-background-and-border-1.jpg","width":500,"height":500,"caption":"SIS"},"image":{"@id":"https:\/\/sisn.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/793109"]}]}},"_links":{"self":[{"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/pages\/101934","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/comments?post=101934"}],"version-history":[{"count":4,"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/pages\/101934\/revisions"}],"predecessor-version":[{"id":106366,"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/pages\/101934\/revisions\/106366"}],"wp:attachment":[{"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/media?parent=101934"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}