Export/Import and Links

Maximum intuition and usability

This highly functional module specially designed for bringing intuition and usability to our business users, helps non-technician users to load data from Access or text files, export it and establish relations between tables for building the data model.

With the “Import module” Access or text files can be uploaded in the analytical database so it can be enriched with external data like geographical or information from a population research.

The “Export module” creates new tables in the analytical database from the existing ones, focusing on the analysis and/or using them as temporary tables during the analysis. All can be exported to an external csv text file.

Import

How can you create a new table from a file with delinquent customer’s data? You can do this by using the "Import tool” and creating a new table based on a file.

See video »

Export file

How can you save in a file all female directors? You can do this by using the "Export tool”, that will allow you to extract the data into a text file delimited by a pipe (|). By default the file will be in a CSV format.

See video »

Save export file

How can you save women directors and men directors in different files? You can do this by using the "Export tool”, that will allow you to extract the data into a text file delimited by a pipe (|). You'll be able to save that export and at the same time facilitate the creation of a second one.

See video »

Export Analytic DB

How can you create a table in your database with the orders made by women directors? You can do this by using the "Export tool” and extract all the data to a table.

See video »

Downloads

Download files released on a deferred basis. In this way, if the file to be exported is very big, you can continue performing tasks while the file is downloading aside.

See video »

Links

Establish relationships between tables to facilitate cross-exploitation. You can delete or modify existing relationships and create new ones.

See video »