How to Make AI-Powered Interactive Dashboard | Bricks Tutorial

About this video

Kevin Stratvert builds an interactive dashboard for the Kevin Cookie Company in the free service Bricks, which combines a chat view, an AI-powered grid spreadsheet, and a board view for presentation. After pasting sales data into the grid and formatting it as a table, he uses natural-language prompts in the grid to clean and prep the data: splitting a combined country-and-product column into two columns, adding a profit column calculated as revenue minus cost, formatting revenue, cost and profit as currency, and applying conditional highlighting for profit over 5,000 in green, with accept/reject controls for AI changes. He then creates visuals both by prompt — a stacked bar chart of profit by country and product, showing India highest and chocolate chip as the biggest driver — and manually, building a line chart of profit over time by dragging date to the x-axis and profit to values, fixing sort order and filtering to 2023 only. Charts are saved to the grid, copied to the board, rearranged and resized, with an additional units-sold-by-month chart built directly on the board. He stresses board data stays live from the grid, and shows sharing via Present mode, inviting collaborators, or publishing to the web as view-only.

Key takeaways

• Bricks combines an AI spreadsheet grid for data prep with a board view for dashboards, plus chat in a single file
• Data cleaning is done by plain-English prompts: split columns, add calculated profit, format as currency and highlight values over a threshold
• Visuals can be AI-generated from a prompt or built manually by dragging fields to axes and values, with sorting, filtering and aggregation options
• Dashboards stay live — edits or filters in the grid immediately update charts on the board
• Dashboards can be presented full-screen, shared with collaborators with grid access, or published to the web as view-only

Episode details: published September 16, 2024 · 16:59 long. Summary written by Self Growth Videos from the episode itself. Business results and any income figures mentioned are Kevin Stratvert’s own claims, shared for education — they are not typical or guaranteed.

← Previous: Microsoft Copilot Tips and Tricks to Boost Your Productivity · Next: The NEW Microsoft Planner: NEVER Miss a Deadline Again →

All Kevin Stratvert videos · Kevin Stratvert profile · Kevin Stratvert on YouTube