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

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
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
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
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
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
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

Go To Top

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.

Go To Top

Quick Links

Locations

Where We've Trained
Some of the Cities in which Webucator has Trained:
1. Phoenix, AZ
2. Pittsburgh, PA
3. Portland, OR
4. Providence, RI
5. Raleigh, NC
6. Sacramento, CA
7. St. Louis, MO
8. San Diego, CA
9. San Francisco, CA
10. San Jose, CA
11. Santa Clara, CA
12. Seattle, WA
13. Sunnyvale, CA
14. Tallahassee, FL
15. Tempe, AZ
16. Toronto, ON
17. Tucson, AZ
18. Tulsa, OK
19. Virginia Beach, VA
20. Washington, DC
1. Fort Worth, TX
2. Hampton, VA
3. Hollywood, FL
4. Houston, TX
5. Huntsville, AL
6. Indianapolis, IN
7. Jacksonville, FL
8. Las Vegas, NV
9. Lexington, KY
10. Los Angeles, CA
11. Louisville, KY
12. Madison, WI
13. Memphis, TN
14. Milwaukee, WI
15. Nashville, TN
16. New York, NY
17. Oklahoma City, OK
18. Omaha, NE
19. Ottawa, ON
20. Philadelphia, PA
1. Amarillo, TX
2. Atlanta, GA
3. Aurora, IL
4. Austin, TX
5. Baltimore, MD
6. Beaumont, TX
7. Boston, MA
8. Buffalo, NY
9. Calgary, AB
10. Cary, NC
11. Chandler, AZ
12. Chicago, IL
13. Cincinnati, OH
14. Cleveland, OH
15. Colorado Springs, CO
16. Columbus, OH
17. Dallas, TX
18. Dayton, OH
19. Denver, CO
20. Detroit, MI
We have trainers all over North America.
1. Indianapolis, IN
2. Boston, MA
3. Silver Spring, MD
4. Portland, ME
5. Detroit, MI
6. Minneapolis, MN
7. Kansas City, MO
8. St. Louis, MO
9. Jackson, MS
10. Charlotte, NC
11. Nashua, NH
12. Atlantic City, NJ
13. Newark, NJ
14. Jersey City, NJ,
15. Reno, NV
16. Philadelphia, PA
17. Calgary, Canada
18. Toronto, Canada
1. Phoenix, AZ
2. Los Angeles, CA
3. Oakland, CA
4. San Diego, CA
5. San Francisco, CA
6. San Jose, CA
7. Santa Clara, CA
8. Sacramento, CA
9. Boulder, CO
10. Denver, CO
11. Hartford, CT
12. Fort Lauderdale, FL
13. Fort Myers, FL
14. Orlando, FL
15. Tallahassee, FL
16. Atlanta, GA
17. Boise, ID
18. Chicago, IL

Compare Us

Compare Webucator to leading Competitors

Training Options

Microsoft Partner

Watch 3-minute Demo Video
of Live Online Training:

Learn the benefits of online training with Webucator

Can't see this video?

Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.

Technology Training

Business Training

MOC 80238 - Business Intelligence for Microsoft Dynamics GP 2010

Delivery Options

Volume Discounts

Webucator Vouchers

Software Assurance Training Vouchers

Webucator Vouchers

Class Description

Class Overview