A business analyst using a shared folder mapped to S \419379942\ receives an Excel We with more than 100 columns Many of the columns are duplicates. The current set of columns mat should be used have the suffix '_c* appended to the column name
What should the business analyst do to load the Excel data?
Answer: C
Question 2
A business analyst needs to share a link to a specific visualization with colleagues
Which steps should the business analyst use?
Answer: A
Question 3
A marketing team is using an app to analyze the company events. The team registers attendees with information such as an ID name and region and discusses business opportunities with attendees Opportunities are evaluated m time and set to a different status.
The team wants to use insight Advisor to query events and opportunities to:
* Review specific areas and periods
* Use marketing terms not currently present in the app when classifying opportunities
* Define calendar periods and add calculations for specific data fields
Some examples are as follows:
Which process should the business analyst follow?
Answer: D
Question 4
A business analyst is creating an app that requires several visualizations
* A scatter plot mat shows the margin percentage and total sales by product category
* A map with a the layer that visualizes lines between retail stores and lactones
* A KPI that shows total cost
Margin?n be calculated by dividing profit by revenue Profit is the difference between total cost and total sates
Which two sets of fields can the business analyst use to meet these requirements? (Select two.)
Answer: A,C
Question 5
A developer has created an application with native objects in a way that is well organized by sheets so that users can gain their insights independently. Users have notebooks, mobile phones and tablets. When the application was created, the developer did not imagine that the application would be accessed by mobile devices, but the good news is that the application adapts very well to any format and screen size.