Managing Metadata-Tableau

Managing metadata is the process where we can edit,change dimensions and measures

Create hierarchies, rename the dimensions and measures, group by folder and creating folder.

Fields can be hidden.
Rename by double click
create hierarchy
rearrage the order
create folders
right click and group by folders
collapse the folders
default datatype
default colours and edit the colors
measure right click default properties ...u can see options like agrregations, hoverin over the field  shows the comment.
But in tableau online/server u cant edit the fields but u can extend the calculations. and adding calcualtion.

All this a part of data connections and changing the underlying data.

Finally if u want to change the data source then right click on the data source and see many options are there.



Comments

Post a Comment

Popular posts from this blog

Mysql

MySql: You deal with data every day… When you want to listen to your favorite songs, you open your playlist from your smartphone. In this case, the playlist is a database. When you take a photo and upload it to your account on a social network like Facebook, your photo gallery is a database. When you browse an e-commerce website to buy shoes, clothes, etc., you use the shopping cart database. Databases are everywhere. So what is a database?  By definition, a database is merely a structured collection of data. The data relate to each other by nature, e.g., a product belonged to a product category and associated with multiple tags. Therefore, we use the term  relational database . In the relational database, we model data like products, categories, tags, etc., using tables. A table contains columns and rows. It is like a spreadsheet. A table may relate to another table using a relationship, e.g., one-to-one and one-to-many relationships. Because we deal with ...
Read more

Multiple Insights through tableau

Image
Lets say what is data visualization?  Data can be visualized pictorial. ie pictorial view of the data through tableau software Tableau offers multiple insights of the business. Lets ask tableau a different questions for the business. Lets considers the retail store data where people are performing transactions and products are ordered and sold by category. This data is huge. Let analyse First connect tableau to the excel file through navigation window and pul the tables to the canvas region of the data source page. tableau automatically assigns join conditions. If the changs have to be made in the grid view. Make changes for changing data type,custom split. First row of the table is column header and it is broken down into dimensions and measures. Lets summarize the questions which we should ask tableau in different ways. 1.What is overall trend of profit and sales of the retail stores. 2.Performance of different regions 3.Profitable and non profitable regions 4. re...
Read more
Image
Ways to Distribute: Tableau Tableau varies in distribution that differs in interactivity,security and data freshness. Images and PDF are static they do not contain any underlying data which cannot be edited. That is, they are the snapshots taken at particular time. Workbooks packaged can used to share to others.  Tableau reader and Tableau desktop. Tableau reader where we can read and interact but cant be edited.Tableau desktop where we can read,interact and edit workbooks. Workbooks can be published to tableau online/server with security,full interactivity and schedule to have refresh. Packaged workbook contains the underlying data and non packaged workbook does not contain underlying data. For publishing views go to worksheet to Export image (legends,layout,title) options For publishing dashboards ..go to dashboard export image and same story publishing Workbooks can be published to tableau online /server with security, full interactivity and live to data...
Read more