EncartaLabs

Datawatch Modeler

( Duration: 2 Days )

Attendees of Datawatch Modeler training course, will learn to perform crucial fundamental operations in the Datawatch Modeler tool.

COURSE AGENDA

1

Report View

  • Know and use terminology necessary for working in Modeler
  • Understand the difference between a template and a model
  • Open a variety of source data including TXT, PRN, PDF, XLS, MDB files
  • Work within four views of Modeler: Report, Table, Summary, Export and have an understanding of the unique attributes and purposes of each
  • Assess a report and use Modeler's extraction process (templates and traps) to extract the data from the source report and generate a valid data table
  • Create templates according to how reports are usually arranged (sort levels). Apply Modeler's templates: detail, append, header, footer, to effectively coordinate the relationships of the various levels of data to form records in the resulting table
  • Demonstrate effective use of literal traps and wild traps to trap data
  • Use the Auto Define Fields feature as a diagnostic tool
  • Use Verify to find and correct fields with incorrect types and boundaries
  • Set a bookmark
  • Use the Search feature to quickly find data in reports, table and summaries. Know how to float multiple views and documents
  • Recognize the consequences of choosing samples and traps unwisely
  • Recognize diverse layouts of report data in more complex reports and see the structure inherent in the data. Evaluate the structure and make appropriate decisions about constructing templates
  • Apply the Advanced Variable Field options as needed to capture and extract "non-standard" data and data inconsistencies such as suppressed fields, multi-line sort levels, variable line addresses and wrapping fields
  • Recognize the need for and successfully employ advanced extraction traps such as wild traps, postal trap, numeric|or, the NOT trap, and floating traps
  • Apply one model file to several periodic reports over time as well as all at once to form comprehensive tables
  • Use Multi-Column Regions to extract data from reports where the detail information resides in multiple columns
  • Name, save and then reapply models to one or many reports simultaneously
2

Data View

  • Change the order of table records by using Sorts
  • Create Calculated Fields that add new columns of data to the table
  • Create and apply Filters to temporarily remove unwanted table records so that only records of interest will be viewed, exported and printed
  • Write formulas called expressions to manipulate table data
  • Understand the various categories of Modeler functions (ex: string, numeric, date, user-defined) and be able to select and apply appropriate functions when writing expressions
  • Nest several functions together in one expression to achieve desired results
  • Create and employ non-formula based filters and calculated fields such as Compound Filters, User Edited Fields, Run Time Parameters, and Lookup Calculated Fields
  • Utilize additional manipulation techniques such as hiding columns, moving columns, changing column titles, adjusting column widths, using the field list, changing field properties
  • Incorporate the logical operators such as "AND", "OR" and "NOT", as well as parenthesis, brackets, quotes and braces into expressions
  • Use the Address Block feature to split memo fields containing addresses into their individual components such as street, city, state, postal code
  • Export from Modeler to other applications such as Excel. Use the Project Export feature for repetitive exporting
  • Control Exporting to Excel so that special formatting, formulas and outlining are retained. Use the First Value of Field macro to customize page headers for print and export
  • Utilize advanced filter options to remove duplicate records from a table and to perform "top 10" analysis
  • Search and explore Modeler's electronic help files
3

Summary View

  • Create a Complete Summary with totals, sub-totals and averages
  • Understand measure fields, item fields and key fields and the role they play in the creation of a Modeler summary
  • Understand the necessity and use of item fields and the value of drilling up and down through the data, producing more, or less, detailed views
  • Apply Summary Design Preferences to create and maintain a consistent look for all summaries
  • Use Across Key to form a matrix and achieve a different perspective

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top