How to better understand your SAP data with Toad for SAP Solutions

Hello, folks. My name is Robert Pound. And I am a product technologist for Quest. This video will cover how to use Toad to better understand your SAP data. In this demo, I'll be using a Query Builder file, but it's the same for both Query Builder and the Editor. So we have several tabs once we get our results. I'm going to start with the Profiling tab. This gives us a summary of our data and lets us know, for instance, if we had duplicate fields in an ID column, we would be a little bit concerned. If we had a, for instance, a column that was reporting body temperature and the median was 48 degrees Fahrenheit, that would be a little bit disconcerting. The profiling tab gives you an overall picture of the data that you're bringing back. In Toad for SAP, we're bringing back just the first 1,000 rows into the profiling. If you're an analyst or someone that's looking deep into the data, you may want to check out the full profiling. It is available in Toad Data Point Professional. So if you don't already have a license for Toad Data Point Professional, you may want to go check into it. And once we have a general understanding of our data, we can also use pivot and chart. This will give us a visual representation of our data as we're pulling it in. So in this case, we can see February has the greatest amount billed in this case, for this particular dataset. And then moving back to the result set, so we can sort, filter and group from the data grid just like you would in your query. So if we want to sort ascending or descending on state, we can just click on the column and it will sort ascending and descending. We can also from here if we wanted to filter out data, we can click on this icon in the upper right of the column. And this will give us a breakdown of currently what's in the column. So you can filter by any one of these. Or you can choose Custom and on the fly create a filtered statement for your data. You can also group the columns. So if it is not by default showing, you can open up the group header by right clicking on any one of the headers and choosing show the group by box. So once the group by box is here at the top, we can take any one of the columns and click and drag into the group by box. And this will group up all of our data, in this case, by state. And we can continue to add group by statements. So for instance, date ordered, we can drop that in there and that will be a sub component. So if we look at Oregon, we'll see that there are only two dates in this case under the group Oregon. And then to undo it, we simply drag it back to the header. And that's all I had to share today for better understanding your data. Hopefully, this helped you understand a little bit more about the tool and how you can use it. For more information on this or other topics, you can check out the help content. It has a wide range of tutorials to help get you started. You can also check out the community driven innovation going on at www.toadworld.com and clicking the Blog tab. For more information on this product, go to www.quest.com/products/toadforsapsolutions. Thank you, and have a great day.