A financial services company is analyzing stock price volatility. An analyst has created a visualization showing daily stock prices. To measure volatility, they need to calculate the standard deviation of the stock price over a rolling 30-day window. Which function is the most appropriate and direct way to achieve this in Tableau?
A marketing team uses Tableau to analyze campaign performance. They have a data source that is updated daily with new performance metrics. The team has a critical dashboard that must always show the latest data with minimal latency. The underlying database is a high-performance analytical database (e.g., Snowflake, Google BigQuery) optimized for fast queries. Which data connection type should be used for the data source to meet these requirements?
An analyst is building a dashboard to compare the sales performance of different product categories. They want to allow users to dynamically select a category and see its sales trend line compared against the average sales trend of all other categories. Which features must be combined to achieve this interactivity? (Select TWO)
True or False: When you publish a workbook to Tableau Server with a live connection to a database that uses integrated authentication (e.g., Windows Authentication), you must configure a Run As User account on Tableau Server to enable successful data source access for all users.
A data analyst for a large e-commerce company is tasked with creating a Tableau Prep flow to clean and prepare sales data. The raw data comes from two different systems. One system provides order details in a CSV file where each row is a line item, including `OrderID`, `ProductID`, and `Quantity`. The other system provides product information in a separate CSV, including `ProductID`, `ProductName`, and `Category`. The goal is to produce a single, clean output file containing `OrderID`, `ProductName`, `Category`, and `Quantity` for all orders. The analyst builds a Tableau Prep flow. They add an Input step for the order details CSV and another Input step for the product information CSV. To combine the two data streams, they need to add another step. Which Tableau Prep step should the analyst use to correctly combine the product names and categories with their corresponding order line items?
**Company Background:** Global Logistics Inc. (GLI) manages a worldwide shipping network. They track shipments, carrier performance, and delivery times. Data is stored in a central data warehouse. Analysts at GLI use Tableau to monitor key performance indicators (KPIs) and identify bottlenecks in their supply chain. **Current Situation:** A senior analyst has been asked to create a new executive dashboard focused on carrier performance. The primary data source is a large, non-normalized table containing millions of shipment records. This table includes fields like `CarrierName`, `OriginCity`, `DestinationCity`, `ShipmentDate`, `DeliveryDate`, and `ShipmentCost`. A key requirement is to calculate the average delivery time for each carrier. **Technical Challenge:** The `ShipmentDate` and `DeliveryDate` fields include weekends and company holidays, but the business requirement is to calculate the average delivery time in *business days* only. The company maintains a separate table in the data warehouse named `CompanyHolidays` which lists all non-working dates. The analyst needs to incorporate this holiday list and exclude weekends from the delivery time calculation within Tableau. **Question:** Which approach is the most efficient and scalable for calculating the average delivery time in business days, correctly accounting for both weekends and the custom holiday list?
An analyst needs to create a view that shows the percentage of total sales for each product Sub-Category within its parent Category. For example, they want to see that 'Chairs' account for X% of 'Furniture' sales, and 'Phones' account for Y% of 'Technology' sales. Which type of calculation is best suited for this requirement?
A Tableau user has created a dashboard with four different worksheets. They want to add a single filter for 'Region' that simultaneously filters all four worksheets on the dashboard. How can this be achieved most efficiently?
An analyst is troubleshooting a dashboard's performance. They suspect that the order in which filters are being applied is causing issues. The dashboard contains an extract filter, a data source filter, a dimension filter set to 'Context', and a standard dimension filter. Which diagram correctly illustrates the order in which Tableau applies these filters? ```mermaid graph TD A[Start] --> B(Extract Filter) B --> C(Data Source Filter) C --> D(Context Filter) D --> E(Dimension Filter) E --> F[View] ```
A consultant is designing a mobile-first dashboard for sales representatives who will view it on their phones. Which of the following design choices are considered best practices for mobile dashboard design in Tableau? (Select THREE)