AtScale recently announced an expanded integration with Microsoft Excel’s advanced analytic functions, according to a press release on the company’s website. An MDX integration makes AtScale’s semantic layer accessible with Excel PivotTables, Slicers, and Cell Definitions. New support also includes the ability to work with cell-level CUBE functions for embedding dimensional queries in cell formulas.
AtScale offers a data virtualization platform that enables users to connect BI tools to live data sources without moving data. The product features support for time-based calculations, hierarchies, semi-additive metrics, multi-level measures, and many-to-many relationships. Customers can use existing BI tool drivers to connect to data platforms as well, and AtScale natively connects Excel to live data on-prem and in the cloud. AtScale includes automatic data lineage and auto-optimized query response time functionality.
Data requests through AtScale’s semantic layer are directed in real-time to underlying cloud data platforms, with no need for extracts or pre-processing of data. AtScale supports Excel’s Single Sign-On with Active Directory / LDAP integration to manage access control and ensure overall data security. The integration also supports Excel’s automatic data refresh to avoid stale data and the need to manually copy and paste raw data.
In a media statement on the news, AtScale Founder and CTO David Mariani said: “Microsoft Excel is the de facto analytics tool for analysts globally. Our strategy at AtScale has always been to let analysts interact with governed enterprise data through a semantic layer, using data visualization and analysis tools of their choice. More than half of our customers leverage Excel in addition to traditional BI or AI/ML platforms in their analytics and data science programs.”
Read How a Semantic Layer Turns Excel into a Sophisticated BI Platform in the company’s blog to learn more.
- 2023 Big Data Engineer Salary Expectations in the United States - May 12, 2023
- 2023 ETL Developer Salary Expectations in the United States - May 12, 2023
- 2023 Data Integration Engineer Salary Expectations in the US - May 12, 2023