Q2
Single choice
A business analyst is creating a data model from several Excel files that contain several hundred thousand rows of data. The requirements include:
1. Users need to drill down to various details within the available data set.
2. Several final measures will be repeatedly used. These final measures require combining several fields in a single table.
3. User experience and load time is a high priority.
Which action should the business analyst take to meet these requirements?