Looker is a business intelligence application with an analytics-oriented application server that sits on top of relational data stores. The Looker platform includes an end-user interface for exploring data, a reusable development paradigm for creating data discovery experiences and an extensible API set so the data can exist in other systems.
Looker Features
BI Platform Features
- Administration via Web Interface
- Live Connection to External Data
- In-memory data model
- Multi-Data Source Reporting (Blending)
- Data warehouse / dictionary layer
Supported Data Sources Features
Data sources that can be consumed by the application.
- Oracle
- MS SQL Server
- IBM DB2
- Postgres
- MySQL
- Cloudera Hadoop
- Hortonworks Hadoop
- EMC Greenplum
- IBM Netezza
- HP Vertica
- ParAccel
- SAP Hana
- Teradata
- Sage 500
- SAP
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
- Integration with R or other statistical packages
- 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
- Support for Machine Learning models
- Integration with R or other statistical packages
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.
- Responsive Design for Web Access
- Dashboard / Report / Visualization Interactivity on Mobile