 |
 |
 |
 |
Microsoft Navision Business Analytics
Course 8422: Two days; Instructor-Led
On This Page
 |
Prerequisites |
|
Course Outline |
|
Take This Training |
Prerequisites
Before attending this course, students must have:
| • | General knowledge of Windows |
| • | Some general familiarity with the software elements involved |
| • | A basic understanding of the business goals and information most frequently analyzed with Business Analytics |
Course Outline
Chapter 1: Introduction
This chapter serves as a broad introduction and overview of the application.
Sections
| • | Purpose of Business Analytics |
| • | Demonstration of data analysis using Excel |
| • | Short Demonstration of Business Analytics Advanced |
Exercises
| • | None |
After completing this chapter, students should be able to:
| • | Understand an overview of the Business Analytics module |
| • | Understand key capabilities and purpose of the software |
Chapter 2: The Business Analytics Environment
In this chapter students will become familiar with the various components of Business Analytics; develop an understanding of the role of each component and how to access the component. In addition, students will also get a brief introduction to the software components of Microsoft SQL Server that is used by Business Analytics.
Sections
| • | Business Analytics Architecture |
| • | Business Analytics Data Mart |
| • | Package for Data Transfer Service |
| • | Business Analytics Configurator |
| • | Business Analytics Client |
| • | Business Analytics Server |
| • | Business Analytics Web Server |
| • | Business Analytics Enterprise Manager |
Exercises
| • | Install Business Analytics |
| • | Connect Microsoft Excel to one of the cubes that you have created |
| • | Configure Business Analytics Server |
| • | Start Business Analytics Analysis Manager |
After completing this chapter, students should be able to:
| • | Understand the general architecture of Business Analytics |
| • | Have knowledge of the software used by Business Analytics |
| • | Understand the installation of Business Analytics |
| • | Understand installation troubleshooting |
Chapter 3: Data Warehousing Basics
This is primarily a theoretical chapter. It covers the fundamentals of data warehousing. Students are also introduced to the Analysis Manager. The terms discussed in this Chapter are used throughout the course.
Sections
| • | OLTP Systems |
| • | OLTP System Characteristics |
| • | OLTP System Examples |
| • | Data Warehouse Characteristics |
| • | Data Warehouse Components |
| • | Understanding OLAP System |
| • | Understanding Data Warehouse Design |
| • | Star Schema |
| • | Snowflake Schema |
| • | Understanding OLAP Models |
| • | OLAP Components |
| • | Working with Cubes |
| • | Working with Dimensions and Hierarchies |
| • | Advanced OLAP |
| • | Shared and Private Dimensions |
| • | Aggregations (Sum, Min, Max, Count, Distinct Count) |
| • | Calculated Members |
| • | Virtual Cube |
Exercises
| • | Start SQL Server Analysis Manager |
| • | Identify all shared dimensions in BA for Navision 4.0 |
| • | Identify all parent-child relationships in shared dimensions |
After completing this chapter, students should understand:
| • | Basic terms used in a data mart |
| • | Rules that apply to the different terms |
| • | Data warehouse/data mart definition |
| • | The origin of data (OLTP) |
| • | OLAP |
| • | Measures |
| • | Dimensions |
| • | Fact tables |
| • | Dimension tables |
| • | Star schemas |
| • | Snowflake schemas |
Chapter 4: Creating Cubes from Navision
This chapter covers defining cubes using the Business Analytics Setup.
Sections
| • | Setting up a New Cube |
| • | Setting up Business Analytics Databases |
| • | Creating Virtual Cubes |
Exercises
| • | None |
After completing this chapter, students should know how to:
| • | Define cubes using BA configuration forms |
| • | Run the BA configurator to generate cubes |
| • | Modify existing cube definition |
| • | Create calculated members |
| • | Create virtual cubes |
| • | Schedule DTS packages for cube and datamart update |
| • | Create calculated members in virtual cubes |
Chapter 5: Working with Business Analytics
This chapter explains the development of views, queries and reports.
Sections
| • | Setting up the consolidation company and subsidiaries |
| • | Exporting data for consolidation (if necessary) |
| • | Testing data to be consolidated |
| • | Consolidating the data |
| • | Processing consolidation eliminations |
| • | Consolidated reports |
Exercises
| • | Create a view showing Sales Invoice Cost trend |
| • | Add intelligent agents to the Globe |
| • | Add Posting Date as a global criteria |
| • | Create a shared view, Sales Person Analysis showing Sales Invoice Amount deviation analysis |
| • | Create a report showing the following fields |
After completing this chapter, students should understand:
| • | Connecting to cubes from Business Analytics Analysis Manager |
| • | Building analysis views |
| • | Advanced features of the Analysis client |
| • | General considerations when analyzing data |
| • | Object perception |
| • | Special objects |
| • | Calculations and functions |
| • | Intelligent Agents |
| • | Triggers/Magic drops |
| • | The Web client |
| • | The Report client |
We are glad to anwer questions regarding our business and course offerings.
Call us at (800) 453-5961 or Send an Email.
DynamicsEdge, Inc. All Rights Reserved. © 2010
Now Hiring!
We are currently looking for Microsoft Certified Trainers (MCT) for training assignments. You must be a MCT in good standing with Microsoft and have a current high-level Microsoft Certification (MCITP, MTS, MCSD) with two years of training experience.
To apply please send an email to MCT@ DynamicsEdge.com
We support Dynamics CRM
Microsoft Dynamics CRM 4.0 is a CRM system your employees will use! Dynamics Edge can provide customization to make Dynamics CRM adapt to your business processes.
Support for Dynamics AX, NAV, SL, and RMS
Dynamics Edge provides support and training for the Dynamics products and the underlying technologies: SQL Server 2005 - 2008, Exchange Server 2003 - 2007 and Sharepoint 2007. .
Classes at Your Site
We offer private on-site classes for up to 8 people for most courses:
5 day private class: $10,995
4 day private class: $8,795
3 day private class: $6,595
1 & 2 day Private classes:
Call (800) 453-5961 or email!
Course Listings
Microsoft Dynamics
- Microsoft Dynamics CRM
- Microsoft Dynamics AX
- Microsoft Dynamics NAV
- Microsoft Dynamics GP
- Microsoft Dynamics SL
Other Products
- Windows Server 2008
- Windows Server 2003
- Windows 7 & Vista
- Exchange
- Share Point
- SQL Server
- SCCM / SMS Server
- Visual Studio & .Net
- Other Server Products