1 / 6

TAFE Datawarehouse How to make it work for you!

TAFE Datawarehouse How to make it work for you!. What is TAFE Datawarehouse ? (TDW). A large database connected to SIS Data source for all Institutes Performance data used by DET Interfaced by TAFEText and Cube Holds enrolment & finance data Holds student statistics

wilma
Download Presentation

TAFE Datawarehouse How to make it work for you!

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. TAFE DatawarehouseHow to make it work for you!

  2. What is TAFE Datawarehouse? (TDW) • A large database connected to SIS • Data source for all Institutes • Performance data used by DET • Interfaced by TAFEText and Cube • Holds enrolment & finance data • Holds student statistics • Is sometimes cranky!

  3. CLAMS / SIS / TDW TAFE Datawarehouse Enrolment (MEVI....etc) CLAMS Enrolment Details Units Student Details Course Fund Code Offer Code Statistics Payments Student Details Course Fund Code Units Statistics SIS

  4. TDW Cube & TAFEText TAFE Datawarehouse Relational Database Student Details Course Fund Code Units Statistics CUBE Excel PDF Report Statistics Table TAFEText

  5. Nothing can go wrong.. go wrong..go wrong..... • TDW opens in All Funds & ‘Current Year’ • Back button in IE = kill the cube! • Summary levels have funny numbers • TDW graphs are %@##*!! • Careful with changes, can kill the cube • Careful with size of query, can kill the cube • Pouts if you don’t pay it enough attention (timeout) • Coffee needed for the boring bits • Really good when you have it tamed!

  6. Activities • TDW options; TAFEText & Cube • Workspace for Cubes • Menu & Wrap • Click to drill down • Click and drag dimensions • Zero suppression • Delete, Hide or Hide/Show • Minimise messes: when to save • Formatting for Excel graphics • Complex data; save, get data later • Dimension Viewer • Cube toolbar • Excel and PDF export • Error messages in Excel • Excel tidy up/format for printing

More Related