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.