2-Day (BI-PCPT075-301-EN)
Description
Analysts and other advanced users learn how to use ProClarity end user clients in order to create publishable content including business logic, custom data sets and key performance indicators. Attendees will learn how to publish analytic views for others to consume in an analytic client or dashboard.
Who should attend
Business Analysts
Database Administrators
Prerequisites
Not required any prerequisite to acces this course.
Course Outline
Day 1
OLAP Terminology
- Overview of OLAP Terms and Concepts
Why Analysis Is Important
- Answering Critical Questions with Analysis
Data Manipulation
- Working with the Setup Panel and Data Layout
- Slicing and Combining Items
- Searching and Selecting Items
- Lab: Data Manipulation
Navigation
- Drilling Down and Up
- Expanding and Collapsing
- Cross Drilling
- Sorting and Filtering
- Lab: Navigation
Viewing Data
- Working with Charts and Grids
- Using the Decomposition Tree
- Using the Perspective View
- Using the Performance Map
- Lab: Viewing Data Jeopardy
Saving and Publishing Views
- Creating Views and Books
- Publishing Content to Analytics Server
- Lab: Saving and Publishing Views
Customizing Views
- Formatting Charts and Grids
- Adding Subtotals
- Creating Measures, Sets and Members
- Lab: Customizing Views
Data Integration
- Exporting Data to Other Containers
- Actions
- Drilling to Detail
- Lab: Data Integration
Day 2
Analytics Server Environment
- Creating Libraries
- Determining Roles and Security
- Lab: Analytics Server Environment
Authoring Tool
- Publishing Briefing Books
- Managing Briefing Books and Other Files
- Lab: Authoring Tool
Business Logic Server
- Creating Sets Using the Selector
- Creating Members Using KPI Designer
- Creating and Sharing Content
- Lab: Creating Sets and Members with Business Logic Server
Web Standard
- Displaying Published Views
- Manipulating Data
- Viewing, Sorting and Filtering Data
- Lab: Web Standard
Dashboard Server
- Navigating through a Dashboard
- Dashboard Parameters
- Dashboard Server Integration
- Creating ‘My Dashboard’