During this course you will learn to unleash the power of Microsoft Power BI on Microsoft 365 Business Central & NAV data. You will learn all essential insights of Microsoft Power BI and apply them on Microsoft Dynamics 365 Business Central and NAV data.
Your course package is designed to provide maximum learning and convenience. This is included in the price of your course:
This Microsoft Dynamics 365 Business Central: Reporting with Power BI course consists of two subcourses and is intended for everyone who wants to learn to make Power BI reports and dashboards based on Business Central or NAV data.
Using our engaging learning methodology including a variety of tools, we’ll cover the entire curriculum.
Microsoft Dynamics 365 Business Central: Power BI
During the workshop you will work on a business case, in which you will:
- Build a datamodel
- Build & publish reports to PowerBI.com
- Make use of scheduled refresh
- Collect data from Dynamics 365 Business Central & NAV with ODATA webservices,
- Retrieve data directly from SQL database with SQL queries, views en stored procedures.
- Refine the datamodel with Calculated columns, Measures en tables (DAX)
- Discuss and use typical DAX patterns
1 - Getting Started
2 - Getting Data from Business Central
3 - Building the Data Model
4 - Refining the Data Model
5 - How Do I Create a Power BI Report
6 - How Do I Create Power BI Dashboards
7 - Embedding Power BI in Business Central
Microsoft Dynamics 365 Business Central: Reporting
1 - Report Design Process
- Report Design Process Overview
- The Report Development Process
- Report Development Tools
- Differences between reporting in C/Side and VSC
- Differences when using C/AL or AL in reporting
2 - Report Components
- The Report Description
- Properties and Triggers
- Data Items and Columns
- The Request Page
3 - Design the Data Model
- Building the datamodel using C/Side vs VSC
- Report & Data Item Properties
- Adding Columns
- Column Properties
- Ordering, Linking and Indenting Data Items
- Multilanguage Reports
4 - Design the Layout
- Layout Design Best Parctices
- Designing Layout with C/Side vs VSC
- Everything is a Tablix
- List, Table, Matrix
5 - Grouping and Totaling
- Interactive Features
6 - The Request Page Designer
- Design the Request Options Page
7 - Advanced Layout Features
- Adding a Report Header
- Adding Hide/Collapse
- Adding a Chart
8 - Report Triggers and Functions
- Report Trigger Execution Flow
- Report Functions
10 - Document Reports
- What are Document Reports?
- The Datamodel for Document Reports
- The layout of Document Reports
- Alternative Solutions
- The Mini Document
- The No. Printed Field
11 - Implementing No. Of Copies
- Implementing No. Of Copies in the Dataset
- Implementing No. Of Copies in the Layout
- Implementing No. Of Copies in the Page Numbers
12 - Word Reports Layouts
- Design a Word Report Layout
The Virtual Classroom is an online room, where you will join your instructor and fellow classmates in real time. Everything happens live and you can interact freely, discuss, ask questions, and watch your instructor present on a whiteboard, discuss the courseware and slides, work with labs, and review.
Yes, you can sit exams from all the major Vendors like Microsoft, Cisco etc from the comfort of your home or office.
Your Readynez Course package includes the exam voucher for Microsoft exams, AWS exams, ISO Exams and almost every other exam.
With Readynez you do any course form the comfort of your home or office. Readynez provides support and best practices for your at-home classroom and you can enjoy learning with minimal impact on your day-to-day life. Plus you'll save the cost and the environmental burden of travelling.
Well, learning is limitless, when you are motivated, but you need the right path to achieve what you want. Readynez consultants have many years of experience customizing learner paths and we can design one for you too. We are always available with help and guidance, and you can reach us on the chat or write us at firstname.lastname@example.org.