Salesforce Analytics-Con-301 Dumps

Comprehensive and Detailed Explanation From Exact Extract:

Tableau’s row-level security (RLS) is applied at the data source level so that all users who connect to the data source—whether through Tableau Desktop, Server, or Cloud—see only the data they are permitted to see.

According to Tableau documentation:

A Data Source Filter is the correct method for enforcing consistent row-level security for all users.

When a Data Source Filter is applied before publishing, it becomes part of the data source’s metadata and is applied every time any user connects to the published source.

This ensures that users creating new workbooks in Tableau Desktop are governed by the same RLS as users viewing published dashboards.

Context filters and extract filters do not provide secure RLS:

A Context Filter only applies inside the workbook where it is created. It does not enforce security in Tableau Desktop when the data source is reused.

An Extract Filter physically removes rows from the extract but does not enforce role-based filtering or dynamic RLS.

“Apply Filter to All Using Related Data Sources” affects workbook behavior, not published data source security.

A Data Source Filter applied prior to publishing is Tableau’s documented approach for secure, reusable row-level security.

Row-Level Security implementation guidance describing Data Source Filters as the foundation of secure RLS.

Tableau Server publishing workflow indicating that Data Source Filters travel with the published source.

Documentation on why Context and Extract Filters do not enforce user-dependent row-level security.

Comprehensive and Detailed Explanation From Exact Extract:

Key Tableau Catalog behaviors:

Connected workbooks = any workbook linked to the published data source.

Impacted workbooks = only workbooks that use the specific field.

If a workbook connects to the data source but never uses the field, it appears as “connected” but not impacted.

This explains EXACTLY why:

7 workbooks are connected

Only 6 use the changed field

Therefore only 6 are impacted

This matches Option C.

Why the other options are incorrect:

A. Field used twice

Still counts as one workbook — does not explain discrepancy.

B. Permission issue

If permissions blocked visibility, the data source would not list 7 connections.

D. Custom SQL use

Catalog can still detect field usage through metadata lineage; Custom SQL does NOT hide workbook dependency.

Thus, only Option C logically explains the scenario.

Data Catalog lineage rules: “Connected vs. Impacted” distinction.

Field-level impact analysis documentation.

Workbook dependency logic within Tableau Catalog.

To improve the loading time of the pipeline dashboard, which primarily suffers from long query execution times due to a comprehensive Relative Date filter:

Relative Date Filter Issue: The existing Relative Date filter on "Created Date" covers a broad range (5 years), leading to significant data processing overhead as it includes granular date calculations over a large dataset.

Optimized Approach: By replacing the Relative Date filter with a Multiple Values (Dropdown) filter based on YEAR([Created Date]), the filter granularity is reduced. Filtering by year simplifies the query by limiting the volume of data processed and reducing the complexity of the filter condition.

Implementation Benefit: This approach still provides the flexibility to view data across different years but does so by reducing the load on the database during query execution, which is critical for improving the performance of the dashboard.

References

This recommendation aligns with Tableau performance optimization strategies, specifically regarding the management of date filters to minimize their impact on query load, as discussed in Tableau performance tuning sessions and guides.

Comprehensive and Detailed Explanation From Exact Extract:

To combine Excel and SQL Server data in the same logical data model, Tableau offers two supported capabilities:

Relationships

Recommended modern method for combining tables from multiple sources.

Supports cross-database relationships between Excel and SQL Server.

Maintains separate physical layers but integrates data at query time.

Cross-Database Joins

Allows joining data from different databases in the physical layer.

Fully supported for Excel + MS SQL Server.

Useful when granular row-level merging is needed.

Why the other options are incorrect:

C. Data Blending

Legacy feature, used only when no direct combination is possible.

Tableau recommends relationships instead.

Produces separate queries and may lose row-level detail.

D. Union

Requires tables to have equivalent structure.

Cannot union Excel with SQL Server unless identical column structure exists.

Not appropriate for most mixed-source reporting.

Therefore, the correct techniques are Relationships and Cross-Database Joins.

Tableau data modeling documentation recommending Relationships for multi-source modeling.

Cross-database join support list including Excel + SQL Server.

To identify which workbooks need to be updated to point to a new data source after a migration, a consultant should use Tableau Advanced Management. This component of Tableau provides comprehensive management capabilities including the ability to track workbook dependencies and data source usage across your entire Tableau environment. Using Tableau Advanced Management allows consultants to assess the impact of changes in the data source on connected workbooks and efficiently manage updates.

Comprehensive and Detailed Explanation From Exact Extract:

Tableau documentation clearly defines user capabilities per license:

Viewer

Can view dashboards only.

Cannot create Data-Driven Alerts.

Cannot perform ad hoc analysis.→ Insufficient.

Explorer

Can view dashboards.

Can create Data-Driven Alerts.

Can perform ad hoc analysis using existing published data sources.

Does NOT require full creator-level capabilities.→ Meets all requirements at lower cost than Creator.

Creator

Full authoring, data source creation, and prep capabilities.

Higher cost.→ Overkill and violates “minimizes licensing costs.”

Site Administrator

Includes Creator capabilities plus admin privileges.

Most expensive.→ Not appropriate for managers.

Therefore, the correct and most cost-efficient role is Explorer.

Tableau role capability matrix showing Explorers can create alerts and analyze existing data sources.

Licensing guidance recommending Explorer for ad hoc analysis without data-source creation.

When dashboards are published to Tableau Cloud, the function USERNAME() returns the user’s Tableau Cloud username, which is the email address associated with their Tableau Cloud account.

Tableau documentation states:

On Tableau Cloud, the value returned by USERNAME() is always the user’s email address.

Row-Level Security (RLS) is typically implemented using a comparison of USERNAME() to an email field in the data source.

For secure filtering, the field compared to USERNAME() must match the authentication identity exactly.

Looking at the provided table:

“Abbreviated Name” contains short custom codes like “SMiller,” which do not match Tableau Cloud usernames.

“Lower Case Name” contains names like “sean miller,” which also do not match Tableau Cloud usernames.

“Email” contains the full email address for each user, such as “Sean.Miller@superstore.com,” which is the only field that corresponds to what USERNAME() returns in Tableau Cloud.

Therefore, the correct field to reference is Email.

Tableau Cloud authentication documentation stating USERNAME() returns the user’s email address.

Row-Level Security setup guidance recommending the comparison USERNAME() = [Email Field].

Tableau security practices indicating only the email column will match USERNAME() values on Tableau Cloud.

Comprehensive and Detailed Explanation From Exact Extract:

Tableau’s RLS entitlement design patterns include:

1. Deepest Granularity Method

Requires one unique role ↔ one unique lowest-level value pairing.

Fails when the dataset contains duplicate lowest-level values (e.g., multiple “East” sub-regions across different regions).

Cannot operate correctly when some lowest-level values are NULL.

Thus, the deepest granularity method is not valid here.

2. Sparse Entitlements Method

Tableau documentation states:

Sparse entitlements define RLS at each level of the hierarchy instead of only at the lowest level.

This method supports duplicate lowest-level values.

Handles scenarios where some levels are NULL because higher-level entitlements (e.g. Region = AMER) can still correctly apply.

More flexible for hierarchical geographic structures (Region → Sub-Region → Country, etc.).

Given the client’s dataset:

Multiple “East” and “West” sub-regions

Some “Null” sub-regions

Hierarchical levels present

Sparse entitlements is the only correct and supported choice.

Why the incorrect options are wrong:

A & B — Deepest Granularity

Deepest granularity fails when the lowest-level values are not unique.

It cannot handle NULL values at the lowest tier.

Performance is not superior in this scenario.

D — Sparse because it is most performant

Performance is not the defining advantage.

Flexibility and ability to handle duplicate lowest-level values is.

Thus, C is the correct statement.

RLS entitlement design patterns: deepest vs. sparse entitlements.

Rules requiring unique lowest-level identifiers for deepest granularity.

Guidance stating sparse entitlements should be used when duplicates or NULL values exist in hierarchical structures.

Comprehensive and Detailed Explanation From Exact Extract:

Tableau’s performance best-practice documentation explains that large workbooks containing many dashboards, multiple data sources, and complex interactions have heavier memory and CPU requirements. When a workbook grows too large, Tableau must:

Load every data source

Cache metadata for all sheets

Maintain connections across all dashboards

Render more worksheets simultaneously

This increases workbook load time and slows dashboard performance.

A documented method for improving performance is to split a large workbook into multiple smaller workbooks, each containing only the dashboards relevant to a particular audience or subject area. Smaller workbooks:

Reduce the amount of metadata Tableau must load

Reduce extract sizes per workbook

Improve caching efficiency

Improve dashboard loading and rendering time

Options A, B, and C do not improve workbook performance:

A. Converting Data Source Filters to Quick Filters reduces performance because Quick Filters (interactive filters) are more expensive than Data Source filters and slow down rendering.

B. Converting extracts to live connections typically worsens performance because live sources depend on database query speed, network latency, and server load.

C. Restricting users does not change workbook performance, only access.

Splitting the workbook is a recognized Tableau strategy for improving performance of large, multi-dashboard workbooks.

Tableau Performance Optimization guidelines encouraging splitting large workbooks into smaller ones.

Workbook design best practices emphasizing reduced complexity and smaller metadata footprints.

Documentation on performance costs associated with Quick Filters and multiple data sources.

Comprehensive and Detailed Explanation From Exact Extract:

Tableau allows certain calculations to be materialized in extracts, meaning they are precomputed and stored inside the .hyper file to improve performance.

According to Tableau’s extract documentation:

Materializable calculations must be compatible with the extract engine and must not depend on dynamic, view-based, or post-query logic.

Only row-level calculations and aggregation-level calculations without dependencies on runtime context can be materialized.

Tableau cannot materialize any calculation containing:

Table calculation functions

Functions requiring post-aggregation logic

View-dependent elements

Parameters that need runtime evaluation

Evaluation of the choices:

A. A row-level calculation — Correct

Row-level calculations operate on each record individually before aggregation.

Tableau documentation specifies that these calculations can be pushed down into the extract and materialized because they do not depend on the visualization or user interaction.

Examples include concatenation, arithmetic, string manipulation, and row-based logic such as:

[Sales] * [Quantity] or IF [Region] = 'West' THEN 1 END

These can be precomputed inside the extract, improving performance.

B. A calculation that contains table calculation functions — Not allowed

Table calculations (WINDOW_SUM, INDEX, RUNNING_SUM, RANK, etc.) depend on the table structure after aggregation and query execution.

Therefore, Tableau documentation states they cannot be materialized in extracts.

C. A calculation that contains parameters — Not allowed

Parameters are evaluated at runtime, meaning the user can change their value.

Because of this, Tableau cannot permanently compute and store such a calculation inside an extract.

D. A calculation that contains an aggregation — Generally not materialized

Aggregated calculations often depend on query context and cannot always be materialized.

Only simple, context-free aggregations might be materialized, but Tableau explicitly warns that aggregations are not guaranteed candidates for extract materialization.

Thus, this is not the best answer compared to row-level logic.

Conclusion

Only row-level calculations meet Tableau’s exact requirements for materialization in extracts.

References From Tableau Consultant Documentation

Tableau Extract documentation describing materializable calculation types.

Tableau guidance stating table calculations and parameter-dependent calculations cannot be materialized.

Extract optimization guidelines describing row-level logic as eligible for materialization.

When “Apply to Nested Projects” is checked in Tableau Server, the permission rules set at the top-level project are enforced for all assets in the project and all nested projects. This means that any custom access previously granted to nested projects will be overridden, and the permissions will revert to those defined at the top-level project. This action ensures consistent application of the data governance strategy across all divisions.

When migrating content between Tableau servers, certain types of content may require special consideration or different tools for migration:

Tableau Prep Flows: These are specific to Tableau Prep and are not included in the standard content migration capabilities of the Tableau Content Migration Tool. Tableau Prep flows often require separate processes for migration due to their distinct setup and integration with data sources and workflows.

Published Data Sources and Workbooks: These can typically be migrated directly using the Tableau Content Migration Tool, which supports moving published data sources (both live connections and extracts) and workbooks without requiring additional tools.

To improve the performance of a Tableau dashboard while maintaining accurate counts, particularly when dealing with unknown or NULL BrowserIDs in the data tables, the following steps are recommended:

Modify the Browser Table: Add a new row to the Browser Table labeled "Unknown," assigning it a unique BrowserID, e.g., 0 or 4.

Update the Site Visitor Table: Replace all NULL BrowserID entries with the BrowserID assigned to the "Unknown" entry. This ensures every record in the Site Visitor Table has a valid BrowserID that corresponds to an entry in the Browser Table.

Change Referential Integrity Setting: Change the Referential Integrity setting from "Some Records Match" to "All Records Match." This change assumes all records in the primary table have corresponding records in the secondary table, which improves query performance by allowing Tableau to make optimizations based on this assumption.

The correct calculation for classifying profit margins into categories based on specified thresholds involves the use of conditional statements that check ranges in a logical order:

Highly Profitable Classification: The first condition checks if the profit margin is 50% or more. This must use the ">=" operator to include exactly 50% as "Highly Profitable".

Profitable Classification: The next condition checks if the profit margin is between 0% and 50%. Since any value falling at or above 50% is already classified, this condition only needs to check for values greater than or equal to 0%.

Unprofitable Classification: The final condition captures any remaining scenarios, which would only be values less than 0%.

When considering a migration from Tableau Server to Tableau Cloud, two critical factors to consider are the client’s need for single sign-on (SSO) and the volume of concurrent extract refreshes.

Single Sign-On (SSO): Tableau Cloud supports SSO, which can streamline user authentication and enhance security. If the client plans to leverage SSO, Tableau Cloud may be a suitable choice1.

Concurrent Extract Refreshes: The number of concurrent extract refreshes is a significant factor because it impacts performance and resource allocation. Tableau Server might be more appropriate if the client has a high volume of concurrent extract refreshes, as it allows for more control over the infrastructure to manage these workloads2.

The Tableau Catalog is part of the Tableau Data Management Add-on and is designed to help users understand the data they are using within Tableau. It provides a comprehensive view of all the data assets in Tableau Server or Tableau Online, including databases, tables, and fields. It can help identify issues such as data quality, data lineage, and impact analysis. In this case, where different departments are getting different answers to the same business questions, the Tableau Catalog can be used to track down inconsistencies and ensure that everyone is working from the same, reliable data source.

The correct calculation to determine the average number of days a customer must wait before a product is shipped is to first find the shipping date, which is the first day of the following month after the order date. This is done using DATETRUNC('month', DATEADD('month', 1, [Order Date])). Then, the average difference in days between the order date and the shipping date is calculated using AVG(DATEDIFF('day', [Order Date], [Calc1])). This approach ensures that the average wait time is calculated in days, which is the most precise measure for this scenario.

The calculation {FIXED [Customer ID], [Region]: COUNTD([Order ID])} is the correct one to use for this scenario. This Level of Detail (LOD) expression will calculate the distinct count of orders for each customer within each region, which is then averaged per month. This approach ensures that the average number of orders per customer is accurately calculated for each region and then broken down by month, aligning with the client’s expectations.

To track which data sources are used most frequently across a site in Tableau Cloud, the client should use the GraphiQL engine and the Metadata API. The GraphiQL engine allows for interactive exploration of the metadata, making it easier to construct and test queries1. The Metadata API provides access to metadata and lineage of external assets used by the content published to Tableau Cloud, which is essential for tracking data source usage2.

For a performant live connection in Tableau Cloud, especially when dealing with large datasets that preclude the use of extracts, relating the tables in Tableau Desktop is the recommended approach. This method allows for flexibility in how the data is queried and can improve performance by leveraging Tableau’s relationships feature, which optimizes queries for the underlying database.

To modify the Percent Contribution calculated field to use a Level of Detail (LOD) expression and accurately calculate the percentage contribution of each manufacturer to the total quantity, follow these steps:

Open the CC Workbook and Access the Worksheet:

Double-click on the CC workbook from the desktop to open it in Tableau Desktop.

Navigate to the Manufacturers worksheet by selecting its tab at the bottom of the window.

Modify the Percent Contribution Calculated Field:

Navigate to the Data pane and find the "Percent Contribution" calculated field.

Right-click on the "Percent Contribution" field and select 'Edit'.

Modify the formula to incorporate an LOD expression that calculates the total quantity across all manufacturers and the specific quantity per manufacturer:

{FIXED [Manufacturer]: SUM([Quantity])} / {SUM([Quantity])}Quantity])}

This formula uses {FIXED [Manufacturer]: SUM([Quantity])} to compute the total quantity contributed by each manufacturer, regardless of other dimensions in the view. The total quantity {SUM([Quantity])} calculates the grand total across all manufacturers. The division calculates the percentage contribution.

Click 'OK' to save the updated calculated field.

Enter Percentage for Newell:

With the updated "Percent Contribution" field, drag it onto the view to update the chart or table.

Identify the value corresponding to 'Newell' in the updated visualization.

Round this value to the nearest hundredth of a percent as required.

Enter this value into the "Newell % Contribution" parameter. To do this, locate the parameter in the Data pane or on the dashboard, right-click it, and choose 'Edit'. Enter the calculated percentage for Newell.

Save Your Changes:

From the File menu, click 'Save' to store all the modifications you have made to the workbook.

To complete the Pareto chart in the "City Pareto" worksheet of your Tableau Desktop and add reference lines to illustrate how the data compares to the Pareto principle, follow these steps:

Open the CC Workbook and Access the Worksheet:

From the desktop, double-click on the CC workbook to open it in Tableau Desktop.

Navigate to the City Pareto worksheet by selecting its tab at the bottom of the window.

Construct the Pareto Chart:

Ensure that sales data is aggregated by city. If not, drag the 'City' dimension to the Columns shelf and the 'Sales' measure to the Rows shelf.

Sort the sales data in descending order to properly align the cities according to their sales contribution.

To create a running total of sales, right-click on the 'Sales' measure on the Rows shelf, select 'Quick Table Calculation', and choose 'Running Total'.

Drag the 'Number of Records' field to the Rows shelf next to the Sales running total. Right-click on it, select 'Quick Table Calculation', and choose 'Running Total'. Set its calculation to 'Percent of Total' from the 'Edit Table Calculation' option to represent the percentage of cities.

Add Reference Lines for the Pareto Principle:

Click on the Analytics tab in the sidebar.

Drag a 'Reference Line' element and drop it onto the chart area.

Set the Reference Line for the Sales axis at 80% to represent the typical Pareto cutoff where 80% of effects come from 20% of causes.

Add another Reference Line on the axis representing the percentage of cities, set at 20%, to visually assess the Pareto principle.

Adjust the Appearance of the Chart:

Format the reference lines by right-clicking on them, selecting 'Edit', and choosing a distinct style or color to make them stand out.

Ensure the chart is clear and labels are appropriately adjusted for easy understanding of the data visualization.

Save Your Changes:

From the File menu, click 'Save' to ensure all your changes are stored.

To add a line showing the cumulative percentage of sales contributed by each product to the incremental sales in the Incremental worksheet of your Tableau Desktop, follow these detailed steps:

Open the CC Workbook and Access the Worksheet:

From the desktop, double-click on the CC workbook to open it in Tableau Desktop.

Navigate to the Incremental worksheet by clicking on its tab at the bottom of the window.

Calculate Cumulative Sales Percentage:

Create a new calculated field to compute the cumulative percentage of sales. Right-click in the Data pane and select 'Create Calculated Field'.

Name this field "Cumulative Sales Percentage".

Enter the following formula to calculate the running sum of sales as a percentage of the total sales:

(RUNNING_SUM(SUM([Sales])) / TOTAL(SUM([Sales])) [Sales]))

Click 'OK' to save the calculated field.

Add the Cumulative Sales Percentage Line to the Chart:

Drag the "Cumulative Sales Percentage" field to the Rows shelf, placing it next to the existing Sales measure.

Ensure that the cumulative line appears as a continuous line. Right-click on the "Cumulative Sales Percentage" field on the Rows shelf, select 'Change Chart Type', and choose 'Line'.

Adjust the axis to synchronize or dual-axis if necessary. Right-click on the axis of the "Cumulative Sales Percentage" and select 'Synchronize Axis' if it's on a dual-axis setup.

Format the Cumulative Sales Percentage Line:

Click on the "Cumulative Sales Percentage" line in the visualization.

Navigate to the 'Format' pane to adjust the line style, thickness, and color to make it distinct from other data in the chart.

Save Your Changes:

From the File menu, click 'Save' to ensure all your changes are stored.

To shape the data in the "US Population Estimates" data source and enter the total number of records into the "Total Records" parameter in Tableau Desktop, follow these steps:

Open the CC Workbook and Access the Worksheet:

From the desktop, double-click on the CC workbook to open it in Tableau Desktop.

Navigate to the Population worksheet by selecting its tab at the bottom of the window.

Format and Shape the Data:

Ensure the data types match those specified in the requirements: Sex, Origin, Race as strings; Year, Age, Population as whole numbers.

To verify or change the data type, click on the dropdown arrow next to each field name in the Data pane and select "Change Data Type" if necessary.

Calculate Total Number of Records:

Create a new calculated field named "Total Records". To do this, right-click in the Data pane and select "Create Calculated Field".

Enter the formula COUNT([Record ID]) or SUM([Number of Records]) depending on how the data source identifies each row uniquely.

Drag this new calculated field onto the worksheet to display the total number of records.

Enter the Value into the Total Records Parameter:

Locate the "Total Records" parameter in the Data pane. Right-click on the parameter and select "Edit".

Manually enter the number displayed from the calculated field into the parameter, ensuring accuracy to meet the data shaping requirement.

Save Your Changes:

From the File menu, click 'Save' to ensure all your changes are stored.

To compute the required calculations and update the worksheet in Tableau Desktop, follow these steps:

Compute Average Sales by Segment for Each Category and Year:

Open the CC workbook and navigate to the Categorical Sales worksheet.

Drag the 'Sales' field to the Rows shelf if it's not already there.

Drag the 'Segment' field to the Rows shelf as well, placing it next to 'Category' and 'Year'.

Right-click on the 'Sales' field in the Rows shelf and select 'Quick Table Calculation' > 'Average'. This will compute the average sales for each segment within each category and year.

Create a Calculation for Year-over-Year Percentage Change:

Right-click in the data pane and select 'Create Calculated Field'.

Name the calculated field something descriptive, e.g., "YoY Sales Change".

Enter the formula to calculate the year-over-year percentage change:

(ZN(SUM([Sales])) - LOOKUP(ZN(SUM([Sales])), -1)) / ABS(LOOKUP(ZN(SUM([Sales])), -1))

Click 'OK' to save the calculated field.

Replace the Original Measure with the Year-over-Year Percentage Change in the Crosstab:

Remove the original 'Sales' measure from the view by dragging it off the Rows shelf.

Drag the newly created "YoY Sales Change" calculated field to the Rows shelf where the 'Sales' field was originally.

Format the "YoY Sales Change" field to display as a percentage. Right-click on the field in the Rows shelf, select 'Format', and adjust the number format to percentage.

Save Your Changes:

From the File menu, click 'Save' to ensure all your changes are stored.

To record the performance of the Property Transactions dashboard in the NYC Property Transactions.twbx workbook and analyze it using a bar chart, follow these detailed steps:

Open the NYC Property Transactions Workbook:

From the desktop, double-click the NYC Property Transactions.twbx workbook to open it in Tableau Desktop.

Start Performance Recording:

Before doing anything else, navigate to the 'Help' menu in Tableau Desktop.

Select 'Settings and Performance', then choose 'Start Performance Recording'.

Open the Property Transactions Dashboard and Reset Filters:

Navigate to the Property Transactions dashboard within the workbook.

Reset all filters to show all values. This usually involves selecting the dropdown on each filter and choosing 'All' or using a 'Reset' button if available.

Stop the Performance Recording:

Go back to the 'Help' menu.

Choose 'Settings and Performance', then select 'Stop Performance Recording'.

Tableau will automatically open a new tab displaying the performance recording results.

Save the Performance Recording:

In the performance recording results tab, go to the 'File' menu.

Click 'Save As' and navigate to the C:\CC\Data\ directory.

Save the file, ensuring it is stored in the desired location.

Create a New Worksheet for Performance Analysis:

Return to the NYC Property Transactions workbook and create a new worksheet by clicking on the 'New Worksheet' icon.

Drag the 'Command Name' field to the Columns shelf.

Drag the 'Elapsed Time' field to the Rows shelf.

Ensure that the 'Worksheet' field is also included in the analysis to break down the time by individual sheets within the dashboard.

Choose 'Bar Chart' from the 'Show Me' options to display the data as a bar chart.

Customize and Finalize the Bar Chart:

Adjust the axes and labels to clearly display the information.

Format the chart to enhance readability, applying color coding or sorting as needed to emphasize sheets with longer load times.

Save Your Work:

Once the new worksheet and the performance recording are complete, ensure all work is saved.

Navigate to the 'File' menu and click 'Save', confirming that changes are stored in the workbook.