A business analyst is creating a data model from several Excel files that contain several hundred thousand
rows of data. The requirements include: • Users need to drill down to various details within the available data set.• Several final measures will be repeatedly used. These final measures require combining several fields in asingle table.• User experience and load time is a high priority.Which action should the business analyst take to meet these requirements?
A business analyst is working with retail data for consumer products. The customer is interested in thefollowing:• Ability to look for outliers on sales volume and margin %• Ability to understand the clustering of products visually• Ability to see products that are above the median sales volumeWhich action should the business analyst take to implement these requirements?
A business analyst is creating a data model from several Excel files that contain several hundred thousand
rows of data. The requirements include: • Users need to drill down to various details within the available data set.• Several final measures will be repeatedly used. These final measures require combining several fields in asingle table.• User experience and load time is a high priority.Which action should the business analyst take to meet these requirements?
A business analyst is creating a data model from several Excel files that contain several hundred thousand
rows of data. The requirements include: • Users need to drill down to various details within the available data set.• Several final measures will be repeatedly used. These final measures require combining several fields in asingle table.• User experience and load time is a high priority.Which action should the business analyst take to meet these requirements?
A business analyst is working with retail data for consumer products. The customer is interested in thefollowing:• Ability to look for outliers on sales volume and margin %• Ability to understand the clustering of products visually• Ability to see products that are above the median sales volumeWhich action should the business analyst take to implement these requirements?