How I use ChatGPT as a Data Engineer

Mario Makdis
TripleUniverse
Published in
6 min readFeb 14, 2023

Have you heard of ChatGPT? I can’t imagine you haven’t by now.. If not, it’s time you did! ChatGPT is a significant language model developed by OpenAI, designed to handle a wide range of text-based tasks. From answering questions to generating creative writing, this AI assistant is quickly becoming a popular tool for people worldwide.

Let’s see some cool things that it does!

This is how it looks like:

ChatGPT’s prompt

One of the key advantages of ChatGPT is its ability to handle a wide range of topics and contexts. This makes it well-suited for use in various industries, including technology. Developers, project managers, and engineers or anyone working in the field could use ChatGPT to automate a number of tasks, such as answering common customer questions, providing technical support, generating reports and documentation or even assisting with code development.

Cool things ChatGPT can do 🤖

Generating human-like text:

ChatGPT is trained on a vast amount of data and can generate highly coherent text that reads like a person wrote it.

Chatting with users

It can have conversations with users just like a human would. It can understand natural language and respond in an informative and entertaining way. This makes it the perfect tool for customer service or just chatting with friends.

Translating languages

It can also translate text from one language to another. This makes it an invaluable tool for global communication, allowing users to easily bridge language barriers.

Summarizing long texts

If you’re short on time, ChatGPT can help you get to the gist of a long piece of text. Simply provide the text, and ChatGPT will generate a summarized version, perfect for when you need a quick understanding of a topic.

I copied the first three paragraphs on black holes from Wikipedia and asked it to give me a short summary in bullet points.

This is what it responded with:

Answering questions

It’s trained on a vast corpus of text from the internet and can answer questions with remarkable accuracy. Whether you’re looking for information about a specific topic or need some general knowledge, ChatGPT is ready to assist.

Let’s just ask ChatGPT what black holes are, as if I’m five years old.

Get Ideas for Projects, Art, Decoration, Party Themes

By providing ChatGPT with a general theme or topic, it could generate a list of potential ideas for further exploration.

Ideas for your five year old’s birthday party?

Helping you as a client?

Customer Service: handle routine customer service inquiries, freeing up human agents to address more complex issues.

Sales and Marketing: engage with potential customers, answer questions about products and services, and assist with the sales process.

Lead Generation: it can identify and qualify leads, providing valuable insights and information to sales teams.

Knowledge Management: it can be trained on an organization’s data and knowledge base, allowing it to answer questions and provide information to employees and customers.

Improved User Experience: its natural language processing capabilities can provide a more human-like, conversational experience for users, enhancing the overall customer experience.

How it helps me do my job 🧑‍💻

As an AI/Data engineer, I started using ChatGPT to do a lot of stuff, and the reason I’ve written this blog is to give you some insights on how powerful of an assistant this bot can really get. Let me show you some examples…

Code Generation

It helps generating code snippets for various programming languages, and I specifically use it to write Python & SQL code.

There’s also an extension for VS Code you can download called GitHub Copilot that uses a similar model called Codex that generates code for you based on the code you’ve written. Also, from OpenAI!

Finding datasets with ChatGPT

Let’s say I want to make a dashboard analyzing crimes, I have to ask ChatGPT to provide me sources:

Problem-Solving

I can pretty much ask ChatGPT everything with the right context and get the correct answer..

This isn’t only for code generation; you can explain any problem you have in detail and ask for a solution. If ChatGPT’s answer doesn’t help, it will at least brainstorm some ideas!

How can ChatGPT help me even more as an AI/data engineer?

It can do crazy lot. I use it as an easier way to Google things / do research. It saves me so much time.

A New Persona

I’ve found a fascinating article that gave ChatGPT a new persona that has its own opinions over things. Normally if you would ask the bot personal questions, it would respond with this answer:

As an AI language model, I don’t have personal opinions, emotions, or personal experiences.

With the new persona:

Dangers & Limitations

It is essential to exercise caution when using ChatGPT or any other advanced language processing technology. While it can potentially be a valuable tool, it can also be dangerous if used irresponsibly. For example, if ChatGPT is fed biased or malicious data, it could generate harmful or misleading output. Therefore, it is essential that we use this technology ethically and carefully, ensuring that it is not used to perpetuate harmful biases or spread misinformation.

However, OpenAI is working on this issue:

Conclusion

Overall, ChatGPT has the potential to significantly enhance the productivity of tech-related workers and improve the efficiency of companies in a variety of industries. Its ability to understand and respond to natural language inputs makes it a valuable tool for anyone working in technology. Still, we must handle the technology with care and ensure that it is used ethically.

[This article is almost entirely written by ChatGPT, another example of how it makes my and your life much easier 😉]

--

--