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
Update: We're Live on Product Hunt Saturday!
EverNext Reporting - the plugin used in this tutorial - is launching on Product Hunt this Saturday. If you found this guide helpful, I'd really appreciate an upvote.
Top comments (0)