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.
数据准备规划
｜
31
分类数据字段是
Branch
（分支机构）、
Product
（产品）和
Date
（日期）。请注意，
在这里捕捉数据类型也是很有用的（见列头上方的标签）。输出中将只有一个字段
用于分析：一个简单的
Sales
（销售）值。
随着你在生成自己的数据集方面经验日渐丰富，这个阶段就会变得简单得多，几乎
变得习惯成自然。你将能在看到一个数据集时，就知道期望的结果应该是什么。一
般来说，确定期望的目标数据状态的过程似乎是令人望而生畏的，所以先画出它的
草图吧
!
3.3
阶段
3
：确定数据从
KYD
到预期状态所需
的转换
先把你的手从键盘和鼠标上拿开，因为在这个阶段，不需要计算机，只需开动你的
大脑。通过观察原始数据并确定所需的最终状态，你将开始了解在这两个阶段之间
所需要的一些转换──数据清理、转换、连接和联合数据。如果这些类型的数据转
换操作对你来说是全新的概念，不要担心，即将到来的章节将帮助你理解和掌握它
们，从而解决你自己的数据相关问题。
先列出你认为需要进行的转换。在
Prep Builder
之外进行这项工作将有助于思考所
要进行的步骤，而不是担心如何在软件中实现它们。如果不知道如何完成一个步骤，
可以在以后再处理。此时很可能你还不能完成全部任务，因为此时还没有建立工作
流程。以下是在这个阶段要问自己的一些问题：
列数据
•
是否有太多的字段？删除不必要的字段或数据转换列，如果它们代表相同的内
容（如日期），就把它们变成行。
•
是否缺少某些列？也许需要
join
（连接）另一个数据集。
join
操作能将两个数据
集“拉”到一起来（见第 ...
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.