DBWillow Logo

Creating Dashboards

Introduction

This tutorial shows you how to create a dashboard in DBWillow to visualize your database data.

Creating Your First Dashboard

Step 1: Open Dashboards

  1. Connect to a database
  2. Click "Dashboards" tab
  3. Click "New Dashboard"
  4. Name it (e.g., "Sales Overview")

Step 2: Add Your First Widget

  1. Click "Add Widget"
  2. Select widget type (e.g., "Count")
  3. Configure the query

Step 3: Configure Widget

For a Count Widget:

SELECT COUNT(*) as total
FROM orders
WHERE status = 'completed';
  1. Enter SQL query
  2. Set widget title: "Total Orders"
  3. Choose refresh interval
  4. Click "Save"

Step 4: Add More Widgets

Repeat for additional widgets:

  • Line chart for sales over time
  • Bar chart for revenue by category
  • Table for top products

Using AI to Create Widgets (Premium)

Step 1: Open AI Assistant

  1. Click "AI Assistant" in dashboard
  2. Describe what you want

Step 2: Describe Widget

Examples:

  • "Show me total users as a big number"
  • "Display monthly sales as a line chart"
  • "Show revenue by category as a bar chart"

Step 3: AI Generates Widget

  1. AI creates SQL query
  2. Generates widget configuration
  3. Widget appears on dashboard
  4. Customize if needed

Widget Types

Count Widget

Single number display:

SELECT COUNT(*) as total_users
FROM users;

Line Chart

Trends over time:

SELECT 
  DATE(order_date) as date,
  SUM(total) as revenue
FROM orders
GROUP BY DATE(order_date)
ORDER BY date;

Bar Chart

Category comparison:

SELECT 
  category,
  SUM(revenue) as total
FROM sales
GROUP BY category;

Pie Chart

Proportions:

SELECT 
  status,
  COUNT(*) as count
FROM orders
GROUP BY status;

Table Widget

Detailed data:

SELECT 
  product_name,
  price,
  stock
FROM products
ORDER BY price DESC
LIMIT 10;

Organizing Your Dashboard

Layout

  • Drag widgets to rearrange
  • Resize by dragging corners
  • Create rows and columns
  • Layout saves automatically

Best Practices

  • Group related widgets
  • Use clear titles
  • Keep it focused
  • Make it scannable

Auto-Refresh

Setting Intervals

Configure widgets to refresh:

  1. Click widget settings
  2. Choose refresh interval:
    • 1 minute (real-time)
    • 5 minutes
    • 15 minutes
    • 1 hour
    • Manual

Use Cases

  • Real-time: Operations monitoring
  • Frequent: Business metrics
  • Hourly: Daily reports
  • Manual: Ad-hoc analysis

Next Steps