Business intelligence in Microsoft Dynamics NAV 2013 R2

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

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.

Microsoft Dynamics NAV basic administration Microsoft Office Excel 2013 Basic Database Design