TL;DR

Don’t have time (or want to) read the whole newsletter? Here’s a summary of this week’s prompt:

Learn how to use ChatGPT to analyze datasets and create graphical outputs, streamlining your workflow by generating visual data representations directly within your chats. When you’re prompting and using ChatGPT as a digital teammate and supporting tool, remember to be specific with your request. In this weeks example, be specific with what “trends” or “comparisons” or analysis you are actually looking for.

Prompt

Instruction:

Act as a data analyst capable of performing data analysis and generating graphical outputs directly. You will analyze a provided dataset, identify key insights, and generate a visual representation (e.g., a bar chart, line graph, etc.) of the data trends. You’ll be given a \\dataset\\.

Focus on identifying [specific] trends, comparisons, or anomalies that would be relevant to [goal of analysis, e.g., performance improvement, market trends, etc.]. Based on the analysis, generate a graphical output that clearly visualizes these insights.

Information:

Dataset = [insert dataset or upload a file that doesn’t contain proprietary data and provide file name here]

Context:

The [team/individual] is looking to better understand [specific aspect of the data, e.g., user engagement trends, revenue growth, etc.]. They want insights on [specific metrics, e.g., month-by-month trends, best-performing products, etc.] and a graphical representation of these insights to help visualize the findings for [intended use, e.g., a presentation, internal analysis, etc.].

End Goal:

Provide a clear analysis of the dataset and generate a graphical output (such as a line graph or bar chart) that visualizes key trends or comparisons. The graphical output should be ready to present to [intended audience, e.g., stakeholders, team members, etc.], helping them interpret the results easily.

See The Prompt In Action

Instruction:

Act as a data analyst specializing in e-commerce data analytics. You’ll be given a dataset that represents monthly sales performance for 2024 YTD for an online electronics store. Analyze the dataset to identify trends and produce a graphical representation (e.g., a bar chart) that shows the sales performance per month.

You’ll be provided with sales data from January to September 2024, segmented by product categories such as mobile phones, laptops, and accessories. Your task is to identify the best-performing category, any months with significant sales spikes, and any underperforming categories. Based on your analysis, create a bar chart that compares monthly sales figures for each product category.

Information:

Dataset

Context:

The sales team is preparing for an internal review to evaluate the performance of different product categories. They want a visual summary of how each category performed over the months to inform their future sales strategy. The bar chart will be used in a team meeting to highlight which product categories contributed the most to revenue.

End Goal:

Provide an analysis of the sales data and generate a bar chart that compares monthly sales across product categories. The chart should clearly highlight the best and worst-performing categories and any noticeable trends across the months. The visual output will be used for the sales team’s review presentation.

The Response We Got

The bar chart above illustrates the monthly sales performance of three product categories—mobile phones, laptops, and accessories—from January to September 2024. Here's a summary of key insights:

• Best-performing category: Mobile phones consistently show the highest sales across all months.

• Significant sales spikes: There is a noticeable sales spike in April for all categories, particularly for mobile phones and laptops.

• Underperforming category: Accessories are the lowest-performing category in terms of sales, consistently lagging behind the other two.

This analysis can be used by the sales team to focus on strengthening the accessories category and to understand what factors may have driven the sales increase in April.