Member-only story

10 Essential Business Analyses You Can Perform with ChatGPT and Excel

Fakrul Islam Tushar
4 min readNov 7, 2024

--

As a business professional, data analysis is crucial for making informed decisions. With the combination of Excel and ChatGPT, you can transform raw data into actionable insights. In this post, I’ll share 10 powerful analyses you can perform and the prompts to unlock ChatGPT’s potential.

1. Sales Trend Analysis

Understand how your sales evolve over time, identify seasonal patterns, and forecast future sales.

Prompt:

“I have a dataset with sales figures by month. Can you analyze the trends and seasonality, and provide a forecast for the next 12 months?”

What You’ll Get:

• Sales trends over time

• Seasonal peaks and troughs

• Forecast for future sales

2. Customer Segmentation

Group your customers based on their purchase behavior or demographics to create targeted marketing strategies.

Prompt:

“Here is a dataset of customer purchases with demographic data. Can you segment the customers into distinct groups based on their behavior and suggest marketing strategies for each group?”

--

--

Fakrul Islam Tushar
Fakrul Islam Tushar

Written by Fakrul Islam Tushar

Ph.D. Student at Duke University |Research Assistant at Center for Virtual Imaging Trials (CVIT)

No responses yet