Steps to Integrate Excel Forecast into Data Model Without Losing Data

Qlik QSDA2022 Question Answer

Refer to the exhibit.

A business department is forecasting revenue within an Excel spreadsheet.

A data architect needs to include this forecast into the existing data model, and without losing any data.

Which two sets of steps will meet these requirements? (Select two.)

1. Load the Excel spreadsheet using the data load editor

2. Use the Unpivot function

3 Use the Sum function to group the forecast by date

4 Connect to the existing data model

1. Load the Excel spreadsheet using the data load editor

2 Use the Crosstable function to unpivot the table

3 Create a composite key out of the date and region

4 Connect the new table to the data model

1 Load the Excel spreadsheet using the data load editor

2. Change the sort order by date

3. Create a composite key out of the forecast and region 4 Connect to the existing data model

1 Load the Excel spreadsheet into the data manager

2. Use the Unpivot function

3. Create a composite key from the date and region

4. Connect the new table to the data model

1 Load the Excel spreadsheet using the data manager

2 Rename the ForecastDate field to Date 3. Disable the Region

4 Connect to the existing data model

Qlik QSDA2022 Summary

Price: $52.5 ~~$149.99~~