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


Brandon Ahmad ( Founder )

Brandon Ahmad is a Microsoft Certified Trainer Regional Lead – USA, and he also has worked as a freelance senior architect for Dynamics 365 Finance and Supply Chain for several years. He developed his competencies as a successful consultant and trainer and has a history of helping companies globally to solve or help with advanced scenarios. Working with a team of talented developers, his projects often focus on solution architecture and automated performance testing and tuning.

He loves what he does and is still as energetic in his forties as he was in his twenties. With the unswerving energy and passion, he continues to work on a number of advanced implementation programming scenarios in Dynamics AX/365. His great enthusiasm and incredible dedication won him several awards for outstanding training and gained an immense... Read More

Frequently Asked Questions

  • This is a Hybrid Course. What does that mean?
    Hybrid courses have the first part of the course live with lectures over Microsoft Teams.   The second part is assisted with guided labs where we setup the labs and have support available for the labs during business hours.   An instructor also remains available to answer any questions.   The labs have more flexible scheduling.
  • What are the working hours for support team?
    We pride ourselves on our service and teaching experience.  A dedicated service desk at Instructor Brandon is available for assistance 8 hours a day (from Monday to Friday).  Instructor support is also available during this time for any questions.
  • How do the videos differ in this course as opposed to some of the traditional video courses offered?
    Due to the fact that this course happens in Azure, we've found that the most effective way to do this course is live.   2 weeks of video access over the recorded lecture is available after the course, but we highly encourage attending the 2 days of lecture over Teams with live sessions.   All lectures are practical based with extensive demonstrations.
  • What will you learn in this course?
    In this course, you will learn how to create dashboards and work with the data model for Dynamics 365 in a Data Lake environment.   You will also learn prerequisites for being successful in a modern data lake like Synapse SQL.
  • Please explain the schedule breakdown
    Our blended learning course is designed to provide the benefits of live instruction but with the flexibility of minimizing disruptions to work.  The course is designed to take one full week of learning with an extra week of lab availability as a grace period for learning. Day 1 (always Friday): Live Lecture for 8 hours along with walkthroughs (you will spend 4 hours following along with the instructor while principles are demonstrated through practical experience) Day 2 (always Saturday): Live Lecture for 8 hours with walkthroughs (you will spend 4 hours following along with the instructor while principles are demonstrated through practical experience) Week 1: There are 24 hours of labs left to be finished at your own time.  We are available for support during standard business hours (9AM till 6PM CST time) Week 2: Backup Week in case you need another week to finish up.  Offers an excellent week to finish up the labs.
  • Can I extend my labs for another week?
    Yes, an ‘Extension Fee’ covers all the costs of your licenses and support; so for a fee of $600, you can extend your lab time for an additional week.
  • How long do I have access to the course?
    The recorded course videos over the lectures will be available for 2 weeks.   Labs will be available for 2 weeks and one week after the labs.  The lab steps and solution files are yours and can be repeated by simply setting up an Azure Data Lake Connection, Power BI, and Dynamics 365.
  • Are there any special licenses being offered during training?
    We provide our students with the licenses needed for the course labs and access to Azure.
  • What if I miss the instructor live lecture, interactive demos, and live questions?
    Please reschedule the course.  We will allow this if you are not able to make the course after the booking.  The course will run at least 4 times during the year and each version of the course is updated with the newest and latest changes.   We do not recommend taking this course without attending the 2 live Instructor Sessions.   These will save countless hours on learning.  Support staff will also be there to help with the interactive walkthrough demonstrations.  
  • When is the deadline to register for the course?
    This course deadline will be 5 days before the run date.  If you miss the deadline, please send a message to support asking to be notified for the next date that the course runs.  We will send out a notification when that happens and you can register for the course.

Students Feedback

Average Course Ratings

0.0

0.0 average based on 1 reviews.

Good
(0)
Above Average
(0)
Average
(0)
Poor
(0)
Very Poor
(0)

Reviews

No review yet.

Learn D365FO Data Lake Reporting & Dashboards in One Week

$3,000.00

    Prominent Features
  • 40 hours of course content
  • Custom enhanced HTML5 RDP labs
  • Interactive video lessons
  • Mobile app
  • Dedicated support (8 hours a day)
  • Course completion certification
  • Licenses for your hands on training