Data collection
- Flexible data collection options from one or multiple sources including delimited, XML, and ODBC formats
- Easy loading of integration metadata about customers, products, or campaigns
- Data collection in real time or batch mode
Extract, transform, and load (ETL)
- Easy extension of the data schema for analysis
- Visibility into processing steps for data validation and auditing
- Automated system checkpoints for faster data reprocessing and recovery
- Extensive data transformation options including parse, append, merge, and categorizing of data for processing and extraction
Rapid performance
- Parallel processing for greater performance and scalability
- “Whole data set” processing on billions of records at a time
- Randomized statistical technique that provides approximate results for trend analysis immediately
Visualization
- Line and bar charts, tables, scatter plots, 2D and 3D process maps, path browsers, and worksheets
- Automatic addition of color-coded legends for better visualization
- Setup of visual markers before or after any event to track activities and trends over time
- Visualization of spatial data such as customer, store, ATM, or competitor locations on interactive global maps
Dimensions and metrics
- Multiple predefined dimension types including simple, many-to-many, numeric, and time based
- Unlimited cardinality dimensions that eliminate data truncation or roll-off
- Ability to define user-specified dimensions and calculated metrics
- Extensive built-in metrics and dimensions logic
- Searchable dimensions to quickly find specific elements
Advanced segmentation and filtering
- Ability to create an unlimited number of real-time segments based on any data in the data set
- Filter Editor that provides comprehensive logic to create segments and subsets of an entire data set
- Segment Export to group customers and export on a one-time or continuous basis to external systems
Analytics
- N-dimensional analysis capabilities to automatically correlate and cross-tab all data
- Sharing of dimensions, metrics, and analysis workspaces to collaborate with colleagues
- Annotation callouts for data clarification and explanation
- Microsoft Excel like worksheets to build scenarios and KPI dashboards
- Navigation from high-level trends to contributing data at its most granular level
- Data correlations and confidence metrics that guide user analysis and validate conclusions
Reporting
- Automated report distribution via email or reporting portal
- Automated output to Excel templates, eliminating the need for data manipulation and formatting
- High-quality reports that can be printed or exported to other Microsoft Office products
- Ability to export both preprocessed and postprocessed data to other systems such as a data warehouse