Sunday 21 August 2016

What are the different data sources used in Spotfire to create data visualization?

Visualization can be made up from different kind of data sources in Spotfire tool. which include below list of data source:

Data from clipboard
• Text Files
• Excel Files
• SAS Files
• Database
• Nielsen Answers
• Information Link

There are different way to load data into the Spotfire analysis. User can add data tables using file menu, Add data tables and Add On-Demand Data Table. We can add more than one data table in Spotfire analysis.

Apart from above data sources Spotfire support external data sources which are mentioned as follow:

• Microsoft SQL Server
• Microsoft Analysis Services
• Oracle Database
• Oracle MySQL Database
• Teradata
• IBM Netezza

As we see, there are various kind of data source used to import data into Spotfire analysis. As a result Spotfire analysis will be categorized into two part In-Memory Data and In-Database Data analysis. Lets see these two category of Spotfire data analysis.

In-Memory Data:

Spotfire loads the data from various data source in the memory. In general data loading from clipboard, Text file, Excel file, Information Link Nielsen Answers load into Spotfire memory as a
data table. Thus we have full control over the data table which is loaded into Spotfire memory. This enable us to perform any number of calculation on columns in data table. Also, we can create calculated columns, predictive analysis and data cluster, etc.

In-Database Data:

When we used external database to load data table into Spotfire database and all the calculation is performed on external source is known as In-Database Data. In this case all aggregation and data transformation performed to external database. Using in-database data allow us to work with huge amount of data and take advantage of the power of external system. While working with external data connection, we access only the current selection of the data. Whereas aggregations and calculations are performed to in-database.

No comments:

Post a Comment