TOAD Data Point Workflow for End Users

Course Description

This hands-on course is aimed at the Oracle professional who wishes to increase their individual or their group’s productivity by utilizing Toad Data Point. This course is tailored for the topics needed to create Workflows as found in other BI tools such as Hyperion. This course will cover Toad Data Point for Oracle installation, the workflow itself, and the Query Builder.
2-Day Hands on Workshop
Contact us for pricing
 

Who should attend

This course is useful for the power user that needs to use TOAD Data Point to perform database queries and create spreadsheets and reports.

Course content overview

Installation of Toad Data Point for Oracle
Configuration Options
Toad Data Point Workflow - Major Features …we build 4 work flows as group exercises
Toad Intelligence Central
Group Exercises on entire product

The 2nd Day covers:
Storing your data in a subset form with automatic refresh
Automation
ODBC/Import/Export/Data Compare/etc
Additional Toad Intelligence Central topics

Topics covered

Toad Data Point Tips and Techniques
Data best use practices to consider
Creates a variety of Excel and Pivot Table worksheets
Covers Dimensional Views, a hidden gem for data analysis
Covers the Query Editor as well

Adapt your SQL from other applications easily!

Lectures and related topics are enhanced with live illustrations and hands-on exercises

Attendees Receive

• Study guide with useful real world examples that includes all presentations and relevant white papers
• A hands-on opportunity to learn more about Toad Data Point and Business Analytics

About Dan Hotka

Dan Hotka is a Training Specialist and an Oracle ACE Director Alumni (a group of recognized Oracle Experts by Oracle Corp) who has over 40 years in the computer industry, over 34 years of experience with Oracle products, over 20 years with decision support tools. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 14 Oracle books and well over 200 published articles. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world.
Dan worked for Quest Software for three years and has maintained a great working relationship with the Toad Team. working mostly with upgrades to the Toad and Toad Data Point products. He developed the Toad and Toad Data Point courseware and worked closely with the Toad Product Manager to develop the Toad Data Point course.

ToadToad Data PointOracle 19cOracle Database 19cTOAD Data-PointOracle ExpertDan HotkaSQL