Friday, June 24, 2016

Tableau - Do it Yourself Tutorial - Live Project for Understanding Imple...

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   

Tableau - Do it Yourself Tutorial - Plotting Shapes on Maps - DIY -17-of-50

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.

-- 
Thanks!!
Bharati DW Consultancy 
cell: +1-562-646-6746
Twitter: @BharatDWCons
Youtube: BharatiDWConsultancy
Whatsapp: +1-562-646-6746 (+1-56-COGNOS-46)

Cognos 10.2 Tutorial -Drill through-Pass ParamValue- Set-26 of 50-Live P...

Cognos 10.2 Tutorial - Cascade Prompts - Multi select - Set-25 of 50 - L...

Cognos 10 2 Tutorial Conditional Formatting Set 24 of 50 Live Proj...

Cognos 10.2 Tutorial - Creating mini dashboard - Set-23 of 50 - Live Pro...

Cognos 10.2 Tutorial - Drill through-build prompt page- Set-22 of 50-Liv...

Cognos 10.2 Tutorial - Master detail relationship - Set-21 of 50 - Live ...

Cognos 10.2 Tutorial - Creating a mini Dashboard - Set-20 of 50 - Live P...

Cognos 10.2 Tutorial - Creating Drill through - Set-19 of 50 - Live Proj...

Cognos 10.2 Tutorial - Creating Cascading prompts - Set-18 of 50 - Live ...

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.