Microsoft Navision Business Analytics

Course 8422: Two days; Instructor-led

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

For more information or to give feedback, send e-mail to info@OneApex.com or call 949-597-2100