Jira apps
Advanced Reports (Jira)
Welcome Email - Advanced Reports

Advanced Reports LogoWelcome to Advanced Reports! 🚀

Subject: Welcome to Advanced Reports - Unlock Powerful Jira Insights with SQL

Hi there! 👋

Welcome to Advanced Reports - you've just unlocked the power to create sophisticated, custom reports from your Jira data using SQL, powered by high-performance data processing.

🎯 What You Can Do Right Now

Advanced Reports goes far beyond basic Jira dashboards. Here's what makes it special:

  • 🔒 100% Secure: Process data locally in your browser (Standard Edition) or in a secure, dedicated cloud database (Advanced Edition)
  • ⚡ SQL Power: Move beyond JQL limitations with full SQL capabilities
  • 🤖 AI-Powered: Generate complex SQL queries from plain natural language prompts.
  • 📊 Rich Visualizations: Create beautiful reports with charts, tables, and metrics
  • 🔄 Dynamic Updates: Reports automatically refresh with your latest Jira data
  • 📈 Historical Analysis: Track trends over time with work item history

🚀 Quick Start Guide

1. Access Your Dashboard

Navigate to Apps → Advanced Reports in your Jira main menu to get started.

2. Generate Insights with AI (or Use Our Examples)

Basic Work Item Analysis:

You can ask our AI Query Generator:

"Count work items by status, ordered from most to least."

Or use this SQL directly:

SELECT status, COUNT(*) AS work_item_count
FROM work_items_display
GROUP BY status
ORDER BY work_item_count DESC;

Team Performance Overview:

You can ask our AI Query Generator:

"Show me each team member's total assigned items and their completion rate. Order by who has the most items."

Or use this SQL directly:

SELECT 
    assignee,
    COUNT(*) as total_items,
    AVG(CASE WHEN status = 'Done' THEN 1 ELSE 0 END) as completion_rate
FROM work_items_display
WHERE assignee IS NOT NULL
GROUP BY assignee
ORDER BY total_items DESC;

3. Create Your First Report

  • Start with a Insight to extract the data you need with SQL query and visualisations
  • Export Insight results as CSV or Parquet files
  • Build a Report to visualize and present your findings
  • Export to Reports as PDFs

💡 Popular Use Cases

  • Sprint Velocity Analysis: Track team performance over time
  • Cycle Time Metrics: Understand how long work stays in each status
  • Team Workload Distribution: See who's handling what
  • Custom KPIs: Create metrics specific to your workflow
  • Historical Trends: Analyze patterns and improvements

🛠️ Need Help Getting Started?

🔥 Pro Tips

  1. Start Simple: Begin with basic queries before diving into complex joins
  2. Use Parameters: Make your queries reusable with dynamic parameters
  3. Include History: Enable changelog data for time-based analysis
  4. Upload Custom Data: Import CSV files to enrich your analysis (team lists, holidays, etc.)

🎁 What's Next?

Your Advanced Reports app is ready to transform how you analyze Jira data. Start with one of the example queries above, or dive into creating a custom report for your team's specific needs.

We're excited to see what insights you'll uncover!

Happy reporting! 📊

P.S. Have questions or want to share what you're building? We'd love to hear from you! Just reply to this email.

Advanced Reports - Powerful SQL reporting for Jira, built for teams who need more than basic dashboards.

SupportIntroduction