An Introduction to WynSheets v9.1

How many times have you exported data from your BI tool into a spreadsheet to do specific analysis before presenting the insights not available in your reports and dashboards. Spreadsheets are where a lot of business decisions actually get made. They are also, in most organizations, cut off from the data that drives those decisions. So the day for a business user deriving insights from their data tends to look the same: export data from a BI tool, paste it into a spreadsheet, fix the formatting, rebuild the calculations, and start over the next time the numbers change. By the time the analysis is ready, the data behind it is already out of date.

That gap has always sat between two tools every business relies on. Governed BI systems are structured and trusted, but running a quick what-if or adding a formula on top of them is not always straightforward. Spreadsheets are fast, flexible, and familiar, but disconnected from the governed data that matters. wynSheets, new in Wyn Enterprise v9.1, closes that gap. It is a spreadsheet that sits directly on top of governed Wyn data, so the analysis your team does in a familiar interface always runs on live, trusted numbers. Your BI data, your spreadsheet, one experience.

What wynSheets Brings 

• Live Wyn data in a familiar spreadsheet: connect directly to governed datasets, with no exports and no manual syncing.
• What-if analysis on trusted data: run scenarios and add business logic on top of governed BI data.
• No-code self-service: business users explore and build their own analysis without waiting on IT or BI developers.
• Governed by design: every cell traces back to a governed Wyn dataset, so there is one source of truth.
• A two-way connection: publish a Sheets table back into Wyn as a live data source for reports and dashboards.

Live Wyn Data in a Familiar Spreadsheet 

With wynSheets, you stop copying data and start connecting to it. A Sheet binds directly to your Wyn datasets, so revenue, cost, customer, and operational data is available right away and always current. You work with the tools you already know, including formulas, tables, filters, and charts, but they run on governed enterprise data instead of a static export. When the underlying BI data updates, the Sheet updates with it. There is no refresh step, no re-export, and no broken links to chase down.

Accelerate Decision-Making 

Because the data is live, teams work on what is happening now rather than on yesterday’s snapshot. You can filter instantly, adjust assumptions, and compare scenarios in seconds, so analysis that used to take hours of preparation happens in the moment. The result is a shorter path from question to answer, with fewer manual steps in between.

No-Code Self-Service for Business Users 

wynSheets does not just speed analysis up. It changes who can do it. Business users can build their own logic, explore data freely, and test assumptions on their own, without writing code and without waiting on IT or the BI team. This is self-service analytics in an environment people already understand, grounded in data they can trust.

Governed Data Meets Spreadsheet Agility 

Flexibility here does not mean losing control. Every cell in wynSheets traces back to a governed Wyn dataset, which means one source of truth, consistent definitions, and no duplicated extracts and none of the data silos that come from manual copies. Business users get the freedom of a spreadsheet, and the organization keeps the accuracy and governance of its BI platform. Those two things have usually been a trade-off; wynSheets is designed so they are not.

Part of Your Wider Wyn Ecosystem 

Analysis in wynSheets does not sit in isolation. Teams can collaborate on the same Sheet in real time and share insights the way they would share a document. For example, you can work on what-if analysis together with your team members at the same time. You can visually see what other team members are accessing and updating in real-time while you work on your analysis.

More importantly, a wynSheets table can feed directly back into Wyn as a live data source, so your work, as an analyst, in a Sheet can become part of the reports and dashboards everyone else uses. The spreadsheet thus becomes part of the data ecosystem rather than a dead end at the edge of it, which helps teams avoid the data silos that ad-hoc exports usually create.

Where wynSheets Fits: Last-Mile Analytics 

wynSheets is built for the last mile of business intelligence, the point where trusted data turns into a real decision. That covers a lot of everyday work: building a Profit and Loss (P&L) analysis or financial model on a governed dataset, running ad-hoc calculations without exporting anything, modeling different business scenarios, exploring data to find a pattern, and sharing the result in a format every stakeholder already reads. Wherever BI provides the trusted data and a spreadsheet provides the flexibility, wynSheets connects the two.

Get Started with wynSheets 

wynSheets is available with Wyn Enterprise v9.1. It brings governed BI data and the flexibility of a spreadsheet into one place, so your team can move from data to decision without the exports, the stale files, and the manual rework in between.

For a closer look at capabilities, sample use cases, and how wynSheets fits into your deployment, visit the wynSheets product page .

Request a Personalized Demo of Wyn Enterprise

Part of the Wyn Enterprise v9.1 release:

Wyn Enterprise Server v9.1 – What’s New
WynDashboards v9.1 – What’s New
WynReports v9.1 – What’s New
WynNotebooks v9.1 – What’s New
Introduction to wynSmartDocs

Bhupesh Malhotra

Bhupesh is a Global Product Manager at wynEnterprise. He loves to tell the story behind data through data visualization techniques. He likes to hear from customers and talk about their experiences with reporting and analytics. When he isn’t thinking about data, he spends time with his family and enjoys traveling to new places with them. You can connect with Bhupesh on Twitter