{"id":102124,"date":"2022-03-07T00:00:00","date_gmt":"2022-03-07T05:00:00","guid":{"rendered":"https:\/\/sisn.com\/7-benefits-of-data-lake-analytics\/"},"modified":"2025-02-16T20:48:22","modified_gmt":"2025-02-17T01:48:22","slug":"thesis-qa-7-benefits-of-microsoft-data-lake-analytics","status":"publish","type":"post","link":"https:\/\/sisn.com\/en-gb\/thesis-qa-7-benefits-of-microsoft-data-lake-analytics\/","title":{"rendered":"THESIS Q&A: 7 Benefits of Microsoft Data Lake Analytics"},"content":{"rendered":"\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Q&A Blog Categories<\/strong><\/span><\/p>

Supply Chain<\/span><\/strong><\/p>

Sheldon Bloom<\/a><\/p>

Change Management<\/span><\/strong><\/p>

Katrina Kostes<\/a><\/p>

Business Intelligence<\/span><\/strong><\/p>

Scott Graham<\/a><\/p>

Project Cost Management<\/span><\/strong><\/p>

Ravi Kannan<\/a><\/p>

Managed Services<\/span><\/strong><\/p>

Jed Hall<\/a><\/p>

Enterprise Asset Management<\/span><\/strong><\/p>

Jim Nelson<\/a><\/p>

ERP Implementation Projects<\/strong><\/span><\/p>

Dr. JT Gorrell<\/a><\/p>

Construction Finance<\/strong><\/span><\/p>

Chelsey Stevens<\/a><\/p>

ERP Project Managers<\/strong><\/span><\/p>

Matt Morey<\/a><\/p>

Construction ERP Pain Points<\/strong><\/span><\/p>

Dave Wolff-Pellingra<\/a><\/p>

Women in Construction and Why it Matters – to Everyone<\/strong><\/span><\/p>

Laurie Jiminez<\/a><\/p>

On-Premise, and Other Construction ERP Insights<\/strong><\/span><\/p>

Charles Rathmann<\/a><\/p>

Real Cost of Procession Union Payroll Manually<\/strong><\/span><\/p>

Luke Dudenhoeffer<\/a><\/p>

AI in construction<\/strong><\/span><\/p>

Ajoy Bhattacharya<\/a><\/p>

ERP User Adoption<\/strong><\/span><\/p>

Steven Mulka<\/a><\/p>

Construction ERP Visibility<\/strong><\/span><\/p>

Mark Egan<\/a><\/p>

Changes in Construction Technology<\/strong><\/span><\/p>

Steve Jones<\/a><\/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

\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Scott Graham | SIS Delivery Manager, BI<\/span><\/strong><\/h2>\n

\"\"Interview by:  Sarah D. Morgan, SIS Senior Marketing Manager<\/span>
<\/span><\/p>\n

\"\"<\/p>\n

\n
\n

Today we are speaking with Scott Graham, Delivery Manager, Business Intelligence at SIS, where he talks about the passing of BYOD to Data Lake, the reasoning, our approach, and the benefits.<\/p>\n

Microsoft describes Data Lake Analytics as \u201cusing your existing IT investments for identity, management, and security. This approach simplifies data governance and makes it easy to extend your current data applications. Data Lake Analytics is integrated with Active Directory for user management and permissions and comes with built-in monitoring and auditing.\u201d<\/p>\n

What we\u2019ve learnt at SIS is that you can connect D365 F&O to a Data Lake to unlock insights hidden in your data with near real-time updates, where the environment is fully managed. You can select data by tables or entities using Power BI, and Azure synapse enabled analytics. This is because Data Lake storage is cheaper and exiting downstream consumption pipes are preserved.<\/p>\n<\/div>\n<\/div>\n

Q: <\/strong>Scott, what can you tell us about your experience with technology?<\/span><\/h2>\n

A:<\/strong><\/span> I\u2019ve been working with ERP data and data warehousing since 2008. Worked a lot of years with SAP \u2013 and the last five years with the Microsoft stack.<\/p>\n

Q: <\/strong>When it comes to BI, what is going on in the market that makes the Data Lake conversation a priority?<\/span><\/h2>\n

A:<\/span>  <\/strong>Companies are migrating their systems to the cloud and looking to democratise their data. To use their data to answer analytical questions as well as enable machine learning. Microsoft\u2019s Azure cloud is a leader in cloud as well as a leader in Analytics. Analytics has also moved into the cloud to enable this.<\/p>\n

Q: <\/strong>Currently, are AX2012 and D365 clients are utilising \u201cBYOD\u201d \u2013 Bring Your Own Database?<\/span><\/h2>\n

A:<\/strong> <\/span> Yes. Exporting data into their own SQL server with BYOD. Now we are seeing clients moving into cloud Data-Lake centric designs and wanting to connect D365 to a data lake. Export to Data lake will help facilitate that migration to a data lake cloud data design. You can connect to an existing Data Lake or bring on a new one. Microsoft will handle all the management of the ETL from D365 F&O to the data lake. Supplying complete and timely data to start you on your analytics journey. Data Lakes are an affordable and scalable way to store data.<\/p>\n

Q: <\/strong>What are a few Client Scenarios?<\/span><\/h2>\n

A:<\/strong><\/span>  1. Client may have an existing BYOD and D365. MSFT\u2019s road map is to have clients move into a Data Lake with Export to Data Lake from D365 F&O to replace BYOD.<\/p>\n

    \n
  1. Client may have D365 F&O currently. Has a desire to move into Azure Analytics. To perform further Analytics with D365 F&O data.<\/li>\n<\/ol>\n

    Q: <\/strong>What is the SIS Methodology to make this happen?<\/span><\/h2>\n

    A:<\/strong><\/span>  SIS has developed and is continuing to invest in Analytic packages that target the construction, engineering, energy, government, and professional services industries. We are building this out with the knowledge that SIS has from working alongside these industries for the past 25 years. We have a suite of dashboards and a cloud architecture that these industries can use to gain valuable insights into their business. These dashboards are delivered along with a modern cloud data platform in Azure. Once installed and configured, this platform will allow clients the ability to utilise the base package and the ability to expand their data analytics platform. It is all based on industry-standard architecture. It allows Ingesting of Data from D365 and many other sources that can be cloud or on-premise. The platform will store, process, and serve the data to end consumers.<\/p>\n