QSBA2018

Refer to the exhibits. A business analyst must create a bar chart to show the total value of orders processed per day. The dataset loaded by the data architect only contains the OrderNo, OrderDateTime, and OrderAmount. The business analyst creates a calculated field, OrderDate, using the expression, Date (OrderDateTime). The...

Report: sheet for the row-level detailsView AnswerAnswer: C

A business analyst is creating a dashboard to analyze supply chains. The app must contain several elements: - A bar chart that shows a number of products and product groups handled by shipper - A map that shows the number of shipments sent from factory locations - A bar chart...

A large organization with more than 100 departments wants to raise money for a donation in the next 30 days. This year, leadership decides to increase employee participation through a competition. Team members of departments that raise $10,000 or more receive two additional holidays. Leadership needs the following capabilities: -...

A business analyst must display current year sales versus previous year sales by region, sub-region, and city. The result will be a pivot table, with rows for the region, sub-region, and city, and columns for Current Year Sales and Previous Year Sales. Which calculated expressions should the business analyst create...

Change the format from ‘Geo data’ to ‘General’View AnswerAnswer: D

A business analyst must display current year sales versus previous year sales by region, sub-region, and city. The result will be a pivot table, with rows for the region, sub-region, and city, and columns for Current Year Sales and Previous Year Sales. Which calculated expressions should the business analyst create...

A bus company wants to analyze customer travel patterns to add additional services or create new routes. The business analyst needs to consider the following data: - 190 routes across the city - Start and end location of each route - Volume of customers travelling per hour - Customer complaints...

A large organization with more than 100 departments wants to raise money for a donation in the next 30 days. This year, leadership decides to increase employee participation through a competition. Team members of departments that raise $10,000 or more receive two additional holidays. Leadership needs the following capabilities: -...

A large organization with more than 100 departments wants to raise money for a donation in the next 30 days. This year, leadership decides to increase employee participation through a competition. Team members of departments that raise $10,000 or more receive two additional holidays. Leadership needs the following capabilities: -...