The materials were excellent and all of the remote setup went smoothly. The instructor was knowledgeable, helpful... More Testimonials »
Home > Microsoft > Dynamics > MOC 80238 - Business Intelligence for Microsoft Dynamics GP 2010

MOC 80238 - Business Intelligence for Microsoft Dynamics GP 2010

Delivery Options

Class Date and Time Price Pricing Information
$1,425.00
or 3 vouchers vouchers
$1,425.00 or 3 vouchers vouchers
Register Now
$1,425.00 or 3 vouchers vouchers
Register Now

Class Description

Class Overview

This three-day instructor-led training class, Business Intelligence for Microsoft Dynamics GP 2010, provides students with knowledge and skill on the current Business Intelligence Tools and delivery Methods available within Microsoft Dynamics GP 2010 and the Microsoft suite of products.

Class Goals

  • Learn to define Business Intelligence
  • Learn to discuss Business Intelligence needs within an organization
  • Learn to plan Business Intelligence reports and create new Business Intelligence reports
  • Explain and Demonstrate the Tools, Applications and Delivery Methods available to fulfill Business Intelligence needs

Class Outline

  1. Business Intelligence Overview
    1. Business Intelligence Overview
    2. Planning a Report
    3. Data Storage
    4. Data Regions
    5. Determine Where Information Exists in Microsoft Dynamics GP
    6. Identify the Data Structure Returned to the Data Set
    7. Table Relationships
    8. Lab: Report Planning
  2. Monitoring
    1. Home Page Metrics
    2. GP Reports and Inquiries
    3. Microsoft Office Word Reports
    4. Business Alerts
    5. Management Reporter
    6. Microsoft SQL Server Reporting Services
    7. Installation of Microsoft SQL Server Reporting Services
    8. Sending Reports through E-mail
    9. Lab: Monitoring
      1. Home Page Metrics
      2. Microsoft Office Word Reports
  3. Analyzing - SmartList
    1. SmartList
    2. Field Options
    3. Create Go To Buttons
    4. Advanced Go To Buttons
    5. Restrictions
    6. Calculated Fields
    7. SmartList Options
    8. Import and Export SmartLists
    9. Security
    10. SmartList Builder Maintenance
  4. Analyzing - Excel Reports
    1. Microsoft Excel and Excel Reports overview
    2. Introduction to Excel Report Deployment
    3. Viewing Excel Reports
    4. Changing and Modifying Excel Reports
    5. Security and Excel Reports
    6. Excel Pivot Table Reports
    7. Drill Down Builder
    8. Drill-Through to Microsoft Dynamics GP
    9. Microsoft Enterprise Reporting
  5. Analyzing - Microsoft SQL Server Reporting Services
    1. Microsoft SQL Server Reporting Services Overview
    2. Report Server
    3. Report Manager
    4. Report Builder
    5. Microsoft Business Intelligence Development Studio
    6. Report Layout
    7. Use Properties to Enhance a Report
    8. Parameters and Filtering
    9. Report Designer
    10. Report Wizard
    11. Report Model
    12. Lab: Analyzing - Microsoft SQL Server Reporting Services
      1. Create a Matrix Report Using Report Builder
    13. Create a Report
    14. Modify the Layout
    15. Set Properties
    16. Create a Multi-Select Parameter List
    17. Deploy and View the Report
    18. Create a New Report Model
    19. Create a New Report from a Report Model Using the Report Wizard
  6. Analyzing - Analysis Cubes and Pivot Tables
    1. Using Cubes
    2. Features and Benefits
    3. Analysis Services Environment
    4. Install and Configure Analysis Cubes
    5. Using Analysis Cubes
    6. Using Pivot Table Report
    7. Create Pivot Table Reports
    8. OLAP Technology
    9. Lab: Analyzing - Analysis Cubes and Pivot Tables
      1. Creating a Pivot Table Report

Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following areas is required:

  • General knowledge of Windows
  • General knowledge of Microsoft Dynamics GP
  • General knowledge of 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
  • General knowledge of Microsoft Office 2007

Technical Requirements

Our computer technical requirements and setup process is easy, with support just a click away.

Quick Links
  1. Watch Presentation
  2. Free Demo
  3. Purchase Vouchers
  4. Partners
  5. Remote Courses
  6. Make Payment
  7. Contact Us
  8. Sitemap
  9. Privacy Policy
Courseware
  1. Purchase Courseware
Client Success
  1. Independent Survey
  2. Client List
  3. Testimonials
Join The Team
  1. Learn how you can become a Webucator Trainer
  2. Career Opportunities
Locations
  1. Where We've Trained
  2. We have trainers all over North America.
Compare Us
Compare Webucator to leading Competitors
Training Options
  1. Live eLearning Public Classes
  2. Private Training
  3. Self-Paced eLearning
Microsoft Partner
  1. Microsoft Certifications
  2. Certified Microsoft Courses
  3. Software Assurance Training Vouchers
Watch 3-minute Demo Video
of Live Online Training: Learn the benefits of online training with Webucator
Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.
© Webucator, Inc. All rights reserved. | Toll Free: 1-877-932-8228 | From outside the USA: 315-849-2724| Fax: 315-849-2723