COURSE DESCRIPTION: This is a 1-day class (6-hours per day) that includes lecture, lab and testing for up to 12 students.
This course is tailored for the topics needed to create Workflows as found in other BI tools such as Hyperion.
This course covers the Workbook feature of Toad Data Point. Topics of interest can be selected from the list in the Toad Data Point outline. This course will cover building queries using both the Query Builder and Editor windows, cleansing the data, and saving the data to various Excel formats. This course also covers some 'hidden gem' features such as dimensional views and other useful topics in/around the Toad Data Point tool.
Lectures and topics are enhanced with live illustrations and hands-on exercises.
Installation of Toad Data Point
Review of Configuration Options
Major Features of Toad Data Point Workflows
AUDIENCE: Power Users that needs to use Toad Data Point to perform database queries and create spreadsheets and reports.
Oracle professional who wishes to increase their individual or their group's productivity by utilizing Toad Data Point.
COURSE OUTLINE: o Introduction and Analytics Overview o Toad Data Point and data warehouse overview
o Creating Workflows
o Working with the Query Builder
Toad Data point - Workflow for End Users
Toad Data Point installation, Workflow, Query Builder