50001: ProClarity Analyst Training (5 Days)
About this Course
This five-day instructor-led course provides students with the knowledge and skills to expand the capabilities of Microsoft Business Intelligence, making information simpler to access, easier to use, and clearer to understand.
Audience Profile
This course is intended for the Information Worker. At Course Completion After completing this course, students will be able to:
- Understand the OLAP environment.
- Manipulate, navigate, and view data.
- Customize views and integrate data.
- Understand the Analytics Server Environment and author tools.
- Use the Business Logic Server, ProClarity Selector, and ProClarity KPI Designer.
Course Outline
Module 1: Introduction: Understanding the OLAP Environment
Lessons
- Multidimensional Data
- OLAP Terminology
- Dimensions
- Hierarchy
- Measures
Module 2: Data Manipulation
Lessons
- Ad-Hoc Query Wizard
- Setup Panel
- Data Layout
- Slicing of Hierarchies
- Combining Members
- Searching for Members
- Selecting Descendants
Module 3: Navigation
Lessons
- Drill Down/Drill Up
- Expand/Collapse
- Show/Hide
- Cross Drill
- Sorting/Filtering
- Custom Order Members
Lab : Navigation
- Concepts of Navigation
Module 4: Viewing Data
Lessons
- Charts and Grids
- Decomposition Tree
- Perspective View
- Performance Map
Module 5: Professional II Objectives
Lessons
- Saving/Publishing Views
- Customizing Views
- Data Integration
Lab : Saving/Publishing Views
- Create a Series of Views
Module 6: Customizing Views
Lessons
- Formatting a Chart
- Formatting a Grid
- Add a Subtotal
- Creating a Measure
- Creating a Set
- Creating a Member
Lab : Customizing Views
- Additional Capabilities Within ProClarity
- Create a Series of Views and Save Them to a Briefing Book
Module 7: Data Integration
Lessons
- Exporting Data to Other Containers
- Drill to Detail
- Perspectives
- Aliasing
- Flattening a Hierarchy
Lab : Data Integration
- Review Basic Concepts
Module 8: Analytics Server Environment
Lessons
- ProClarity Web Standard
- Desktop and Web Professional
Lab : PAS Environment
- Review Basic Concepts
Module 9: Authoring Tool Training
Lessons
- Authoring Tool
- Create Pages and Save to Briefing Book
- Organize Briefing Book
- Publishing and Retrieving Books
- Publishing and Retrieving Files
- Managing Books and Libraries
- Managing Roles
Lab : Authoring Tool
- Create a Library and Manage Content
Module 10: Business Logic Server
Lessons
- Issues with Getting Answers
- The Value of One Truth
- The Sales Scenario
- Finance Scenario
- Healthcare Scenario
- Product Structure
- Organizational Value
Module 11: ProClarity Selector
Lessons
- Value of Selector Sets
- Create a Selector Set
- Different Selector Sets
- Save a Selector Set
- Use for Selector Sets
Module 12: ProClarity KPI Designer
Lessons
- Value of KPIs
- Create a KPI
- Save a KPI
- Import Templates
- How KPI Designer Is Used
Lab : Business Logic Server 1 - Selector
- Review Basic Concepts
Lab : Business Logic Server 2 - KPI Designer
- Create sets and members
- Publish to Business Logic Server
Module 13: Web Standard Training
Lessons
- Getting Started
- Navigation
- View Types
- Saving/Publishing Views
- Data Manipulation
- Exporting Views
- Other
Module 14: Viewing Data
Lessons
- Grid/Chart
- Chart Types
- Advanced Views
- Sorting/Filtering
- Subtotals
- Flattening Hierarchy
- Pages with Notes
Module 15: Sharing and Exporting Views
Lessons
- Saving a View
- Opening a View
- Export a Grid
- Printing a View
- E-mailing a View
- Analyzing with Professional
- Drill to Detail
Module 16: Data Manipulation
Lessons
- Data Layout
- Slicing/Un-Slicing Hierarchies
- Pivoting
- Selecting Descendants
- Searching for Members
- Shared Items
- Member Selection and Properties
- Actions
Lab : Web Standard
- Accessing and Browsing a Briefing Book
Module 17: Dashboard Server
Lessons
- The Value of PDS
- Dashboard Navigation
- Analysis of Views
- User Personalization
Lab : Dashboard Server
- Review Basic Concepts
Before attending this course, students must have:
- Basic knowledge of Microsoft ProClarity.