Business Intelligence Dashboards Using Grafana Reporting

Create and organize a Grafana dashboard by cleaning the home view, saving notes, and moving dashboards into Adventure Works folders for later panel creation.

Create a simple table visualization in Grafana by adding a panel, selecting table, wiring a salesperson details query from SQL Server, and styling with color, background, and display options.

Create a stat visualization in Grafana, defining a metric and value for sales (average, total, minimum) from a SQL Server data source, then format with currency and style.

Create a gauge visualization in Grafana using a SQL Server data source to show the number of employees per department. Use sorting and thresholds to highlight departments on the dashboard.

Create a bar gauge panel in Grafana to show total sales by territory from Microsoft SQL Server, using currency units, retro LCD styling, and a save-and-resize dashboard workflow.

Create a Grafana bar chart panel showing the top 10 products by customer rating, with product names on the x-axis and ratings on the y-axis.

Create a time series visualization in Grafana to show employee growth over time, customize line style, fill, color, and hover details alongside top 10 product readings.

Create a pie chart panel in Grafana showing top 10 products by subcategory. Switch to donut, customize tooltips and legends (percent or value), hover for details, and save the dashboard.

Learn to build a geo map panel in Grafana to visualize sales by location using latitude and longitude, with dummy data, hover insights, and interactive zoom across the world.

Create teams and users, assign users to teams, and adjust roles so different departments view specific Grafana dashboards, all managed via the server admin panel.

Create marketing and engineering teams, then assign folder and dashboard permissions to teams rather than individual users, enabling role-based access within Gryffindor, with no code needed.

Assign users to Gryphon's engineering and marketing teams by adding members via the team dropdown and search, verify two members per team, and preview upcoming authorization controls.

Create two folders for marketing analytics and engineering application; set folder permissions so marketing can edit analytics while engineering can only view, with default viewer roles and team-based permissions.

Demonstrate role-based authorization by creating analytics and engineering Grafana dashboards and verifying view and edit permissions for engineering and marketing users.

Install third-party plugins by using the Gryffindor server on Windows, run a command line to install the Jason API data source, then restart the service and verify the new panel.

Manage dashboard versions by viewing history, restore points, and comparing versions to track changes. Export the JSON model, copy dashboards, and use variables to power reusable queries.