DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Please enter at least three characters to search
Refcards Trend Reports
Events Video Library
Refcards
Trend Reports

Events

View Events Video Library

Zones

Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks

Modernize your data layer. Learn how to design cloud-native database architectures to meet the evolving demands of AI and GenAI workkloads.

Secure your stack and shape the future! Help dev teams across the globe navigate their software supply chain security challenges.

Releasing software shouldn't be stressful or risky. Learn how to leverage progressive delivery techniques to ensure safer deployments.

Avoid machine learning mistakes and boost model performance! Discover key ML patterns, anti-patterns, data strategies, and more.

Related

  • Advancements in AI for Health Data Analysis
  • Search for Rail Defects (Part 3)
  • How Artificial Intelligence (AI) Is Transforming the Mortgage Industry
  • Fueling the Future: How Tech Funding Empowers IT Consultants in AI/ML and Cybersecurity

Trending

  • Fixing Common Oracle Database Problems
  • Unlocking AI Coding Assistants Part 1: Real-World Use Cases
  • Develop a Reverse Proxy With Caching in Go
  • It’s Not About Control — It’s About Collaboration Between Architecture and Security
  1. DZone
  2. Data Engineering
  3. AI/ML
  4. Introduction to Modern AI 2024 Edition, Part 2

Introduction to Modern AI 2024 Edition, Part 2

In this post, walk through a real-life business problem and make use of ChatGPT with Advanced Data Analysis to help with the solution.

By 
Joel Nylund user avatar
Joel Nylund
DZone Core CORE ·
Apr. 19, 24 · Tutorial
Likes (3)
Comment
Save
Tweet
Share
1.6K Views

Join the DZone community and get the full member experience.

Join For Free

In part one of this article, we brought you up to speed on the latest terminology and tools around artificial intelligence and machine learning. We also talked about business problems that can be solved using these tools. Finally, we covered several of the popular tools today in this space. In part two of this article, we will walk through a real-life business problem and make use of ChatGPT with Advanced Data Analysis to help us solve it.

A Real Life Example

This is really fun stuff to experiment with. We will walk through a quick demo of using ChatGPT to write code for you and utilize ML. It is an interesting form of ML where you just tell ChatGPT what you want to do and it generates the Python code for you and executes it to create the models.

Let's walk through a real-world example: We have a customer that specializes in the catering business and they currently cater many Solution Street events. They also cater a lot of weddings, which is really their bread and butter. I discussed with them some possible uses of machine learning for gaining insights into their data. They wanted to look at historical bid wins and losses to see if they could start to predict which bids they would win and possibly focus more on the ones they were more likely to win.

Solution Street has created a process around machine learning projects that we applied while working on the catering project:

Solution Street machine learning process

Step one is to understand the business problems of the target domain, which in this case is the catering industry, and review their data to identify potential use cases that affect their business and can potentially leverage ML. We picked catering bid wins and losses as the business case with high potential. The next step is to interview the customer and find out all about their data and see if there's any hidden data that the customer thinks is important. 

After that, we can begin building a model, and then looking at the results, we can feed the results into the customers’ systems. We can sometimes run through this process every hour, once a day, or other times just on demand.

While our process may be similar to others out there, a key differentiator is that we put more emphasis on analyzing the business problem and the customer's data. Some people like to jump right into modeling (self-admission: I did this my first time), and then quickly learn that things can go horribly wrong because you end up modeling the wrong thing based on the wrong data.

I performed the first two steps, talked to the customer, cleaned up the data, and put it into a CSV file (which is similar to an Excel spreadsheet). My file now had about 700 records all about wedding bids. I then asked ChatGPT to load this wedding data set: 

ChatGPT prompt: Load this file as a dataset


ChatGPT response (dataset)

As you can see here, ChatGPT is very chatty and tells you, "Oh hey look, I found that you have all these columns and this file seems to capture information about wedding events." It figured out what I had here without me even telling it. That is pretty cool, right? 

Another cool thing about ChatGPT is a little icon you can click on that shows you the code it generates.

Analysis: Python


Result

In this case, this is just Python code that loads the file and shows the first few records.

Then I said, “Okay, hey can you please build me a model to predict if future bids are won or lost?” Below is the generated code!

Python generated code by ChatGPT - 1

Python generated code by ChatGPT - 2

I didn't even tell it what kind of model to use, what type of algorithm to use, or anything else about the data. Note that you can see it uses scikit-learn, which is the first framework or utility that I noted earlier, and the only one used by ChatGPT today. So, they're just basically writing all the code that I would normally have to write. Also, note they are using a Random Forest classifier as the model. It spits out the results of the model:

Results of the Random Forest model

I can now predict with almost 80% accuracy which bids will be won … hmm, that’s actually not so great, right? We will come back to that, but first, let’s see which variables were most important in predicting the results:

Most important variables to determine result

Note that all the cost fields are in the top 5 along with the guest count, which makes a lot of sense!

We can also have ChatGPT use the model to predict the results of data we come up with:

ChatGPT prompt: Predict results of data

ChatGPT response

One interesting thing to note here: ChatGPT fixed my misspelling and also made the prediction.

So in my example, it predicts we will not win that bid, so maybe it’s not a bid we should spend a ton of time working on!

In addition to modeling, we can also ask ChatGPT all sorts of questions about the data and have it build graphs for you. My customer wanted to know if his win percentage was improving each year, so I asked ChatGPT to graph the win percentage at the top five venues.

Top five venue graph

So it spits this graph out which is nice, but even nicer, I can check the code behind it to make sure it's correct. Many times in my experimenting, ChatGPT has [confidently] given me the wrong answer!

Back to our model, I talked to the customer about the confidence level not being the greatest and was wondering if there was additional data we could gather to improve the model. The customer mentioned that lots of the data is not being collected in the database. We found out that much of the data was being collected in a Google Sheet! Things like:

  • Who was the designated salesperson? (Instead of spreadsheet)
  • Keep accurate track of the brand used (Some records may have been the wrong brand)
  • Did they meet in person with the customer? (Track dates)
  • Did they have a tasting? (Track dates)
  • Is the venue a “preferred venue”?

So we agreed to enhance the customer's system to make it easier to collect this additional information and to feed the data from the Google sheet into the system. Once this is done, we plan to feed the new data back into the model to see if it can better predict results. Following that, we can enable the model usage from their bid system and show which bids we think will be winners!

Summary

In part one of this article, we summarized all the latest terminology around artificial intelligence and machine learning with examples. We also showed typical business problems that can be solved with the latest tools. In part two, we walked through a real-life example and demonstrated AutoML and how you can generate a model without doing any coding. We also showed how sometimes models can’t predict results with great accuracy. Lastly, we showed how ChatGPT can do other cool things with our data like data analysis and graphing.

I hope you enjoyed this article. If you are looking for help in understanding how AI and ML can help you, drop me a line!

AI Data analysis Data set Machine learning ChatGPT

Published at DZone with permission of Joel Nylund. See the original article here.

Opinions expressed by DZone contributors are their own.

Related

  • Advancements in AI for Health Data Analysis
  • Search for Rail Defects (Part 3)
  • How Artificial Intelligence (AI) Is Transforming the Mortgage Industry
  • Fueling the Future: How Tech Funding Empowers IT Consultants in AI/ML and Cybersecurity

Partner Resources

×

Comments
Oops! Something Went Wrong

The likes didn't load as expected. Please refresh the page and try again.

ABOUT US

  • About DZone
  • Support and feedback
  • Community research
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Core Program
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 3343 Perimeter Hill Drive
  • Suite 100
  • Nashville, TN 37211
  • support@dzone.com

Let's be friends:

Likes
There are no likes...yet! 👀
Be the first to like this post!
It looks like you're not logged in.
Sign in to see who liked this post!