Toad Data Point for End Users

Request more details:

submit request
Description:
Give your technical staff that competitive edge with this Workshop for end users. This course introduces students to the querying and analytical capabilities of using Toad Data Point and Intelligence Central. Students will learn to load/modify/save data, create spreadsheets and other deliverables, and refine/run ad hoc queries. They will learn to view, chart, and analyze multidimensional data. They will also learn to produce individual ad hoc reports and make these reports and information easy to access via dash boards. Lectures are supported by hands on student lab exercises.
Prerequisites:
Topics covered:
Introduction/Analytics Overview
Toad Data Point and data warehouse overview
Introduction to Toad Data Point and Intelligence Central
Toad Data Point Quick Start
Working with various data sources
Transform and cleanse data
Accessing data in various data stores and formats
Apply Joins and Conditions
Introduction to Query Builder
Data Manipulation including transform, cleanse, views, and snapshots
Working with SQL, functions, and code snippets
Visualization Techniques in formatting Data/Views/Graphs
Export/Import of connections and other maintenance items
Automation and scheduling for any Toad Data Point task

Recommended additional course: SQL for End Users Includes SQL, ANSI SQL, and an overview of Analytical SQL (Oracle database only)

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 38 years in the computer industry, over 32 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.