See the complete Steps below in Explanation
Explanation:
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.
References:
Tableau Help: Offers detailed guidance on using LOD expressions for precise and context-independent aggregations.
Tableau Desktop User Guide: Provides comprehensive instructions on managing calculated fields and parameters, ensuring accurate data analysis.
By following these steps, you will have successfully updated the calculation for percent contribution using LOD expressions, providing a more accurate analysis of each manufacturer's contribution to the total quantity. Moreover, updating the parameter with Newell's specific contribution rounds out the task by reflecting precise data inputs for reporting or further analysis.

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.

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.
References: The recommendation for using Tableau Catalog is based on its features that support data discovery, quality, and governance, which are essential for resolving data inconsistencies across different departments12.
When different departments report different answers to the same business questions using the same databases and tables, the issue often lies in how data is being accessed and interpreted differently across departments. Tableau Catalog, a part of Tableau Data Management, can be used to solve this problem:
Visibility: Tableau Catalog gives visibility into the data used in Tableau, showing users where data comes from, where it's used, and who's using it.
Consistency and Trust: It helps ensure consistency and trust in data by providing detailed metadata management that can highlight discrepancies in data usage or interpretation.
Usage Metrics and Lineage: It offers tools for tracking usage metrics and understanding data lineage, which can help in identifying why different departments might see different results from the same underlying data.
References:
Tableau Catalog Usage: The Catalog is instrumental in providing a detailed view of the data environment, allowing organizations to audit, track, and understand data discrepancies across different users and departments.

See the complete Steps below in Explanation
Explanation:
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.
References:
Tableau Desktop Guide: Provides detailed instructions on managing data types, creating calculated fields, and updating parameters.
Tableau Data Shaping Techniques: Outlines effective methods for manipulating and structuring data for analysis.
This process will ensure the data in the "US Population Estimates" is accurately shaped according to the specified format and that the total number of records is correctly calculated and entered into the designated parameter. This thorough approach ensures data integrity and accuracy in reporting.

The Workbook Optimizer is a tool specifically designed to evaluate a workbook against performance best practices. It provides feedback on key design characteristics and offers concrete guidance on how to improve workbook performance. This tool is beneficial for both new and experienced Tableau users to ensure their dashboards are optimized for performance1.
References: The Workbook Optimizer's functionality is detailed in Tableau's official documentation, which explains how it assesses workbooks against a set of rules derived from best practices1. Additionally, the Performance Recording feature in Tableau Desktop and Server can be used to identify performance issues, but the Workbook Optimizer gives a more comprehensive analysis of the workbook's adherence to best practices23.