Data Wrangling Inline with Your Analysis
Gaining insight from analytics depends on organized, accurate, and actionable data. Many analytic projects require that 50%—80% of their time be spent wrangling data for the purposes of analysis because data is messy, contains errors, or is not organized for analysis. TIBCO Spotfire® uniquely offers inline data wrangling through a unified visual analysis and preparation interface to help you easily and rapidly clean and enrich data while performing analysis.
Immersive Data Wrangling
The underlying philosophy with Spotfire is that some data preparation is always needed before the analysis, but in most cases, you will actually figure out what needs to be done only after you visually immerse yourself in the data. Only then you can see what is wrong and how the data needs to be organized. It also becomes very important that you visually validate the changes right there and then, as you make them.
Auto-Generated Visual Model
As you wrangle the data, Spotfire builds a visual model that self-documents all the changes that were made during the process. Traceability to the data model is ensured in this process as information about the data sources, connections, operations and transformations performed in the wrangling process is self-documented. The data model can also be exported and made available for reuse by other applications.
Wrangling without the Back and Forth
Moving between tools for data wrangling and analytics slows the analytics process—and can introduce errors. Spotfire data wrangling functions let you easily make adjustments to data without leaving your analysis. They include one-click unpivot, change data type and categorization, dynamically group columns, modify sort order, change column names, split columns based on any delimiter, create calculated columns, and replace missing values in the data.
No Need for Dedicated Preparation Tools
You don't need multiple technologies for data preparation and analytics. With Spotfire, you can fix your data interactively while you analyze. Spotfire empowers you to improve data quality and analytical results before you start, or while you're immersed in analysis.
Data Access Made Easy
Spotfire makes it extremely easy to connect to and blend data from relational and NoSQL databases, OLAP, Hadoop data stores, and web services. Connecting to cloud applications like Google Analytics and Salesforce.com is also seamless.
Spotfire Automation Services can be used to create automated jobs to store prepared data to specified locations and use the data as input to analytic applications.