Get in Touch
 Duration 14 hours

Course Outline

Introduction to WrenAI Spreadsheets and the Metrics Library

  • Overview of core capabilities and applicable use cases
  • Key distinctions from conventional spreadsheet tools
  • Familiarization with pre-existing metrics

Getting Started with AI-Enhanced Spreadsheets

  • Creating and styling spreadsheet layouts
  • Utilizing natural language to generate formulas and queries
  • Applying AI support for data preparation tasks

Utilizing the Metrics Library

  • Reviewing standardized KPIs across various departments
  • Configuring metrics for RevOps, finance, and marketing functions
  • Best practices for maintaining consistency and accuracy

Data Integration and Real-Time Updates

  • Linking spreadsheets to databases and SaaS applications
  • Streamlining data refresh intervals through automation
  • Overseeing permissions and access controls

Operational Reporting Workflows

  • Generating recurring reports using templates
  • Monitoring cross-departmental performance indicators
  • Automating alerts and notification systems

Data Visualization and Distribution

  • Building charts and dashboards directly from spreadsheets
  • Enabling real-time collaboration with team members
  • Sharing finalized reports with stakeholders

Scaling Operational Analytics

  • Implementing the metrics library across multiple business units
  • Standardizing reporting procedures across the enterprise
  • Integrating with current Business Intelligence (BI) platforms

Advanced Capabilities and Future Developments

  • Investigating AI-based forecasting within spreadsheets
  • Customizing and expanding the metrics library
  • Previewing upcoming features in WrenAI operational analytics

Recap and Future Actions

Requirements

  • Basic understanding of operational reporting principles
  • Proficiency in using spreadsheets
  • Knowledge of business metrics and KPIs

Target Audience

  • Revenue Operations (RevOps) teams
  • Finance operations teams
  • Marketing operations and Project Management Office (PMO) teams

Related Categories