Learn D365FO Data Lake Reporting & Dashboards in One Week

This course will teach you how to implement a modern Dynamics 365 Business Finance and Supply Chain strategy with Azure [...]

Live session course for Learn D365FO Data Lake Reporting & Dashboards in One Week
Live Course
Run date: June 05, 2023
Course Duration: 7 Days

What you will learn

  • Differences between Synapse, Azure Data Lake, and Synapse in D365 FO
  • How to Query the Data Lake for Information with D365 F&S
  • Report & Dashboard Strategies with D365
  • Practical D365FO Data Lake Reporting by Example
  • Dashboarding Options within D365 such as the Workspace
  • How to trace down data by using the data model in D365

Requirements

  • Students taking this course need internet speeds of at least 10 Mbps.
  • At least 2 monitors are recommended with 1920x1080 resolution.
  • Ability to log into Microsoft Teams for the Live Lesson and view Web Cam

Description

This course will teach you how to implement a modern Dynamics 365 Business Finance and Supply Chain strategy with Azure Data Lake. This course contains over 26 hours of hands-on practical labs designed to teach the following :

  • What are the pros and cons between a pure Data Lake approach, a BYOD approach, and a Synapse based approach for D365?
  • How to go about setting up reporting when using a Data Lake?
  • How to navigate the data model in Dynamics 365 Finance and Supply Chain?
  • What are some of the built-in or Dynamics D365 for reporting and dashboards?
  • How can one utilize the Data Lake to build Powerful Dashboards in conjunction with Power BI?
  • How to utilize modern tools and syntax to query the data lake and get reporting data out of it?
 

Azure Data Lake Enhancements

In this course, you will work extensively from an Azure Data Lake. You will also use other modern software interfaces, such as Databricks, to fully harness the data lake.

Course Content
16 Lectures
8 Quizzes
30 Hands-on Labs
40 Hours
lessons and hands-on labs
  • Module 1 Introduction to Dynamics 365 F&O Reporting
    Introduction to Dynamics 365 F&O Reporting
    Lessons Duration
    Lesson 1 BYOD VS Data Lake Vs Azure Synapse
    		30 min
    Lesson 2 Components needed for Azure Data Lake Setup
    		30 min
    Labs Duration
    Lab 1 Setup an Azure Data Lake for D365 Reporting 1 hour
    Lab 2 Configure Azure Data Lake for Data Retrieval 1 hour
    Lab 3 Configure Azure Data Lake and Power BI 1 hour
  • Module 2 Data is in Data Lake, Now what?
    Data is in Data Lake, Now what?
    Lessons Duration
    Lesson 1 Understanding Databricks SQL to pull Data
    		1 hour
    Lesson 2 Understanding Spark SQL to pull Data
    		1 Hour
    Labs Duration
    Lab 1 Data Lake SQL Challenge 1 1 Hour
    Lab 2 Data Lake SQL Challenge 2 1 Hour
    Lab 3 Data Lake SQL Challenge 3 1 Hour
  • Module 3 Modeling Purchasing in Dynamics 365 F&O Data Lake
    Modeling Purchasing in Dynamics 365 F&O Data Lake
    Lessons Duration
    Lesson 1 Understanding the Primary Tables in Purchasing
    		30 min
    Lesson 2 Mapping the Tables to the Entities for Purchasing
    		30 min
    Labs Duration
    Lab 1 Create a Data Model in the Data Lake for Purchase Reporting 1 Hour
    Lab 2 Bring the Data Model into Power BI for reporting 1 Hour
    Lab 3 Configuring Dynamics Data Lake for Source Control 1 hour
  • Module 4 Modeling Incoming Inventory Process in Dynamics 365 F&O Data Lake
    Modeling Incoming Inventory Process in Dynamics 365 F&O Data Lake
    Lessons Duration
    Lesson 1 Understanding the Primary tables in Incoming Inventory
    		30 min
    Lesson 2 Mapping the tables to the Entities for Inventory Reservation
    		30 min
    Labs Duration
    Lab 1 Create a Data Model in the Data Lake for Inventory Reservation 1 Hour
    Lab 2 Bring the Data Model into Power BI for Reporting 1 Hour
    Lab 3 Challenge Questions in Databricks SQL 1 Hour
  • Module 5 Modeling Project Module Processes in Dynamics 365 F&O Data Lake
    Modeling Project Module Processes in Dynamics 365 F&O Data Lake
    Lessons Duration
    Lesson 1 Understanding the Primary Tables for Project Contracts
    		30 Min
    Lesson 2 Mapping the tables to the Entities for Project Contracts
    Labs Duration
    Lab 1 Create a Data Model for the Primary Tables in Project Module 1 Hour
    Lab 2 Challenge Solve the Databricks Queries by pulling the data 1 Hour
    Lab 3 Challenge Map from form to Entities for Project Module 1 Hour
  • Module 6 Modeling Worker Dependent Activities in Dynamics 365 F&O Data Lake
    Modeling Worker Dependent Activities in Dynamics 365 F&O Data Lake
    Lessons Duration
    Lesson 1 Understanding the Primary Tables for Worker Dependent Activities
    		30 Min
    Lesson 2 Mapping the Tables to the Entities for Worker Dependent Processes
    		30 Min
    Labs Duration
    Lab 1 Create a Data Model for the Primary Tables in Worker Dependent Activities 1 Hour
    Lab 2 Challenge: Solve the Databricks Queries by pulling the Data 1 Hour
    Lab 3 Challenge: Map from form to Report Ready Dataset for HR Dependent Activities 1 Hour
  • Module 7 Modeling Sales Quotation Process in Dynamics 365 F&O Data Lake
    Modeling Sales Quotation Process in Dynamics 365 F&O Data Lake
    Lessons Duration
    Lesson 1 Create a Data Model for the Primary Tables in the Sales Quotation Process
    		30 Min
    Lesson 2 Mapping the Tables to the Entities for the Sales Quotation Processes
    		30 Min
    Labs Duration
    Lab 1 Create a Data Model for the Primary Tables in the Sales Quotation Process 1 Hour
    Lab 2 Challenge: Solve the Databricks Queries by pulling the Data for the Sales Quotation Process 1 Hour
    Lab 3 Challenge: Map from form to Report Ready Dataset for Sales Quotation Activities 1 Hour
  • Module 8 Modeling Customers in Dynamics 365 F&O Data Lake
    Modeling Customers in Dynamics 365 F&O Data Lake
    Lessons Duration
    Lesson 1 Create a Data Model for the Primary Tables in the Customer Process
    		30 Min
    Lesson 2 Mapping the Tables to the Entities for the Customer Process in Dynamics 365 F&O
    		30 Min
    Labs Duration
    Lab 1 Create a Data Model for the Primary Tables in the Customer Process 1 Hour
    Lab 2 Challenge: Solve the Databricks Queries by pulling the Data for the Customer Process 1 Hour
    Lab 3 Challenge: Map from form to Report Ready Dataset for Customer Process 1 Hour
  • Module 9 Modeling Vendors in Dynamics 365 F&O Data Lake
    Modeling Vendors in Dynamics 365 F&O Data Lake
    Lessons Duration
    Lesson 1 Create a Data Model for the Primary Tables in the Vendor Process
    		30 Min
    Lesson 2 Mapping the Tables to the Entities for the Vendor Process in Dynamics 365 F&O
    		30 Min
    Labs Duration
    Lab 1 Create a Data Model for the Primary Tables in the Vendor Process 1 Hour
    Lab 2 Challenge: Solve the Databricks Queries by pulling the Data for the Vendor Process 1 Hour
    Lab 3 Challenge: Map from form to Report Ready Dataset for Vendor Process 1 Hour
  • Module 10 Modeling Invoices (Purchase) in Dynamics 365 F&O Data Lake
    Modeling Invoices (Purchase) in Dynamics 365 F&O Data Lake
    Lessons Duration
    Lesson 1 Create a Data Model for the Primary Tables in the Purchase Invoices
    		30 Min
    Lesson 2 Mapping the Tables to the Entities for the Primary Tables in the Purchase Invoices
    		30 Min
    Labs Duration
    Lab 1 Create a Data Model for the Primary Tables in the Purchase Invoices 1 Hour
    Lab 2 Challenge: Solve the Databricks Queries by pulling the Data for the Purchase Invoices 1 Hour
    Lab 3 Challenge: Map from form to Report Ready Dataset for Purchase Invoices 1 Hour

About the Instructor