EIEIOTECHNOVATION
← Training programmes

EIEIO / AUTOMATION & EMERGING TECHNOLOGY

Grafana Dashboards and Reports

Course outline

2 days

Duration

2 days

What you will learn

  • Creating modern looking static or dynamic dashboards
  • Creating template reports and export as pdf
  • Setting up notations and alerts
  • Integrate Grafana with MySQL
  • Integrate Grafana with InfluxDb
  • Integrate Grafana with ElasticSearch
  • Integrate Grafana with SQL Server

Introduction

  • Setup Prometheus
  • Prometheus for the Windows User
  • Start Prometheus
  • Connect Prometheus to Grafana
  • Data Source Connection

Dashboards

  • Building DashBoards
  • Visualizing DashBoards

Variables

  • Intro to Variables
  • Building a variable
  • Interploation

Grafana Dashboard Efficiency

  • Annotations
  • KeyBoard ShortCuts
  • Are you quick enough?
  • DashBoard Folders
  • PlayList
  • Search
  • Sharing

Alerts

  • Configuration File
  • Create a Notification Channel
  • Create an Alert
  • Check the Alert
  • Alerting Test!
  • Intro to Slack Alerts
  • Slack alerting

Administration

  • Grafana CLI
  • Intro to PlugIns
  • Install your PlugIn
  • Use the PlugIn
  • Permissions
  • Add a user
  • Add a team
  • Add Users to the Team
  • Hierarchy of Permissions

Syncing up with a JSON DataScource

  • Install the Json Plug In
  • Install Python on the Mac(Optional)
  • Install Python on Windows(Optional)
  • Install Flask
  • The Custom Code behind the datasource
  • Running the Code
  • Final Testing

Installing and Configuring Grafana on Ubuntu

  • Installing Grafana on Ubuntu
  • Components Of Graphite
  • Installing and configuring Graphite on Ubuntu
  • Configuring Sampling Frequency and Retention Period
  • Installing StatsD on Ubuntu
  • Installing Graphite, and StatsD using Docker (Windows and Mac)
  • Sending Metrics to StatsD and Graphite

Using Grafana

  • The ShoeHub Global Company!
  • Adding Data Sources: Connecting to Graphite
  • Creating and Managing Dashboards
  • Using the Graph panel
  • Comparing a series of data with the same data in the past (time shift)
  • Using the Single Stat and Gauge Panels
  • More Advanced Graphs with the Gauge Panel
  • The All-New Bar Gauge and Pie Chart Panels
  • Variables and Dynamic Dashboards
  • Using the Heatmap panel
  • Annotations
  • Installing Plugins in Grafana
  • Raising Alerts
  • Notifications (via Email)
  • Configuring External Image Storage & Sending Notifications to Slack

Tips and Tricks

  • Increasing the visibility of data with logarithmic scaling
  • Monitoring Windows Serverrs with InfluxDB, Telegraf and Grafana

Integration with DataSources

  • Integration of Grafana with MySQL
  • Integration of Grafana with SQL Server (version 5.3 and above)
  • Integration of Grafana with Elasticsearch
  • Integration of Grafana with AWS Cloudwatch
  • Integration of Grafana with InfluxDB

Grafana reporter

  • Creating template reports
  • Export dashboard report as PDF

Programme scope, delivery arrangements and suitability are confirmed during enquiry.