/u/gilbertopsantosjr/collections/data-analysis-excel7 promptsupdated 3 d ago
Collection
Public
Data Analysis & Excel
Upload a CSV or Excel file, or paste a sample: explore data, write formulas and SQL, clean data, plan KPIs and build charts.
GSCurated by @gilbertopsantosjr
- Promptv1
Write and Explain an Excel 365 Formula
GSGilberto SantosExcel 365. Column A = {{column_a_field}}, B = {{column_b_field}}, rows 2–{{last_row}}. Write a formula that {{goal}}, explain it and…
4 vars0 runsUpdated 3 d ago
- Promptv1
Clean Messy Data With Power Query or pandas Steps
GSGilberto SantosList every cleaning step this data needs (duplicates, dates, spaces, types) and give Power Query or pandas steps: {{sample_rows}}
1 var0 runsUpdated 3 d ago
- Promptv1
Plan a KPI Dashboard for Any Department
GSGilberto SantosSuggest 6 KPIs for a {{department}} dashboard: formula, why it matters, target direction and best chart.
1 var0 runsUpdated 3 d ago
- Promptv1
Write a Commented SQL Query From Your Tables
GSGilberto SantosTables: {{tables}}. Write {{sql_dialect}} to answer: {{question}}. Add comments and an example output.
3 vars0 runsUpdated 3 d ago
- Promptv1
Explain Data Results to a Non-Technical Manager
GSGilberto SantosTurn these results into 5 plain-English insights and one recommendation for a non-technical manager: {{results_table}}
1 var0 runsUpdated 3 d ago
- Promptv1
Create an Interactive Chart That States the Insight
GSGilberto SantosCreate an interactive chart artifact from this data showing {{message}}, with a clear title that states the insight: {{data}}
2 vars0 runsUpdated 3 d ago
