Clear Analytics is a business intelligence solution that enables non technical end users to perform analytics by leveraging existing knowledge of Excel coupled with a built in query builder. Some key features include: Dynamic Data Refresh, Data Share and In-Excel Collaboration.
Clear Analytics Features
BI Platform Features
- Administration via Windows App
- Live Connection to External Data
- Snapshot of External Data
- In-memory data model
- Multi-Data Source Reporting (Blending)
- Data warehouse / dictionary layer
- ETL Capability
- ETL Scheduler
Supported Data Sources Features
Data sources that can be consumed by the application.
- MS Excel Workbooks
- Text Files (CSV, etc)
- MS SQL Server
- IBM DB2
- SAP Hana
- Sage 500
BI Standard Reporting Features
Standard reporting means pre-built or canned reports available to users without having to create them.
- Pixel Perfect reports
- Customizable dashboards
- Report Formatting Templates
Ad-hoc Reporting Features
Ad-Hoc Reports are reports built by the user to meet highly specific requirements.
- Drill-down analysis
- Formatting capabilities
- Report sharing and collaboration
Report Output and Scheduling Features
Ability to schedule and manager report output.
- Publish to Web
- Publish to PDF
- Output Raw Supporting Data
- Report Versioning
- Report Delivery Scheduling
Data Discovery and Visualization Features
Data Discovery and Visualization is the analysis of multiple data sources in a search for pattern and outliers and the ability to represent the data visually.
- Pre-built visualization formats (heatmaps, scatter plots etc.)
- Location Analytics / Geographic Visualization
Access Control and Security Features
Access control means being able to determine who has access to which data.
- Multi-User Support (named login)
- Role-Based Security Model
- Multiple Access Permission Levels (Create, Read, Delete)
- Report-Level Access Control
- Table-Level Access Control (BI-layer)
- Field-Level Access Control (BI-layer)
Mobile Capabilities Features
Support for mobile devices like smartphones and tablets.
- Dedicated iOS Application
- Dedicated Android Application
- Dashboard / Report / Visualization Interactivity on Mobile