| Course OutlineModule 1: Introduction This chapter serves as a broad introduction and overview of the application. Lessons - Purpose of Business Analytics
- Demonstration of data analysis using Excel
- Short Demonstration of Business Analytics Advanced
After completing this chapter, students will be able to: Module 2: The Business Analytics EnvironmentIn 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. Lessons - 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
Lab : 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 will 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
Module 3: Data Warehousing BasicsThis 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. Lessons - 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
Lab : 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 will be able to: 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
Module 4: Creating Cubes from NavisionThis chapter covers defining cubes using the Business Analytics Setup. Lessons - Setting up a New Cube
- Setting up Business Analytics Databases
- Creating Virtual Cubes
After completing this chapter, students will be able 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
Module 5: Working with Business AnalyticsThis chapter explains the development of views, queries and reports. Lessons - 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
Lab : 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 will be able to: 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
|
| |
