Arcwise Documentation
English
English
  • 👋Welcome to Arcwise!
  • 📘Arcwise setup
    • ⚙ïļUser & Role Management
    • 🌐Add to Google Workspace
    • 🔌Connect Data Warehouse
      • ðŸ“ŦArcwise Fixed IP Address
      • ❄ïļSnowflake
      • 🔍BigQuery
      • 🐘Postgres
      • ðŸ§ąDatabricks
      • ðŸŠķAthena
      • ðŸŠĢS3
    • ðŸ’ŧConnecting data tools
      • 🎆Connect to dbt
      • 🔎Connect to Looker
      • 🧊Connect to Cube
    • 📜Audit logging
    • ☁ïļIntegrations
      • Overview
      • Hubspot
      • Salesforce
    • ❔FAQ
  • 🔐Google Login Errors
  • 📜Product Changelog
  • Connecting data
    • âœĻConnecting Data
    • ðŸ’ŋData Warehouse
    • ⮆ïļUploading CSV Files
    • ðŸ”ĻImporting Data from Other Tools
    • ðŸĪ–Selecting Spreadsheet Data for AI Analysis
  • Using Arcwise in sheets
    • â–ķïļArcwise Connected Data
      • Adding Columns
      • Filtering
      • Sorting
    • 🗃ïļWorking With Large Data
    • 🧊Using Formulas in Sheets
    • 🟰Supported Formulas
    • 📊Pivot Tables
    • 📉Creating Manual Visualizations
  • Using Arcwise AI Analyst
    • ðŸĪ–AI Analyst Overview
    • ❇ïļUsing AI Analyst in Sheets
    • 📂Getting Data Using AI
    • 📈Creating a Visual
    • ðŸ’ĄGenerating an Insight
    • 📃Using AI Analyst on Spreadsheet Data
    • Embedding the AI Analyst Chat
  • Using Arcwise AI Formulas
    • ðŸĪ–GPT Formulas Overview
    • ✔ïļGPT Formula Basics
    • 📖GPT Formula Reference
Powered by GitBook
On this page
  1. Using Arcwise AI Analyst

Generating an Insight

PreviousCreating a VisualNextUsing AI Analyst on Spreadsheet Data

Last updated 1 year ago

Arcwise AI analyst is uniquely design to generate data based insights. Insights can help answer questions like:

  • Why was there a sales spike in July?

  • Why were shipments delayed yesterday?

  • What factors led to the increase in inbound last week?

Arcwise can help do the analysis so that the user can get answers. Arcwise doesn't have all of the business context and can't draw conclusions but it can search the data it has access to for possible causes.

Arcwise is best able to generate insights after information has been added to the AI context. Without business specific context the AI will be less focused and may not have the proper information to get to a root cause analysis.

Arcwise can only leverage data is has access to. This may or may not include data in your data warehouse. Ask your administrator what Arcwise has access to.

To ensure Arcwise has access to some specific piece of data you can always connect it to the sheet: Connecting data.

Case Study

We start with a data set from Salesforce that contains all of our deals. We want to track the total value of closed deals over time. We can get this information from the AI analyst.

show me total deal size over time by month for 2022

We see there is a very large spike in July and now we would like to know why. This is where we need to generate some kind of insight about what happened in July. We can ask for some insight.

explain the spike in july

This will prompt the AI to look for relevant data that could lead to an explanation. In this case it looks at 4 related metrics to help explain the situation, visualizes those metrics, and provides a text summary of the data.

From these results we can see that there was a much larger deal size for Direct Traffic and also that the average deal size was much higher. We can continue asking questions to further refine this insight.

ðŸ’Ą
Deal sizes were much larger for Direct Traffic
A summary of findings