English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 145 lectures (9h 29m) | 3.85 GB
Master Grafana 11: Data Visualization and Dynamic Dashboards for IT Professionals
Welcome to this course on Grafana, the leading tool for infrastructure monitoring, data visualization and dashboard creation.
This course is designed both for beginners who want to get started in the world of data visualization, and for professionals looking to deepen their knowledge in Grafana and improve their skills in creating advanced dashboards.
The course is based in version 11 of Grafana, released in April 2024.
This course is meticulously designed to guide, step by step and from scratch, any person or IT professional who wants to learn how to create visualizations and work with data analysis through the fundamentals and advanced techniques of Grafana, providing practical skills to transform raw data into actionable insights.
What will you learn?
- Introduction to Grafana: Understand the architecture of Grafana, its ecosystem, and its position in the world of data monitoring and analysis.
- Configuration and Customization: Learn how to install and configure Grafana, adapting it to your specific needs.
- Connect to Data Sources: Connect to various data sources such as Prometheus, InfluxDB and SQL databases, and understand how Grafana can read and process this data.
- Dashboard Creation: Develop skills to design intuitive and visually attractive dashboards that allow you to see your data correctly.
- Using Charts and Dashboards: Delve into the different types of charts and dashboards available in Grafana, and learn how to use them effectively.
- Dynamic Dashboards: Create dynamic dashboards with variables and other components
- Transformations: Transform your data to adapt it to your needs
- Alerts and Notifications: Set up alert systems to monitor your metrics and receive real-time notifications about critical events.
- Plugins- Add plugins to Grafana: datasources, panels and app plugins.
- Security: users, groups and permissions.
- And many more concepts
Table of Contents
Introduction
1 Introduction to the course
2 Course Content
3 Ratings
Introduction to Grafana
4 Introduction to observability
5 Introduction to Grafana
6 History of Grafana
7 Options for using Grafana
8 Grafana Play
9 Other Grafana products. Loki, Tempo, Mimir
Installing and starting Grafana
10 Download and installation. Options
11 Installation on Windows
12 Installation with package manager on Linux. Example with Ubuntu
13 Standalone installation in Linux
14 Install in Docker
15 Create an account in Grafana Cloud
16 Grafana directories and files
17 Configuration File
First Steps
18 Console Review Part 1
19 Console Review Part 2
20 What is a dashboard in grafana
21 Dashboard construction process
22 Create a dashboard with Grafana test data
23 Create our first Dashboard, Part 1. Load the plugin for CSV files
24 Create our first Dashboard, Part 2. Create the DataSource
25 Create our first Dashboard, Part 3. Create the Dashboard
26 Modify some graph properties
27 Add a panel to the Dashboard. Table Chart
28 Add a row
29 Folders
30 Practice. Creating a Dashboard with the 10 most populated countries
Time Series
31 Let’s talk about time series
32 Installing the Infinity connector for a JSON file. WEB server requests
33 Create a Time Series dashboard
34 Work with time ranges
35 Modify some graph properties
36 Practice. Control the number of calls from a CALL-CENTER
Prometheus and Grafana
37 Introduction to Prometheus
38 Prometheus architecture
39 Control a Linux server with Prometheus. Proposed architecture
40 Control a Linux server with Prometheus.Install Prometheus
41 Controlar un servidor Linux con Prometheus. Node Exporter
42 Integrate node exporter with Prometheus. Prometheus website
43 Control a Linux server with Prometheus. Integration with Grafana
44 Other panel options
45 Autorefresh
46 Add a query
47 An example with PromQL
48 Use indicator type graphics (Gauge). View used memory
49 Practical laboratory. Stress the machine’s memory
50 Add a second server (with Docker)
51 Label Filters
52 Use Bar Gauge type charts. See labels in the legend and other options
53 Import a ready-made dashboard
54 Practical laboratory. Set up a second Prometheus environment with Docker. Part 1
55 Practical laboratory. Set up a second Prometheus environment with Docker. Part 2
56 Practical laboratory. Set up a second Prometheus environment with Docker. Part 3
57 Using the Prometheus node-exporter image
58 Practice step by step. Docker environment with 2 prometheus servers and 4 nodes
59 Panels with different time frames
Hands-on lab with Windows
60 Practical laboratory. Monitor a Windows Server. Windows Exporter
61 Practical lab. Windows Exporter as a service
62 Import a Dashboard made to monitor Windows
Variables. Dynamic dashboards
63 Introduction to variables in Grafana
64 Custom type variables
65 Text Box Variables
66 Query variables
67 DataSource Variables
68 Interval variables
69 Add hoc variables
Other interesting components of our DashBoards
70 Tags
71 Dashboard Links
72 Panel links
73 Add information to our panels
74 Versions
75 Snapshots
76 Library Panels
77 Public Dashboards
78 Where can you see public dashboards
79 Inspecting a Panel
80 Explorer
Work with Databases. MySQL and Microsoft SQL Server
81 Introduction to MySQL Connectors
82 Create a container with MySQL database
83 Create a connection with the MySQL connector built into Grafana
84 Create a Bar Chart with a Query
85 STAT type graphics. Calculating the total units
86 Checking the space occupied by databases with a STAT graph
87 Histograms. Introduction
88 Example of a histogram
89 Prometheus and mysqld_exporter. Part 1. Download and start mysqld
90 Prometheus and mysqld_exporter. Part 2. Configure Prometheus with other job
91 Prometheus mysqld_exporter. Part 3. Work with Grafana
92 Import a ready-made MySQL Dashboard
93 Options to install a SqlServer
94 Create a Sqlserver docker container
95 Create a SQLServer with Amazon AWS if you don’t have one
96 An example with Microsoft SQL Server
97 Create a PIE chart
98 Practice. Create a MySQL dashboard
Transformations
99 Introduction to transformations
100 create a calculated field
101 Options for a transformation
102 Filter fields
103 Group by and Sort by
104 Filter by value and Convert fields
105 Grouping By Matrix Transformation with a STATE TIMELINE type graph
106 Practice with transformations
Alerts
107 Introduction to alerts
108 Review of the alerts screen
109 Create an alert Part 1
110 Create an alert Part 2
111 Testing the alert
112 Create an email contact point
113 Create a Notification Policy
114 Test an alert with the notification policy
115 Send the alert to a contact point directly
116 Create an alert from a panel
117 Another example of Contact Point Discord
118 Alert type chart
InfluxDB and Grafana
119 InfluxDb introduction
120 Download InfluxDB
121 Install InfluxDB
122 Install and configure Telegraf
123 A comment on InfluxDB versions and their languages
124 Create a DataSource with the Flux language
125 Import a complete DashBoard with Flux language
126 Create a DataSource with FluxQL language
127 Create a Dashboard with FluxQL
Other types of visualizations
128 TEXT type display. Part 1
129 TEXT type display. PART 2. HTML and JavaScript
130 Heatmaps
131 Canvas
132 Candlestick
133 Maps Part1
134 Maps Part 2
Plugins and command line client
135 Introducción a los plugins
136 Polystat. Install a panel plugin
137 Redis. Install an App type plugin
138 Install a plugin from GRAFANA CLI
Administration. Organizations, users and teams
139 Enterprise License and Default preferences
140 Organizations
141 Users
142 Teams
143 Dashboard permissions
End of the course
144 End of the course
145 Bonus Lecture
Resolve the captcha to access the links!