Kyvos Excel Add-In

Kyvos Excelerate is a cloud-native solution that powers up Excel capabilities and allows users to perform interactive analytics on extremely large datasets on the cloud directly from their Excel interface. It is a massively scalable, self-service, interactive reporting, and analytics platform that enables flexible and intuitive reporting on Excel with sophisticated filtering, responsive dashboards, in-cell charting, dynamic charts, and brilliant visualizations.

With Kyvos Excelerate, you can:

• Embrace and extend Excel in a data-connected, no-code model
• Eliminate data size limitations and analyze as much data as you need
• Create interactive visualizations and get instant dashboard refreshes
• Perform in-depth analysis through flexible selections & slicers, intuitive calculations, and more
• Overcome pivot table restrictions and analyze with unrivaled flexibility

For Business Leaders

• Historical analysis on years of data
• Simplified view of complex financial KPIs
• Instant insights with sub-second responses on billions of rows
• No limits on the amount of data that can be analyzed

For Finance Teams

• Advanced charting and visualization features
• Full control over report layout and formatting
• Interactive analysis with drill-down to transaction-level details
• High accuracy calculations with extreme decimal support

For IT Experts

• Cloud-native architecture with unlimited scalability
• Seamless adoption by business teams
• Saves BI costs on the cloud
• Eases cloud migration journey

Analyze Billions of Rows

Deal with the scale and complexity of today’s data without limiting your analysis to smaller datasets or encountering performance slowdowns on Excel. Kyvos Excelerate builds a semantic layer on the cloud that helps you to query billions of rows of data directly from your Excel interface while your pivot tables and charts update in sub-seconds.

Our Machine learning-powered Smart Recommendation Engine™ helps you build optimized data models that deliver the performance you need without compromising on the scale.

Best Practice Financial Reporting

Kyvos Excelerate implements the best practice rules of IBCS that enable you to design practical proposals for business communication that are applied to conceptual, semantic perceptual, and design of charts and tables. You can add and share business rules across workbooks. These rules allow thousands of users across the enterprise to map data to standard financial reporting types and automatically apply the correct IBCS formatting. You can create a template of your choice to display numeric and chart-based comparisons of dates and scenarios and get insights into massive data instantly

Overcome Pivot Table Restrictions

As data volumes rise, business users encounter performance issues, hierarchy selection restrictions, and other limitations while using Pivot tables. Kyvos Excelerate helps you overcome those restrictions while extending the capabilities of Pivot Tables, enabling you to add any Excel formula straight into the grid without any trouble.

It provides flexible and intuitive ways to perform in-depth analysis across any metric, such as filtering the selections, embedded charts for visualization data in a grid, user-defined calculations, and full interactivity with exceptionally high performance.

Freedom of Formula Reporting

Formula reporting is generally useful in financial reporting for dashboards or scorecards where the layout is critical. However, many array formulas in Excel slow down when made to work on large datasets. With Kyvos Excelerate, you get the freedom of formula reporting on cloud-scale data with total flexibility over layout, formatting, and dynamic reporting using conditional statements.

As it creates a live connection between Excel and your cloud data platform, you can quickly retrieve hierarchy members and values to create highly customizable, sophisticated, and dynamic reports. These formula reports enclose interactivity and can be drilled down to the lowest hierarchy level

Governed Sharing & Scheduled Distribution

Publish your Excel reports and dashboards so that users across the enterprise get a single version of the truth and can interact with the published reports directly from the browser. Incorporate existing active directory roles, groups, and SSO authentication into Kyvos Excelerate for folder-level access rights.

Kyvos Excelerate also offers row and column level security at a user or group level to hide dimensions, measures, or a row for a specific set of users. Additionally, it offers scheduled distribution of reports which require you to set the necessary parameters such as what is to be sent and when. Once set, the reports are sent automatically via email so that you do not have to worry about missing any critical piece of information.

Advanced Visualization

Create visually appealing reports and responsive dashboards on extremely large and complex data. Our advanced visualization features such as dynamic charts, in-cell charts, and responsive dashboards, help you make highly effective business decisions. A key advantage is that these visuals are not restricted to worksheet data and don’t require you to maintain complex data ranges within Excel.

While dynamic charts help you create compelling charts, the in-cell charts are highly configurable and can be inserted directly into a grid as part of a data table to display relative volumes, historical context, actual to target variances, and distributions. You can explore further by drilling into members and breaking the chart into smaller views for better understanding.

When users across the enterprise use Excel for reporting, cloud costs become a major concern as they fire resource-intensive queries on massive data.

Kyvos Excelerate’s unique price-performant querying approach aggregates data in advance, ensuring that minimal resources are consumed per query.

This means you can scale out for thousands of users and handle high concurrency without exploding costs or degrading performance. Additionally, you can further reduce your costs during lean periods by pre-scheduling resources in response to predictable load changes, helping you save on costs during lean periods.

Kyvos Excelerate offers native support for Amazon Web Services, Microsoft Azure, and Google Cloud Platform. It also supports cloud data warehouses such as Snowflake, Amazon Redshift, Google BigQuery, Teradata, Oracle RDS, and Databricks’ Delta Lake