Flexible Filters: Build a Real-Time Dashboard that can Filter on Any Dimension скачать в хорошем качестве

Flexible Filters: Build a Real-Time Dashboard that can Filter on Any Dimension

Come learn how to build a powerful, flexible, and fast filtering system for your real-time dashboard. We'll build a fully-functional real-time web analytics dashboard with a powerful click-to-filter feature, allowing the dashboard to show metrics, time series charts, and tables filtering by any combination of selected dimensions. It's the ultimate dashboard filter, implemented live. You'll learn how to: Dynamically query your database based on any filter, directly from the application How to optimized database table schemas and SQL for high performance reads regardless of filtering dimension (and without needing many indexes) How to integrate your dashboard frontend with a real-time analytics backend 0:00 Introduction & Welcome 0:31 Tinybird Builds Overview & Next Week Preview 1:24 Today's Goal: Cross-Dimensional Filtering 2:08 Demo of Web Analytics Starter Kit Dashboard 3:54 Setting Up Local Tinybird Environment 4:15 Exploring the Tinybird UI & Data Sources 6:05 Current Filtering Limitations Demo 8:02 Understanding Multi-Tenant Architecture 10:00 Examining Materialized Views & Data Structure 15:23 Building Test Suite with Tinybird Code 20:23 ClickHouse as Analytics Backend Discussion 31:16 Performance Considerations & Memory Constraints 39:00 Working on Cross-Dimensional Filtering Implementation 53:36 Generating Mock Data for Testing 1:04:00 Testing Performance with Larger Datasets 1:15:00 Optimizing Queries & Performance Improvements 1:20:00 Final Testing & Results 1:24:42 Wrap-up & Getting Started with Tinybird