Business Intelligence

Data analysis and presentation using ProClarity (Course Code: 1291)

Course Schedule:

Please call 8622 8900 or email us for further information

Overview

This course is designed to provide both a thorough introduction to the concepts of data warehousing as well the use of the main features of a leading toolset for data analysis and presentation, ProClarity. The course is hands-on with many practical exercises.

Learning Method

Instructor Led
Participants will work through hands-on practical sessions and exercises in a PC equipped laboratory.

Who will benefit from this course?

Data analysts
Data base analyst’s wishing to extend their skill set
OLAP designers

Pre-requisites

Familiarity with OLAP databases and data warehousing concepts would be helpful but is not mandatory.

What can you expect to gain from this course?

Proficiency in extracting meaningful information from data warehouses
An understanding of the benefits and confidence in utilising business data to forecast trends
Experience in publishing performance related data

Course content

Why analysis is important?

OLAP Terminology:

multi-dimensional data
catalog
cube
dimensions
hierarchy
level
member
measure

Using ProClarity Professional - Part 1

Module 1:Data Manipulation

ad-hoc query wizard
table of contents/dimension tool
data layout
slicing of dimensions
combing members
searching for members
selecting descendants
Exercise 1.1: Data Manipulation

Module 2:Navigation

drill up/down
expand/collapse
show/hide
cross drill
sorting/filtering
custom order members
Exercise 1.2: Navigation

Module 3:Viewing Data

charts and grids
decomposition tree
perspective view
performance map
Exercise 1.3: Viewing Data / Jeopardy

Using ProClarity Professional - Part 2

Module 1:Saving/Publishing Views

saving a view
saving a briefing book
editing a briefing book
sending/publishing a book
Exercise 2.1: Saving/Publishing

Module 2:Customising Views

formatting a chart
formatting a grid
add a subtotal
creating a measure
creating a set
creating a member
Exercise 2.2: Customizing Views

Module 3:Data Integration

exporting data to other containers
drill to detail
perspectives
actions
Exercise 2.3: Data Integration

Module 4:PAS Environment

analytics server platform
web standard
desktop and web professional
library
roles and security
Exercise 2.4: PAS Environment

Module 5:Authoring Tool

creating pages and save to briefing book
organise briefing book
publishing and retrieving books
managing books and libraries
managing roles
Exercise 2.5: Authoring Tool

Module 6:Business Logic Server, Selector

create and save a selector set
point and click creation of complex set expressions
multi-layered filtering and sorting
create and publish scripts
build complex multi-layered queries
Exercise 2.6: Business Logic Server 1 - Selector

Module 7:Business Logic Server, KPI Designer

create and save a KPI
import templates
wizard driven creation of calculations (KPI’s)
create and publish KPI templates
Exercise 2.7: Business Logic Server 2 - KPI Designer

Module 8:ProClarity Web Standard

navigating
view types
saving/publishing views
data manipulation
exporting views
slicing and pivoting
sorting and filtering
viewing member properties
actions
Exercise 2.8: Web Standard

Module 9:Dashboard Server

navigating through a dashboard
integrating with dashboards
chart interactivity
parameters
security
customising my dashboard
Exercise 2.9: Dashboard Server