Information%20Technologies

1
The Data Warehouse

• Information the way you want it

2
What is a data warehouse?

• A copy of operational data
• Data comes from a variety of places
• Simplified view

3
How does it help you?

• Extends the capabilities of FRS
• New summaries (e.g. memo code)
• Searching
• Loading spreadsheets
• Printed reports
• Minimise effects on operational systems

4
Current Situation

• 300 users
• SIS, HR, Financial, and others
• 14,000,000,000 bytes of data
• Updated daily
• Microsoft Access is the query tool

5
Problems

• Complex data (e.g. FTE, GST)
• Security
• Lack of function in Microsoft Access
• Inadequate documentation
• Client-side software
• Poor Macintosh support

6
Evolution

Main Frame
DW
Transform Load
DW Manager
Microsoft Access
Web-based Tool
7
New Tools

• Web based
• More sophisticated queries(subtotals, charts,
  crosstabs, etc.)
• Ability to share requests and results
• Pre-analyzed data
• Integrated documentation

8
New Tools (continued)

• Publish to HTML, PDF, Excel
• Scheduled execution
• Automated delivery via e-mail
• Portal integration

9
Evolution

OLAP Cubes
Main Frame
DW
Transform Load
DW Manager
Microsoft Access
OLAP Query Tool
Web-based Tool
10
OLAP

• Online Analytical Processing
• Cubes of data
• Fast slice and dice
• Requires up-front calculations
• Available on the web

11
Acquiring the new tools

• RFP to six vendors
• Business case
• 500,000 people hardware
• Decision by September

12
Business Case

• Will this help you?
• Planning, KPIs, Management
• Let us know what you think!