How to use charts in Toad Decision Point

Please enable Javascript to watch this video

http://www.DellSoftware.com/Toad-Decision-Point Learn how to use charts in Toad Decision Point, part of Dell Software's Toad Business Intelligence Suite.

Hello. My name is Peter Evans. I'm the product technologist consultant for Dell Software, and I'd like to talk to you very briefly about Toad Decision Point and using charts. Toad Decision Point enables you to work with your data and provide a visual output of your data to be able to interrogate, analyze, and actually drive decisions from that data.
Here you can see a dashboard that's been created within Toad Decision Point, and this allows you to have a multifaceted view of each type of data within your workbook. A workbook starts out in a dimensional form, and you can drag and drop the data into dimensional views where it is automatically rolled up and grouped up by facts and dimensions.
It allows you to build out a chart very quickly by clicking on the center chart view, which will send the data within that grid into a basic chart. You can then manipulate that chart as you wish. You can also start a new view from the New button at the top by dragging down and choosing either line, area, bar, scatter, or pie, or our pivot or cross tab charts, which allow you to look at the data in a particular way.
The pivot chart allows you to do particular ways of looking at values. It allows you to create calculated columns, and it allows you to add in totals and subtotals. Within our bar charting, you can change the theme very quickly. So you can move from the industrial theme here to maybe a classic vibrant, and then work with that data very quickly.
You can also apply trend lines and calculated fields to this data very quickly from in the chart itself. You can actually create a calculated column just by clicking here, or you can apply a trend line. So here I've just applied two trend lines to the data. I've got one for sales amount and one for total cost, and these are actually linear trend lines.
Now, I can edit by clicking on the Edit button here, choose the trend line that I want to actually change, and then click on the linear and change to what we want to see. So for here we'll choose a weighted moving average. If I apply that, you can immediately see that my second trend line has been changed to this weighted moving average line.
We can move between different types of charts. We can have area charts, we can have scatter plot charts. We can have multi-tenanted views of the data as we go along, and very quickly we can do quick chart calculations, as well. Here we have a corporate database type chart with data labels applied and the trend line applied. This is very useful to gain insight from your data.
Because this goes over more than one page, we actually paginate the data for you so you can move between that pagination. Here I made a simple bar chart, and I may want to actually look at this data, and I may want to create a calculated view of that data. So very quickly I can go to quick calculation, I can supply the type of calculation I want to do.
So here we'll do a percentage of difference, pane over pane. And if I apply that in a create new series section, I immediately get the data below the chart that I'm actually looking out. So here now we have the rolling trend analysis of the data, and here we have an analysis of pane over pane of that data. Very useful if you're trying to see why your sales have collapsed over a particular area of time.
As I've said, we can move this data into dashboards. And to do that, it's very quickly, just by hitting fixed or fluid layout, choosing the layout that you wish to apply, and then applying that into your actual charts as well. You can drill into the data and actually segment the data very quickly by right clicking on a chart, and then choosing a particular point and applying a drill down by left clicking, drill down by, and select how you want to actually look at that data.
And it will then provide a chart for you, automatically created from the view that you were looking at. That has been a very quick overview of Toad Decision Point's charting capabilities. If you'd like to know anymore, please follow the link on the following page.