본문 바로가기

Category91

Experimental Query Generation: Using Sample Queries to Build Complex SQL Most of the queries we need help with are probably non-trivial. If you really just need to see all the rows in a table, you can likely figure that out without AI. Where AI really helps is when we want to ask and answer questions, which are almost never answered by showing you everything. However, these types of question-answering queries are often hard to craft. When you've finally identified.. 2025. 6. 22.
The CLUE Technique: Grounding Generative AI The CLUE technique offers a systematic approach to preserving and reusing database context, enabling more efficient and accurate interactions with AI. With the CLUE technique, you can build a reusable starting point for your database conversations.C: Continuing Established ConversationsThe first element of the CLUE technique leverages the AI's ability to maintain context throughout a conversatio.. 2025. 6. 20.
Grounding Generative AI: Avoiding Hallucinations When Working with Databases Why Hallucinations OccurOne of the most remarkable aspects of generative AI is its creative capacity—its ability to generate novel ideas, stories, and solutions. However, this same creative power can lead to problems when working with databases and SQL, where precision is paramount.When generative AI lacks sufficient context about your database environment, it attempts to "fill in the blanks" wi.. 2025. 6. 20.
Chat with Your Data: Generative AI-Powered SQL Data Analysis The world of data analysis has transformed dramatically in recent years. With generative AI integrated into SQL data analysis, anyone can now talk to their data. As I've been learning data analysis, I've realized that AI-powered SQL tools are more than just technical aids they open up new possibilities for growth and learning. Yet, I sometimes worry: "Does relying on AI make me seem less skilled.. 2025. 6. 20.
Amazon Data Analysis for Sales Growth [Final project] Amazon Data Analysis for Sales Growth The objective of this project is to analyze Amazon's sales, customer, and product data to gain insights into the current state through visualization and identify opportunities for revenue improvement. By examining Amazon's sales trends, customer behavior, and product performance, the aim is to develop effective business strategies. The expected outcomes incl.. 2024. 7. 12.
WIL : Weekly I Learned 05.0.24 WIL : Weekly I Learned 05.07.24  FactThis week was the project period. During this time, my team members and I focused on selecting a topic, preprocessing data, analyzing the data, and creating a dashboard. The dashboard was made using Tableau. For this project, I wanted to dedicate a lot of time to learning Tableau. Using Tableau was enjoyable. However, the downside is that Tableau is a paid so.. 2024. 7. 8.