DEV Community: EverNext Solutions

How to Create a WordPress Dashboard Without Code (Step-by-Step)

EverNext Solutions — Fri, 24 Apr 2026 01:47:53 +0000

You want a dashboard. Revenue charts, customer counts, inventory levels, KPI cards — all on one screen, automatically updated, accessible from your WordPress site.

The problem? You're not a developer, and enterprise BI tools cost thousands per year.

This tutorial shows you how to build custom dashboards in WordPress without writing a single line of code.

What We're Building

By the end of this tutorial, you'll have:

A KPI card showing total revenue
A line chart tracking sales over time
A bar chart comparing product categories
A data table with order details
A date range filter that updates all charts

What You'll Need

WordPress 5.8 or higher
A reporting plugin that supports dashboards (we'll use EverNext Reporting)
Access to your data source (database, or the plugin's sample data)

Step 1: Install the Plugin

Go to Plugins → Add New in WordPress admin
Search for "EverNext Reporting"
Click Install Now, then Activate
You'll see a new EverNext Reporting menu item in your admin sidebar

Step 2: Connect Your Data Source

Option A: Connect to Your Database

Go to EverNext Reporting → Connections
Click Add New Connection
Enter your database details (host, port, database name, username, password)
Click Test Connection
Save the connection

Option B: Use Sample Data

Don't have a database ready? Sample datasets are available in the report builder so you can follow along.

Step 3: Create Your First Report (KPI Card)

Let's start with a simple KPI card showing total revenue.

Go to EverNext Reporting → Reports → Add New
Name it "Total Revenue"
Select your data connection
In the Visual Query Builder:
- Select the orders table
- Choose the amount column
- Set aggregation to SUM
Under Chart Type, select KPI Card
Configure: Label "Total Revenue", Prefix "$", Format with commas
Preview and save

Result: A KPI card showing your total revenue as a single big number.

Step 4: Create a Line Chart (Sales Over Time)

Line charts are perfect for trends.

Create a new report: "Sales Trend"
In the Visual Query Builder:
- Select orders table
- Choose order_date and amount
- Group by order_date
- Set amount aggregation to SUM
Select Line Chart as the chart type
Map axes: X = order_date, Y = amount (sum)
Preview and save

Step 5: Create a Bar Chart (Category Comparison)

Bar charts are great for comparing categories.

Create a new report: "Revenue by Category"
Query setup:
- Select category and amount
- Group by category
- SUM the amount
- Sort by amount descending
Select Bar Chart
Preview and save

Step 6: Create a Data Table (Order Details)

Sometimes you need to see the raw data.

Create a new report: "Recent Orders"
Select columns: order_id, customer_name, product, amount, order_date, status
Sort by order_date DESC
Limit to 100 rows
Select Data Table as the chart type
Enable: Search box, Column sorting, Pagination, Export to CSV/Excel
Preview and save

Step 7: Build the Dashboard

Now combine all four reports into a single dashboard.

Go to EverNext Reporting → Dashboards → Add New
Name it "Sales Dashboard"
Drag reports onto the canvas:
- Total Revenue KPI card at the top
- Sales Trend line chart next to it
- Revenue by Category bar chart below
- Recent Orders table at the bottom (full width)
Resize and rearrange as needed

Layout Tips

Put KPI cards in a row at the top
Use full-width for data tables
Group related charts together
Leave some white space

Step 8: Add a Global Filter

Global filters apply to every report on the dashboard.

In the dashboard editor, click Add Filter
Select Date Range filter type
Choose the date column (e.g., order_date)
Set default range (e.g., "Last 30 days")
Save

Now when users select a date range, every chart updates automatically.

Step 9: Embed on Your Site

Dashboards can be embedded anywhere using shortcodes.

Copy the dashboard shortcode from the editor
Paste into any page or post
Publish

[evernext_dashboard id="1"]

The dashboard renders with all interactive features — filters, sorting, export buttons.

Step 10: Set Up Auto-Refresh (Optional)

For dashboards on wall-mounted screens:

In dashboard settings, find Auto-Refresh
Set the interval (e.g., every 5 minutes)
Save

Real-World Dashboard Examples

Sales Dashboard: Revenue KPIs, trends, top products, orders, rep leaderboard
Inventory Dashboard: Stock levels, low stock alerts, inventory value
Customer Portal: Order history, account balance, personalized per user
Operations Monitor: Real-time order status, shipping, warehouse throughput

Common Questions

Can I control who sees the dashboard?

Yes. Set visibility to public, logged-in users only, or specific roles. Filter data so users only see their own records.

Will this slow down my site?

Dashboards only load data when viewed. Enable caching for frequently-accessed dashboards.

Can I schedule email reports?

Yes. Schedule any report or dashboard to be emailed automatically with Excel attachments.

What if my data is in multiple databases?

EverNext Reporting supports multi-source joins — combine data from different databases in one report.

Conclusion

Building dashboards in WordPress doesn't require coding or expensive BI tools. With the right plugin, you can connect your data, build visualizations, and create interactive dashboards in an afternoon.

Start simple — one KPI, one chart — and build from there.

Get started with EverNext Reporting and build your first dashboard today.

Originally published at evernextsolutions.com

7 Best WordPress Reporting Plugins in 2026 (Compared)

EverNext Solutions — Fri, 24 Apr 2026 01:47:21 +0000

Need to display data, build charts, or create dashboards in WordPress? There's no shortage of plugins claiming to do the job. But they're not all built for the same use cases.

Some excel at simple tables. Others focus on WooCommerce analytics. A few can connect to external databases. And the pricing ranges from free to hundreds per year.

We tested the most popular WordPress reporting plugins to help you pick the right one.

Quick Summary

Best for external databases: EverNext Reporting
Best for simple tables: TablePress
Best for WooCommerce: WooCommerce Analytics (built-in)
Best for Google Sheets: Visualizer
Best all-around (with budget): wpDataTables

1. EverNext Reporting

Best for: Connecting to external MySQL, MariaDB, or PostgreSQL databases and building reports without code.

EverNext Reporting is designed specifically for businesses that need to report on data living outside WordPress.

Key Features

Visual query builder — no SQL required
14 chart types (bar, line, pie, gauge, KPI cards, data tables)
Multi-source joins — combine data from two different databases
Dashboard builder with drag-and-drop grid layout
Scheduled email reports (hourly, daily, weekly, monthly)
AES-256 encryption for database credentials

Pricing

Free version on WordPress.org. Pro version for PostgreSQL, email scheduling, and advanced features.

Best For

Businesses with data in external databases (CRM, ERP, inventory) who want reports without coding or expensive BI tools.

2. wpDataTables

Best for: Feature-rich tables and charts with multiple data source options.

wpDataTables is one of the most established WordPress table plugins. It supports MySQL queries, Excel/CSV imports, Google Sheets, and manual data entry.

Key Features

Multiple data sources (MySQL, Excel, CSV, Google Sheets, JSON)
Responsive tables with sorting, filtering, pagination
Chart engine with multiple chart types
Conditional formatting
Frontend editing

Limitations

MySQL queries only connect to WordPress database by default
No visual query builder — write SQL manually
No PostgreSQL support
No scheduled email reports

Pricing

Starts at $69/year for a single site.

3. TablePress

Best for: Simple, static tables without database connections.

TablePress is the most popular WordPress table plugin with over 800,000 active installations. It's free, simple, and works well for manually-entered data.

Key Features

Spreadsheet-style table editor
Import from Excel, CSV, HTML, JSON
Sorting, pagination, and search
Completely free (core plugin)

Limitations

No database connections
No charts or visualizations
Tables are static (won't auto-update)

Pricing

Free. Premium extensions available.

4. Visualizer

Best for: Charts from Google Sheets or manual data entry.

Visualizer by Themeisle focuses on charts powered by Google Charts. Good option if your data lives in Google Sheets.

Key Features

15+ chart types (Google Charts library)
Import from Google Sheets, CSV, or manual entry
Responsive and interactive charts
Gutenberg block support

Limitations

No direct database connections
Requires Google Sheets as intermediary
Limited dashboard capabilities

Pricing

Free version available. Pro starts at $99/year.

5. Data Tables Generator by Supsystic

Best for: Large datasets with server-side processing.

Handles large tables well thanks to server-side processing. Solid choice for displaying thousands of rows.

Key Features

Server-side processing for large datasets
Import from CSV, Excel, Google Sheets
Conditional formatting
WooCommerce integration

Limitations

No external database connections
Limited chart options

Pricing

Free version available. Pro starts at $49.

6. WooCommerce Analytics (Built-in)

Best for: WooCommerce store owners who need sales and order reports.

If you're running WooCommerce, the built-in analytics might be all you need.

Key Features

Pre-built sales and order reports
Date range comparisons
Product and category analytics
CSV export

Limitations

Only reports on WooCommerce data
Can't connect to external databases
Limited customization

Pricing

Free (included with WooCommerce).

7. Jetstark Smart Charts

Best for: Quick charts from JetEngine or simple data sources.

Works well if you're already using JetEngine for custom post types and fields.

Key Features

Integration with JetEngine
Multiple chart types
Elementor and Gutenberg support

Limitations

Best suited for JetEngine users
No external database connections

Pricing

Included with Jetstark All-Inclusive ($199/year).

Comparison Table

Plugin	External DB	PostgreSQL	Visual Builder	Dashboards	Email Reports	Free Tier
EverNext Reporting	✅	✅	✅	✅	✅	✅
wpDataTables	Limited	❌	❌	❌	❌	❌
TablePress	❌	❌	❌	❌	❌	✅
Visualizer	❌	❌	❌	❌	❌	✅
Supsystic	❌	❌	❌	❌	❌	✅
WooCommerce	❌	❌	❌	Basic	❌	✅
Smart Charts	❌	❌	❌	❌	❌	❌

Which Plugin Should You Choose?

Data in external databases? → EverNext Reporting

Simple static tables? → TablePress (free)

Data in Google Sheets? → Visualizer

WooCommerce reports only? → Built-in WooCommerce Analytics

Maximum features + know SQL? → wpDataTables

Conclusion

The "best" plugin depends on where your data lives and how technical you want to get.

For businesses with data outside WordPress, EverNext Reporting fills a gap others don't — direct database connections with a visual builder anyone can use.

For simple tables, TablePress is hard to beat. And if you're in the Woo ecosystem, the built-in analytics might be enough.

Originally published at evernextsolutions.com

How to Connect WordPress to an External Database (MySQL, PostgreSQL)

EverNext Solutions — Fri, 24 Apr 2026 01:41:46 +0000

WordPress stores its data in a MySQL database — posts, pages, users, settings. But what if your business data lives somewhere else? Maybe you have a CRM running on a separate MySQL server, inventory in PostgreSQL, or a custom application with its own database.

This guide covers three methods to connect WordPress to external databases.

Why Connect to an External Database?

Common use cases:

Business reporting — Display sales data, inventory levels, or customer metrics on your WordPress dashboard
Data portals — Let customers or partners view their own data through your WordPress site
Legacy system integration — Connect to existing databases without migrating data
Multi-system dashboards — Combine data from CRM, ERP, and other systems in one place

The key challenge: WordPress doesn't natively support connecting to external databases. The built-in $wpdb object only connects to your WordPress database.

Method 1: Custom PHP Code (PDO)

PDO (PHP Data Objects) is the modern way to connect to databases in PHP. It supports MySQL, PostgreSQL, SQLite, and more.

<?php
function get_external_db_connection() {
    static $pdo = null;

    if ($pdo === null) {
        try {
            $pdo = new PDO(
                'mysql:host=your-server.com;dbname=your_database;charset=utf8mb4',
                'username',
                'password',
                [
                    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
                    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
                ]
            );
        } catch (PDOException $e) {
            error_log('External DB connection failed: ' . $e->getMessage());
            return null;
        }
    }

    return $pdo;
}

function get_external_customers() {
    $pdo = get_external_db_connection();
    if (!$pdo) return [];

    $stmt = $pdo->query('SELECT * FROM customers ORDER BY created_at DESC LIMIT 100');
    return $stmt->fetchAll();
}

For PostgreSQL, change the DSN:

'pgsql:host=your-server.com;dbname=your_database'

Display Data with a Shortcode

function external_customers_shortcode() {
    $customers = get_external_customers();

    if (empty($customers)) {
        return '<p>No customers found.</p>';
    }

    $html = '<table><thead><tr>';
    $html .= '<th>Name</th><th>Email</th><th>Joined</th>';
    $html .= '</tr></thead><tbody>';

    foreach ($customers as $customer) {
        $html .= sprintf(
            '<tr><td>%s</td><td>%s</td><td>%s</td></tr>',
            esc_html($customer['name']),
            esc_html($customer['email']),
            esc_html($customer['created_at'])
        );
    }

    $html .= '</tbody></table>';
    return $html;
}
add_shortcode('external_customers', 'external_customers_shortcode');

Pros: Complete control, no plugin dependencies
Cons: Requires PHP knowledge, you handle security, maintenance burden

Method 2: Use a Reporting Plugin (No Code)

If you want external database connections without writing code, a WordPress reporting plugin handles the complexity:

Visual query builder
Multiple database type support
Charts and visualizations
Built-in security (encrypted credentials, SQL injection prevention)

EverNext Reporting is designed for this. Connect to MySQL, MariaDB, or PostgreSQL, build queries visually or with SQL, and embed reports anywhere with shortcodes.

Pros: No coding, visual builder, built-in security, charts included
Cons: Plugin dependency

Method 3: REST API Integration

If your external system has a REST API, fetch data without a direct database connection:

function fetch_external_api_data() {
    $response = wp_remote_get('https://api.example.com/customers', [
        'headers' => [
            'Authorization' => 'Bearer YOUR_API_KEY',
        ],
        'timeout' => 30,
    ]);

    if (is_wp_error($response)) {
        return [];
    }

    $body = wp_remote_retrieve_body($response);
    return json_decode($body, true);
}

Security Best Practices

1. Use a Read-Only Database User

CREATE USER 'wordpress_reader'@'%' IDENTIFIED BY 'secure_password';
GRANT SELECT ON your_database.* TO 'wordpress_reader'@'%';

2. Use Prepared Statements

// WRONG - vulnerable to SQL injection
$pdo->query("SELECT * FROM users WHERE id = $user_id");

// CORRECT - safe
$stmt = $pdo->prepare("SELECT * FROM users WHERE id = ?");
$stmt->execute([$user_id]);

Which Method Should You Choose?

Custom PHP — Full control, for developers
Reporting plugin — No-code, with charts and dashboards
REST API — When direct database access isn't available

Originally published at evernextsolutions.com