Home Plataan Training Consulting Project Management Bookshop
                         
 
ERP: Dynamics NAV  •  Dynamics AX  •  Continuans
CRM: Dynamics CRM
Business: Project Management  •  Change Management
Database: SQL Server
Modalities: Formulas  •  Conditions
Business Intelligence for IT Professionals in Microsoft Dynamics NAV 2009
Introduction
This training material explores the Business Intelligence functionality of Microsoft Dynamics NAV 2009 Classic client from an IT professional’s point of view. Furthermore, the training covers the possibilities of performing business intelligence tasks on various online analytical processing (OLAP) clients using a Business Analytics (BA) database configured in Microsoft Dynamics NAV. The BA database, created in this training material and used in business intelligence analyses throughout the training, is based on the standard demonstration data of Microsoft Dynamics NAV 2009.
 
Course Outline
Chapter 1: Chapter 1: Business Intelligence Overview
Lessons

  • Business Intelligence Overview
  • Business Analytics Architecture
  • OLAP technology
  • Terminology
Chapter 2: Chapter 2: Business Analytics Installation and Setup
Lessons

  • General Requirements and Preconditions
  • Installing Business Analytics Basic for Microsoft Dynamics NAV 2009 Classic with Microsoft SQL Server
  • Installing Business Analytics Basic for Microsoft Dynamics NAV 2009 Classic with Database Server
  • Installing Business Analytics Advanced Version
  • Troubleshooting

Labs

  • Installing Business Analytics Basic for Microsoft Dynamics NAV 2009 Classic with Microsoft SQL Server
  • Installing Business Analytics Suite
  • Linking a BA Database to Business Analytics for Microsoft Dynamics NAV
Chapter 3: Chapter 3: Configuring a BA Database in Microsoft Dynamics NAV
Lessons

  • BA Database Components
  • Setting Up a BA Database

Labs

  • Configuring a BA Database
Chapter 4: Chapter 4: Processing Cubes in Analysis Services Using Microsoft SQL Server Management Studio
Lessons

  • Microsoft SQL Server Analysis Services
  • Analysis Services Environment
  • Browsing a Cube and Building a Pivot Table

Labs

  • Browsing a Cube in Microsoft SQL Server Management Studio
Chapter 5: Chapter 5: Designing Reports in Microsoft SQL Server Business Intelligence Development Studio
Lessons

  • Reporting Services Overview
  • Configuring Reporting Services
  • Creating a Report in Microsoft SQL Server Reporting Services
  • Publishing Reports to a Report Server

Labs

  • Creating and Deploying a Report in Microsoft Visual Studio
Chapter 6: Chapter 6: Using Business Analytics Advanced
Lessons

  • Business Analytics Suite Overview
  • User Interface
  • Intelligent Analysis
  • Cross Tabulation
  • Business Analytics Reports
  • Printing, Exporting, Sending, and Saving

Labs

  • Building a Cross Tabulation
Chapter 7: Chapter 7: Data Analysis using Microsoft Office Components
Lessons

  • Building Pivot Tables in Microsoft Office Excel
  • Building Pivot Charts

Labs

  • Building a Pivot Table and a Pivot Chart in Microsoft Office Excel

Key Benefits
After completion of this training, you should be able to:

  • Set up Business Analytics
  • Configure a BA database in Microsoft Dynamics NAV
  • Perform a business intelligence analysis using various OLAP clients, such as
    • Microsoft SQL Server Management Studio
    • Microsoft SQL Server Business Intelligence Development Studio
    • Business Analytics for Microsoft Dynamics NAV
    • Microsoft Office Excel.
 
Subscribe
 
Prerequisites
Before reviewing this training individuals must have general knowledge of:

  • Microsoft Dynamics NAV essentials. 
  • Microsoft Dynamics NAV 2009 Classic client. 
  • Microsoft SQL Server: 
  • Analysis Services 
  • Reporting Services. 
  • Microsoft SQL Server Management Studio. 
  • Microsoft SQL Server Business Intelligence Development Studio.
  • Microsoft Office Excel 2007.

In addition, individuals should have:

  • Basic knowledge of analytics.
 
More info
  IT-Pro Training
  Technical Training
  Level 2 - Core
 
Social media




Share on LinkedIn

 
Microsoft Gold Certified Partner (Learning Solutions)     Continuans Certified Service Partner   Q*For Customer Satisfaction   Visit us on LinkedIn Visit us on Facebook Visit us on Twitter Visit our blog
Legal terms