Connect Excel WorkBooks to Live Cloud Data Sources

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.

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.

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

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

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

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

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

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

ABOUT ATSCALE

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.