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.
数据准备规划
｜
33
•
我们有两个分类数据字段（
Branch[
分支机构
]
和
Product[
产品
]
）。
•
其余的列都是以
Date
（日期）为首，包含销售值。
—
这些日期需要被旋转以形成第三个分类字段。这将为每个月
/
分公司
/
产品组
合添加另一行。数据转换过程将创建一个数值构成的列。
•
分支机构和产品字段都包含标点符号（分别是下划线和连字符），需要删除。
对于行数据，分析时需要为每一个唯一的分支机构（
Town[
城镇
]
）、产品和日期的
组合设置一行。这意味着我们将需要以下操作：
•
将
Lewisham_1
和
Lewisham_2
的销售汇总在一起，以正确的粒度输出数据。与
原始数据集相比，这也将改变所需状态数据集的行数。
我们可能还需要完成以下步骤：
•
重命名字段。每个列名是否能清晰地表达它所包含的数据？
•
改变字段的数据类型。将字符串改为可以进行汇总的数字（本书第二部分“数
据类型”中会有更详细的介绍）。
3.4
阶段
4
：构建工作流程
好了，现在我们回到鼠标和键盘上。该从哪里开始构建这个工作流程呢？好吧，制
订一个基本的分步计划是一个好策略。通过
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,
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.