AMI Datasources 2: Excel Sheets

In this second tutorial in the series we will be looking at how to create a Microsoft Excel datasource in AMI. This datasource can either reference one specific Excel file or a directory containing multiple Excel files and we will demonstrate both. AMI is able to import each sheet in an Excel file independently which we will use as the basis for creating multiple visualizations and carrying out some simple aggregation. Finally, we will demonstrate how to export data contained within AMI to an Excel file, add formula columns to worksheets and make the resulting files available as a download via the web browser.