How many times have you sat with an Excel table or wanted to extract data from documents and invested an hour or more in it? (If you gave up altogether, it’s relevant to you). Forget everything you knew, ChatGPT does an amazing job on this topic and will create tables, graphs, and analyze a DB for you whether you provide it with Excel, Google Sheets, CSV, or others. You just need to write in simple language what you want to know and within seconds you will receive an answer. Here are some examples:
Upload the DB file to ChatGPT
It can be almost any type of file containing the data in an organized manner. If you just want to play with ChatGPT’s ability to analyze the data, you can download a dataset for free from here: https://www.kaggle.com/
For the purpose of writing the item, we downloaded a pizza sales list:
Ask ChatGPT to analyze the table and create a new table
We wanted to see a breakdown of the sales hours of size M ital_supr pizzas and requested:
Analyze the document and create a table that shows the sales of ital_supr size M pizza also show the time stamp
We received the table with the intersection we wanted in seconds:
Create Graphs with ChatGPT
We wanted to see which 5 pizzas sold the most yesterday. We didn’t ask to show the quantity, but ChatGPT added it on its own:
Create a bar chart showing the top five pizza types sold
Now we want to see the sales distribution by pizza types in different colors that we choose:
Create a pie chart showing pizza type. Use green for veggie, yellow for chicken and red for supreme
We omitted one of the types and ChatGPT knew to add it:
Data Analysis with ChatGPT
Now we wanted to know how many pizzas were sold in total (you can definitely ask more complex queries and get quality answers):
How many pepperoni pizzas were sold in total?
Summary:
ChatGPT and artificial intelligence make data analysis simple and visual, it’s time to understand the data in depth and use it to maximize your operations.
Tips
1. You can edit the colors of the graph after creating it easily, click on the settings icon in the top right corner of the image and a window will open allowing you to do so:
2. Use ChatGPT for analysis in Hebrew and the results are almost as good as in English.
