How to use data visualization in Toad Data Point

This new enhancement to Toad for Data Analyst 3.0 is called data visualization. Data visualization is basically, taking a fairly large amount of data and representing it visually, so that you can easily extrapolate meaningful information. So any place that you have a grid, such as the Query Builder or Editor, you can right click on it and say send visualization. It's grabbing that data and analyzing it and actually saving it in our new local storage and going to represent it to you in a graphical manner. It'll take a minute or two, depending on what the data is that you're showing. Now in this set here what we have are retail totals over 3 months October, November, and December. And if we click on these, we can drill into what makes up that total. In this case, these are all the products that total-- that total during that time. We can also click further into it, and this will show me the region. But let's say I don't like that sequence. I would actually like to see it broken down by region first. I can grab this and drag this here and go-- now I can drill in, and it'll give me the region first. So now I can see that this Southern region is actually a larger percentage of it, and then drill in and see that this is my product here that sold the most. So this gives you a, kind of, quick way to drill in and get meaningful information. You can change some of the things here. We've put the data in to dimensions and measures. Under order, you can come down to the property area, and if you'd like to change it to grouping, you can change it to year or week, what have you. You also can give it a different graph visualization type. You can save this file also to a new file extension, TDR. No, I'm sorry. It's not TDR. What is it? It's TDV, which means you now can close this file and reopen it. It will re-query the local database, so that you can deal with this. You can also print out a hard copy of this file. And so it's a new tool that I think will be very useful for larger amounts of data.