> ## Documentation Index
> Fetch the complete documentation index at: https://university.gumloop.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Data Analyst Agent | Use Case Walkthroughs

> Build an agent that connects to your database, answers data questions on the spot, and automates reports for your team.

<div id="gumloop-auth" data-token={user?.accessToken || ''} data-email={user?.email || ''} style={{display: 'none'}} />

<div className="lesson-page">
  <div className="lesson-breadcrumb">
    <a href="/">University</a>

    <svg xmlns="http://www.w3.org/2000/svg" width="14" height="14" viewBox="0 0 24 24" fill="none" stroke="currentColor" strokeWidth="2" strokeLinecap="round" strokeLinejoin="round" className="chevron">
      <path d="m9 18 6-6-6-6" />
    </svg>

    <a href="/use-case/data-analyst-agent">Use Case Walkthroughs</a>

    <svg xmlns="http://www.w3.org/2000/svg" width="14" height="14" viewBox="0 0 24 24" fill="none" stroke="currentColor" strokeWidth="2" strokeLinecap="round" strokeLinejoin="round" className="chevron">
      <path d="m9 18 6-6-6-6" />
    </svg>

    <span className="current">Data Analyst Agent</span>
  </div>

  <div className="lesson-video">
    <div className="lesson-video-aspect">
      <iframe src="https://player.vimeo.com/video/1176029451?h=a30949a26e" allow="autoplay; fullscreen; picture-in-picture" allowFullScreen />
    </div>
  </div>

  <div className="lesson-transcript">
    <input type="checkbox" id="transcript-toggle" className="transcript-toggle" />

    <label htmlFor="transcript-toggle" className="transcript-header">Video transcript</label>

    <div className="lesson-transcript-body">
      <p>Imagine asking, "What is our cost of acquisition per channel?" Or, "Are high-usage customers more likely to stay on paid plans?" And just literally getting the answer. Let's build a data analyst agent.</p>
      <p>Creating a data analyst agent is surprisingly simple. We'll start by connecting our database. I'm going to use BigQuery, but you can use Snowflake, Salesforce, Airtable, whatever you consider a database. Then I'll authenticate it, and that's it.</p>
      <p>I can already ask my agent questions like, "What is our MRR growth over the last three months?" And our Gumloop agent will start exploring and analyzing our database. AI is exceptional at this type of work. And come back to us with an answer. This is a data analyst agent, and it's ready to go.</p>
      <p>Now, it's not the most efficient data analyst agent. If I look at the tool calls between my question and its answer, the agent is spending a lot of time and tokens and effort figuring out our database. It's listing all the tables, the schemas. It's going to do that in every conversation because agents have no memory. We can fix this by creating a skill, a reusable set of instructions so the agent knows what it's looking at, simply by asking, "Write me a skill about our BigQuery setup." It'll explore the tables, relationships, and write itself a guidebook on what it understood, which it can reuse in the next question or any agent can reuse.</p>
      <p>Here's that same question again. "What is our MRR growth over the last three months?" Notice how much more efficient it is. It started by reading its skill and instantly knew where to go.</p>
      <p>Two more tips to getting the most out of your data analyst agent. First, give it more tools. Let's give it Google Sheets so it can spit analysis out to a sheet or compare a forecast that lives in a spreadsheet to actual data in our database. Same with email, so it can automate reports for you with something like, "Every Friday at 9 a.m., send me a report of our revenue over the last week broken down per channel."</p>
      <p>Final tip, bring your agent into Slack so everyone can finally start asking the questions they've always wanted to. In fact, not ask questions, but get answers.</p>
    </div>
  </div>

  <div className="bta-overview">
    <h1 className="lesson-title">Data Analyst Agent</h1>
    <p className="bta-overview-value">Connect your database to a Gumloop agent so anyone on your team can ask data questions and get answers instantly.</p>

    <div className="bta-overview-row">
      <div className="bta-overview-item">
        <span className="bta-overview-label">Apps</span>

        <div className="bta-overview-apps">
          <div className="bta-app"><img src="https://mintcdn.com/gumloop_university/C7D4vwrU0ikATMuv/images/logos/bigquery.png?fit=max&auto=format&n=C7D4vwrU0ikATMuv&q=85&s=fd530bfe8341aab27221af37472e9d15" alt="BigQuery" width="512" height="512" data-path="images/logos/bigquery.png" /><span>BigQuery</span></div>
          <div className="bta-app"><img src="https://mintcdn.com/gumloop_university/C7D4vwrU0ikATMuv/images/logos/gsheets.png?fit=max&auto=format&n=C7D4vwrU0ikATMuv&q=85&s=2af2d24a8cd0cd55efdd439f08e3b0fa" alt="Google Sheets" width="512" height="512" data-path="images/logos/gsheets.png" /><span>Google Sheets</span></div>
          <div className="bta-app"><img src="https://mintcdn.com/gumloop_university/C7D4vwrU0ikATMuv/images/logos/gmail.png?fit=max&auto=format&n=C7D4vwrU0ikATMuv&q=85&s=32b41d36a5b826f73848358401bac2cc" alt="Gmail" width="4000" height="4000" data-path="images/logos/gmail.png" /><span>Gmail</span></div>
        </div>
      </div>
    </div>
  </div>

  <div className="bta-step">
    <div className="bta-step-header">
      <span className="bta-step-num">1</span>
      <h2 className="bta-step-title">Create an agent and connect your database</h2>

      <input type="checkbox" className="bta-step-check" />
    </div>

    <div className="bta-step-body">
      Connect the database where your data lives.

      <div className="bta-overview-apps" style={{marginTop: '12px'}}>
        <div className="bta-app"><img src="https://mintcdn.com/gumloop_university/C7D4vwrU0ikATMuv/images/logos/bigquery.png?fit=max&auto=format&n=C7D4vwrU0ikATMuv&q=85&s=fd530bfe8341aab27221af37472e9d15" alt="BigQuery" width="512" height="512" data-path="images/logos/bigquery.png" /><span>BigQuery</span></div>
        <div className="bta-app"><img src="https://mintcdn.com/gumloop_university/C7D4vwrU0ikATMuv/images/logos/snowflake.png?fit=max&auto=format&n=C7D4vwrU0ikATMuv&q=85&s=4767654fc677d79be8ceb88fbb0465c0" alt="Snowflake" width="200" height="200" data-path="images/logos/snowflake.png" /><span>Snowflake</span></div>
        <div className="bta-app"><img src="https://mintcdn.com/gumloop_university/C7D4vwrU0ikATMuv/images/logos/airtable.png?fit=max&auto=format&n=C7D4vwrU0ikATMuv&q=85&s=855986add1a4c516aca3a46ae3d32eef" alt="Airtable" width="256" height="256" data-path="images/logos/airtable.png" /><span>Airtable</span></div>
        <div className="bta-app"><img src="https://mintcdn.com/gumloop_university/C7D4vwrU0ikATMuv/images/logos/salesforce.png?fit=max&auto=format&n=C7D4vwrU0ikATMuv&q=85&s=2de4eaa25cc5a4ea79c9739e4fb223bd" alt="Salesforce" width="256" height="256" data-path="images/logos/salesforce.png" /><span>Salesforce</span></div>
      </div>

      <a href="https://www.gumloop.com/agents" target="_blank" className="lesson-try-link">Create an agent <svg xmlns="http://www.w3.org/2000/svg" width="14" height="14" viewBox="0 0 24 24" fill="none" stroke="currentColor" strokeWidth="2" strokeLinecap="round" strokeLinejoin="round"><path d="M7 17L17 7" /><path d="M7 7h10v10" /></svg></a>
    </div>
  </div>

  <div className="bta-step">
    <div className="bta-step-header">
      <span className="bta-step-num">2</span>
      <h2 className="bta-step-title">Start asking your agent questions</h2>

      <input type="checkbox" className="bta-step-check" />
    </div>

    <div className="bta-step-body">
      Just by connecting your tools, you can already use your agent. Ask it anything about your data and it will explore your database and come back with an answer.

      > What is our MRR over the last 3 months?
    </div>
  </div>

  <div className="bta-step">
    <div className="bta-step-header">
      <span className="bta-step-num">3</span>
      <h2 className="bta-step-title">Create a skill</h2>

      <input type="checkbox" className="bta-step-check" />
    </div>

    <div className="bta-step-body">
      Your agent will be drastically more performant if it writes itself a skill with instructions on how your database is structured.

      > Write a skill on how our BigQuery is structured

      <img src="https://mintcdn.com/gumloop_university/C7D4vwrU0ikATMuv/images/skills-demo.gif?s=0729761a97496f64d94a0c6765e94bd9" alt="Creating a skill in Gumloop" style={{maxWidth: '100%', borderRadius: '12px', margin: '16px 0 0'}} width="2560" height="1440" data-path="images/skills-demo.gif" />
    </div>
  </div>

  <div className="bta-step">
    <div className="bta-step-header">
      <span className="bta-step-num">4</span>
      <h2 className="bta-step-title">Add more tools</h2>

      <input type="checkbox" className="bta-step-check" />
    </div>

    <div className="bta-step-body">
      Your agent can do so much more than just answer questions. Add in other tools your team relies on.

      <div className="bta-overview-apps" style={{marginTop: '12px'}}>
        <div className="bta-app"><img src="https://mintcdn.com/gumloop_university/C7D4vwrU0ikATMuv/images/logos/gsheets.png?fit=max&auto=format&n=C7D4vwrU0ikATMuv&q=85&s=2af2d24a8cd0cd55efdd439f08e3b0fa" alt="Google Sheets" width="512" height="512" data-path="images/logos/gsheets.png" /><span>Sheets</span></div>
        <div className="bta-app"><img src="https://mintcdn.com/gumloop_university/C7D4vwrU0ikATMuv/images/logos/gmail.png?fit=max&auto=format&n=C7D4vwrU0ikATMuv&q=85&s=32b41d36a5b826f73848358401bac2cc" alt="Gmail" width="4000" height="4000" data-path="images/logos/gmail.png" /><span>Gmail</span></div>
        <div className="bta-app"><img src="https://mintcdn.com/gumloop_university/C7D4vwrU0ikATMuv/images/logos/asana.png?fit=max&auto=format&n=C7D4vwrU0ikATMuv&q=85&s=bbf601f6e0065a5e27e42c95792bff42" alt="Asana" width="512" height="512" data-path="images/logos/asana.png" /><span>Asana</span></div>
        <div className="bta-app"><img src="https://mintcdn.com/gumloop_university/C7D4vwrU0ikATMuv/images/logos/linear.png?fit=max&auto=format&n=C7D4vwrU0ikATMuv&q=85&s=e839bdc9fdb7ba8bd6dd01d55e56eb0b" alt="Linear" width="800" height="800" data-path="images/logos/linear.png" /><span>Linear</span></div>
      </div>
    </div>
  </div>

  <div className="bta-step">
    <div className="bta-step-header">
      <span className="bta-step-num">5</span>
      <h2 className="bta-step-title">Bring your agent to Slack</h2>

      <input type="checkbox" className="bta-step-check" />
    </div>

    <div className="bta-step-body">
      Give everyone on your team the power of getting answers instantly by bringing your agent into Slack.
    </div>
  </div>

  <div className="lesson-nav-grid">
    <div className="lesson-nav-spacer" />

    <a href="/use-case/crm-agent" className="lesson-nav-card lesson-nav-next">
      <span className="nav-label">
        Next

        <svg xmlns="http://www.w3.org/2000/svg" width="14" height="14" viewBox="0 0 24 24" fill="none" stroke="currentColor" strokeWidth="2" strokeLinecap="round" strokeLinejoin="round">
          <path d="M5 12h14" />

          <path d="m12 5 7 7-7 7" />
        </svg>
      </span>

      <span className="nav-title">CRM Agent</span>
    </a>
  </div>
</div>