Unlocking key metrics and patterns using Grafana
summary
Shows how Grafana reads Google Sheets via the Google Sheets data source plugin using an API key or service account, demos building a table and time-series panel from a real sheet, applies transformations (rename/hide fields), panel overrides (colored cell backgrounds, data links), value mapping for status coloring, and dashboard variables to switch ranges dynamically; includes live demo where links and annotations work and mentions Grizzly for dashboard-as-code and alerts support in progress.
AI-written summary · about
chapters (10)
- 0:00Introduction and Speaker Background
- 1:14The Importance of Data in IT
- 2:37Challenges with Excel Sheets
- 4:57Introduction to Grafana
- 5:58Setting Up Google Sheets Plugin in Grafana
- 7:28Demo: Creating a Simple Dashboard
- 9:36Advanced Data Transformations in Grafana
- 11:55Panel Configuration and Overrides
- 16:27Dynamic Dashboards and Annotations
- 20:07Final Takeaways and Q&A
related talks
49mUnlocking Key Metrics and Patterns Using Grafana
51m30 Ways Google Sheets Can Help Your Company Uncover and Share Data Insights
22mBuilding Interactive Grafana Dashboards for Business Intelligence
41mUsing Google Data (now Looker) Studio for Dashboard Analytics Reporting
26mDataEngBytes 2023 - BRI-T1-05 - Larene Le Gassick
27mFrom Zero Visibility to Full Observability with Grafana
14mLightning Talk: Visualizing Data Confidently. Integrating React and Tableau Public
49mA Practical Guide to Dashboarding