 Hello, a very warm welcome to a session on design flow, data types and data terminologies in Tableau. This is Dr. Anita Pujar, professor in computer science and engineering department of wall chain Institute of Technology, SolarPort. Now let's see the outcome of this video. At the end of this session, learners are able to demonstrate the design flow of Tableau, data types used in Tableau and data terminologies used in Tableau. Now let's start with the design flow, Tableau starts with connecting to a data source, building the data views, enhance the data views, create and organize the dashboards and finally create a story. Now let's start with the design flow. It starts with connecting to a data source, Tableau can connect to all popular data sources such as relational databases, SQL sources, cloud databases, simple text files, PDF files and save data sources also. Next Tableau builds data views that is after connecting to the data source, it gets all the columns and the data available in the Tableau environment, then it categorizes the fields as dimensions and measures, decides the hierarchies and builds the views. Next enhance the views. The views created may need further enhancement by applying aggregations, filters, formatting of colors and borders etc. Then create the worksheets, that is create different worksheets for different views on the same data. Create and organize dashboards, dashboards contains multiple linked worksheets, any change in the worksheets can change the content in the dashboard. Finally create a story. A story is a sheet that contains a sequence of worksheets that work together to convey information. That is stories convey the facts, how they are connected and provide the context. Now let's see some of the data types supported in Tableau. Tableau classifies all the data into one of the four types, that is string, number, boolean and datetime. Now let's see these data types one by one. Let's start with boolean data type. Boolean data types as you know has only two values that is true and false. Then date, date data type is supported by Tableau in almost all formats. If you want to force a Tableau to consider a string as a date, then you have to prefix a hash symbol to the data. Then datetime, that is this consists of date followed by time, time being in the format of hours, minutes and seconds. Tableau also supports geographical values, that is geographical data, that is geographical values consist of the mapping of the locations to their latitude and longitudinal values. String it is a sequence of zero or more characters included in the quotes. Number this format supports integers as well as floating point numbers, but floating point numbers have to be rounded up before using in mathematical equations. Now let's go to this tool in the Tableau, a very popular tool for creating the different analysis that is show me. It is an advanced data visualization tool. It can apply views such as pie charts, scatter plot, line chart to the existing data in the worksheet without writing any custom code. Show me can be used to visually analyze the relation between two fields or even multiple fields. It helps to analyze the two fields or multiple fields. So show me has the following options, text table, heat map, highlight table, a very popular horizontal bar chart, then filled map, pie chart and symbol map. We'll be studying all these options in the next video in detail, but we'll see how show me is seen in the screen. So you can find that this tool is seen on the right hand side of the screen. It has various options in it. Some of the options have been grayed out, which means these options cannot be used in this particular data set. Now let's go to some of the data terminologies used in Tableau. So we'll start with alias. As you already know alias is an alternative name that can be assigned to fields or dimension members. BIN, it is a user defined grouping of measures in the data source, bookmark. It is a file with extension dot TBM in the bookmarks folder in Tableau repository. Now this file, it is very similar to the web browser bookmark. It helps to quickly display the different analysis. Calculated field, again you are familiar with this. This is a new field that is generated by applying the mathematical formula on the existing fields. Cross-tap, it is a text table view. This cross-tap is helpful in displaying the associated values with the dimension members. Dashboard, it is a collection of multiple views laid out on a single page. Dashboards help to compare and monitor a variety of data immediately. Data pane, it occurs on the left side of the worksheet. This pane consists of the data fields of the data source that is connected to the Tableau. All the data fields are listed on the, on in this pane and they are categorized as dimensions and measures. Dimensions and measures can be dragged and dropped onto various shelves to create the views. Data pane also consists of customized fields such as your newly calculated fields, groups or bind fields. Data source page, it is a page where the data source is laid out. It consists of four areas that is the left pane, join area, preview area and metadata area. Extract, it is a saved subset of a data source. It is used offline to analyze and improve the performance. Data can be created by defining filters and limits on the data in the data source so that it will include only that data that is required into the extract to perform the analysis. Filter shelf, again this is on the left side of your worksheet. Filter shelf, into this you can drag the dimensions and measures to filter out the data from the view. Format pane, format pane consists of various settings for controlling the formatting options of an worksheet or the individual fields. Level of detail expression, it is a syntax that supports aggregate expression. Level of detail can be used to attach one or dimension members to this aggregate expression. Marks, it is a part of view which consists of one or more rows of data source. Using this marks, we can apply the type, format, color and everything to the marks fields. Marks can be for example line, bar or square. Marks card, it is a card which forms a part of the view which is on the left side of the view. You can drag the dimensions or measures into the marks card to control their colors, format, shape, levels of detail and so on. Row shelf, it occurs on the top of the worksheet. Row shelf are used to create the rows in the data table. Dimensions and measures can be dragged and dropped into this row shelf. When you drag the dimensions, row shelf automatically creates the headers for these dimensions. When you drag and drop the measures into the row shelf, it will create quantitative access for these measures. So shelves are nothing but the named areas that occur on the left of the worksheet or onto the left of the worksheet or on the top of the worksheet which are used to create the views by dragging and dropping the dimensions and measures onto these shelves. Workbook, it is a file with extension dot TWB in the tableau repository. It consists of multiple worksheets, possibly including dashboards as well as stories. Worksheet, it provides the, it is used to build the data views on the data in the data source. The formatting of the worksheets can be controlled by using a format pane. Now let's see some of the terminologies on this screenshot. On the left side, you can see the data source pane where there is a list of dimensions and measures. On the top, you can see the row shelves and again the various pages shelf. There are marks onto this where which is used to control the formatting of the individual fields and on the bottom there is a collection of the worksheets together forming a workbook and so on. Now let's pause the video, think and write. Shelves are the named areas to the left and top of the view which help to build or enhance the views. So is it sets, dimensions, measures or shelves? So answer to this question is shelves. Because shelves are the named areas that occur on the left or on the top of the view and they help to build or enhance the views by dragging and dropping the required dimensions and measures onto these shelves. These are some of the references that are used for creating these videos. Thank you.