ChatGPT is the best partner for data processing with its latest update.
You can search for data on the web, exploit it with the Code Interpreter and export it in Excel format easily.
Here's how to do it with ChatGPT's new features:
1. Search for data
Start by finding the latest data available with ChatGPT's built-in web search.
Here's a prompt template you can use:
"Can you give me the 7 most popular and profitable niches and sectors for digital solopreneurs, such as e-commerce, coaching, consulting, content creation, etc. in the US?
Most importantly: give the dollar value of each market.
Write very short bullet points for each niche and use internet research to find this data."
Limiting the search by number and location is recommended to avoid off-topic data.
Also, make sure to give it a specific goal. This is the market value.
Important:
Don't forget to check the source of the data by clicking on the blue icons given by ChatGPT.
2. Process data
Code Interpreter is the best tool for analyzing and manipulating data.
For the example, we'll create a chart from the previous web search.
But we're also going to ask ChatGPT to interpret the data and write a conclusion with GPT-4 Turbo.
Prompt (e.g):
"Use the code interpreter to create a bar chart with each niche and its value.
Then write a short conclusion with recommendations for solopreneurs."
ChatGPT automatically understands the context as we are in the same conversation.
You can already download it as an image to put it in a presentation for example.
I don't understand why many people don't use this free AI Copilot from Microsoft.
You can use GPT-4 for free, generate images, and more.
I'll show you how to use and access it:
1. Access Copilot in Edge
You can use it for free on laptop and mobile:
- Windows → open Edge, which is installed by default
- macOS → install Microsoft Edge available for ARM and Intel
- Android → install Microsoft Edge from Google Play
- iOS → install Microsoft Edge from the App Store
Then open Copilot by clicking on the icon at top right on laptop and bottom center on mobile.
You can even select the most suitable mode.
Let's take a look at a few use cases ↓
2. Use GPT-4 for free
Edge Copilot is based on Bing Chat.
You can use GPT-4 for free by selecting the "Creative" mode.
Then enter your prompt and Copilot will mix data from the Internet and GPT-4 to answer you.
Tip:
You can ask Copilot to perform a specific search before replying.
Example:
"Search the internet for the latest announcements made by OpenAI and summarize them in short, easy-to-understand bullet points".