AI Vitrina — AI Tools and Services Catalog

Q: How do I create a complex Excel formula using a prompt?

Describe the task in words: what input data you have, what you need to calculate, which cells contain the data. The AI will generate a formula with an explanation of each part. Works for VLOOKUP, INDEX/MATCH, SUMIFS, array formulas, and any combinations. Our prompts generate formulas compatible with Excel and Google Sheets.

Q: Can AI write an SQL query from a description?

Yes, AI writes excellent SQL. Describe the table structure (or paste CREATE TABLE statements) and the task: 'Find customers who made more than 3 orders in the last month and show the total amount.' The AI will write a query with JOIN, GROUP BY, HAVING, and subqueries. Supports MySQL, PostgreSQL, ClickHouse, and other dialects.

Q: How do I use prompts for data visualization?

Paste data (CSV, table) into a prompt and describe the desired chart. ChatGPT with Code Interpreter will build a visualization in Python (matplotlib, seaborn). For regular reports, use prompts that generate dashboard code. AI also suggests which chart type best suits your data.

Q: Which prompts are useful for report automation?

Report prompts help: transform raw data into structured tables, calculate KPIs and metrics, generate textual insights from numbers, create regular report templates. Specify the output format (table, bullet points, paragraph) — and AI will adapt the result to your needs.

📊

Prompts for Working with Data

Ready-made queries for creating formulas, writing SQL queries, data visualization, and report automation

AI model

GPT-4oFast multimodal modelGPT-4o miniLightweight and affordable versiono3Chain-of-thought reasoning modelo4-miniCompact reasoning model

Analyst Prompts — Excel, SQL, and Visualization

Data prompts turn AI into an analyst assistant: creating complex Excel and Google Sheets formulas, writing SQL queries from descriptions, data visualization, and report generation. No need to remember syntax — describe the task in words.

Prompts support various SQL dialects (MySQL, PostgreSQL, ClickHouse), work with complex Excel formulas, and generate code for Python visualizations. Specify the data structure — get a ready query or formula with explanation.

Currently 18 prompts in this category — choose an AI model via the filter to find the right one.

Prompts for Working with Data

Analyst Prompts — Excel, SQL, and Visualization

Frequently Asked Questions

Power BI DAX Formula

RegEx Data Extractor

Statistical Analysis Helper

Excel Formula Helper

Pivot Table from Data

Data Cleaning Script

Dashboard Design for Data

Excel Formula Wizard

Text Data Extraction

Google Sheets Automation

Data Visualization Advisor

KPI Dashboard Designer

Pivot Table Builder

CSV Transformer

Data Storytelling Narrator

SQL Query Optimizer

Python Data Analysis

Data Transformation & Cleaning