Hello, my name is Robert Pound, and I am an Product Technologist from Quest. In this video, I'd like to talk to you about the profiler and Toad Data Point and how it can give you a leg up in your analysis. Understanding and combining data are two of the major endeavors of the front end of any data analysis task. Toad Data Point addresses these issues in a number of ways. However, the focus of this video will be on the profiler.
Highlights of the profiler include the ability to rapidly understand your data through the use of visual tools, grid data, and statistics. As well as the ability to drill down on specific data sets. Now let's have a more detailed look at the profiler. There are different options to access the profiler.
If you have a query builder or a SQL editor open and you have a result set that you want to profile, you can go to the Profiling tab and choose Full Profiling in the upper right. This will open up a window that allows you to select the type of sampling, as well as the data types that you want to choose as well as columns. I'm going to cancel out of this. You can also, from the Object Explorer, right click on an object and choose Profile. You can also select it from the tools or from the ribbon bar.
Since I have a profiling tab open, one of the sources available is the current window. I can also choose data objects that I have access to. From the library I can choose any SQL file that I have stored in the library to select data, or I can enter in a query in the wizard itself.
I'm going to go back to data objects and choose Address At this point, I can choose options as well. So once I have the data selected I can, again, choose all, some, or a random selection. I can choose the type of analysis that I want to do that we'll get to in a second. Here I'm going to just use the defaults.
And again, the column selection. So you can choose all the columns, you can choose a select subset of the columns depending on what type of analysis you want to do. I'm going to choose all, but if you have a larger table or result set you may want to de-select certain columns. And with this I'm going to go ahead and choose Profile.
And with the Profiling tab open we are presented with a Summary tab inside of it. This gives us information about the columns and the types of patterns, statistics, data types, breakdown of how each column is populated, and we also have a visual representation. So if you highlight-- so if you hover over any of these columns you'll get a percentage breakdown as well.
The information in the legend explains exactly what each one of these columns mean. I will not get into that, but you can read them for yourself. And you have all the data at the bottom as well. So if you want to take a look at the data, it's right here at the bottom.
So moving on to the Statistics tab. This gives a breakdown of the individual columns, so as you select the columns on the left it's going to give you the statistical breakdown, as you can see here, as well as the numerical breakdown of the individual categories. And on the right as we choose, you can choose a grouped up frequency distribution, percentiles, value distribution, etc.
As we can see here, for Address ID it's grouped it into 100. So 100, 200, 300. And if we want to look at, in this case, the 300 to 400 we can double click on this, and it will open up a Selected tab. So now we only have addresses in the 300s if we want to drill down into this subcategory. And if we want all data we can, again, select the All Data tab.
Moving on to frequency. So the Frequency tab has information specifically about the frequency of each one of the objects in a given column. So for the address ID it's going to have only a count of one for each one of them because, as we saw in the previous tab, the address ID was unique. But if we look to, for instance, state, it's going to give a breakdown of each one of the states. And then if you want to, again, drill in, you can double click, and now we have all the addresses in Texas for instance.
Moving onto the Patterns tab. So this breaks down what sort of patterns show up in individual columns. So in the case of city it's going to be all letters. There are some hyphens in this case. If we look at the address it's going to be digits followed by letters, and then we have the breakdown of each one of those here. And in the case of postal code it's only going to be digits, which is what we expected.
And looking at the Language tab-- this is just going to show any sort of character sets you have for each one of the columns. And finally, the Duplicates tab. We can further drill down into the duplicates. So looking at address-- if I check address and then check duplicates.
So these addresses are the same but they are in different cities and state. So if I choose address and then either one state or city-- let me choose state-- and then check duplicates again, there will be no duplicates because even though the address is repeated, the combination of address and data is not repeated.
And finally, looking down at the toolbar. So you have access to the tutorials and the ability to save this profile as a file to reopen. You can