AtScale and Amazon Redshift
The Atscale Intelligence Platform is designed to support key requirements of modern big data analytics.
We support hybrid data access to the most common big data platforms and provide open data interfaces (SQL, MDX, or API) to virtually any analytics front-end. AtScale’s self-tuning engine ensures interactive performance for data consumers on even the largest data sets.
Designed for universal semantic model management AtScale provides an easy-to-use interface to model virtual cubes, while system metadata maintains a graph of data lineage all the way to the underlying raw data. With native support for complex business analytics, including distinct counts, percentiles, parallel periods, multi-fact models, and complex MDX calculations, AtScale Intelligence platform can support your most complex analytic and OLAP use cases.
"AtScale was born to deliver on the promise of making big data useful for the business."
- Jen Underwood, Impact Analytix
Standard connection to your Favorite BI Tools: AtScale supports current business processes by allowing your analysts to use the BI tools they already know and love, but at sub-second speeds on live Big Data.
Common Metadata Repository is a BI Force Multiplier: With a universal semantic layer and robust metadata and lineage tracking, AtScale enables business logic to exist directly on top of the big data cluster and of BI tool-specific semantics. As a result, the AtScale semantic layer (also known as a Virtual Cube) can be used by your favorite BI or analytics tool.
"The Switzerland of semantic layers."
Krishna Roy, 451 Research
Multi-Dimensional Queries on Big Data Made Simple: While big data platforms excel at low-cost distributed storage and parallel data processing, interactive support for BI-style queries remains a challenge. Additionally, multi-dimensional analytical queries often demand complex OLAP-style calculations and functions. AtScale’s dimensional calculation engine enables these complex business queries directly on your big data.
Automated Query Optimization: With AtScale, your queries run fast on Big Data because we automatically generate and maintain your aggregates. Advanced machine-learning algorithms optimize your BI query workloads on-demand to deliver the performance you and your users have come to expect from BI, multidimensional and OLAP systems.
Abstracting Dimensionality into Big Data: With AtScale’s patented approach to data abstraction you easily create complex, multidimensional analytical models directly on top of a variety of Big Data types (flat files, relational data structures, or semi-structured). Now Enterprises can model the most complex business structures for analysis – live on the data in your on-prem and cloud big data platforms.
"AtScale’s no-ETL and no-data movement approach is simply a gamechanger. This application should be required for anyone who wants to do BI on Hadoop."
Kevin Johnson CEO, Ebates
Enterprise-Level Access Control, Monitoring, and Management: AtScale works with Enterprise Big Data deployments to offer data governance and security for the data residing in Hadoop and other Big Data Platforms. Administrators have complete control over who can access which data across Big Data in the Enterprise.
Easy, Intuitive BI Model and Cube Design: Business users get to interact directly with data in Hadoop and other big data systems via the AtScale Design Center web app. Data analysts can design virtual analytical (aka OLAP) cubes using familiar workflows and intuitive drag-and-drop interactions.
AtScale delivers an advanced set of features you won’t find together in one solution, anywhere else.
Built for the business analyst, drag and drop enables rapid cube design & deployment. Build sophisticated models without writing any code.
Supports multiple clusters, multiple environments, and multi-tenant data; significantly lowering IT maintenance costs.
AtScale is the only BI platform that supports both SQL and MDX queries against the same multidimensional model.
Hierarchical analysis is core to any BI application, and AtScale delivers rich support including multiple hierarchies, role-playing, and sharing.
Make sure that the right users see the right data with support for dynamic user-to-attribute security policies.
Statistical models predict optimized queries even before a user executes it, while smart algorithms keep aggregates up-to-date with zero human intervention.
Many-to-Many models, a requirement for any advanced BI platform, are supported in to AtScale.
No need to rescan your entire data to update aggregates. Incremental updates look only at the most recent partitions of data.
Built by developers for developers, we ensure that you can restore and dif any version of your model.