Editing Metadata in Tableau

Last updated on Oct 25 2021
Ramnath Swami

Table of Contents

Editing Metadata in Tableau

After connecting with the data source, Tableau captures the metadata details of the source, such as the columns and their data types. This is used to create the measures, dimensions, and calculated fields used in views. You can browse the metadata and change their properties for some specific requirements.

Checking the Metadata

After connecting with a data source all possible tables and columns will be displayed in the data source.
Example: The source ‘Sample Coffee Chain‘ for checking the metadata.
• Click the Data menu and select to connect with a data source. Browse for the MS access file named as ‘Sample Coffee chain.’
• Drag the table which is named Product, to the data canvas.
• After choosing the file, you will get the below-given screen that shows the column names, and their data types. In Tableau, the string data types are shown as “Abc,” and Numeric data types are shown as “#.”

tableau 49
tableau

Changing the Data Type

You can change the data type for some of the fields (if required). Depending on the nature of the source data, sometimes Tableau may fail in recognizing the data type from the data source. In this structure, you can manually edit the data type. The below screenshot shows the options.

tableau 50
tableau

Renaming and Hiding

You can change the column names by using the renaming option. You can also hide a column, after that it will not appear in the data view. All these options are available after clicking on the data type icon in the metadata grid, you can see in the below screenshot.

tableau 51
tableau

Column Alias

Each column of the data source is assigned as aliases, which helps in better understanding the nature of the column.

tableau 52
tableau

Choose the aliases option from the above figure, and a screen comes up, which is used to Edit or Create the aliases.

tableau 53
tableau

Click on the OK button, and after that, you can see the changes in the column of the data sources.

tableau 54
tableau

So, this brings us to the end of blog. This Tecklearn ‘Editing Metadata in Tableau’ blog helps you with commonly asked questions if you are looking out for a job in Tableau Desktop. If you wish to learn Tableau Desktop and build a career in Business Intelligence domain, then check out our interactive, Tableau Desktop Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

Tableau Desktop

Tableau Desktop Training

About the Course

Tecklearn’s Tableau Desktop Training teach you how to transform raw data into interactive and shareable dashboards using Tableau. Our Tableau Course covers the necessary analytical skills to Advanced data visualizations by incorporating real-world use-case scenarios, labs, and exercises. Some of the topics included are Data Blending, Data Mapping, Graphs, creation of charts, and LOD expression by using different versions of Tableau, such as Tableau Desktop, Tableau Reader, and Tableau Public.

Why Should you take Tableau Desktop Training?

• The average salary of a Tableau Professional ranges between $108,697 to $158,000 per annum -Indeed.com.
• Tableau has been positioned as a Leader in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms – Gartner.com.
• Fidelity Investments, Capgemini, EY, Deloitte, EY, JP Morgan, Verizon, Facebook, Dell, General Motors, KPMG, Bank of America and 40,000 other MNCs worldwide across industries use Tableau.

What you will Learn in this Course?

Understanding Tableau
• Why Tableau
• Tableau Product Platforms
• Tableau Architecture
• Tableau Interface
Data Connection with Tableau Desktop
• Features of Tableau Desktop
• Connect to data from File and Database
• Types of Connections
• Data Blending
• Joins and Unions
• Tableau Desktop User Interface
• Basic project: Create a workbook and publish it on Tableau Online
Basic Visual Analytics
• Visual Analytics
• Basic Charts: Bar Chart, Line Chart, and Pie Chart
• Hierarchies
• Data Granularity
• Highlighting
• Sorting
• Filtering
• Grouping
• Sets
Advanced Visual Analytics
• Parameters
• Tool tips
• Trend lines
• Reference lines
• Forecasting
• Clustering
Calculations in Tableau
• Calculated Fields
• Numeric, String, Data, Logical, Addressing and Partitioning
• Table Calculations
Level of Detail (LOD’s) Calculations
Advanced Charts in Tableau
• Box and Whisker’s Plot
• Bullet Chart
• Bar in Bar Chart
• Gantt Chart
• Waterfall Chart
• Pareto Chart
• Control Chart
• Funnel Chart
• Bump Chart
Parameters
• What If Scenarios
• Parameter in CF (KPI control)
• Parameter in Filter (Top N)
• Parameter in reference line
Dashboards and Stories
• Introduction to Dashboards
• The Dashboard Interface
• Dashboard Objects
• Building a Dashboard
• Dashboard Layouts and Formatting
• Interactive Dashboards with actions
• Designing Dashboards for devices
• Story Points
Data Security in Tableau
Optimizations tips and tricks
Interacting with Tableau Server
Working with Tableau JavaScript API

Got a question for us? Please mention it in the comments section and we will get back to you.

0 responses on "Editing Metadata in Tableau"

Leave a Message

Your email address will not be published. Required fields are marked *