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.
处理数字
｜
63
年龄作为度量标准
计算所分析数据中的平均年龄可以帮助我们针对某个年龄段的人群定制产品、
服务或营销渠道。
年龄作为类别
按客户的年龄段看购买数量或平均销售额，对了解客户的生命周期也很有帮助。
7.4
汇总
在确定了数值数据字段是否为度量数据后，分析师经常会问的下一个问题是：我们
应该如何汇总这些值？你可能还记得前几章的内容，汇总的意思是求和、求平均，
或者找最小值或最大值。即使是在一个简单的
100
行数据集中，仅仅知道每一个单
独的销售数字也不能真正帮助我们分析这些数值。因此，计算总和、平均值、最大
值或标准差是找到数据集背后蕴含的信息的关键。
在使用
Tableau Desktop
等
BI
（商业智能）工具之前就应该开始考虑这个问题，确
切来说，是在工作的数据准备阶段就评估这个问题。如果能将数据汇总到更高的粒
度，则有助于加快分析速度，因为它会减少
BI
或可视化分析工具所需要处理的数据
行数。数据准备阶段是进行这种汇总的最佳时间节点，可以一次处理数据到所需的
粒度，而不是要求每个用户都去处理汇总。
7.5
数字的格式化
在数据准备阶段，不需要使数据集中的值的最终格式太过精确。在
Prep Builder
中，
没有太多的选项用于格式化将被带到
Tableau Desktop
中的值。然而，在一些特定情
况下，预格式化数据能避免后续编写额外的计算：
货币
将数值四舍五入到小数点后两位，将产生易于在分析中使用的数值。但是，要
避免在数字中添加货币符号，这样做会将数字转换为字符串，防止数据汇总。
如果有必要，在列头中指定符号 ...
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.