Course 8422: Two days; Instructor-Led
On This Page
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
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
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 |
|
