A client builds a dashboard that presents current and long-term stock measures. Currently, the data is at a daily level. The data presents as a bar chart that
presents monthly results over current and previous years. Some measures must present as monthly averages.
What should the consultant recommend to limit the data source for optimal performance?
A client has a published data source in Tableau Server and they want to revert to the previous version of the data source. The solution must minimize the impact
on users.
What should the consultant do to accomplish this task?
A client wants to see the average number of orders per customer per month, broken down by region. The client has created the following calculated field:
Orders per Customer: {FIXED [Customer ID]: COUNTD([Order ID])}
The client then creates a line chart that plots AVG(Orders per Customer) over MONTH(Order Date) by Region. The numbers shown by this chart are far higher
than the customer expects.
The client asks a consultant to rewrite the calculation so the result meets their expectation.
Which calculation should the consultant use?
A client wants to provide sales users with the ability to perform the following tasks:
· Access published visualizations and published data sources outside the company network.
· Edit existing visualizations.
· Create new visualizations based on published data sources.
. Minimize licensing costs.
Which site role should the client assign to the sales users?
A company has a data source for sales transactions. The data source has the following characteristics:
. Millions of transactions occur weekly.
. The transactions are added nightly.
. Incorrect transactions are revised every week on Saturday.
· The end users need to see up-to-date data daily.
A consultant needs to publish a data source in Tableau Server to ensure that all the transactions in the data source are available.
What should the consultant do to create and publish the data?
A client is using Tableau to visualize data by leveraging security token-based credentials. Suddenly, sales representatives in the field are reporting that they
cannot access the necessary workbooks. The client cannot recreate the error from their offices, but they have seen screenshots from the field agents. The client
wants to restore functionality for the field agents with minimal disruption.
Which step should the consultant recommend to accomplish the client's goal?
Use the following login credentials to sign in
to the virtual machine:
Username: Admin
Password:
The following information is for technical
support purposes only:
Lab Instance: 40201223
To access Tableau Help, you can open the
Help.pdf file on the desktop.
From the desktop, open the CC workbook.
Open the Categorical Sales worksheet.
You need to use table calculations to
compute the following:
. For each category and year, calculate
the average sales by segment.
. Create another calculation to
compute the year-over-year
percentage change of the average
sales by category calculation. Replace
the original measure with the year-
over-year percentage change in the
crosstab.
From the File menu in Tableau Desktop, click
Save.
From the desktop, open the CCworkbook. Use the US PopulationEstimates data source.
You need to shape the data in USPopulation Estimates by using TableauDesktop. The data must be formatted asshown in the following table.
Open the Population worksheet. Enterthe total number of records contained inthe data set into the Total Recordsparameter.
From the File menu in Tableau Desktop,click Save.
From the desktop, open the NYC
Property Transactions workbook.
You need to record the performance of
the Property Transactions dashboard in
the NYC Property Transactions.twbx
workbook. Ensure that you start the
recording as soon as you open the
workbook. Open the Property
Transactions dashboard, reset the filters
on the dashboard to show all values, and
stop the recording. Save the recording in
C:\CC\Data\.
Create a new worksheet in the
performance recording. In the worksheet,
create a bar chart to show the elapsed
time of each command name by
worksheet, to show how each sheet in
the Property Transactions dashboard
contributes to the overall load time.
From the File menu in Tableau Desktop,
click Save. Save the performance
recording in C:\CC\Data\.
From the desktop, open the CC workbook.
Open the Incremental worksheet.
You need to add a line to the chart that
shows the cumulative percentage of sales
contributed by each product to the
incremental sales.
From the File menu in Tableau Desktop, click
Save.
From the desktop, open the CC workbook.
Open the City Pareto worksheet.
You need to complete the Pareto chart toshow the percentage of sales compared tothe percentage of cities. The chart mustshow references lines to visualize how thedata compares to the Pareto principle.
From the File menu in Tableau Desktop, clickSave.
From the desktop, open the CC workbook.
Open the Manufacturers worksheet.
The Manufacturers worksheet is used to
analyze the quantity of items contributed by
each manufacturer.
You need to modify the Percent
Contribution calculated field to use a Level
of Detail (LOD) expression that calculates
the percentage contribution of each
manufacturer to the total quantity.
Enter the percentage for Newell to the
nearest hundredth of a percent into the
Newell % Contribution parameter.
From the File menu in Tableau Desktop, click
Save.
A consultant plans a Tableau deployment for a client that uses Salesforce. The client wants users to automatically see Tableau views of regional sales filtered
by customer as soon as the users sign into Salesforce.
Which approach should the consultant use to deliver the final visualization?
A client wants to produce a visualization to show quarterly profit growth and aggregated sales totals across a number of product categories from the data
provided below.
Which set of charts should the consultant use to meet the client's requirements?
A client needs to design row-level security (RLS) measures for their reports. The client does not currently have Tableau Data Management Add-on, and it
may be an option in the future.
What should the consultant recommend as the safest and easiest way to manage for the long term?
A client has a database that stores widget inventory by day and it is updated on a nonstandard schedule as shown below.
They want a data visualization that shows widget inventory daily, however their business unit does not have the ability to modify the data warehouse
structure.
What should the client do to achieve the desired result?