September 2020
Beginner
442 pages
9h 54m
English
Content preview from Tableau Prep: Up & Running
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.
Chapter 11. Profiling Data
The art of data preparation is understanding the data set in order to determine what you might need to do to prepare it for analysis. Understanding the profile of the data is key to forming a full view of the data. Without profiling the data, you can easily miss an obvious preparation step or add in unnecessary work. This chapter will explore what profiling is, why profiling data is important, and how Prep profiles data.
What Is a Profile?
By profile, I mean the characteristics of the data set. As discussed in earlier chapters, understanding the types of data you have in the data set is essential to your analysis. Equally important is understanding the number and variance of the categorical data fields of the data set. Determining the data set’s level of granularity will help you to identify how many unique records there are, or whether there are duplicate records that you need to remove in the data preparation process. All of these factors form the foundation of the data set profile, which comprises these factors:
-
Minimum, maximum, and range of values: Does the range between the minimum and maximum values make sense?
-
Data outside of limits: Are there natural limits in the data, like 100%, or current dates that cannot be exceeded but have been?
-
Outliers: Do the values lie inside a certain range except for one or a few that sit outside of it?
-
Irregular number of records: Is there a consistent number of rows for certain dimensions, and does this ...
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.