INSYNTIVEAcademy
IDEN
Sign inSign up freeSign up

AI & Dashboard Guides

AI workflows for data analysis & dashboards.

Step-by-step guides with copy-ready prompts for ChatGPT, Claude and Gemini, plus example results, practice files and a checklist before you share anything.

@googleindonesia6 min

Build a Google Sheets dashboard with Gemini Canvas in one prompt

Open a blank sheet, ask Gemini to build it as a canvas, and get a family finance dashboard with an input table, charts, budget tracking and savings. The exact prompt, a full version, and follow-ups.

  1. Open Sheets
  2. Open Gemini
  3. One prompt
  4. Check it
  5. Make it yours

Google SheetsGeminiSheets canvas

LAYOUT7 min

7 simple dashboard layout rules, with before and after examples

The full layout checklist: start with a wireframe, pick one hero chart, group, space, simplify, guide the eye, and leave room for insight. Every rule has a before and after.

  1. Wireframe
  2. Hero chart
  3. Group
  4. Spacing
  5. Fewer sections
  6. Reading flow
  7. Insight

Power BIExcelTableauLooker StudioGoogle Sheets

EXCEL6 min

Build a complete Excel template and dashboard with AI

Tell ChatGPT what you track, the KPIs you need, and the look you want. It builds the structure, formulas, charts, and dashboard; you test it and own it.

  1. Plan
  2. Build
  3. Test
  4. Polish

ChatGPTChatGPT for ExcelExcel