Analyzing Complex Data and Extracting Insights
In professional documents like reports, proposals, and papers, insights reflected in their conclusions are crucial. However, manually analyzing data to draw conclusions requires a lot of time and effort from humans.
By utilizing AI's excellence in finding patterns and drawing conclusions, the process of analyzing data and deriving conclusions can be optimized.
How can we analyze data and extract insights?
Let’s assume that we have sales data from two online stores as shown below.
Sales Data Table
| Store | Period | Date | Category | Product | Quantity | Unit Price | Total Sales |
|---|---|---|---|---|---|---|---|
| Store A | 2023-01-01 to 2023-06-30 | 2023-01-01 | Electronics | Smartphone | 5 | 599 | 2995 |
| Store A | 2023-01-01 to 2023-06-30 | 2023-01-02 | Electronics | Laptop | 3 | 999 | 2997 |
| Store A | 2023-01-01 to 2023-06-30 | 2023-01-03 | Home Appliance | Washer | 2 | 799 | 1598 |
| Store B | 2023-01-01 to 2023-06-30 | 2023-01-04 | Home Appliance | Refrigerator | 1 | 1499 | 1499 |
| Store B | 2023-01-01 to 2023-06-30 | 2023-01-05 | Fashion | Jeans | 10 | 49 | 490 |
| Store B | 2023-01-01 to 2023-06-30 | 2023-01-06 | Fashion | T-Shirts | 20 | 20 | 400 |
| Store B | 2023-01-01 to 2023-06-30 | 2023-01-07 | Household | Soap | 50 | 2 | 100 |
| Store B | 2023-01-01 to 2023-06-30 | 2023-01-08 | Household | Toothpaste | 30 | 3 | 90 |
After exporting sales data to a format like CSV or JSON that AI can easily understand, you can request AI to analyze the data as shown below.
Please analyze the sales data in the following CSV format and extract insights for report preparation.
### CSV Sales Data Format
Store,Period,Date,Category,Product,Quantity,Unit Price,Total Sales
Store A,2023-01-01 to 2023-06-30,2023-01-01,Electronics,Smartphone,5,599,2995
Store A,2023-01-01 to 2023-06-30,2023-01-02,Electronics,Laptop,3,999,2997
Store A,2023-01-01 to 2023-06-30,2023-01-03,Home Appliance,Washer,2,799,1598
Store B,2023-01-01 to 2023-06-30,2023-01-04,Home Appliance,Refrigerator,1,1499,1499
Store B,2023-01-01 to 2023-06-30,2023-01-05,Fashion,Jeans,10,49,490
Store B,2023-01-01 to 2023-06-30,2023-01-06,Fashion,T-Shirts,20,20,400
Store B,2023-01-01 to 2023-06-30,2023-01-07,Household,Soap,50,2,100
Store B,2023-01-01 to 2023-06-30,2023-01-08,Household,Toothpaste,30,3,90
### Response Format
Sales by Store:
[Present the total sales of Store A and Store B in a table format]
Sales Share by Category:
[Present the sales share by category out of the total sales in a table]
Sales Rank by Product:
[Present the sales rank by product from the total sales in a table]
Top Focus Products:
[List the top 2 products for focused sales in one sentence]
Store Operation Strategy:
[Propose a specific operation strategy for each store based on the sales characteristics of Store A and Store B in one paragraph each]
While manually analyzing sales data and extracting insights can be time-consuming and energy-draining for humans, AI, with its pattern recognition and inferential abilities, can rapidly analyze data and derive insights.
Sample AI Response
Sales by Store
| Store | Total Sales |
|---|---|
| Store A | $7,590 |
| Store B | $2,579 |
Sales Share by Category
| Category | Sales Share |
|---|---|
| Electronics | 62.91% |
| Home Appliance | 27.48% |
| Fashion | 7.98% |
| Household | 1.63% |
Sales Rank by Product
| Rank | Product | Total Sales |
|---|---|---|
| 1 | Laptop | $2,997 |
| 2 | Smartphone | $2,995 |
| 3 | Washer | $1,598 |
| 4 | Refrigerator | $1,499 |
| 5 | Jeans | $490 |
| 6 | T-Shirts | $400 |
| 7 | Soap | $100 |
| 8 | Toothpaste | $90 |
Top Focus Products
The two top products for focused sales are Laptops and Smartphones.
Store Operation Strategy
Store A is generating high sales from Electronics and Home Appliances, so it should focus on securing new products in these categories and invest in marketing efforts. Due to the high demand for Laptops and Smartphones, enhancing promotions for these products could significantly boost sales.
Store B offers a diverse range of products in Fashion and Household categories, so maintaining a varied product lineup to meet customer needs is important. With stable sales from Jeans and T-Shirts, emphasizing quality and cost-effectiveness in marketing strategies, along with seasonal fashion items, can improve customer loyalty.
Data Visualization
Recently, tools like chatGPT can offer data visualization features that produce graphs and charts based on provided data.
By appending “Please generate graphs and charts based on the analysis” at the end of a data analysis prompt, AI can visually represent analysis results.
Practice
Send the prompt example and compare the AI's responses.
Want to learn more?
Join CodeFriends Plus membership or enroll in a course to start your journey.