Pages

Do you feel that you are Tableau Expert? Then try this challenge 13

Using below data try to solve this challenge.

Using above data try to build below report.

In above report Opening Balance and Closing Balance are calculated columns in Tableau.

Opening Balance:

For 2015 Jan, user will provide Opening Balance using parameter which is shown in above image. For this scenario assume that Opening Balance for 2015 Jan is “1,000”.

Closing Balance:
Opening Balance + Deposit
Closing Balance of 2015 Jan will become Opening Balance for 2015 Feb.

Explanation:

For 2015 Jan:
Opening Balance is 1,000 (User Entered in Parameter)
Closing Balance = 1,000 (User Entered in Parameter) + 1,500 (Deposit) = 2,500

For 2015 Feb:
Opening Balance = 2,500 (which is Closing Balance of 2015 Jan)
Closing Balance = 2,500 (Opening Balance of 2015 Feb) + 2,000 (Deposit) = 4,500

So on…

Suppose if user enters Opening Balance as 5,000 in Parameter reports looks like below.

Finally, I would like to add month selection for this report. User will select month then it should show data only for that month.

More results based on user selection:

Do you feel that you are Tableau Expert? Then try this challenge 12

Using below data try to solve this challenge.

Below Image I am showing Year over year growth based on some rules. Please follow rules and try to solve this challenge.

Generally, Year over Year(YoY) growth calculated using below formula.
((Current Year Sales – Previous Year Sales) / Previous Year Sales) * 100

But I have some rules while calculating YoY Growth.

Note: we are computing data from left to right (means from 2016 to 2008) in above image.

Rule No 1:
If any year does not have sales, then YoY growth for following years should be NULL.

For example, in Central, 2016 does not have sales so 2016 onwards till 2008 there is no year over year growth.

Similarly, you can see South, 2014 onwards and West 2015 onwards YOY is empty.

Rule No 2:
While calculating YOY if there is not data for previous year then, you need to use before previous year data.

For example, in west region, 2016 we don’t have sales in 2015 so I took sales of 2014 and then calculated YoY.

((128-81) / 81) * 100 = 58%

If before to previous data is not there then you can display YoY as NULL for that year.

For Example, in south 2014 year, there is no sales in 2013 and at the same time there is no sales for 2012 also. So, YoY for 2014 is NULL.

See one more example below, Assume I have data till 2014. I just filtered above data for this example.

For Central 2014:
((157-180) / 180) *100 = -13%

For Central 2013:
((180 – 196) / 196) *100= -8% (According to Rule 2)

For Central 2012 onwards YoY is NULL (According to Rule 1)

Note: This is not very complex challenge. I just used only one calculation filed to display YoY. I am giving clue also. I used only 4 functions along with if statement. Out of four functions two functions that I used ISNULL and SUM.

Experiment… Observe… Learn…

Tableau Server 10 Videos

These video links are Tableau official videos. Just for quick access I am posting here. If you want to download related material for that video, please visit Tableau Software official website.

Collaborate with Tableau Online

Publish to Tableau Online

Manage Tableau Online

Security with Tableau Online

Collaborate with Tableau Server

Publish to Tableau Server

Deploy and Manage Tableau Server

Security with Tableau Server
If you find any of the above links are not working please send notification mail to suresh.n2008@gmail.com

Tableau Desktop 10 Videos

These video links are Tableau official videos. Just for quick access I am posting here. If you want to download related material for that video, please visit Tableau Software official website.

Getting Started

Connecting to Data

Visual Analytics

Dashboards and Stories

Mapping

Calculations

Why is Tableau Doing That?

How To
If you find any of the above links are not working please send notification mail to suresh.n2008@gmail.com

Do you feel that you are Tableau Expert? Then try this challenge 11

Using data shown in above table try to build chart which is shown below.
This chart builds using 1 dimension (Quarter) and 4 measures (Actual Sales, Target Sales, Actual Profit and Expected Profit).
For Sales I am showing, yellow color as Actual Sales and blue color as Target Sales. Or out side bar is Target sales where as inside bar is Actual Sales
For Profit I am showing, Red color as Actual Profit and Green color as Expected Profit. Or out side bar is Expected profit where as inside bar is Actual Profit.
Note: I did not use any data reshaping technique for this is chart. This chart builds only with 1 dimension and 4 measures.

Very interesting challenge. Try this.

Do you feel that you are Tableau Expert? Then try this challenge 10

Using above data which is shown in table, build below chart.

Do you feel that you are Tableau Expert? Then try this challenge 9

Here I am coming with real time challenge. Those who are interested can try this and test your knowledge.

Image 1

Image 2

Image 3

You can observe the above 3 images you will understand the challenge here.

I am showing report with category and Sum(Sales). User will select Dimension name from the “select dimension parameter”. Based on user selection, in next filter the values of that dimension will show.

For example see Image 1:
User selected region in “Select Dimension parameter”. Below to that parameter, user can able to see the Region dimension values.

Similarly for the Segment dimension also.

Now the challenge is how you will show Top 5 Product names by Sum(sales) in filter, when user selects “Top 5 Products by Sales” in Select dimension Parameter. If you perfectly archive this challenge, Numbers in 3 images should exactly match with your numbers. Use data set attached below this post.

Note: This challenge is implemented in a single sheet. I did not used dashboard or multiple sheets to get this challenge.

Participate in "Make India Proud Data" visualization Contest

Hi Everyone,

On the eve of 70th Indian Independence day, we are pleased to invite you to an exciting Tableau contest #‎MakeIndiaProud.

Let the world know the greatness of India by your Tableau skills. It’s the time to show your passion and profession. Be a proud Indian

Here you can find the roadmap of this contest:

Last date for the registration: August 13th 2016 9:00 AM IST

You can come up with any type of visualization which will show us, proud moments of India.
You can prepare your data by yourself or you can use below links to collect information.

Submit your workbook to our official Email ID:  makeindiaproud16@gmail.com on or before August 13th 2016 9:00 PM IST.

After that, we will publish all the workbooks to Tableau Public and the next process will get kick started.

Top 3 winners will decide by Tableau Ambassadors and community leaders. Winners will get a surprise gift which will help them to gain more insights in to Tableau.

Winners will be announced at Tableau Bangalore Meetup on Aug 27th 2016 (Tentative) organized by Tableau A2Z FB and Tableau Learners FB group.

Incredible India

Do you feel that you are Tableau Expert? Then try this challenge 8

Here I am coming with real time challenge. Those who are interested can try this and test your knowledge.

Here we go with challenge:

In above image I am showing New Customers, Retention Customers and % of Retention for each Segment.

This report contains two parameters (Year and Retention Gap).

Understanding Requirement:

For Consumer:

New Customers:
New Customers are 64 in 2012. So there are 64 new customers whose first purchase was in 2012.

Retention Customers:
Retention Customers are 46 for 1 year Retention Gap. Out of 64 New Customers, 46 customers are purchased again in 2013(because Retention Gap is 1 year).
If we select Retention Gap is 2 years then we have to find:
Out of 64 customers, how many customers are purchased again in 2014?

% of Retention:
(Retention Customers/New Customers) * 100

Please look at below images for more examples:

Example 1:

Example 2:

Example 3:

Note: Please download the Data from below link to solve this challenge. If you use this data result should match with above image.