i2 iBase Importing Intermediate Course

• Planning an Import Specification 

• • Discuss real world data issues 
  • Understand how to duplicate check Entities and Links 
  • To Update Matching Records or not? 
  • The impact of blank data 
  • Checking the results of an Import 

• Understand and manage errors 

• • Validate Selected From Code Lists 

• Field Actions to standardise data 

• Set Link Direction from a column in an Excel file 

• Importing data from other file and database types 

• • Text files 
  • MS Access 
  • Documents in a folder 

• Scheduling regular imports 

• • Batch Imports 
  • Scheduled Imports 

• Correcting some data quality issues in an iBase database: 

• • Export the data 
  • Using Record Id on Import 

By the end of the course delegates will be able to:

• Import a variety of data, using multiple Field Actions to transform incompatible structures 

• Import from different file types and schedule import specifications to run at specified times 

• Check data quality and make corrections without compromising the database, and select the right option to populate their database depending on the data available 

All of our courses are delivered by our own, in-house, highly experienced trainers, who specialise in training i2 software. We believe that to learn software effectively you need access to a friendly and professional training environment where you have the maximum time spent hands-on using the software; where questions and discussion are encouraged, and that makes you think about how anything you learn will be applied back at work.

Our training uses sets of training data that we have created to look and feel familiar. We will never ask you to use or provide examples of your real data or be in a position to access it.

You will use an array of example training data, such as:

• Intelligence reports including: People, Places, Vehicles, Telephones and Companies; Excel 
  Spreadsheets including: Person data and Communication records

This course is aimed at:

• Users who are required to ask more complex questions of their data by understanding more of the analysis capabilities.

You must have attended an iBase Level 1 – Foundation Course or be an experienced user who understands how to use iBase.  

All courses are conducted in English so you should have a good understanding of spoken and written English.

Please note: translators can be used on closed courses.

Any iBase Level 2 - Progression Courses. More specifically: 

• To understand more of the Analysis capabilites, attend the iBase Analysis Course 

• If you use iBase and Analyst’s Notebook together then the Using iBase with Analyst’s Notebook Course will help you control charting so you can use the Analyst’s Notebook visualiasation and analysis capability efficiently. 

Our online courses are run using virtual machines, with everything you need provided in a secure 
and straightforward environment. 

It is a simple process, and we will send all the relevant links and details on how to do this. 

You can use your own personal computers to attend this training as we provide the i2 software 
and course materials. This is an option being used by customers where IT policy prevents them 
accessing the environment on a work computer.