Saturday, May 28, 2016

Cognos 10.2 Tutorial - Creating Reports for Project - Set-17 of 50 - Liv...

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.



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.






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.





Sunday, May 15, 2016

Cognos 10.2 Tutorial - Dashboard Interactivity - Set-16 of 50 - Live Pro...

Cognos 10.2 Tutorial - Formatting the Dashboard - Set-15 of 50 - Live Pr...

Cognos 10.2 Tutorial - Creating a Dashboard - Set-14 of 50 - Live Projec...

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)

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.