Every Monday morning at work, I used to organize weekly sales data in Excel and summarize it into a PPT. I automated this with the ChatGPT code interpreter. Let me walk you through the process.
1. First, I write a query to export raw data as CSV. You should do preprocessing and deduplication directly in SQL to keep the file size small.
2. I enter this into ChatGPT: "Analyze this CSV and give me the weekly sales trend, category breakdown, and week-over-week change rate." Then, if I need additional metrics, I add them one by one through the conversation.
3. Once I get the results, I ask it to save them as an Excel file, and then immediately ask for a PPT slide script. The key here is to request insights, not just numbers. If you copy the numbers as-is, the slides end up as plain tables.
4. Finally, when moving everything into Figma or PowerPoint, I just set the tone and keep the graph colors consistent.
This reduced my Monday morning task from 40 minutes to 5 minutes. Of course, it took time at first to understand the data, but once you build the pipeline, it's really convenient. If you're interested, try it on a similar task.