Course Overview
This Digital Learning course covers the business intelligence capabilities in Microsoft Dynamics NAV 2013 R2 to assist companies transform raw data into meaningful and useful information for business purposes. This course demonstrates advanced ways on how IT professionals can transform data from a Microsoft Dynamics NAV database into business intelligence information.
Course Outline
Module 00: Introduction
Module 01: BI Overview
Module 02: Reports in Reporting Services
Module 03: Data Analysis using Microsoft Office Components
Module 04: Using Query Objects
Module 05: Charts
Course Objectives
Demonstrate advanced ways on how IT professionals can transform data from a Microsoft Dynamics database into business intelligence information.
Explain how to optimize performance across the entire organization.
Teach Microsoft Dynamics NAV 2013 integrated business intelligence capabilities.
Explain how to create meaningful BI reports.
Provide a general review of the Microsoft SQL Server Reporting Services (SSRS) functionality.
Outline Microsoft SQL Server Reporting Services (SSRS) to explain how to create, manage, and deliver traditional, paper-oriented reports and interactive, Web-based reports.
Describe how to configure Microsoft SQL Server Reporting Services (SSRS) and set up a Report Server database.
Describe how to create a Report in SSRS.
Explain how to publish a Report to a Report Server.
Outline how to perform Data Analysis using Microsoft Office Components.
Describe how to analyze data, create reports, build diagrams and other graphical reports using the integration of Microsoft Dynamics NAV 2013 R2 with Microsoft Office Excel 2013 analytical facilities.
Describes how to use Microsoft Office Excel 2013 as an online analytical processing (OLAP) client application.
Describe how to combine, aggregate and export information coming from multiple tables to build pivot tables or reports in Power View.
Outline how to graphically represent data in charts that you can display in the Microsoft Dynamics NAV Windows client.
Introduce Microsoft Dynamics NAV 2013 R2 Business Chart control add-in.
Pre-requisites
Microsoft Dynamics NAV basic administration
Microsoft Office Excel 2013
Basic Database Design