Other Cube Browsers

1
Other Cube Browsers

• Presented by Peter Gfader

2
Admin Stuff

• Attendance
• You initial sheet
• Hands On Lab
• You get me to initial sheet
• Certificate
• At end of 10 sessions
• If I say if you have completed successfully ?

3
Course Overview

• The 5 Sessions (Part B)
• SSIS and Creating a Data Warehouse
• Creating a Cube and Cube Issues
• Reporting Services
• Other Cube Browsers
• RS Report Builder
• Data Analyzer
• Excel 2007
• Proclarity
• Thin Slicer
• zzCrystal
• Data Mining
• http//www.ssw.com.au/ssw/events/2009UTSSQL/
• http//tinyurl.com/UTSSQL

4
Recap

• Reporting services
• Building reports
• Adding interactivity with drill down and drill
  through
• Export formats
• Building ad hoc reports
• Report Administration
• Creating scheduled reports
• Performance - Caching
• Performance - Snapshots
• Security

5
Session 4 Tonights Agenda

• Overview
• RS Report Builder on DB OLAP (Recap)
• Microsoft Data Analyzer
• Proclarity
• Excel 2007/2003
• Excel services
• Thinslicer
• Performance Point
• Demos

6
Reporting Services Models

• Reporting Services Report Builder
• Creating a reporting services model
• Can create models based on cubes or relational
  data sources

7
Microsoft Data Analyzer
8
ProClarity (now assimilated by MS)
9
ProClarity Selection of Data Charts

• Drillable Charts e.g. Bar, Line, Pie, Area
• Simple selection of data via Hierarchies
• Auto-Highlighting for Readability

10
ProClarity - Decomposition

• Analyse via the decomposition Tree

11
ProClarity Performance Map

• Use for showing relative performance change
  between Dimensions

12
ProClarity Perspective View

• Allow for comparison of 2 measures against
  selected hierarchies
• Good for detecting values outside the norm
• Statistical Sliders

13
ProClarity Other Features

• Views
• Briefing Books to share your analysis

14
Excel 2007 - Pivot Table

• Connecting to an OLAP cube
• General navigation of member information and cube
  data
• Drilling down to details of reporting summaries
• Venturing beyond the " X-Y " dimensions, and
  making the PivotTable Report truly
  multidimensional
• Select formatting options for our Excel 2007
  PivotTable Reports.

15
Pivot Sample
16
Excel 2007 Pivot Table - Fields and Drop Zones
17
Excel Services

• Publishes Excel pivot tables onto SharePoint
• http//richardlees.com.au/sites/Demonstrations/Pag
  es/NZCensus_Excel.aspx

18
(No Transcript)
19
ThinSlicer

• http//richardlees.com.au/sites/Demonstrations/Pag
  es/TS_Foodmart.aspx
• Bought by Angry Koala in 2008
  www.angrykoala.com.au
• Adhoc Cube Browser on the Web

20
ThinSlicer
21
Microsoft Performance Point

• http//richardlees.com.au/sites/Demonstrations/Sha
  red20Documents/Windows20Performance20Monitor/Pe
  rfmon.aspx

22
(No Transcript)
23
Performance Point

• Interactive Charts
• Interactive tables
• Auto refresh to show live data
• Will be part of the next version of SharePoint
  (Enterprise Edition)

24
Summary

• Overview
• RS Report Builder
• Data Analyzer
• Proclarity
• Excel 2007
• Excel Services
• Thin Slicer
• Performance Point
• zzCrystal

25
2 things

• PeterGfader_at_ssw.com.au

26

• Thank You!
• Gateway Court Suite 10 81 - 91 Military Road
  Neutral Bay, Sydney NSW 2089 AUSTRALIA
• ABN 21 069 371 900
• Phone [phone] Fax [phone]
• info_at_ssw.com.auwww.ssw.com.au