Grafana: Complete Dashboards + Monitoring

Build an interactive Grafana dashboard by integrating a data source, formatting the data, and visualizing daily sales, best selling product, and monthly markets for a Latin America retail case study.

Explore the logic of sql queries in PostgreSQL, including select, from, where, and group by, with practical examples from a sales database for analysis in Grafana.

Open the query editor, write a select query for date, country, and revenue from the sales table, and filter by language = 'Spanish' to see Spanish-speaking countries.

Aggregate results in PostgreSQL using group by to sum revenue by country from the sales table, following select, from, and where syntax, for Grafana data sources.

Prepare a PostgreSQL database as a Grafana data source by setting up a cloud instance on Elephant SQL, creating the course database, building the sales table, and loading sample data.

Connect a PostgreSQL data source in Grafana Cloud and link an Elephant SQL database, configure host, database name, user, and password, then test the connection for dashboards.

Test the data source connection by saving and testing, as Grafana confirms the connection is working; in the next class, build dashboards and analytical reports with Grafana Cloud.

Create and organize Grafana interactive dashboards in Grafana Cloud, including folders, dashboards, and panels, and learn to save and access the sales results dashboard within a structured workflow.

Learn Grafana panel logic by selecting a time, a metric, and a value to analyze revenue; compare sales by product, country, or language and create dashboards.

Learn to create and save a Grafana panel, connect to a PostgreSQL data source, and configure time, product, and revenue variables to build charts for a dashboard.

Learn how to transform a daily revenue table into a consolidated per-day metric on a Grafana dashboard by editing a panel, adjusting the query, and applying a sum aggregation.

Disable the table view, switch to a time series chart of daily revenue in USD, and customize the panel with titles, legends, axes, and tooltips to reveal trends.

Explore building a revenue by product chart in Grafana by duplicating a panel, creating a table to sum revenue by product, and visualizing with a pie/donut chart in a dashboard.

Learn to analyze monthly revenue by country in Grafana, building a dashboard panel that compares months and segments revenue by country using bar charts.

Set up Grafana alerts to monitor daily revenue against a 180,000 threshold, assign a label, and configure notification policies for immediate alerts.

Configure Grafana alert notifications by setting up contact points and message templates, create notification policies with label matches, apply mute rules, and save the policy for automated alerts.