MSD GP

Inventory Control

1. General Knowledge of Microsoft Windows.
2. General knowledge of Microsoft Dynamics GP.
3. Microsoft SQL Server:
Analysis Services
Reporting Services
Microsoft SQL Server Management Studio
Microsoft SQL Server Business Intelligence Development Studio
Microsoft SQL Server Report Builder 2.0
4. Microsoft Office 2007

Training Type: Classroom
Duration: 30hrs

Topic

Sub Topic

Duration

Business Intelligence

  • Business Intelligence Overview
  • Monitoring
  • Analyzing – SmartList
  • Analyzing - Excel Reports
  • Analyzing - Microsoft SQL Server Reporting Services
  • Analyzing - Analysis Cubes and Pivot Tables

30 Hours

Module 1: Business Intelligence Overview

This module introduce the students to Business Intelligence, and explains how to plan for BI reports.

Module 2: Monitoring

This module explains the Tools, Applications and Delivery Methods for monitoring Business Intelligence in Microsoft Dynamics GP.

Module 3: Analyzing – SmartList

This module explain how to use SmartList in Microsoft Dynamics GP to analyze the Business Intelligence need. It also describe how to add SmartList searches as a SmartList favorite and how to import and export to Office Excel or Office Word.

Module 4: Analyzing - Excel Reports

This module explain how to use Microsoft Excel to analyze the Business Intelligence needs, it explains how Microsoft Dynamics GP and Microsoft Office uses Office Data Connection (ODC) to view Microsoft Dynamics GP data in an Excel worksheet.
It also describe how to deploy these reports locally, to a network share, or to Microsoft Office SharePoint Server 2007, and how to modify these reports as needed. In addition, how to design and deploy custom Excel reports and integrate Excel reports into Microsoft Office Outlook.

Module 5: Analyzing - Microsoft SQL Server Reporting Services

This module explain how to use Microsoft SQL Server Reporting Services to analyze the Business Intelligence needs. It describe how to deploy reports to Report Manager. How to create report models and how to create and modify report models in Model Designer. It also explain how to use Report Designer and Report Builder

Module 6: Analyzing - Analysis Cubes and Pivot Tables

This module explain how to use Analysis Cubes and Pivot Tables to analyze the Business Intelligence needs. It describe the key features for Analysis Cubes, how to install and use Analysis Cubes.
It also explain how to create a Pivot Table report using Analysis Cubes and describe the OLPA Technology.

Our Customers

Always and forever at your Service

andryan
aurigo
axiscade
cgi
cipher
defiance
fitkids
genisys
infogain
lnt
magicrete
maxmedia
media_us
nalasha
niit
paladion
rashmitha
sourcedge
synova
tenaxe
vjtech
zenith