

Nectari Academy
Data Modeler Advanced Course - 3 Months
The Data Modeler Advanced course will help you gain an understanding of the more complex functionalities of Nectari/Sage Enterprise Intelligence’s Data Model Designer. You’ll also learn how to build your first OLAP Cube as well as learn the concept of consolidation in the ETL module.
Includes:
- Data Modeler Advanced Course (Access course materials in Nectari Academy for 3 months after purchase)
- Nectari/SEI Training Environment
- 8 Modules
- 3 Exercises
- 1 Exam
What you’ll be able to do after completing this course:
- Get acquainted with the Cube Concepts and its advantages
- Navigate through the OLAP Manager
- Get familiar with the Cube Process
- Learn about different types of cubes in Nectari
- Create a cube with a single data source
- Optimize Cube performance using slices
- Understand ‘Load All’ versus ‘Incremental Load’
- Understand the two types of tracking
- Understand Tracking types advantages and disadvantages
- Build a cube
- Schedule a cube for Load all or Refresh
- Log Build/Load process to debug an error
- Understand the purpose of data model parameters
- Create and use data model parameters
- Understand how to enable the data entry capabilities of Nectari
- Learn the different options available in the Edit section.
- Use the data entry options when working with Worksheets
- Understand the purpose of Nectari’s Info Pages and how to trigger SQL scripts based on given parameters
- Attach views to an execution of a stored procedure
- Limit the results coming from a data model by using the Where clause in the Data Model Designer
- Understand Script Parameters and how to utilize them
- Maintain and Create Global Scripts
- Attach scripts to data models and understand why it is beneficial to keep them updated