In TM1, missing data usually means that there is a defect in the logic of your ETL script or you need to check your SQL. In SPSS Modeler, missing values arise for a variety of reasons and they must be considered carefully. You might expect that missing values imply errors or should those records be […]
Posts Tagged ‘IBM SPSS Modeler Professional’
Data Indiscretions
Data loaded into a TM1 or SPSS model will, in most cases, include files consisting of thousands (or hundreds of thousands) of records. It is not reasonable, given the number of fields and records in files of this size, for you to visually inspect all fields in every record (of every file) for missing or […]
Data Consumption – Cognos TM1 vs. SPSS Modeler
In TM1, you may be used to “integer or string”, in SPSS Modeler, data gets much more interesting. In fact, you will need to be familiar with a concept known as “Field Measurement Level” and the practice of “Data Instantiation”. In TM1, data is transformed by aggregation, multiplication or division, concatenation or translation, and so […]
Importing Data into SPSS Modeler for the TM1 Developer
If you have a TM1 background it is a quick step to using SPSS Modeler -if you look for similarities in how the tools handle certain tasks like, for example, importing data. With TM1, source data is transformed and loaded into cube structures for consolidation, modeling and reporting using its ETL tool TurboIntegrator. In SPSS […]
A Data Mining Workbench
Data mining provides organizations with a clearer view of current conditions as well deeper insight into the future. In many previous posts, I’ve talked about IBM SPSS Statistics and Modeler. Here is some basic information: IBM® SPSS® Modeler Professional is the data mining workbench for the analysis of structured numerical data to model outcomes and […]