SSAS Replacement on Snowflake with AtScale

View PDF Button Arrow

Leveraging AtScale enables organizations to replace SQL Server Analysis Services and migrate the workload to Snowflake

The Problem

SSAS has several drawbacks, including its inability to handle big data and the complexity of defining and modifying dimensional models. Further, using SSAS requires moving data out of Snowflake which is complex and fails to leverage the power of the Snowflake Data Platform SQL Server Analysis Services (SSAS) is a popular platform for delivering dimensional analysis. SSAS exposes “cubes” to end users which makes data easier to consume for business users

The Solution

AtScale delivers an architecturally superior alternative to SSAS. AtScale allows you to do multi-dimensional analysis directly on data in Snowflake, without extracting data to pre-aggregate it. AtScale is built for big data and will scale with your business while improving your Snowflake ROI.

Ultimately, this helps organizations deliver better sales analytics velocity and granularity, as well as delivering a powerful platform for BI teams to build robust and usable business insight programs.

AtScale helps Snowflake customers build world-class business intelligence and data science programs while leveraging the full flexibility and capability of the Snowflake Data Cloud. Removing SSAS from the equation means better agility and performance, faster modeling and accelerated data access.

Key Business Benefits

dollar sign icon

Realize 2.5-9X ROI improvements for data and analytics by switching to AtScale + Snowflake. ROI realized through improved query performance, user concurrency, compute costs, and SQL complexity.

decentralization icon
Zero Disruption

AtScale has been proven in production environments to easily replace SSAS with no disruption to operations. One customer ran 300,000 queries per month with SSAS and runs the same number using AtScale with no issues.

optimize cloud icon
Optimized Cloud Analytics

Optimize analytics programs built on cloud infrastructure. Ensure performance, manage costs, bridge multi-cloud data.

gold star coin icon
Cost Control

AtScale has an order of magnitude impact on ROI for each major cloud data warehouse, including Snowflake. Customers using AtScale control costs and complexity of cloud analytics.

new construction icon

Customers using AtScale on Snowflake maintain a consistent and compliant view of data across the enterprise.

speedometer icon
Force Multiplier

Get more value out of resource-constrained data and analytics teams without needing to increase headcount. Accelerate operational decisions from days to seconds.

security shield icon
Trusted Data

Make higher quality decisions based on trusted, consistent data, even across multiple users and timeframes. Take advantage of rapidly evolving economic conditions.


AtScale enables smarter decision-making by accelerating the flow of data-driven insights. The company’s semantic layer platform simplifies, accelerates, and extends business intelligence and data science capabilities for enterprise customers across all industries.