Excel as a Data Source

The C:\TU\InMemory\Data folder contains an Excel workbook with the name CustomerMonthBudgetMultipleYears.xlsx.

When opening this Excel file, you will see that it contains seven sheets with seven years of monthly budget data for all the companies in our current data warehouse.

Our task is to integrate these budget data into the current data warehouse so we can start comparing Amounts and Budgets for these companies on a monthly basis.

First, we will need to add the Excel Workbook as a Data Source in our InMemory Project:

Of course, this is an Excel type Data Source:

Browse to the file location and select the Excel Workbook and give the data source a proper name:

Once completed, the new Data Source will be available to the InMemory project: