Interactive HTML Dashboards From Any Excel File

Turn any Excel file into an interactive HTML dashboard — no Power BI license, no design skills, no coding. Just Claude, a clear prompt, and about 15 minutes. 00:00 — The problem every analyst knows 00:22 — What we're building today 00:42 — What you'll learn 01:20 — Meet the dataset (Olist Brazilian E-Commerce) 01:50 — What the raw data actually looks like 02:19 — Why most people get bad results from AI 03:00 — The 4-ingredient prompt framework 03:30 — Prompt 1: Setting context (don't skip this) 04:48 — Reading Claude's first response 05:13 — Prompt 2: The dashboard build 06:55 — Reviewing the first result critically 07:26 — Prompt 3: Iterating with specific feedback 08:31 — Reviewing round 2 08:50 — Prompt 4: Final polish + sortable tables 09:52 — The finished dashboard walkthrough 10:08 — ⚠️ The verification rule (do not skip) 10:58 — My 5-minute verification workflow 12:04 — Data safety: what NOT to upload 13:02 — Recap of the 5 takeaways 13:44 — Where to get the prompt templates In this walkthrough I take a real public dataset (100,000 Brazilian e-commerce orders from Kaggle) and build a full executive-ready dashboard from raw rows to interactive HTML — KPI cards, filters, trend lines, sortable tables, the whole thing. You'll see every prompt, every iteration, every mistake, and every fix. Not just the polished result. This is the same workflow I use to turn weekly operational reports into stakeholder-ready dashboards in minutes instead of days. It works for anyone who lives in Excel — analysts, ops leads, finance, consulting, BI. ━━━━━━━━━━━━━━━━━━━━ 🎯 WHAT YOU'LL LEARN ━━━━━━━━━━━━━━━━━━━━ ✅ The 4-ingredient prompt framework that gets non-generic results ✅ How to set context so Claude actually understands your business ✅ The full iteration loop — every prompt, every refinement, in real time ✅ Which interactive features are worth asking for (filters, toggles, trend lines, tooltips) ✅ The verification workflow that protects you from AI hallucinations ✅ Data safety rules — what NOT to upload to any AI model ━━━━━━━━━━━━━━━━━━━━ 📁 RESOURCES ━━━━━━━━━━━━━━━━━━━━ 📊 Dataset (Olist Brazilian E-Commerce — Kaggle): https://www.kaggle.com/datasets/olistbr/brazilian-ecommerce 📝 The 4 prompt templates from this video: https://drive.google.com/file/d/15P9OT_G0N5-kHc8TxQ_fQsb_DqFIDS-D/view?usp=sharing ━━━━━━━━━━━━━━━━━━━━ 💬 JOIN THE CONVERSATION ━━━━━━━━━━━━━━━━━━━━ If you build a dashboard using this workflow — drop a comment and tell me what you made. I read every one and I'm collecting the best examples for a follow-up community video. Also curious: what's the most painful recurring report you'd want to automate next? Sales scorecards? Incident reviews? Financial summaries? Tell me below — top vote becomes the next deep dive. 🔔 Subscribe to TechNika for weekly walkthroughs of AI workflows that actually hold up in real operations. 👍 Like the video if it saved you a future Sunday afternoon. 🔁 Share it with the analyst on your team who's still emailing color-coded spreadsheets. ━━━━━━━━━━━━━━━━━━━━ 🎯 ABOUT TECHNIKA ━━━━━━━━━━━━━━━━━━━━ TechNika is the channel for the people who actually have to deploy AI — not just talk about it. Every video shows a complete, tested workflow with real data, real outputs, and real failure modes. No hype, no theory, no "AI will change everything in 2030" content. Just the moves that change what your work looks like when it lands on a stakeholder's desk on Monday. Built for operations analysts, business analysts, consultants, finance pros, and anyone whose job involves turning messy data into decisions. ━━━━━━━━━━━━━━━━━━━━ ⚠️ A NOTE ON DATA SAFETY ━━━━━━━━━━━━━━━━━━━━ Never upload confidential, commercially sensitive, or personally identifiable data to any AI tool unless you've verified your company's AI usage policy and your license terms. The dataset used in this video is publicly available and open source for exactly this reason — practice the workflow on safe data first, then deploy with the right governance in place. #ClaudeAI #ExcelDashboard #DataAnalysis #AIforAnalysts #TechNika