Connect Excel WorkBooks to Live Cloud Data Sources

View PDF Button Arrow

The Challenge of Working with Live Cloud Data in Excel

Microsoft Excel is the leading self-serve analysis platform in the world. Even in organizations leveraging using traditional BI platforms, analysts and executives rely on the flexibility of excel for ad hoc analysis, data exploration, and dashboard prototyping. Excel based reports and analytics typically rely on extracts of data – imported or copy/pasted – from primary data sources. The row limitations of excel worksheets can become a challenge. And extracts must be manually updated as underlying data changes.

Access Live Cloud Data from Excel

AtScale integrates seamlessly with Microsoft Excel through the Get Data utility. AtScale leverages a native MDX connector that does not require an additional driver or client-side software. Excel users can access data and models through the AtScale semantic layer with PivotTables, Slicers, and CUBE functions. As cuts of data are requested in Excel, AtScale provides high performance query access to live data on leading cloud data warehouses and data lakes. This addresses the data size limitations of Excel while preserving its full analytic flexibility.

AtScale Excel integrate access live cloud data

Key Business Benefits

AtScale lets Excel users take advantage of the analytic and reporting flexibility they value while gaining live query connection to cloud data sources through a semantic layer that ensures consistency, governance, and high performance.

exchange icon
Live Query Support

Establish single view of critical business metrics (e.g., revenue, COGs, headcount) and establish common analytics vocabulary across all analyst groups.

three layers icon
Semantic Modeling

Visualize AtScale dimensional model within Excel PivotTable with consistent view of metrics and analysis dimensions across organization

line graph icon
Performance Optimization

Visualize AtScale dimensional model with iOptimize end-to-end analytics performance from cloud data platform to Excel

new construction icon
Security and Governance

Extend role-based security and governance policies of source data to analytics

Bridge of AI BI icon
AI/ML Ready

Leverage AtScale to simplify access to AI-generated insights with ability to explore model outputs (e.g., forecasts) with multi-dimensional Excel analysis

bar and line graph icon
Integrate New Data Sources

Enhance Excel-based analyses with new data sources including integrations with third party data from popular data marketplaces


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.