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
Cognos 10.2 Tutorial - Creating a Report Template - Set-13 of 50 - Live ...
Cognos 10.2 Tutorial - Creating a Report Template - Set-13 of 50 - Live Project
Cognos 10.2 Tutorial - Dashboard Interactivity - Set-16 of 50 - Live Project- CFO-1
Cognos 10.2 Tutorial - Formatting the Dashboard - Set-15 of 50 - Live Project- CFO-1
Cognos 10.2 Tutorial - Creating a Dashboard - Set-14 of 50 - Live Project- CFO-1
Cognos 10.2 Tutorial - Creating a Report Template - Set-13 of 50 - Live Project
Cognos 10.2 Tutorial - SnowFlake Schema in Framework Manager - Set-12 of 50 - Live Project
Cognos 10.2 Tutorial - Set-11 of 50 - Publishing a Package - Live Project
Cognos 10.2 Tutorial - Set-10 of 50 - Creating Model Query Subjects - Live Project
Cognos 10.2 Tutorial - Set-9 of 50 - Star Schema in Framework Manager - Live Project
Cognos 10.2 Tutorial - Set-8 of 50 - Usage Properties in Framework Manager - Live Project
Cognos 10.2 Tutorial - Set-7 of 50 - Framework Manager Model - Live Project
Cognos 10.2 Tutorial - Set-6 of 50 - Creating Datasource - Live Project
Cognos 10.2 Tutorial - Set-5 of 50 - Star Schema - Live Project
Cognos 10.2 Live Practical Project Implementation demo, Star Schema, Framework Manager, Dynamic Cubes, Transformer Cubes, Relational Model (RMR), Dimensional Model (DMR)
Cognos 10.2 Tutorial - Dashboard Interactivity - Set-16 of 50 - Live Project- CFO-1
Cognos 10.2 Tutorial - Formatting the Dashboard - Set-15 of 50 - Live Project- CFO-1
Cognos 10.2 Tutorial - Creating a Dashboard - Set-14 of 50 - Live Project- CFO-1
Cognos 10.2 Tutorial - Creating a Report Template - Set-13 of 50 - Live Project
Cognos 10.2 Tutorial - SnowFlake Schema in Framework Manager - Set-12 of 50 - Live Project
Cognos 10.2 Tutorial - Set-11 of 50 - Publishing a Package - Live Project
Cognos 10.2 Tutorial - Set-10 of 50 - Creating Model Query Subjects - Live Project
Cognos 10.2 Tutorial - Set-9 of 50 - Star Schema in Framework Manager - Live Project
Cognos 10.2 Tutorial - Set-8 of 50 - Usage Properties in Framework Manager - Live Project
Cognos 10.2 Tutorial - Set-7 of 50 - Framework Manager Model - Live Project
Cognos 10.2 Tutorial - Set-6 of 50 - Creating Datasource - Live Project
Cognos 10.2 Tutorial - Set-5 of 50 - Star Schema - Live Project
Cognos 10.2 Live Practical Project Implementation demo, Star Schema, Framework Manager, Dynamic Cubes, Transformer Cubes, Relational Model (RMR), Dimensional Model (DMR)
Monday, May 9, 2016
Sunday, May 8, 2016
Tableau - Do it Yourself Tutorial - Parameters - DIY -4a-of-50
Tableau - Do it Yourself Tutorial - Handling Parameters - DIY -4a-of-50
Tableau Training for Beginners
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 Tutorial - Handling Parameters - DIY -4-of-50
Use the data connection from the Video-1 of the Tableau DIY series
1- Open the saved TWB file - Tableau BDCS DIY.
2- Create a new Sheet, and rename it to DIY - Vid -4
3- Right Click Customer Country, and create a parameter -- "Pick Dimension"
4- Click on "Clear All" button to clear out all values.
5- Add two values - Country and Department.
6- Create a new calculated field "Show Dimension", and then use the if statement as shown.
if([Pick Dimension] = 'Country') then ([Customer Country])
else([Department])
end
7- Right click the parameter - and Show parameter control.
8- Add the calculated field "Show Dimension", and a measure Sales Amt.
9- Change the parameter, in the Show param control.
Hands on - DIY #8
1- Create a new Sheet, and rename it to DIY #8
2- Right Click Channel Type, and create a parameter.
3- Click on "Clear All" button to clear out all values.
4- Add three values - Channel Type, Sales Type and Department.
5- Create a new calculated field "Show Dimension-3", and then use the if statement as shown.
6- Right click the parameter - and Show parameter control.
7- Add the calculated field "Show Dimension-3", and a measure Sales Cost
8- Change the parameter, in the Show param control.
Now Challenge Yourself......
Hands on - DIY #9
Do the exact same exercise as above, but for measures - Sales Amount and Sales Cost.
Create a parameter to Pick Measures.
Tableau Training for Beginners
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 Tutorial - Handling Parameters - DIY -4-of-50
Use the data connection from the Video-1 of the Tableau DIY series
1- Open the saved TWB file - Tableau BDCS DIY.
2- Create a new Sheet, and rename it to DIY - Vid -4
3- Right Click Customer Country, and create a parameter -- "Pick Dimension"
4- Click on "Clear All" button to clear out all values.
5- Add two values - Country and Department.
6- Create a new calculated field "Show Dimension", and then use the if statement as shown.
if([Pick Dimension] = 'Country') then ([Customer Country])
else([Department])
end
7- Right click the parameter - and Show parameter control.
8- Add the calculated field "Show Dimension", and a measure Sales Amt.
9- Change the parameter, in the Show param control.
Hands on - DIY #8
1- Create a new Sheet, and rename it to DIY #8
2- Right Click Channel Type, and create a parameter.
3- Click on "Clear All" button to clear out all values.
4- Add three values - Channel Type, Sales Type and Department.
5- Create a new calculated field "Show Dimension-3", and then use the if statement as shown.
6- Right click the parameter - and Show parameter control.
7- Add the calculated field "Show Dimension-3", and a measure Sales Cost
8- Change the parameter, in the Show param control.
Now Challenge Yourself......
Hands on - DIY #9
Do the exact same exercise as above, but for measures - Sales Amount and Sales Cost.
Create a parameter to Pick Measures.
Subscribe to:
Posts (Atom)