Tableau に関するその他の情報

Are you as Tableau-smart as a Tableau consultant?

I joined Tableau in September 2013 as a product consultant. We PCs are Tableau experts. We help with all things product-related, from technical sales to internal support and training, to content development. Basically, if you have a problem in Tableau, you get help from a PC.

So how did I become a Tableau expert after graduating with a degree in Environmental Science and Studio Art? How did I go from possessing weak Excel skills to writing advanced calculations and nested LOD Expressions?

It started with solving customer challenges. In the beginning, they were easy:

“How do I connect to my data?”

And then I had to solve slightly more difficult problems like this one:

“I want to highlight all of the weeks that have sales above a threshold and then for all of the weeks above the threshold label the last week in a row with the total amount of sales above the threshold in the consecutive series.”

Every time I solved a customer challenge like the one above, I would document the solution so that I could reference it in the future. Eventually I had built a library of practical solutions that I could use to easily answer any Tableau question.

Solving these customer challenges proved to be the most effective way of learning Tableau. I noticed that this was not just true for me, but for all of the PCs around me. So I turned my library of Tableau solutions into a library of Tableau challenges. I called this the challenge workbook.

Every new PC starts working through the challenge workbook on the first day. The goal is to become an expert before ever getting on a customer call. This works so well for us internally that I thought it would only be fair to share with our community! So without further ado, I present to you the Tableau challenge workbook, which I first shared with TC15 attendees earlier this week:

こちらもご覧ください

コメント

The viz is not meant to be downloaded. The workflow is as follows:
1. Select a challenge on the left
2. Read the description
3. Download the challenge on the bottom to try for yourself.

If the images are not rendering when you click the challenge try a different browser. I know that IE and Chrome both work. Chrome works best.
If you are getting errors using other browsers please let me know which they are so that I can make a note of this in the viz.

When I download a challenge, I receive a pop up that it does not exist on Tableau public so cannot be opened. However, I see it on your Tableau Public profile. Anyone else remedy this issue? Tried in IE, Chrome, and a few other things..

Despite the words of caution, but eager to get my hands on the workbooks, I tried using FireFox to download the workbooks and it works well (but not like you'd expect). Just click the link of the challenge, hit the Challenge-button at the bottom of the workbook. Now comes the trick... click with your right mouse button in the frame with the gobbledygook, select 'This frame »' and download using 'Save Frame As'. Workbook is now downloaded as .twbx.

The Intermediate > Time Series Realignment is rather interesting as in real life i wonder how it may be applied to offset start dates to same date.
Resolution time: ~12 minutes (5 minutes to think about a solution, 3 minutes to get the table calculation(s) right)
Solution uploaded to Tableau Public: https://public.tableau.com/profile/ojoswi#!/vizhome/timeseriesalignment/TimeSeries

I was working on the Market Basket challenge and came across an issue (using 9.2, 9.3 & 10.0 versions). I'm not able to add the <> join for the sub-category join. Does anyone else have/know of this issue? I'm going to try and work this by using a calc instead, but was curious.

I came across this webpage today and I am not able to solve the first question itself.
"Fix the x-axis so that the end never goes below 20% regardless of the size of the bars, but will expand larger when the bars are above 20%."