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.
｜
181
输出到数据库
如果数据集是干净的，可以进行分析，没有潜在的缺点，而且在数据库上有写操作
/
覆盖的权限，那么把干净的数据写回来是防止将来返工的好办法。
如果数据来源于系统负载，你或
Tableau Prep Conductor
可能需要定期刷新流程，以
防止当新记录被添加时，脏数据被推回清洁表。你也可以与你的数据团队合作，向
他们展示你所做的操作，以及为什么这么做，因为他们可能将这些定期刷新任务建
立在正常的加载流程中。
20.1.2
简化的数据连接
将表连接在一起可以创建非常有用的数据集用于分析。然而，设置连接条件和连接
类型来实现这一点可能很复杂。所以，如果你已经使用
Prep Builder
将复杂的表连
接在一起，那么输出所得到的数据集既有可以与他人分享的好处，也可以省去他们
自己连接这些数据集的工作。这样也可以避免错误和返工，使这些数据集的用户分
析起来更加容易。
20.1.3
阶段表和参考表
可以使用
Prep Builder
将数据集添加到数据库中，有助于实现更简单、更详细的分
析过程。你可以将混乱的非结构化数据作为暂存表加载到数据库中，并通过不同阶
段的改进工作，直到它可以作为生产表使用。
Prep Builder
可以帮助你处理这些来源，
以确定它们所需的操作和清理动作。
另一个节省时间的做法是参考表，可以使用它将长字符串替换为更易于存储和更快
处理的数值。要在
Prep Builder
中创建一个参考表，可以使用
row_number()
函数和
Aggregate
（汇总）操作步骤。
20.2
写入数据库的设置 ...
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.