This is the continuation of the transcript of a Webinar hosted by InetSoft in April 2017 on the topic of "What are the Benefits of a Visual Reporting Solution?" The speaker is Abhishek Gupta, product manager at InetSoft.
There are some questions about mapping data and this is one in particular for the geographic mapping capabilities, do the longitude and latitude need to be stored in the data, and is there mapping for a zip code? Here is another example of using a map in a visual analysis. We have a set of popular maps included in the visualization application. So you have fields and tables. It comes with latitude and longitude for U.S. cities and states. Here’s location, and it comes with the U.S. city and states, U.S. zip, international cities, Canadian cities and provinces. It comes with a latitude and longitude.
You can also put your old latitude and longitude in, and it comes with a set of maps. You can add your own maps to it. You have got basic U.S. maps, but it’s pretty easy to put in any rectangular. Actually any rectangular image can come in as a map. We have people put in their map with specific cities. Campus maps can go in here. We have to put in logical maps and floor plan map.
The map is for plotting data on the map. And in this case on cities there are people counts. The map can be any image. We just plotting data on coordinates. The map is interactive, so if you select things from a list, here it shows up in the other chart. And if I go to another chart it will update. The map is going to update to show where the people in next reunion live out of everybody in the alumni universe.
For the last question, this is about data prep and data modeling. What level of data modeling is required by the visualization application? Can I work directly from a spreadsheet? Do I need to go to an OLAP data warehouse?
We prefer a load relational tables, rows and columns. So if there is an OLAP structure we prefer to get the base table and work from there. And they are most often reloading relational table out of Oracle or SQL Server as if an individual user is access it himself. Probably that would be the most common databases we’re loading from. But our data access engine can handle the whole range of data types.
Great. Well, thanks to all of you for your attendance. There has been huge interest in this webinar, and we will be following up with the recording when it is ready. Also thank you so much for the many questions that have come in. We will be following up with each of you personally. But we will also be posting your questions on our blog.
So I would encourage you to visit that, see what others are asking and to read the answers to all of the questions. Once again we thank you so much for your time today. Watch for our next webinar, forward to talking to you again. Have a good day.
Copyright © 2024, InetSoft Technology Corp.
