Attendees of Datawatch Modeler training course, you will learn to perform crucial fundamental operations in the Datawatch Modeler tool.
Datawatch Modeler
( Duration: 2 Days )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 6,000 various courses 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 https://www.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.
Notice
X