Inc.5000 Companies 2014

This example is based on Inc.5000 Companies data as of 2014. It's a simple project that loads 2 tables from a local database (comes with the exampe) and a text file, merges them, calculates new column, aggregates data, and exports the result into an Excel report. The example demonstrates basic transformations, visual database query, project parameters, expressions, export to file.

Summary

  • Source data: 1 database table (5000 rows), 1 CSV file
  • Transformations: 11
  • Export: 1 spreadsheet
  • Full run time*: less than 1 second
  • Designed for EasyMorph v3.6 or above

Download

US Census 2012 (with Tableau workbook)

This project transforms data from the US census of 2012. It loads data from a 100MB text file, performs lookups using 3 external tables, filtering and aggregating, and then exports the final result into a Tableau Data Extract.

The example also includes a Tableau workbook with dashboard built using the TDE file generated in EasyMorph.

Summary

  • Source data: 4 text files, 450'000 rows (10MB zipped)
  • Transformations: 24
  • Export: 1 Tableau Data Extract
  • Full run time*: 15 seconds
  • Designed for EasyMorph v2.8 or above

Download

Formula 1 (querying a database)

This example shows how to load data from a database using a parametrized query. A sample tiny SQLite database is included so that no additional software installation required — the example works out of the box.

Summary

  • 1 database (included)
  • 1 text file
  • Full run time*: less than 1 second
  • Designed for EasyMorph v3.1 or above

Download

QlikView

This example shows how a data transformation logic can be designed in EasyMorph and then integrated with QlikView (or Qlik Sense). This allows users to see and modify transformation logic in a visual way, without dealing with the loading script. The example also demonstrates QVD file generation by EasyMorph and a way to iterate (process) a list of files.

In order to use this example you will need a trial license key. Download trial key.

Summary

  • Source data: 3 text files
  • Export: 1 QVD file
  • 1 QlikView application
  • 2 EasyMorph projects
  • Full run time*: 1-2 seconds
  • Designed for EasyMorph v2.8 or above

Download

Data normalization

This example demonstrates extracting dimensions and partial normalization of a denormalized dataset. It loads Inc5000 Companies data, creates a new table with a list of states and their primary keys, and finally replaces states in the main dataset with their respective keys. The example is a good demonstration of use of derived tables in EasyMorph.

Summary

  • Source data: 1 text file, 5000 rows
  • Transformations: 9
  • Full run time*: less than 1 second
  • Designed for EasyMorph v3.1 or above

Download

Character count (with parameters)

A small project that demonstrates the use of parameters in EasyMorph: transformation properties (e.g. file names) as parameters, calculated parameters, parameters in expressions.

The project loads a text file (specified by a project parameter) and then automatically counts number of characters in its first N lines, where N is also a parameter. You can re-run the project multiple times specifying different text files and different number of lines.

Summary

  • 3 parameters
  • 9 transformations
  • Full run time: depends on selected text file
  • Designed for EasyMorph v3.1 or above

Download

Iterations

Examples of various use cases for iterations in EasyMorph. Iterations is a powerful feature that allows arranging loops, processing lists of files, running projects for a range of dates, and re-using logic between different projects.

Designed for EasyMorph v3.0 or above.

Examples

  • Example 1 – load multiple files
  • Example 2 – split one file into many files
  • Example 3 – batch processing of several files
  • Example 4 – iterate and append data into one table
  • Example 5 – iterate another table (requires ver.3.1 or above)

Download

Income Statement

This example demonstrates how data transformation and simple reporting can be done using only EasyMorph and Excel.

The project extracts data from a complex Excel spreadsheet with income statement of a real public company, and then exports the data into an Excel report with a pivot table and a chart. You can modify the project, run it and see how the Excel report updates automatically when it's re-opened.

Summary

  • Source data: Excel spreadsheet and a mapping file
  • Target: another Excel spreadsheet
  • Full run time*: less than 1 second
  • Designed for EasyMorph v3.1 or above

Download

Computers

Experience a bit of nostalgia (or amusement, depending on your age) looking at typical computer specs of 1993-1995 and learn a few advanced techniques in EasyMorph — use of derived tables, self-join and referencing data from previous row.

Summary

  • Source data: 1 text file, 6'200 rows
  • Transformations: 30
  • Full run time*: less than 1 second
  • Designed for EasyMorph v3.1 or above

Download

* Run time was estimated on a laptop with Pentium i5 CPU and 16GB RAM.