Operationalizing Analytics with Spotfire Statistica®

When you perform an analysis, Statistica® generates output (results) in the form of tables (spreadsheets) and graphs. Then an engineer or data scientist reviews the output to make decisions. 

But there are other ways to think about operationalizing an analytic project. For example: 

• workspace executes, cleans data, analyzes, and writes results into a database at 1:00 AM every day
• the workspace is scheduled to run every Monday to rebuild and test the model against the most recent outcomes (i.e. the model predicts fraud but was fraud actually found?)
• quality control chart analysis is automatically run every 3 hours -  it is out of spec -  triggers a text message to be sent and a process is stopped to avoid scrap (i.e. avoid an expense)
• open Spotfire .dxp file that is linked to a workspace (i.e. the displayed dashboard is using the workspace as a no-code analytics engine)
• model is deployed into the Teradata database which scores a row of data as it is added
• generate C++ model code and compile it into an internal application
• deploy the model to Statistica® Live Score Server; optimized for a scoring single row of data like a loan application
• nurse enters data into a web form while in surgery to score the post-surgical "avoid infections" treatment
• deploy the model to Spotfire® Streaming for IoT
• generate a SQL stored procedure for the model and insert it into the database

Workspace

Workspace is a flexible graphical user interface used for storing and automating steps of the whole data analysis process. It is in the form of a white canvas where you can drag and drop nodes and logically interconnect them. Each node represents one functionality of the software. By inserting your nodes and connections you are creating your data analysis process. In the workspace you can load the data, clean the data, merge the data, prepare data for data analysis, use statistical methods to get insight from the data, you can build predictive models and in the end save the results. More info about Statistica® Workspace can be found here.

Workbook

Statistica® Workbook is the default way of managing output. Each output document is stored as a tab in the workbook. Output can be organized into hierarchies of folders or document nodes using a tree view. Technically speaking, workbooks are ActiveX document containers. This provides compatibility with a variety of file formats (text files, Microsoft Office documents), which can be easily inserted into workbooks and in-place edited. 

Workbooks can be saved and shared as HTML or an Excel workbook (.xlsx).

All the graphs within a workbook can be saved into a Word document or PowerPoint presentation. 

Report

Statistica® Report offers a more traditional way of handling output where each object (spreadsheet, graph) is displayed sequentially in a word processor-style document. A Statistica® report is saved as a .str file. A report can also be saved as .html, .rtf, .pdf, .txt, .xml.

Microsoft Word

When sending spreadsheet analytical results to Word, Statistica® will take advantage of Word's table editing facility, and convert the spreadsheet to a table. For multi-page spreadsheets, you can control where to break the rows and columns. These spreadsheets will be broken by columns such as will be allowed without exceeding the page width. All rows for a given set of columns will be rendered before the next set of spreadsheet columns is rendered in the Word document. This solution enables the presentation of spreadsheets in Word that are natively editable in Word, displays the entire contents of the spreadsheet, and prints and paginates correctly.