Friday, June 24, 2016
Saturday, June 11, 2016
Tableau - Do it yourself - Tutorials
Tableau Do it yourself Tutorial - Full playlist here
| Sr.No | Topic /Content | URL |
| 1 | Tableau Architecture | https://youtu.be/h_9ErR39bYc |
| 2 | Getting Started | https://youtu.be/1BLywLrQUcE |
| 3 | Creating Sets and Calculations | https://youtu.be/KNx_rXXLQRo |
| 4 | Top N Analysis & Sorting | https://youtu.be/PkgrcY-Vzoo |
| 5 | Creating Parameters | https://youtu.be/aclMW-Gjwf0 |
| 6 | Creating Parameters - contd | https://youtu.be/0YO0JLCyz_g |
| 7 | Dynamic Calculations | https://youtu.be/PqZyMRvK20c |
| 8 | Histograms using Bins | https://youtu.be/yvkwQLy87BQ |
| 9 | Heat Maps | https://youtu.be/YDt7LWRj3DA |
| 10 | Tree Maps | https://youtu.be/ViOxCBIiWKE |
| 11 | Waterfall Charts | https://youtu.be/aj8I59mOjkk |
| 12 | Word Cloud & Bubble Charts | https://youtu.be/OmqXEGoYiPs |
| 13 | Pareto Charts | https://youtu.be/JDRKnm1epII |
| 14 | Reference Lines, Bands, & Box | https://youtu.be/eZQi7Abdhdw |
| 15 | Dual Axis & Multiple measures rendering | https://youtu.be/AOwmKp1bEjk |
| 16 | Window Functions | https://youtu.be/UecpQphMq0E |
| 17 | the Playback Functionality | https://youtu.be/dZzp4dLctgM |
| 18 | Working with Maps | https://youtu.be/bTmF-jZvVJ8 |
| 19 | Plotting Shapes on Maps | https://youtu.be/eWqtebEYzNc |
| 20 | Custom Geocoding | |
| 21 | Creating Dashboards | https://youtu.be/Rt6r5vm1Gk4 |
| 22 | Dashboard Interactivity | https://youtu.be/jzeTNJUMDnQ |
| 23 | Creating Stories | https://youtu.be/CfQMjXaCOuM |
| 24 | Intro to Tableau Extract files | https://youtu.be/_k1JB6RSa8Q |
| 25 | Publishing to Tableau Public | https://youtu.be/6EYqzaTcmkM |
| 26 | Publishing to Tableau Online | https://youtu.be/Yct_2p-3YIk |
| 27 | Tableau Online Navigation | https://youtu.be/kYdochl8D6E |
| 28 | Concept of Calculations | https://youtu.be/xvcHo2DFCXw |
| 29 | LOD Calculations | https://youtu.be/ZJzbdRe-WiA |
| 30 | Table Calculations | https://youtu.be/yb5XNLbF_1M |
| 31 | Database Connections | https://youtu.be/Y2wtG3cjTLw |
| 32 | Automated Forecasting | https://youtu.be/IsA4xE3c7HI |
| 33 | More on Calculations | https://youtu.be/ae4nT2nFVw8 |
| 34 | Date Calculations | https://youtu.be/1h6y6gXMT4U |
| 35 | Refresh Extracts using Command line | https://youtu.be/FuDX1u9QSb8 |
| 36 | Data Blending | https://youtu.be/k6yGzHDOA5I |
| 37 | Creating Joins & Unions | |
| 38 | Editing Metadata |
Friday, June 10, 2016
Saturday, June 4, 2016
Thursday, June 2, 2016
Tableau Free Training - Do it yourself - Study Circle
Details:
To enroll - just send an email to bharati.dwconsultancy@gmail.com
#1) Here's the link:
https://www.youtube.com/watch?v=BY42DWd6L94
#2) Fees - $0 …. Yes, absolutely no cost. No Hidden costs.
#3) Duration: 14 Day course. Daily 1-2 hrs. Complete the course at your own pace.
#4) This is an email based course. You will receive daily emails with content, and exercises each day, which will continue for 14 days, describes activities to be done for each day.
#5) At the end of the course take an online exam, and receive a course completion certificate by Bharati DW Consultancy.
#6) Just invest and dedicate some effort and time, and we look to provide directions.
#7) Attend online session - a) Introduction session & b) 1 or 2 doubt clearing sessions.
#8) A new Facebook group will be created to create a Tableau Study circle.
--
To enroll - just send an email to bharati.dwconsultancy@gmail.com
#1) Here's the link:
https://www.youtube.com/watch?v=BY42DWd6L94
#2) Fees - $0 …. Yes, absolutely no cost. No Hidden costs.
#3) Duration: 14 Day course. Daily 1-2 hrs. Complete the course at your own pace.
#4) This is an email based course. You will receive daily emails with content, and exercises each day, which will continue for 14 days, describes activities to be done for each day.
#5) At the end of the course take an online exam, and receive a course completion certificate by Bharati DW Consultancy.
#6) Just invest and dedicate some effort and time, and we look to provide directions.
#7) Attend online session - a) Introduction session & b) 1 or 2 doubt clearing sessions.
#8) A new Facebook group will be created to create a Tableau Study circle.
--
Thanks!!
Bharati DW Consultancy
cell: +1-562-646-6746
website: http://www.bharaticonsultancy.in
Twitter: @BharatDWCons
Youtube: BharatiDWConsultancy
Whatsapp: +1-562-646-6746 (+1-56-COGNOS-46)
Wednesday, June 1, 2016
Tableau - Do it Yourself Tutorial - Window Functions - DIY -14-of-50
Tableau - Do it Yourself(DIY) Tutorial - Window Functions - DIY -14-of-50
In this video, we will see how to create visualizations with Window Functions.
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 - 14
4- Drag and drop the Country and the Location dimensions in the rows shelf.
5- Next, drag and drop the Sales Cost to the Marks-text area.
6- From the Analysis menu, create a calculated field, Calc_Window_Func
7- Type the following function - WINDOW_SUM (SUM( [Sales Cost]), -1, 1).
WINDOW_AVG (SUM( [Sales Cost]), -1, 1).
8- Drag and drop that Calc_Window_Func to the sheet.
9- Let's do the following Hands-on exercises.
Hands on - DIY #24
1- Add a new sheet.
2- Drag and drop the Department, and item Category dimensions to the columns shelf area.
3- Create two new calculations for the Windows function, to calculate windows sum for 6 months, using the Sales Amount and Profit/Loss measures.
4- Use WINDOW_SUM (SUM( [Sales Amount]), -6, 6), and WINDOW_SUM (SUM( [Profit/Loss]), -6, 6)
5- Add Profit/Loss measure to Mark-color area.
Hands on - DIY #25
1- Add a new sheet.
2- Drag and drop the Channel Type, and Employee Country dimensions to the columns shelf area.
3- Now, use the window functions calculations, created in the above steps WINDOW_SUM (SUM( [Sales Amount]), -6, 6), and WINDOW_SUM (SUM( [Profit/Loss]), -6, 6).
4- Create a dual axis chart.
Tableau - Do it Yourself Tutorial - Dual Axis & Multiple measures render...
Tableau - Do it Yourself(DIY) Tutorial - Dual Axis & Multiple measures rendering - DIY -13-of-50
In this video, we will see how to create a chart with multiple measures.
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 - 13
4- Drag and drop the Sale Date, and set the detail @Month.
5- Next, drag and drop the Sales Amount to the rows shelf.
6- From the show menu set the chart type to the line chart.
7- Next, drag and drop the Sales Cost measure to the rows shelf.
8- Click the Sales Cost, on the rows shelf, and select Dual Axis.
9- You can see that both the measures are displayed, as a part of one single chart.
Alright, now to some advance concepts.
10- Right click on the sheet name at the bottom, and select duplicate sheet.
11- Rename the new sheet as DIY - Vid - 13(b)
12- Remove Sales Cost measure.
13- Then click on Sales Amount, and Add Table Calculation.
14- Calculate the moving average of Sales Amount across the table, smoothed with 3 months before and after the date, and also including current value.
15- Let's do the following Hands on exercises.
Hands on - DIY #22
1- Add a new sheet.
2- Drag and drop the Department, and item Category dimensions to the columns shelf area.
3- Now, Drag and drop the Sales Cost and Profit/Loss measure to the row shelf area.
4- Select Dual Axis.
5- Add Profit/Loss measure to Mark-color area.
Hands on - DIY #23
1- Add a new sheet.
2- Drag and drop the Channel Type, and Employee Country dimensions to the columns shelf area.
3- Now, Drag and drop the Sales Cost measure to the row shelf area.
4- Then click on Sales Cost, and Add Table Calculation.
5- Calculate the moving average of Sales Cost across the table, smoothed with 1 month before and after the date, and also including current value.
Tableau - Do it Yourself Tutorial - Window Functions - DIY -14-of-50
In this video, we will see how to create visualizations with Window Functions.
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 - 14
4- Drag and drop the Country and the Location dimensions in the rows shelf.
5- Next, drag and drop the Sales Cost to the Marks-text area.
6- From the Analysis menu, create a calculated field, Calc_Window_Func
7- Type the following function - WINDOW_SUM (SUM( [Sales Cost]), -1, 1).
WINDOW_AVG (SUM( [Sales Cost]), -1, 1).
8- Drag and drop that Calc_Window_Func to the sheet.
9- Let's do the following Hands-on exercises.
Hands on - DIY #24
1- Add a new sheet.
2- Drag and drop the Department, and item Category dimensions to the columns shelf area.
3- Create two new calculations for the Windows function, to calculate windows sum for 6 months, using the Sales Amount and Profit/Loss measures.
4- Use WINDOW_SUM (SUM( [Sales Amount]), -6, 6), and WINDOW_SUM (SUM( [Profit/Loss]), -6, 6)
5- Add Profit/Loss measure to Mark-color area.
Hands on - DIY #25
1- Add a new sheet.
2- Drag and drop the Channel Type, and Employee Country dimensions to the columns shelf area.
3- Now, use the window functions calculations, created in the above steps WINDOW_SUM (SUM( [Sales Amount]), -6, 6), and WINDOW_SUM (SUM( [Profit/Loss]), -6, 6).
4- Create a dual axis chart.
Tableau - Do it Yourself Tutorial - Reference Lines, Bands,
Tableau - Do it Yourself Tutorial - Reference Lines, Bands, & Box - DIY -12-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 - Reference Lines, Bands, & Box - DIY -12-of-50
In this video, we will see how to create Reference Lines, Bands, & Boxes.
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 - 12
4- Drag and drop the Sale Date and department to the columns shelf area, and set the detail @Year.
5- Next, drag and drop the Sales Amount to the rows shelf.
6- From the show menu set the chart type to bar chart.
7- To add a reference line, right click on the Y-axis on the left side, and then select Add Reference Line.
8- Add a reference line to show the average of Sales Amount.
9- Add reference bands.
10- Do the following Hands on excercises.
Hands on - DIY #20
1- Add a new sheet.
2- Drag and drop the Department, and item Category dimensions to the columns shelf area.
3- Now, Drag and drop the Profit/Loss measure to the row shelf area.
4- Add a Reference Band.
5- Add Profit/Loss measure to Mark-color area.
Hands on - DIY #21
1- Add a new sheet.
2- Drag and drop the Channel Type, and Employee Country dimensions to the columns shelf area.
3- Now, Drag and drop the Sales Cost measure to the row shelf area.
4- Add a Reference Box.
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 - Reference Lines, Bands, & Box - DIY -12-of-50
In this video, we will see how to create Reference Lines, Bands, & Boxes.
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 - 12
4- Drag and drop the Sale Date and department to the columns shelf area, and set the detail @Year.
5- Next, drag and drop the Sales Amount to the rows shelf.
6- From the show menu set the chart type to bar chart.
7- To add a reference line, right click on the Y-axis on the left side, and then select Add Reference Line.
8- Add a reference line to show the average of Sales Amount.
9- Add reference bands.
10- Do the following Hands on excercises.
Hands on - DIY #20
1- Add a new sheet.
2- Drag and drop the Department, and item Category dimensions to the columns shelf area.
3- Now, Drag and drop the Profit/Loss measure to the row shelf area.
4- Add a Reference Band.
5- Add Profit/Loss measure to Mark-color area.
Hands on - DIY #21
1- Add a new sheet.
2- Drag and drop the Channel Type, and Employee Country dimensions to the columns shelf area.
3- Now, Drag and drop the Sales Cost measure to the row shelf area.
4- Add a Reference Box.
Subscribe to:
Posts (Atom)