background
background
background
  • ERP
  • MS Dynamics
  • SharePoint
  • Staffing
  • Products
  • Training
   

  • ERBrains IT Solutions Pvt. Ltd is an independent IT consulting firm based in the Bangalore.
  • Our focus is to ease our client into a long-term relationship with a business and execution model.
  • At ERBrains we believe that the success of your Enterprise Resource Planning software solution.

Links


ERBrains


Business Intelligence for Microsoft Dynamics GP 2010

------------------------------------------------------------------

Prerequisites:

1. General Knowledge Of 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: Class Room

Duration: 30 Hours

----------------

Course Outline:

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

----------------

Course in Detail:

Topic I: Business Intelligence for Microsoft Dynamics GP 2010

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



Highlights

Quick Links

Click here to download Brochure

Industries

Our Verticals

More

Contact Us

Tel: 080-41524930
Email : info@erbrains.com