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 OracleConfiguration 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 TechniquesData 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