80695AE: Reporting in Microsoft Dynamics AX 2012 R3 CU8 Training

1. Overview

• Introduction to BI
• Overview of BI Tools
• Selecting the Right BI Tool
• List Pages
• Export to Microsoft Excel
• Auto Reports
• Build an Ad-hoc report in Microsoft Excel
• Working with Microsoft Word Templates
• Report Execution and Batch Printing
• Build a Report using SSRS
• Role Centers

2. SQL Server Reporting Services (SSRS)

• Out-of-the-box Content
• Report Data Sources
• Reporting Architecture
• Installation and Configuration
• Native Mode and Microsoft SharePoint Integrated Mode
• Report Development Tools and Process
• Creating Reports using AX Queries - Build Quer
• Creating Reports using AX Queries - Create Report
• Creating Reports using AX Queries - Add Dataset
• Creating Reports using AX Queries - Add Design
• Creating Reports using AX Queries - Preview and Customize
• Creating Reports using AX Queries - Integrate with AX
• Deploying Reports and Working with Static Reports
• Creating Reports using Business Logic
• Creating Reports using Business Logic - Temporary Tables
• Creating Reports using Business Logic - Create a Query
• Creating Reports using Business Logic - Create a Data Contract
• Creating Reports using Business Logic - Create a Report Data Provider
• Creating Reports using Business Logic - Create a Report
• Creating Reports using Business Logic – Summary
• Advanced Report Artifacts
• Customizing Reports
• Report Parameters - Introduction
• Report Parameters - Creating Parameters
• Report Parameters - Control Data and Presentation
• Report Parameters - Properties
• Report Parameters - Binding Parameters to Datasets
• Report Parameters - Securing Data
• Creating and Using Style Templates
• Auto versus Precision Reports
• Integrating Data From Multiple Data Sources
• Creating a Drill Through Report
• Shared Library and Shared Components
• Creating a Column Chart Report
• Migrating Reports from X++ to SSRS
• Interacting with Reports using X++
• Working with Data Methods

3. SQL Server Analysis Services (SSAS)

• Overview of SSAS and Cube Structure
• Installation and Configuration
• Out-of-the-box Content
• Exploring data using Microsoft Excel
• Developing New Cubes
• Customizing Existing Cubes
• Cube Security
• Advanced Analytics using Power BI
• Creating Reports using Cube Data

4. Enterprise portal and Role Centers

• Out-of-the-box Content
• Installation and Configuration
• Enterprise Portal Web Parts
• Customization and Personalization of Role Centers
• Creating new Role Centers
• Integrating Power BI into Role Centers
• Integrating Reports into Role Centers