Excel Your KPIs with AI Copilot Start for free today
Your AI Copilot for Data
Definitive Guide to Decision Intelligence
Subscribe to our newsletter>
Get the latest products updates, community events and other news.
Excel and Snowflake have had a rocky romance. Yes, people are finding ways to connect Excel and access Snowflake data, but it hasn’t been pretty and there isn’t native support for Pivot Tables from Snowflake. This is why we’ve created Kyligence Pivot to Snowflake; a cloud solution that solves this problem.
The Snowflake cloud data warehouse has seen tremendous growth in the past 5 years thanks to its straightforward user experience, transparent pricing model, and native cloud architecture. Users can literally create a data warehouse and start analyzing data in a couple hours, without the overhead of server provisioning, storage planning, network setup, etc. usually required for setting up a traditional data warehouse.
While many BI products can read data from Snowflake through purpose-built connectors, one of the most popular BI tools still has no easy way to work with Snowflake, and that is Excel Pivot Tables.
Pivot tables are probably the most powerful analytical feature in Excel. With pivot tables, users can gain valuable insights by summarizing detailed records across multiple worksheets. The following example shows a pivot table on the right and its corresponding detailed data on the left.
Figure 1: Transactions and Pivot Table
(Microsoft Support Document)
Pivot Tables enable analysts to conduct multi-dimensional analysis without writing complex SQL statements. The data in the pivot table can also be used to draw Pivot Charts and build dashboards.
Unfortunately, it has not been possible for users to run Pivot Tables against Snowflake data directly. A common workaround is to download a subset of data from Snowflake to local laptops and analyze them as a bunch of CSV files. But ideally, we’d like to use Pivot Tables on live data in Snowflake to get the most accurate results possible.
Kyligence Pivot to Snowflake is a solution for Snowflake users. It leverages Kyligence Cloud MDX, Unified Semantic Layer, and Query Pushdown capabilities to build Pivot Tables on top of Snowflake data warehouses.
Figure 2: Kyligence Pivot to Snowflake – A Solution for Pivot Tables on Snowflake
The above diagram shows these key components that comprise the Kyligence solution:
Users of Kyligence Pivot to Snowflake can expect the following benefits:
Kyligence Pivot to Snowflake is available now on AWS and Azure. I encourage you to check out the webinar and this quick demo video or give us a call to see a live demo.
Excel users have been more or less locked out of using data in Snowflake until now. Isn’t it about time that they lived happily ever after?
Webinar: Excel, Data Discovery, and Snowflake: Unhappy Together
Webinar: Snowflake: The Good, the Bad, and the Ugly
Webinar: Architecting Snowflake for High Concurrency and High Performance
Webinar: Kyligence Pivot to Snowflake - A Solution for Excel Pivot Tables on Snowflake
Demo: Kyligence Pivot to Snowflake Demo
Explore these exceptional cloud analytics tools. Assess their pros, cons, and pricing to pinpoint the optimal one for your business.
Unlock the potential of cloud analytics. Explore the cost-effective, flexible, and scalable solution cloud-based analytics offers businesses.
Delve deeper into integration of SaaS growth metrics. Learn how Kyligence integrates and tracks these metrics to drive your business forward.
Dive into this Guide on SaaS growth metrics for PLG. Uncover challenges, methodology, and essential tech tools to drive SaaS success
Embedded analytics seamlessly integrates with existing applications, unveiling hidden potentials. Explore top tools and their benefits.
Discover the power of actionable data in decision-making. Learn how to transform raw data into insights and explore Kyligence Zen as a solution.
Data analytics field is evolving. Learn about the top 10 data and analytics trends in 2023 like AI analytics, natural language processing, small data, and Reverse ETL.
99 Almaden Boulevard Suite #663
San Jose, CA 95113
+1 (669) 256-3378
Ⓒ 2023 Kyligence, Inc. All rights reserved.
Already have an account? Click here to login
A complete product experience
A guided demo of the whole process, from data import, modeling to analysis, by our data experts.
Q&A session with industry experts
Our data experts will answer your questions about customized solutions.
Please fill in your contact information.We'll get back to you in 1-2 business days.