August 2022
Beginner to intermediate
463 pages
9h 22m
Chinese
Content preview from Tableau Prep即学即用
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
44
｜
第
4
章
联合在第
17
章有更详细的介绍。
图
4
-
11
：数据集联合的过程
4.4
将数据重组技术应用于冰淇淋味的香皂案例
让我们把这些数据重组技术应用于冰淇淋味的香皂案例。
4.4.1
步骤
1
：将列数据转换为行数据
创建一个包含日期的单列将使我们能够更容易地在
Tableau Desktop
中使用数据，因
为日期字段可以放在
Tableau Desktop
的
Columns Shelf
（列功能区）上，以创建一
个包含数据集中所有日期的
x
轴。这使得我们可以很容易地进行基于时间的分析。
这个数据转换步骤创建了一个标有
Pivot1 Names
的列，用来存放以前的列头（见图
4-12
）。为了表达得更清晰，
Pivot1 Names
列头应改名为
Date
。
Shelf
（功能区）是在
Tableau Desktop
中用于放置数据进行分析的地方。
塑造数据
｜
45
图
4
-
12
：列数据到行数据的转换结果
4.4.2
步骤
2
：将行数据转换为列数据
要为每个度量创建一列，我们需要将度量列值转换为包含相关销售额和利润数据的
新列的列头（见图
4-13
）。这些列中的数据将来自
Pivot1
值的列。
图
4
-
13
：从行数据到列数据的转换结果
根据所需的分析和需要采用的分析方法，你可能希望在此时将数据汇总到每个度量
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.