Hello also to everybody back home, streaming this live or seeing this in the future.

同時，也向在國內觀看直播或將來看到直播的各位問好。

Starting with a short introduction, my name is Tore Levensen, I'm from Norway, the only Yeah, we have this one, but sorry about this.

首先做一個簡短的自我介紹，我叫托爾-萊文森，來自挪威。

I don't care too much about this.

我不太關心這個。

This is me.

這就是我。

So I'm a Tableau Jedi from Inmeta Consulting.

我是 Inmeta Consulting 公司的 Tableau 絕地武士。

I am a Tableau ambassador, and also I run the Norwegian Tableau user group.

我是 Tableau 大使，也是挪威 Tableau 用戶組的負責人。

I have a wife, I have two kids, and I have a cat named Cecil.

我有一個妻子，兩個孩子，還有一隻名叫塞西爾的貓。

Hi everyone.

大家好

My name is Heidi Kalbe, I'm an associate solution expert at Woodmark Consulting.

我叫 Heidi Kalbe，是 Woodmark Consulting 公司的助理解決方案專家。

We are one of the premier partners in Germany.

我們是德國最重要的合作伙伴之一。

So if you have any business in Germany, feel free to come talk to me.

是以，如果您在德國有任何業務，請隨時來找我談。

Also feel free to talk to me under any other circumstances.

也歡迎在任何其他情況下與我交談。

I am a Tableau ambassador in my fourth year, Tableau user group ambassador now, as I am a co-lead for Data Plus Women Germany and Rheinland Tableau user group also in Germany.

我擔任 Tableau 大使已經第四年了，現在是 Tableau 用戶組大使，因為我是德國 Data Plus Women 和德國萊茵州 Tableau 用戶組的共同負責人。

So feel free to connect.

請隨時聯繫我們。

A nice welcome also from my side.

我也表示熱烈歡迎。

My name is Annabel Rincon.

我叫安娜貝爾-林孔。

I have the chance to be a Tableau visionary and Tableau ambassador, and I am leading two initiatives, Data Plus Women Zurich.

我有機會成為 Tableau 的遠見卓識者和 Tableau 大使，並上司著蘇黎世 Data Plus Women 的兩項活動。

If you want to be amazed and inspired by women working in data, please feel free to register.

如果您想從從事數據工作的女性身上獲得驚奇和靈感，請隨時註冊。

Our events are virtual and free.

我們的活動是虛擬和免費的。

And I'm also co-leading the analytic Tableau user group.

我還是 Tableau 分析用戶組的聯合上司。

In case you want to learn how to do analytics in Tableau, this talk is for you.

如果您想學習如何使用 Tableau 進行分析，本講座就是為您準備的。

And please feel free to connect with me on LinkedIn.

歡迎在 LinkedIn 上與我聯繫。

It would be my pleasure.

這是我的榮幸。

So let's start because I have exactly 12 minutes and I will probably mess up.

那我們就開始吧，因為我正好有 12 分鐘，我可能會搞砸。

So the first tip I have for you, it's not a Tableau tip, it's more like a learning tip.

所以，我給你的第一個建議不是 Tableau 建議，更像是學習建議。

Surround yourself with people that make you grow.

與能讓你成長的人為伍。

What I mean by that, attend Tableau user group, participate to community events like Workout Wednesday, for instance, ask for feedback, connect with people, because we never learn better than when we learn together.

我的意思是，參加 Tableau 用戶組，參加社區活動，比如 "星期三鍛鍊"，徵求反饋意見，與人交流，因為我們一起學習的效果會更好。

And that's why, by the way, I'm doing this session with these two amazing guys, because I will mess up with their computer today, for sure.

順便說一下，這也是我為什麼要和這兩個了不起的傢伙一起做這個環節的原因，因為我今天肯定會把他們的電腦弄得一團糟。

The tip that I will be presenting to you, some of them are coming from the data farm from Klaus Schulz and Rosa Yogana, that are two amazing visionaries.

我將向大家介紹的小竅門，其中一些來自克勞斯-舒爾茨和羅莎-約加納的數據農場，他們是兩位了不起的遠見卓識者。

If you don't follow them, you should probably.

如果你不遵守這些規定，也許你應該遵守。

And how I learned about that, by attending a Tableau user group or reading blogs.

我是通過參加 Tableau 用戶組或閱讀博客瞭解到這些資訊的。

So what I didn't tell you about me is that I am living in Switzerland.

我沒有告訴你的是，我現在住在瑞士。

And in Switzerland, we love our chocolate, great, well done.

在瑞士，我們熱愛我們的巧克力，非常棒，做得很好。

So let's imagine I'm working for a chocolate factory and I'm very happy.

假設我在一家巧克力工廠工作，我非常開心。

I have done this visualization, I show it to my boss.

我做過這種可視化，我把它展示給我的老闆看。

I have the sales and profit for different chocolate type and beans origin.

我有不同巧克力種類和巧克力豆產地的銷售額和利潤。

So I'm happy and she tells me, yeah, but I don't like you have the total at the bottom, right?

所以我很高興，她告訴我，是的，但我不喜歡你把總數放在最下面，對嗎？

And I tell her, yeah, sure, I can put it on the top quite quickly.

我告訴她，是的，當然，我可以很快把它放上去。

But she tells me, I would like that it's written like total dark chocolate here and total milk chocolate here.

但她告訴我，我希望這裡寫的是黑巧克力，這裡寫的是牛奶巧克力。

I can try, write dark chocolate.

我可以試試，寫黑巧克力。

But as soon as I do that, it changes every subtotal.

但我一這麼做，每個小計就都變了。

So how I do that?

那我該怎麼做呢？

For this tip, I will be using a calculated field that's called number of beans.

在本提示中，我將使用一個名為 "豆子數量 "的計算字段。

It's nothing else than the cone distinct of the beans origin.

這無非是豆子產地的錐形區別。

I just show you so you trust me.

我只是做給你看，讓你相信我。

So you see here, it's like one for each row, six for dark chocolate because there are six beans origin difference and the grand total.

所以，你看，這就像每行一顆，黑巧克力六顆，因為有六種豆子的產地差異和總計。

And I will be creating a fake column.

我將創建一個假專欄。

I put it here and I will use this column to display the label.

我把它放在這裡，然後用這一列來顯示標籤。

Create calculated field.

創建計算字段。

Let's call it new label.

就叫新標籤吧。

Let's see if I don't mess up.

看看我有沒有搞砸。

Yes.

是的。

Yeah, it's not my computer, so I'm happy to.

是的，這不是我的電腦，所以我很樂意。

So if number of bean equal, no, equal one, that means that I am on every row label and I can, in this case, I want that it display beans origin.

是以，如果豆子的數量等於，不，等於 1，這意味著我在每一行的標籤上都可以，在這種情況下，我希望它顯示豆子的原產地。

Let's make it bigger, otherwise you will not see what I'm writing.

讓我們把它放大，否則你就看不到我在寫什麼了。

Else if, if my number of beans equal the total of number of beans, meaning the 14, but maybe tomorrow I have more beans origin, so I want that my calculation always works.

否則，如果我的豆子數量等於豆子數量的總和，即 14 個豆子，但也許明天我有更多的豆子原產地，所以我希望我的計算始終有效。

So then in this case, let's write grand total chocolate.

是以，在這種情況下，讓我們寫出巧克力的總和。

And else, what we want is like this subtotal.

否則，我們想要的就是這樣的小計。

So else, like written total, space, and a little plus sign with chocolate type and put an end.

所以，還可以寫上總計、空格和一個巧克力字體的小加號，然後畫上句號。

And here Tableau say, Annabelle, you messed up because number of beans is a distinct, is an aggregated field, and the other one it's not.

在這裡，Tableau 會說，Annabelle，你搞砸了，因為 "豆子數量 "是一個不同的聚合字段，而另一個字段不是。

So here it's not a big issue, I will just add like a minimum on the string.

是以，在這裡這不是一個大問題，我只需在字符串上添加一個最小值。

So Tableau will be happy and he will have his aggregation exactly, and now it's okay.

這樣，Tableau 就會很高興，而他也能準確地進行聚合，現在就沒問題了。

So I can just like drag and drop this new label into my label, and now I have exactly what I want.

這樣，我就可以把這個新標籤拖放到我的標籤中，現在我就可以得到我想要的東西了。

And now it's just a question of a little bit of formatting that we will be very quick.

現在只需稍稍調整一下格式，我們會很快完成。

We will change like the type by a Gantt chart, we will put the label in the left, we will remove the show header, and remove also the bean number because we are not interested.

我們將改變甘特圖的類型，把標籤放在左邊，去掉顯示標題，也去掉豆子編號，因為我們對它不感興趣。

And now, dual axis, synchronize the axis, very important, and Tableau messed up again, but that's fine, I can just like remove the measure name, and I have whatever I want.

現在，雙座標軸，同步座標軸，這非常重要，Tableau 又搞砸了，不過沒關係，我可以移除測量名稱，然後就能得到我想要的東西了。

So now for my boss like to be happy, I will remove the show header and I will write sales here on the bottom.

現在，為了讓我的老闆高興，我將去掉顯示標題，在底部寫上銷售額。

Quite cool, no?

很酷，不是嗎？

So because I have a very demanding boss, she will come back and tell me, yeah, Annabelle, what I want now is that you create a visualization that allows me to understand the number of how many percentage of my spending I generated by how many percentage of my vendors.

因為我的老闆要求很高，她會回來告訴我："好的，安娜貝拉，我現在想要的是你創建一個可視化工具，讓我瞭解我的支出中有多少百分比是由多少百分比的供應商產生的。

And that is a Pareto.

這就是帕累託。

So let's try to do the Pareto first, and don't worry, my boss will have like other requests.

所以我們先試著做帕累託，別擔心，我的老闆還會有其他要求的。

So on the vendor idea, on the Pareto, you have first to sort, right?

是以，根據供應商的想法，根據帕累託理論，你必須先進行排序，對嗎？

So it's quite easy, you sort by field, descending order, and then, it's not my computer, I'm messing up, name the vendor idea.

所以很簡單，你按字段降序排序，然後，這不是我的電腦，我搞砸了，說出供應商的想法。

What I want is not to have each vendor idea, I need like a measure.

我想要的不是每個供應商的想法，我需要的是一個衡量標準。

So I will right click on this thing of the measure, and I will add a table calculation because the Pareto, what I really need is a running total.

是以，我將右鍵單擊 "措施"，然後添加一個表格計算，因為我真正需要的是帕累託總計。

Based on the vendor idea, I had a second calculation and have a percentage of total.

根據供應商的想法，我進行了第二次計算，得出了總額的百分比。

Yes, it's big enough.

是的，它足夠大。

Okay, and I will do exactly the same here, hot table calculation, running total, I was by the secondary calculation and percentage of total.

好的，我會在這裡做完全相同的事情，熱表計算，運行總計，我是通過二次計算和總計的百分比。

So that's good.

這樣很好。

I just have now to remove the bar for line, and now I present that to my boss, and she can know that 30% of the vendor represent 91% of our spending.

現在，我只需將這一欄去掉，然後把它交給我的老闆，她就可以知道，30% 的供應商代表了我們 91% 的支出。

And she said, yeah, but it's not what I want.

她說，是的，但這不是我想要的。

I want that I just write here, let's do the zoom, that I write 80% and that you create the intersection line.

我希望在這裡寫下 "讓我們進行縮放"，寫下 80%，然後創建交叉線。

Sure.

當然。

So I already created the parameter for that.

是以，我已經為此創建了參數。

So in that case, I just, with the parameter, I can just right click, add reference line, select my parameter.

是以，在這種情況下，我可以用參數右鍵單擊，添加參考線，選擇我的參數。

I could have chosen like a better name, I think, but anyway, add the value, and I can obviously like change a little bit of the formatting, have a nice color, for instance.

我想，我本可以選擇一個更好的名字，但無論如何，添加數值後，我顯然可以改變一下格式，比如說，換一種漂亮的顏色。

Let's put like a format, so you see very well and had some shading.

讓我們用這樣的格式，讓你看得很清楚，並有一些陰影。

We have 80%.

我們有 80%。

But the problem now is to create these lines, and it's automatic, right?

但現在的問題是要創建這些線條，而且是自動創建的，對嗎？

So let's create a calculation.

是以，讓我們創建一個計算。

To earn some time, I already copy-paste that.

為了節省時間，我已經複製粘貼了這些內容。

That is nothing else that what we have in column.

這就是我們的專欄。

I will explain that to you, intersection, yes.

我會向你解釋的，交叉路口，是的。

So the first one is the one that we have in the row.

所以，第一個就是我們這一排的那個。

So the running sum of the sum of the spending divided by total, to make the percentage of total, and what I want to write here for the intersection, if this big formula is below my parameter, then I will start doing the running sum of the count of the vendor divided by the total, else, null, because I'm not interested in what happened after the intersection.

如果這個大公式低於我的參數，那麼我就會開始做供應商計數除以總數的運行總和，否則為空，因為我對交叉點之後發生的事情不感興趣。

And then I can just drag and drop this intersection into detail.

然後，我就可以把這個交叉點拖放到細節中。

Don't forget to compute using vendor ID.

不要忘記使用供應商 ID 進行計算。

Right-click, add the reference line, select it from the intersection, add the value, and we are done.

右鍵單擊，添加參考線，從交叉點中選擇它，添加數值，就完成了。

And now my boss, I can even like a parameter, but action, but if she write down 75% now, yes, sorry, 0 point, yes, I think that I didn't put, like, so correct.

現在我的老闆，我甚至可以像一個參數，但行動，但如果她寫下75％，現在，是的，對不起，0點，是的，我覺得我沒有把一樣，那麼正確。

Okay, trust me.

好吧，相信我

Yes, sorry.

是的，對不起。

I was with a comma instead of a zero.

我用的是逗號而不是零。

Do you like it?

喜歡嗎？

Yes.

是的。

Yeah?

是嗎？

Okay, right on time.

好的，很準時

For the last tip, it's coming from Rosario Gona, so thank you, Rosario, if you are followers.

最後一條提示來自羅薩里奧-戈納，謝謝你，羅薩里奧，如果你是粉絲的話。

So my boss came to me and said, Annabelle, I want that you select, I want to be able to select a parameter like this and have, like, if I select the number of customer, the graph is automatically updated if I select the number of order, et cetera, et cetera.

是以，我的老闆找到我說："安娜貝拉，我希望你能選擇這樣一個參數，比如，如果我選擇客戶數量，圖表就會自動更新，如果我選擇訂單數量，圖表就會自動更新，等等等等。

So yes.

所以是的。

So I create, like, a visualization very quickly with the dark chocolate, mild chocolate, beans origin, like always, and I have a metric selected here.

是以，我很快就創建了一個可視化的黑巧克力、淡巧克力、豆類產地，就像往常一樣，我在這裡選擇了一個指標。

The metric selected, I will show you very quickly.

我很快就會向你展示所選的指標。

It's simply, like, whatever I select on the parameter, if I select customer, it will be the condistinct of the customer name.

簡單地說，無論我在參數上選擇什麼，如果我選擇客戶，它都將是客戶名稱的分隔符。

If the select order, condistinct of the order.

如果是選擇順序，則與順序無關。

If I select the last one, I want, like, the number of order by customer.

如果我選擇最後一項，我想要的是按客戶分列的訂單數量。

So that's fine.

所以這很好。

And that display.

還有那個顯示屏。

The only problem here, what happened, and I will show it to you immediately, the label.

這裡唯一的問題是，發生了什麼，我馬上給你看，就是標籤。

So for customer and order, it's okay.

是以，對於客戶和訂單來說，這沒什麼問題。

But for order by customer, I have a lot of digits, and my boss doesn't like that.

但按客戶下訂單時，我有很多數字，我的老闆不喜歡這樣。

She wants, like, a different format depending on her selection.

她希望根據自己的選擇，採用不同的形式。

And how we do that?

我們如何做到這一點？

We cannot.

我們不能。

But Rosario come with a tip, because in Tableau, what we have is, like, we can change a format if the value is negative or if the value is positive.

但羅薩里奧帶來了一個小提示，因為在 Tableau 中，我們可以在數值為負或正時更改格式。

So let's do that.

那就這麼辦吧。

Here I have a display metric, and I just said that if the metric section is order by customer, it's a bad guy that's causing issue, we will multiply the metric selected by minus one.

在這裡，我有一個顯示指標，我剛才說過，如果指標部分是按客戶下單，那就是一個造成問題的壞傢伙，我們將把所選指標乘以減一。

If I just drag and drop now metric selected into label, you see I have a negative value.

如果我把現在選中的度量值拖放到標籤中，你會看到我有一個負值。

And now I just have to copy-paste this format, right-click, format, numbers, custom, copy-paste.

現在我只需複製粘貼這個格式，右擊，格式，數字，自定義，複製粘貼。

And that's it.

就是這樣。

Because what we have done here is, like, the first one is positive.

因為我們在這裡所做的第一件事是積極的。

Let's try to do that.

讓我們試著這樣做。

Can I?

可以嗎？

No.

不

Sorry.

對不起。

I just want, like, to show it to you.

我只是想給你看看。

Exactly.

沒錯。

When it's positive, it's this format that is a full integer.

當它是正數時，這種格式就是一個完整的整數。

And when it's negative, it's one digit after the zero.

如果是負數，則是 0 後面的一位數。

And that concludes my session.

我的會議到此結束。

I hope that you like it.

希望你們喜歡。

And I'm right on time.

我很準時

And Torre, the stage is yours.

託雷，舞臺屬於你。

Yeah.

是啊

So that was tips from a visionary.

這就是一個有遠見的人給我的提示。

Now it's down to lower level, simple tips from an ordinary ambassador from Norway.

現在，一位來自挪威的普通大使為我們帶來了更低級、更簡單的提示。

I do tiny Tableau tips on X every Wednesday, so I'm going to do some of those.

我每週三都會在 X 上發佈一些 Tableau 小貼士，所以我也會發布一些。

And I'm going to start with this one, where I'm just going to start up Grammarly.

我將從這個開始，啟動 Grammarly。

You know Grammarly?

你知道 Grammarly 嗎？

Yeah.

是啊

Yeah.

是啊

And we don't know yet, but tomorrow there's going to be devs on stage.

我們還不知道，但明天會有開發人員上臺。

Will there be spellcheck in Tableau?

Tableau 中會有拼寫檢查功能嗎？

We don't know.

我們不知道。

I asked Mr. Miller last night.

我昨晚問過米勒先生

He didn't want to divulge anything.

他不想洩露任何資訊。

So if they don't want to share this tomorrow at devs on stage, if you install Grammarly, which is free, we can use the free version, you see that I have some spelling mistakes in here.

所以，如果他們不想明天在開發人員的舞臺上分享這個，如果你安裝免費的 Grammarly，我們可以使用免費版本，你會發現我這裡有一些拼寫錯誤。

And you see that the G is spotting my mistakes.

你看，G 正在發現我的錯誤。

And I can click accept, but Grammarly can't change anything in Tableau, unless you open up the dialog box.

我可以點擊接受，但 Grammarly 無法在 Tableau 中更改任何內容，除非你打開對話框。

You can't change the title, unless you edit it.

除非編輯，否則無法更改標題。

So when I go in here, I have three suggestions.

是以，當我來到這裡時，我有三個建議。

Or maybe I'm going to click...

或者，也許我會點擊...

What do you want to do?

你想做什麼？

I don't know what I want to do.

我不知道自己想做什麼。

I want to fix my mistakes, please.

我想改正錯誤，求你了。

Just the same as Annabelle.

和安娜貝爾一樣

When it doesn't work, it actually works.

當它不起作用時，它實際上是起作用的。

So this one apparently works.

所以，這個顯然是有效的。

Watch our session tomorrow at 9, then we're going to fix it.

請收看明天 9 點的會議，我們會解決這個問題。

But this works on any dialog box that you can open, a caption, a calculated field, or anything.

但這適用於任何可以打開的對話框、標題、計算資料欄或任何其他內容。

So until Tableau fixes spellcheck, you can use Grammarly instead.

是以，在 Tableau 解決拼寫檢查問題之前，你可以使用 Grammarly 來代替。

And trust me, it actually works.

相信我，它確實有效。

I've seen it.

我看過了。

I've seen it as well.

我也見過。

If you have a dashboard with multiple different visualizations like this one, just a simple bar chart, and you would like to save some space.

如果你的儀表盤有多種不同的可視化效果，比如這個，只是一個簡單的柱形圖，而你又想節省一些空間。

So this could be one of many different sheets inside of a workbook.

是以，這可能是工作簿中許多不同工作表中的一張。

See that if I click on any of these, it zooms in inside of the same container to save space.

看，如果我點擊其中任何一個，它都會在同一個容器內放大，以節省空間。

If I select multiple, it also shows multiple inside of the same space.

如果我選擇多個，也會顯示同一空間內的多個。

So I'm using a container to contain my data.

是以，我使用一個容器來容納我的數據。

But also if you pay attention to my axis, it goes to 300,000K.

但如果你注意看我的軸線，它也會達到 30 萬千瓦。

So it doesn't matter if I click on Chairs, or if I click on Art, it still keeps the same axis.

是以，不管我是點擊 "椅子"，還是點擊 "藝術"，它都會保持相同的軸線。

So how is this done?

那麼，如何做到這一點呢？

If I go over to my worksheet, you see this nice little bar chart.

如果我翻到我的工作表，你會看到這個漂亮的小條形圖。

And I've created a calculated field that is called Fixed Max Sales.

我創建了一個名為 "固定最大銷售額 "的計算字段。

I'm going to edit this one, and I'm going to zoom in.

我要編輯這張照片，然後放大。

So for each and every subcategory, I'm going to find the sum of sales, basically the same as you see on the label.