+
Snowflake Logo – Cloud Data Platform

SSAS Replacement on Snowflake with AtScale

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 vs ssas feature table

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

ROI

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.

cloud mining 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

Governance

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.

Key Analytics Benefits
  • Faster dimensional modeling
  • Accelerated data access
  • Better analytics velocity and granularity
  • Robust and accessible business insights
  • A powerful platform for business intelligence teams