Tableau 10 Business Intelligence Solutions - Volume 1

Data Preparation 7 lectures 38:14 The Course Overview This video provides an overview of the entire course. Using the Data Interpreter and Pivot The aim of this video is to prepare data using an interpreter and pivot. • Connect Tableau to the Excel file • Clean the file with Data interpreter • Pivot the fields and set filters Using schema.ini to Resolve Data Type Issues The aim of this video is to create a data file with fixed width lengths. • Save the file as schema.ini • Connect Tableau to the file • Explore the limitations of schema.ini Pivoting Columns The aim of this video is to prepare a data set on the population of people. • Make selections on the downloaded file • Connect the text file as a new data source • Pivot the age group column Using Union The aim of this video is to combine comma separated values to a new dataset. • Download the CSV version of all the files • Add the files to a union window • Append the data using the union operator Using Join The aim of this video is to combine fields of two separate Excel worksheets into one. • Add both files to a data connection window • Link both files using Join • Learn how it works Using Blend The aim of this video is to combine a text file with an excel file. • Add the txt file as a data source • Switch the data source to excel file • Take a look at some examples and know how it works Data Preparation 7 lectures 38:14 The Course Overview This video provides an overview of the entire course. Using the Data Interpreter and Pivot The aim of this video is to prepare data using an interpreter and pivot. • Connect Tableau to the Excel file • Clean the file with Data interpreter • Pivot the fields and set filters Using schema.ini to Resolve Data Type Issues The aim of this video is to create a data file with fixed width lengths. • Save the file as schema.ini • Connect Tableau to the file • Explore the limitations of schema.ini Pivoting Columns The aim of this video is to prepare a data set on the population of people. • Make selections on the downloaded file • Connect the text file as a new data source • Pivot the age group column Using Union The aim of this video is to combine comma separated values to a new dataset. • Download the CSV version of all the files • Add the files to a union window • Append the data using the union operator Using Join The aim of this video is to combine fields of two separate Excel worksheets into one. • Add both files to a data connection window • Link both files using Join • Learn how it works Using Blend The aim of this video is to combine a text file with an excel file. • Add the txt file as a data source • Switch the data source to excel file • Take a look at some examples and know how it works The Course Overview This video provides an overview of the entire course. The Course Overview This video provides an overview of the entire course. The Course Overview This video provides an overview of the entire course. The Course Overview This video provides an overview of the entire course. This video provides an overview of the entire course. This video provides an overview of the entire course. Using the Data Interpreter and Pivot The aim of this video is to prepare data using an interpreter and pivot. • Connect Tableau to the Excel file • Clean the file with Data interpreter • Pivot the fields and set filters Using the Data Interpreter and Pivot The aim of this video is to prepare data using an interpreter and pivot. • Connect Tableau to the Excel file • Clean the file with Data interpreter • Pivot the fields and set filters Using the Data Interpreter and Pivot The aim of this video is to prepare data using an interpreter and pivot. • Connect Tableau to the Excel file • Clean the file with Data interpreter • Pivot the fields and set filters Using the Data Interpreter and Pivot The aim of this video is to prepare data using an interpreter and pivot. • Connect Tableau to the Excel file • Clean the file with Data interpreter • Pivot the fields and set filters The aim of this video is to prepare data using an interpreter and pivot. • Connect Tableau to the Excel file • Clean the file with Data interpreter • Pivot the fields and set filters The aim of this video is to prepare data using an interpreter and pivot. • Connect Tableau to the Excel file • Clean the file with Data interpreter • Pivot the fields and set filters Using schema.ini to Resolve Data Type Issues The aim of this video is to create a data file with fixed width lengths. • Save the file as schema.ini • Connect Tableau to the file • Explore the limitations of schema.ini Using schema.ini to Resolve Data Type Issues The aim of this video is to create a data file with fixed width lengths. • Save the file as schema.ini • Connect Tableau to the file • Explore the limitations of schema.ini Using schema.ini to Resolve Data Type Issues The aim of this video is to create a data file with fixed width lengths. • Save the file as schema.ini • Connect Tableau to the file • Explore the limitations of schema.ini Using schema.ini to Resolve Data Type Issues The aim of this video is to create a data file with fixed width lengths. • Save the file as schema.ini • Connect Tableau to the file • Explore the limitations of schema.ini The aim of this video is to create a data file with fixed width lengths. • Save the file as schema.ini • Connect Tableau to the file • Explore the limitations of schema.ini The aim of this video is to create a data file with fixed width lengths. • Save the file as schema.ini • Connect Tableau to the file • Explore the limitations of schema.ini Pivoting Columns The aim of this video is to prepare a data set on the population of people. • Make selections on the downloaded file • Connect the text file as a new data source • Pivot the age group column Pivoting Columns The aim of this video is to prepare a data set on the population of people. • Make selections on the downloaded file • Connect the text file as a new data source • Pivot the age group column Pivoting Columns The aim of this video is to prepare a data set on the population of people. • Make selections on the downloaded file • Connect the text file as a new data source • Pivot the age group column Pivoting Columns The aim of this video is to prepare a data set on the population of people. • Make selections on the downloaded file • Connect the text file as a new data source • Pivot the age group column The aim of this video is to prepare a data set on the population of people. • Make selections on the downloaded file • Connect the text file as a new data source • Pivot the age group column The aim of this video is to prepare a data set on the population of people. • Make selections on the downloaded file • Connect the text file as a new data source • Pivot the age group column Using Union The aim of this video is to combine comma separated values to a new dataset. • Download the CSV version of all the files • Add the files to a union window • Append the data using the union operator Using Union The aim of this video is to combine comma separated values to a new dataset. • Download the CSV version of all the files • Add the files to a union window • Append the data using the union operator Using Union The aim of this video is to combine comma separated values to a new dataset. • Download the CSV version of all the files • Add the files to a union window • Append the data using the union operator Using Union The aim of this video is to combine comma separated values to a new dataset. • Download the CSV version of all the files • Add the files to a union window • Append the data using the union operator The aim of this video is to combine comma separated values to a new dataset. • Download the CSV version of all the files • Add the files to a union window • Append the data using the union operator The aim of this video is to combine comma separated values to a new dataset. • Download the CSV version of all the files • Add the files to a union window • Append the data using the union operator Using Join The aim of this video is to combine fields of two separate Excel worksheets into one. • Add both files to a data connection window • Link both files using Join • Learn how it works Using Join The aim of this video is to combine fields of two separate Excel worksheets into one. • Add both files to a data connection window • Link both files using Join • Learn how it works Using Join The aim of this video is to combine fields of two separate Excel worksheets into one. • Add both files to a data connection window • Link both files using Join • Learn how it works Using Join The aim of this video is to combine fields of two separate Excel worksheets into one. • Add both files to a data connection window • Link both files using Join • Learn how it works The aim of this video is to combine fields of two separate Excel worksheets into one. • Add both files to a data connection window • Link both files using Join • Learn how it works The aim of this video is to combine fields of two separate Excel worksheets into one. • Add both files to a data connection window • Link both files using Join • Learn how it works Using Blend The aim of this video is to combine a text file with an excel file. • Add the txt file as a data source • Switch the data source to excel file • Take a look at some examples and know how it works Using Blend The aim of this video is to combine a text file with an excel file. • Add the txt file as a data source • Switch the data source to excel file • Take a look at some examples and know how it works Using Blend The aim of this video is to combine a text file with an excel file. • Add the txt file as a data source • Switch the data source to excel file • Take a look at some examples and know how it works Using Blend The aim of this video is to combine a text file with an excel file. • Add the txt file as a data source • Switch the data source to excel file • Take a look at some examples and know how it works The aim of this video is to combine a text file with an excel file. • Add the txt file as a data source • Switch the data source to excel file • Take a look at some examples and know how it works The aim of this video is to combine a text file with an excel file. • Add the txt file as a data source • Switch the data source to excel file • Take a look at some examples and know how it works Basic Charts. 12 lectures 01:01:31 Creating a Bar Chart The aim of this video is to show the data using a bar chart. • Connect to the data source • Drag the data to rows and columns • Sort in descending order with different colors Creating a Stacked Bar Chart The aim of this video is to show the data using Stacked bar chart. • Open the Stacked bar worksheet In tableau • Drop a discrete field on to a formatting card • Create color partitions using Genre Creating a Line Chart The aim of this video is to demonstrate a line series graph. • Connect the master table to data source • Drag the data of Began and the number of records to rows and columns • Annotate your marks Creating a Scatter Plot The aim of this video is to determine the correlation between earnings and value of endorsements of a player using scatter plot. • Connect to the data source • Add dimensions in the Marks card • Use the data highlighter feature Creating a Heat Map The aim of this video is to showcase the data of floods using a heat map. • Identify the dimensions and place them into rows and Columns • Use the feature for a finite color to be used in the grid • Annotate and Mark the column with the darkest color to distinguish between the data Creating a Text Table (Crosstab) The aim of this video is to display a data of the top 20 movies using a text table. • Set the number format • Identify the dimensions and place them into rows and Columns • Add the Audience Score percentage and Profitability to the text table Creating a Highlight Table The aim of this video is to create a highlighted text table displaying the data of a film's worldwide gross amount. • Create a text table • Drag the data to Color in the Marks card • Edit the title by choosing a color for the text to display the data Creating an Area Chart The aim of this video is to create an area chart to display the results of restaurants re-inspection strong The aim of this video is to display a data of the top 20 movies using a text...