Module:  Data Access Options and Considerations                                                       Print

Lesson Objective Discuss options for getting data into Spotfire and common issues with data formatting
Section Description
Data Access Four common data input options include:  Copy - Paste, File - Open, File -Import, and Information links to databases within your organization.
Data Formatting Basic data format expected by DecisionSite is discussed, including column and row format and the handling of numeric vs. non-numeric data.
Accessing Data from Microsoft® Office Excel A discussion of different access options and different format considerations from this very common data source.
Data Interpretation Problems A discussion of some common potential data interpretation problems and how to check data types in DecisionSite.
Changing Data Column Types A solution for incorrect data column types which involves copying data to the clipboard then re-importing using import agent.
Information Services Data access from the DecisionSite Analytics server is briefly discussed.  Additional information on Information Builder, Information Library, and Information Designer can be obtained via Spotfire Developer training.