Saturday, May 28, 2016
Thursday, May 26, 2016
Wednesday, May 25, 2016
Tableau - Do it Yourself Tutorial - Word Cloud
Tableau - Do it Yourself(DIY) Tutorial - Word Cloud & Bubble Charts - DIY -10-of-50
In this video, we will see how to create Word Cloud & Bubble Charts.
1- Open the saved TWB file - Tableau BDCS DIY.
2- Use the data connection from the Video-1 of the Tableau DIY series
3- Goto a new Sheet - DIY - Vid - 10 - WC (for Word Cloud)
4- Drag and drop the Customer dimension to the Marks - Label Area.
5- Next, drag and drop the Sales Amount to the Marks - Size area.
6- Create a new calculation here - name it as Profit/Loss, (Sales Amount - Sales Cost).
7- Now, drag the newly created column Profit/Loss in the Marks - Color area. If needed, change the Mark type back to Text.
8- Add the Country column in the filter area, and click on show filter.
9- Now, let's create a Bubble chart, on the similar lines - create a new Sheet - DIY - Vid - 10 - BC (for Bubble Chart)
10- Follow similar steps as we did for Word Cloud. But, Just change the Mark type back to Circle.
11- Do the following Hands on exercises.
Hands on - DIY #18
1- Add a new sheet.
2- Create a Word Cloud, and Bubble Chart for the following scenarios.
3- Use Item Name, Sales Quantity and Profit/Loss to create this visualization.
4- Add Item Category Filter, enable show filter.
In this video, we will see how to create Word Cloud & Bubble Charts.
1- Open the saved TWB file - Tableau BDCS DIY.
2- Use the data connection from the Video-1 of the Tableau DIY series
3- Goto a new Sheet - DIY - Vid - 10 - WC (for Word Cloud)
4- Drag and drop the Customer dimension to the Marks - Label Area.
5- Next, drag and drop the Sales Amount to the Marks - Size area.
6- Create a new calculation here - name it as Profit/Loss, (Sales Amount - Sales Cost).
7- Now, drag the newly created column Profit/Loss in the Marks - Color area. If needed, change the Mark type back to Text.
8- Add the Country column in the filter area, and click on show filter.
9- Now, let's create a Bubble chart, on the similar lines - create a new Sheet - DIY - Vid - 10 - BC (for Bubble Chart)
10- Follow similar steps as we did for Word Cloud. But, Just change the Mark type back to Circle.
11- Do the following Hands on exercises.
Hands on - DIY #18
1- Add a new sheet.
2- Create a Word Cloud, and Bubble Chart for the following scenarios.
3- Use Item Name, Sales Quantity and Profit/Loss to create this visualization.
4- Add Item Category Filter, enable show filter.
Tuesday, May 24, 2016
Saturday, May 21, 2016
Tableau - Do it Yourself Tutorial - Heat Maps - DIY -7-of-50
Tableau - Do it Yourself(DIY) Tutorial - Heat Maps - DIY -7-of-50
Use the data connection from the Video-1 of the Tableau DIY series
A Heat map is a graphical representation of a dataset, in which where the values are represented as colors.
In this video, we will see how to create a Dynamic Calculation.
1- Open the saved TWB file - Tableau BDCS DIY.
2- Use the data connection from the Video-1 of the Tableau DIY series
3- Goto a new Sheet.
4- Drag and drop the Sale Date dimension onto the columns shelf. Change the dimension interval to Month.
5- Now, Drag and drop the Country and Item Category dimensions to the rows shelf.
6- Drag and drop the Sales Cost to the Marks - Size area, set mark type to square.
7- Drag and drop the Sales Quantity to the Marks - color area.
8- Change the view to entire view.
9- Do the following Hands on exercises.
Hands on - DIY #13
1- Add a new sheet.
2- Drag and drop the Sale Date dimension onto the columns shelf. Change the dimension interval to Year.
3- Now, Drag and drop the Department and Pay Type dimensions to the rows shelf.
4- Drag and drop the Sales Amount to the Marks - Size area, set mark type to square.
5- Drag and drop the Sales Quantity to the Marks - color area.
6- Change the view to entire view.
Tableau - Do it Yourself Tutorial - Histograms using Bins - DIY -6-of-50
Tableau - Do it Yourself(DIY) Tutorial - Histograms using Bins - DIY -6-of-50
by
Bharati DW Consultancy
cell: +1-562-646-6746 - Cell & Whatsapp
email: info@bharaticonsultancy.in
bharati.dwconsultancy@gmail.com
website: http://bharaticonsultancy.in/
Tableau - Do it Yourself(DIY) Tutorial - Histograms using Bins - DIY -6-of-50
Use the data connection from the Video-1 of the Tableau DIY series
Histogram is a graph which consists of columns, whose area is proportional to the frequency of a variable or values of a column and whose width is equal to the class interval.
For creating Histograms, we will see how to create bins.
1- Open the saved TWB file - Tableau BDCS DIY.
2- Use the data connection from the Video-1 of the Tableau DIY series
3- Goto a new Sheet.
4- Create bins for Sales cost; right click on the Sales Cost measure, and select Create bins.
5- Now set the bin-size as 50. You can set it to per the requirement.
6- Drag and drop the bin, created in the previous step, to the columns shelf.
7- Drag and drop the Sales cost measure to the rows shelf.
Also, change the aggregation property of Sales cost to Count, right in the rows shelf.
8- Drag and drop the Country dimension to color.
9- Drag the sales cost in the label too.
10- Do the following Hands on exercises.
Hands on - DIY #11
1- Add a new sheet.
2- Create bins for Sales amount - size 100, and then drag these bins to the columns shelf.
3- Add Sales Amount in the row shelf, and change the aggregation property to count.
4- Add Channel Type in the rows shelf Marks.
5- Add the Department to the color area.
Hands on - DIY #12
1- Add a new sheet.
2- Create bins for Sales Quantity - size 10, and then drag these bins to the columns shelf.
3- Add Sales Quantity in the row shelf, and change the aggregation property to count.
4- Add Item Category in the rows shelf Marks.
5- Add the Pay Type to the color area.
6- Add Sales Quantity to the label area.
by
Bharati DW Consultancy
cell: +1-562-646-6746 - Cell & Whatsapp
email: info@bharaticonsultancy.in
bharati.dwconsultancy@gmail.com
website: http://bharaticonsultancy.in/
Tableau - Do it Yourself(DIY) Tutorial - Histograms using Bins - DIY -6-of-50
Use the data connection from the Video-1 of the Tableau DIY series
Histogram is a graph which consists of columns, whose area is proportional to the frequency of a variable or values of a column and whose width is equal to the class interval.
For creating Histograms, we will see how to create bins.
1- Open the saved TWB file - Tableau BDCS DIY.
2- Use the data connection from the Video-1 of the Tableau DIY series
3- Goto a new Sheet.
4- Create bins for Sales cost; right click on the Sales Cost measure, and select Create bins.
5- Now set the bin-size as 50. You can set it to per the requirement.
6- Drag and drop the bin, created in the previous step, to the columns shelf.
7- Drag and drop the Sales cost measure to the rows shelf.
Also, change the aggregation property of Sales cost to Count, right in the rows shelf.
8- Drag and drop the Country dimension to color.
9- Drag the sales cost in the label too.
10- Do the following Hands on exercises.
Hands on - DIY #11
1- Add a new sheet.
2- Create bins for Sales amount - size 100, and then drag these bins to the columns shelf.
3- Add Sales Amount in the row shelf, and change the aggregation property to count.
4- Add Channel Type in the rows shelf Marks.
5- Add the Department to the color area.
Hands on - DIY #12
1- Add a new sheet.
2- Create bins for Sales Quantity - size 10, and then drag these bins to the columns shelf.
3- Add Sales Quantity in the row shelf, and change the aggregation property to count.
4- Add Item Category in the rows shelf Marks.
5- Add the Pay Type to the color area.
6- Add Sales Quantity to the label area.
Tableau - Do it Yourself Tutorial - Dynamic Calculation - DIY -5-of-50
Tableau - Do it Yourself(DIY) Tutorial - Dynamic Calculation - DIY -5-of-50
by
Bharati DW Consultancy
cell: +1-562-646-6746 - Cell & Whatsapp
email: info@bharaticonsultancy.in
bharati.dwconsultancy@gmail.com
website: http://bharaticonsultancy.in/
Tableau - Do it Yourself(DIY) Tutorial - Dynamic Calculation - DIY -5-of-50
Use the data connection from the Video-1 of the Tableau DIY series
In this video, we will see how to create a Dynamic Calculation.
1- Open the saved TWB file - Tableau BDCS DIY.
2- Use the data connection from the Video-1 of the Tableau DIY series
3- Goto a new Sheet- DIY - Vid - 5
4- Right Click on the Employee Name from the left side, Create - Set for Employees, having Sales_Amt <2000.
Please use the the Condition tab to calculate the range for Sales Amt.
5- Similarly create another set for Employees, having Sales_Amt >4000.
6- Now goto the Analysis menu, and then create a calculated field with the name "Employee Sales Band".
Use the following formula:
If [SA<2k] then "Band <2k"
elseif [SA>4k] then "Band >4k"
else "Band 2k to 4k"
end
7- Add the Employee Location from the dimensions to the rows shelf.
8- Add Sales Amount in the column shelf.
9- Drag the newly created calculated field "Employee Sales Band" to Color.
10- Do the following Hands on exercises.
Hands on - DIY #10
1- Add a new sheet.
2- Create a set for Pay Type - for Sales Amount - ranges 0-10k, 10k-20k and over 20k.
3- Create a calculated field for "Pay Type Sales Band".
4- Add Sales Amount in the column shelf
5- Add Channel Type in the rows shelf.
6- Add the newly created calculation "Pay Type Sales Band" in the color section.
by
Bharati DW Consultancy
cell: +1-562-646-6746 - Cell & Whatsapp
email: info@bharaticonsultancy.in
bharati.dwconsultancy@gmail.com
website: http://bharaticonsultancy.in/
Tableau - Do it Yourself(DIY) Tutorial - Dynamic Calculation - DIY -5-of-50
Use the data connection from the Video-1 of the Tableau DIY series
In this video, we will see how to create a Dynamic Calculation.
1- Open the saved TWB file - Tableau BDCS DIY.
2- Use the data connection from the Video-1 of the Tableau DIY series
3- Goto a new Sheet- DIY - Vid - 5
4- Right Click on the Employee Name from the left side, Create - Set for Employees, having Sales_Amt <2000.
Please use the the Condition tab to calculate the range for Sales Amt.
5- Similarly create another set for Employees, having Sales_Amt >4000.
6- Now goto the Analysis menu, and then create a calculated field with the name "Employee Sales Band".
Use the following formula:
If [SA<2k] then "Band <2k"
elseif [SA>4k] then "Band >4k"
else "Band 2k to 4k"
end
7- Add the Employee Location from the dimensions to the rows shelf.
8- Add Sales Amount in the column shelf.
9- Drag the newly created calculated field "Employee Sales Band" to Color.
10- Do the following Hands on exercises.
Hands on - DIY #10
1- Add a new sheet.
2- Create a set for Pay Type - for Sales Amount - ranges 0-10k, 10k-20k and over 20k.
3- Create a calculated field for "Pay Type Sales Band".
4- Add Sales Amount in the column shelf
5- Add Channel Type in the rows shelf.
6- Add the newly created calculation "Pay Type Sales Band" in the color section.
Sunday, May 15, 2016
Subscribe to:
Posts (Atom)