Get Native
Analytica provides the first native language and technology for the reporting and analysis of JSON documents. Analytica processes documents directly in their native JSON format without any additional hard-to-define and slow-to-execute ETL processes. By operating on JSON natively, users can leverage the rich document format of JSON while performing analysis and reporting.
The Analytica Script language provided by Analytica is a succinct, intuitive, declarative language tailored to the analysis of JSON documents. Instead of procedural programming to describe how to transform data, an Analytica Script expression simply defines what a particular property should be and performs the required computations.
Data analysts can use Analytica directly from Excel through an Excel add-in, allowing them to connect to MongoDB databases, browse data, analyze it, and create graphics. Additionally, a REST API is provided, enabling developers to leverage Analytica from their programming language of choice, such as Java, Python, PHP, Ruby, Javascript or C#.
Analytica supports a broad range of users and applications, facilitating the iterative development of reporting and deep analytical applications, without resorting to traditional programmatic methods.
How it Works
An Analytica user defines calculations, requests results, and initiates the execution of reports through set and get functions. The server executes the request, including all the necessary computations. Data is fetched from one or more Mongo databases, and Analytica processes data in JSON format natively and directly. There is no flattening of data, no loss of relationships of data organized as a hierarchy of collections. Various tools, such as a JSON Schema Browser, are provided to help the user navigate through the collections and properties that exist in the database, assisting in rapid and error-free creation analysis. One key feature of Analytica is its ability to logically extend the data models of the databases. This is accomplished by sending Analytica Script’s hierarchical computational expressions to the server via the set command, which defines persistent (and reusable, and shareable) calculated properties and collections, which, once defined, are indistinguishable from collections and properties stored in the database.