What is Scoop?
Introducing Scoop: the ultimate game-changer for business and data analysts! Scoop is the first data workbench designed for business people, letting you harness the value of your data, work with it and publish/share it to get the most out of it - all without requiring any database, SQL, infrastructure, data modeling or integration skills. Instead, Scoop substitutes the skills most familiar to business people - spreadsheets, and leverages AI to automatically produce customer/executive ready report presentations, and easily explore and analyze your data. Scoop breaks the trade-off between old-school BI with it's fragmented stack requiring engineering skills and investment to use, and spreadsheets which only offer point in time windows into small subsets of data and are intensely manual.
Scoop is revolutionary because:
- You can manipulate data and create datasets that up until now required extensive knowledge of databases and SQL. Scoop's spreadsheet data preparation is a breakthrough.
- Spreadsheets allow extremely complex multi-step calculations that users take for granted as they are so easy. Scoop lets you use that full power to shape and blend your datasets. Even the best handwritten SQL by detailed data teams struggle to match the power of spreadsheet data preparation.
- No-code solutions like visual data prep tools are extremely limited. Scoop breaks the choice between tinker-toy no-code products, and exceptionally complex database/SQL coding. If you know how to use a spreadsheet, you can outperform a SQL data team.
- Scoop produces the output you actually need - presentations and presentation-ready data stories. Scoop is a publication tool as well as a data tool. It lets you automate the production of your slides with live data and turns your slides into interactive data elements. You can automate the generation of any of your presentations, saving enormous amounts of time, and preventing costly mistakes and errors. And because Scoop is based on PowerPoint, the quality is executive/customer-ready. It will look fabulous.
- AI makes data far more easy to work with:
- Have AI build analyses for you in an instant that you can then adjust and explore
- Have AI create entire slide presentations to create a data narrative along with detailed explanations of content - taking reporting requirements that would take hours or days and doing them in minutes.
- Scoop's automated snapshots of all your data allow for unprecedented analysis of change. The automated snapshotting and the construction of snapshot change analysis tables allow you to analyze how your business does business - changes can be analyzed to see how you are performing. This is something built-in operational reporting cannot do, and no other business intelligence product does without extensive custom coding by experts.
Scoop blends innovation with familiarity. If you're comfortable with spreadsheets and slide presentations, you'll find Scoop incredibly intuitive. But here’s the twist: Scoop integrates these familiar tools with live data and a robust data analysis engine, without the need for a conventional data team. No SQL, databases, servers, or infrastructure required!
With a solid grasp of spreadsheets and formulas, you can blend datasets and create new calculations, unlocking the full potential of your data. And AI is fantastic at making that logic easy to create and BI easy to use. Dive into the future of data analysis with Scoop and transform the way you tell your data stories!
The Basic Scoop Workflow
Scoop data applications that are created from scratch follow a basic flow:
- Identify a data source - either an object from one of our api-connected applications, or a report in any source application that has the data one wants to analyze (reports can literally come from any application as Scoop reads the output content like a human would), and set it up for automatic ingestion
- If necessary, augment the dataset from that report with new columns and calculations using spreadsheet logic
- Create charts, tables, kpis and other visual summaries of that data using Scoop Explorer (or potentially do some ad hoc data exploration)
- Do that either by manually creating visualizations and summarizations or letting AI help you build individual ones
- You can also have AI build an entire data presentation for you that satisfies a business need, generating a full data story arc for you at the press of a button
- Drop those visualizations and summaries onto a Scoop Canvas for presentation (and potentially add interactivity to that canvas with prompts)
- Share that presentation with others
- If desired, pull aggregations from those datasets into your spreadsheets for further analysis
Additionally, users can create Scoop live worksheets, which are spreadsheets that can be connected to Scoop data and automatically refreshed and updated. Scoop can also leverage data in those live worksheets to present in canvases and even provide windows into those live worksheets on a canvas, allowing users to interactively change/update data in those live worksheets while using a canvas.
Workspaces
In Scoop, a Workspace is a container for a group of related datasets, analyses, charts, tables, live worksheets, canvases, etc. Datasets are added to a workspace, and users are granted access to a workspace. Users can then build charts, analyses, and data summaries on those datasets and display them on canvases. Those canvases can be shared with other workspace users and optionally with external users who may want to view the analysis on a canvas.
A new user to Scoop has two workspaces already defined for them:
- A sample workspace showing them a sample dataset, canvas and other Scoop items to play with
- An empty personal workspace ready to add new datasets and create new analysis
The very first time a user enters Scoop, they should start in the sample workspace, allowing them to tour the features and capabilities of Scoop. To change workspaces, simply select the desired workspace from the workspace selector in the upper left next to the Scoop logo.
Scooping Reports into Datasets
Scooping
Scoop revolutionizes access to business data by bypassing the need for traditional infrastructure like data warehouses and data lakes. It connects to your data sources, either APIs or reports, and automatically handles sophisticated dataset creation and management.
Either point it to an application API for automated data capture, or use a cutting-edge engine that mimics human interpretation to ingest data directly from human-ready reports output by any application.
Datasets and the Scoop Analytical Time Series Database
The datasets that underlie Scoop are stored in a powerful analytical time series database, that can be sliced, diced, filtered, modified, etc. far more flexibly than data in a spreadsheet alone. This allows users to work with far more data than would be feasible in a conventional spreadsheet, and to flexibly summarize and manipulate it, but doing so without requiring the enormous infrastructure typically involved in data warehousing.
Each report that is Scooped, is analyzed. Scoop then determines what columns are present in that report, what types of data are represented in those columns, the presentation formats of that data, and even how that data should be aggregated. Scoop then creates a unique dataset for each report. Each time a new report of the same type is provided to Scoop, the data from that report is added to the Scoop dataset. If new columns are added to the report in the future, Scoop will automatically add those new columns to the dataset if it makes sense without requiring any interventions from the user. See Understanding Scoop Datasets for more details on how Scoop intelligently accumulates and manages datasets.
Intelligent Data Snapshotting to Track Changes
There are two types of datasets that Scoop supports:
- Basic, transactional dataset: With this dataset type, essentially all rows in a source report are considered as unique items or transactions and just added to the dataset. This dataset intuitively just accumulates all rows in all the reports provided to Scoop.
- Intelligent snapshot dataset: This powerful dataset type is designed to allow the tracking of changes to items over time. Each report needs to have a column with a unique identifier for each item (e.g. sales opportunity id, marketing lead id, order number, service request ticket number, etc.). This is typically used with reports that are showing the status of certain business items (like leads or sales opportunities). Each report then becomes a snapshot in time and Scoop remembers all snapshots it has seen and then allows for powerful analysis of changes to those items over time. This kind of analysis is generally not possible in business applications and allows for very powerful insights into how processes behave.
When adding a new dataset, the user selects which type it is at the beginning, and Scoop then manages that dataset accordingly when it processes new reports.
Canvases
Canvases allow you to create live data stories based on your datasets. Unlike tools that use dashboards as a presentation concept, Scoop embraces a more modern user experience, broadening the idea of what it means to present data and tell a story. Dashboards are typically limited to charts, tables and analytical controls that, while functional, keep data in it's own place, separate from the conversation and business process.
Canvases, on the other hand, are designed for the broader purpose of including all the elements of data story telling, including descriptions, narratives, diagrams, and all of the elements of a modern presentation tool. In fact, Scoop can import the full designs of your Microsoft Powerpoint or Google Slides presentations as a backdrop for data. Those presentation canvases can be presented just as you would in a conventional presentation too. They can also be shared as live, interactive data applications, allowing data to be utilized far more widely in an organization (or even external to an organization). Also, you can synchronize your canvas presentation with Google Slides, allowing you to edit them there too.
The idea is to create a fully live and interactive data story that can be directly shared and communicated with other business professionals, embracing the full human element of presentation, but enriching it with powerful, interactive analytical and data content. In effect, with Scoop, one can build powerful data applications that can be delivered to any business constituency.
Canvases are, in effect, just that, a nearly infinite background to place content. A canvas can start completely bank, and one can place text, charts, tables, arrows, etc. on top in any arrangement desired. One can zoom in and zoom out to see the entire canvas. Additionally one can layer frames onto a canvas that facilitate presentations. When one switches to presentation mode, each frame becomes an interactive slide that can be shared. Importing a Microsoft PowerPoint slide deck into Scoop creates a frame for each slide, importing all the slide content. Users can then layer additional interactive Scoop elements on top of those slides to enrich them with live data.
Exploring Data and Creating Visual Summaries
Once a dataset has been created, one can explore the data in that dataset, producing a wide variety of highly styled charts and tables. These artifacts can then be saved and dropped onto a canvas at a later point. In Scoop Explorer, you can define KPIs that can be saved and re-used. KPIs are very powerful and allow one to control things like aggregations, time dimensions, prior period comparisons and other things to enable sophisticated calculates that can be re-used.
Scoop makes extensive use of theming. Saved themes allow one to have consistent formatting across a wide variety of elements. This includes colors, fonts, backgrounds, formatting options, etc. In fact, when Scoop imports a PowerPoint presentation, it automatically analyzes that presentation and intelligently creates a color theme that will match. The idea is to make your analysis extremely presentable, as well as powerful.
Synchronize with Google Slides Presentations
In addition to extending what you can do with spreadsheets, Scoop radically enables your presentations with live data as well. When Scoop ingests one of your presentations, it keeps a live copy in Google slides. When you make changes to the presentation in Google Slides, you can synchronize those changes back into Scoop, allowing you to use the full range of Slides' capabilities within Scoop. Additionally, any Scoop visualizations or summaries can be saved back into Google slides. This allows you to take that presentation anywhere, save it, print it or do whatever you might do with any normal slide presentation. In Scoop and presenting in Scoop leaves the visualizes live and drillable, while the visualizations in Slides are static and can be saved for historical record.
Spreadsheet Data Preparation
To fully work with data, one almost always needs to manipulate it. This may include creating new calculations based on the data in a source report, or even combining the data from two different datasets to create a new, third dataset. Traditionally, in the expensive and technical world of data warehousing, this involved extraordinarily complex tools and processes that required sophisticated training and specialized skill sets. This complexity typically required the setting up of some sort of analytical database to hold a data warehouse and extensive use of database tools to build and automate complex, technical logic, typically in a language like SQL or XML - the purview of data teams with deep backgrounds, but not most business users. Broadly, this process of data preparation has been an enormous barrier that has prevented broader use of data in organizations.
Scoop changes this dynamic, by allowing business users to leverage a skill set they already have, the spreadsheet, to manipulate and prepare data. In fact, Scoop has created an entirely new way to prepare data, called Spreadsheet Data Preparation. With Spreadsheet Data Preparation, users can use normal spreadsheet formulas, with the actual spreadsheets they normally use (like Google Sheets or Microsoft Excel), to create new calculations and to blend data from different datasets. Moreover, Scoop fully leverages the full power and flexibility of a spreadsheet, allowing one to put data anywhere, reference it, create side calculations, lookup tables, etc. Users do not have to sacrifice the immense flexibility of the spreadsheet, to use it in preparing data - meaning that Scoop is not only ridiculously easy to use and fast to get setup, but the types of calculations a business user can create can actually go beyond what a typical data team generally can implement because of the immense expressiveness of a spreadsheet - i.e. it's more powerful too.
Calculated Columns (adding new columns to an existing report dataset)
A source report for Scoop should have all the raw data elements that one needs. However, one might want to add a new column that leverages the raw report columns. For example one might like to:
- Combine first and last name into a full name
- Extract the year, month or day out of a date for some specific test
- Lookup a value in a reference table to enrich it (e.g. lookup a discount rate based on a code, or determine if a specific item needs manual adjustment because of an error)
- Bucket a number into categories for grouping (e.g. large, medium and small deal sizes)
These are all possible with Scoop's ability to create calculated fields. On can add calculations to any dataset that is based on raw data. By simply clicking on the calculated columns tab (as pictured above) after a dataset has been created, Scoop creates a new spreadsheet with a template for creating calculations. Scoop fills out one set of cells with values for each of the columns that are present in the original report. Scoop then creates another section where one can create new columns and add formulas to calculate them. Scoop progressively fills the source columns one row at a time from the raw source report, runs the calculations in the new columns row, and then adds the results of those calculations to the dataset. Any spreadsheet calculation can be specified (e.g. an VLOOKUP into table on another sheet), to provide immense power to the user. For more information see the section on Adding Calculated Columns
Blended Datasets (combining two datasets into a new one)
Calculated fields are very powerful, but blended datasets take Spreadsheet Data Preparation to another level, by allowing a user to take data from two different datasets and flexibly blend them together to create a new one. It builds on the concepts of calculated fields, but extends it to two different source datasets with some powerful abilities to control how that data is aggregated and filtered.
The basic building block for a blended dataset is a dataset query. Here Scoop allows the user to specify which columns from another dataset are to be leveraged for the blending. It also allows one to filter that dataset for specific values as well as to aggregate by columns in the query. A user can specify one query and use that by itself to create a new calculated dataset based on the aggregation of an initial one, or one can specify two queries, and create a new dataset based on the combination of those. To do the latter, one specifies a "blending condition". Scoop scans each record from each query and tests which combinations yield a TRUE for the blending condition. If that condition is TRUE, an output record is created in the blended dataset. Typical uses are to:
- Test whether a column in one query is equal to the column in another one and link based on that (i.e. a JOIN in the data world)
- Test whether some fuzzy condition is met and link based on that (some sort of lookup)
For more details on how to combine aggregated data from two datasets to create a new one, see Blending Two Datasets
Live Worksheets
Scoop augments the way you work. That includes what you can do with spreadsheets. In fact, Scoop tightly integrates with and extends your existing spreadsheets. Every spreadsheet element shown previously inside Scoop is backed by an actual cloud spreadsheet from Microsoft or Google. If you will notice in each of the prior two screenshots, there was a spreadsheet icon in the upper left of each of the spreadsheet elements. If you click on it, you would open up the actual Google Sheet that is behind this SheetLet. Scoop blends with your spreadsheet application very tightly. In addition to being able to read/utilize a Google Sheet directly, Scoop can populate a Google Sheet with live Scoop data. As such, the relationship between Scoop and Live Worksheets is bi-directional, Scoop can populate sheets, and it can treat them as data sources. Nothing else like this exists in the data world...
Notice the small Scoop logo on the right hand toolbar in Google Sheets right above the plus at the bottom. This triggers the Scoop Add On that facilitates bringing data into Google Sheets from Scoop. You need to add that add on from the Extensions menu item. And when you do, all data in Scoop is now available to data in your Google Sheets. See Installing Scoop Plugin for Google Sheets
Live Worksheets Populated with Scoop Data
Clicking on the Scoop for Sheets addon button in the side bar opens the plugin's main panel.
One can create new queries based on Scoop dataset data and Scoop will populate sheets in your workbook with the results of those queries.
You can also manually refresh the data in your worksheets or have Scoop do that for you automatically when a source dataset changes (e.g. every day when there is new data). See Dataset Queries for more info.
Scoop Leveraging Live Worksheets as a Data Source
Scoop can also leverage Live Worksheets directly as a datasource. If you supply Scoop a named range that has a proper table of data, Scoop will allow you to visuallize, aggregate and filter that data into expressive summaries. If that table is based on calculations, and those calculations are a function of canvas prompts, or values that are exposed in a Sheetlet (a spreadsheet window on a canvas), then those changes will update whatever chart or table analysis/summary in real time. This enables what-if type analysis in real time.
Insights and Advanced Analysis
In addition to helping users assemble datasets and produce analytical stories, Scoop has a powerful Insights engine that allows for deeper analysis of snapshot data. A key goal of a business analyst is to leverage data to understand what is working and what isn't working well in a process. Key questions often surface about how a process unfolds over time, where things move quickly or where they don't and where things tend to go sideways. Snapshot datasets provide a foundation for this type of insight. Each snapshot captures a picture of the current status of a set of objects, much like a single frame in a roll of movie film. By taking snapshots daily over a period of time, Scoop can replay that movie and help make a variety of very useful measurements that describe how that underlying process is performing or not performing.
Process Analysis
As mentioned above, Process Analysis plays back snapshot history and analyzes how a process evolves over time. Generally, each analysis is focused on a particular status item (e.g. sales stage for sales opportunities, or lead status for a lead). These business items can move through many different states throughout their lifetime and generally there is an ideal end-state (e.g. closed won for sales opportunities). The key is to understand how items move from state to state, how likely they are to go from any one state to another and how likely they are to ultimately wind up in a successful outcome.
With that as a goal, Scoop offers two types of visual analysis to explore processes - the process diagram and the Sankey chart. Both show how a process unfolds and provide different ways to explore that. A process diagram gives precise measurement of conversion rates from one state to another as well as cycle times (how long it takes to get to the next state, and/or to the final/successful state). The Sankey chart visually shows the proportions that move across different states and allows one to visualize how different groups move through several successive states. Both of these are based on snapshot datasets and both can be filtered for specific attributes (e.g. products, people or regions), or time periods to really help drill down into where processes are working well, and where they may be getting stuck.
To learn more see Process Analysis
Recipes
Everything above describes the various tools Scoop can bring to bear to create a solution. Users connect to datasets, build analysis and create data stories to help business people understand and make better decisions. Given that many businesses are often trying to analyze the same process and make the same decisions, Scoop has pre-created solutions for a number of use cases. These pre-built solutions are called Recipes. Like a meal recipe, they include ingredients that are the requirements to utilize them. Typically a recipe focuses on a specific business use case like:
- Sales forecasting
- Product usage analysis and customer value
- Marketing cost per lead
Instant Recipes
Instant recipes rely on a single data source and are able to be instantiated with a single click. Scoop will connect to your data, extract a dataset and map the recipe on top of it. You can set one up in less than a minute on your data and start playing with Scoop. Each recipe is built on top of a known dataset and there are potentially several recipes for the same dataset (you can add new ones and they will leverage the dataset you already have).
Multi-source Recipes
Multi-source recipes are more sophisticated and involve blending the data between two different sources. Scoop enables you to extract from your applications and setup best-practice analysis based on that with unprecedented ease.
For more information see Understanding Recipes
Updated 6 days ago