Project: DocAssistant.Charty is an AI-powered app that transforms natural language queries into SQL-generated charts and analytics for seamless data interaction.

[YuriyMorozyuk95]

Project Name

DocAssistant.Charty

Description

DocAssistant.Charty is an advanced AI-powered data management and analytics tool designed to help businesses and individuals make data-driven decisions. By integrating sophisticated AI technologies, DocAssistant.Charty provides users with the ability to query, analyze, and visualize their data effortlessly. The tool is versatile and can be tailored to meet the needs of various industries, including retail, hospitality, financial services, and more.

Key Features:

1. Natural Language Processing (NLP):

   • User-Friendly Queries: Users can ask questions in natural language, and the AI translates these queries into SQL commands.
   • Multi-Language Support: The tool supports multiple languages, making it accessible for users worldwide.

2. Data Insights and Analytics:

   • Comprehensive Reports: Generate detailed reports on sales, customer demographics, popular products, and more.
   • Visualizations: Create charts, graphs, and tables to visualize data trends and insights.
   • Financial Analysis: Analyze income and expenses, track investments, and optimize costs with annual financial reports.

3. Industry-Specific Solutions:

   • Retail: Track inventory, sales, and customer preferences.
   • Hospitality: Analyze customer preferences, peak times, and popular items.
   • Barbershops and Hookah Bars: Monitor customer frequency, popular services, and source of customers.

4. Technical Robustness:

   • Database Integration: Easily upload and integrate various databases, with support for schema changes.
   • AI Training: Train the AI to generate more accurate SQL queries using example prompts.
   • Answer Generation: Efficiently process and execute SQL queries, generating HTML tables and visualizations.

5. Scalability and Flexibility:

   • Multiple Databases: Communicate with multiple databases simultaneously.
   • Customizable Settings: Users can select specific servers, databases, and tables to refine their queries.

Use Cases:

1. Customer Interaction:

   • Example: A customer in a vintage shop querying available stock.

2. Business Owner Interaction:

   • Example: A business owner analyzing sales data to improve their business strategy.

3. Industry-Specific Examples:

   • Vintage Shops: Monitor sales, customer demographics, and popular products.
   • Bars: Analyze peak times for orders, customer preferences for warm or cold drinks.
   • Barbershops: Identify regular customers, popular hairstyles, and customer acquisition channels.
   • Hookah Bars: Track popular flavors, seating preferences, and wait times.

4. Financial Analysis:

   • Example: Analyzing personal or business financial data to track income, expenses, and optimize costs.

Technical Explanation:

• Database Upload: Connect and upload databases by copying the connection string, extracting DDL schemas, and storing them in a vector database index.
• AI Training: Use an 'Example' page to create and upload prompt examples, improving the accuracy of AI-generated SQL queries.
• Answer Generation: Retrieve relevant schemas and examples, translate prompts to SQL queries, execute the queries, and generate visualizations using a code interpreter.

Workflow diagram:

Conclusion:

DocAssistant.Charty is a powerful, adaptable tool designed to help users harness the power of their data. Whether you are a business owner looking to gain insights into your operations or an individual seeking to analyze your financial data, DocAssistant.Charty provides the tools you need to make informed, data-driven decisions.

Project Team:

Yurii Moroziuk – Project Lead /.Net AI Developer
E-mail: Yurii.Moroziuk@hotmail.com
Credly: https://www.credly.com/users/yurii-moroziuk/badges
GitHub: https://github.com/YuriyMorozyuk95

Khrystyna Halytska - .Net AI Developer
E-mail: christinaozarko@gmail.com
Credly: https://www.credly.com/users/khrystyna-ozarko
GitHub: https://github.com/KhrystynaOX

Igor Shurygin - Business Analysis, AI Prompt Engineer, Video Production & Marketing E-mail: yottaimusic@gmail.com
Credly: https://www.credly.com/users/igor-shurygin
GitHub: https://github.com/ishurygin

Technology & Languages

• [ ] JavaScript
• [ ] Java
• [X] .NET
• [ ] Python
• [ ] AI Studio
• [X] AI Search
• [ ] PostgreSQL
• [X] Cosmos DB
• [X] Azure SQL

Project Repository URL

https://github.com/YuriyMorozyuk95/DocAssistant.Charty

Deployed Endpoint URL

https://test-sql-rag-swn.azurewebsites.net/

Project Video

https://youtu.be/D7a_xvlpATk

Team Members

YuriyMorozyuk95, ishurygin, KhrystynaOX

[Yash-Kavaiya]

@YuriyMorozyuk95 @ishurygin @KhrystynaOX Amazing project

[YuriyMorozyuk95]

Resource is removed and deployed endpoint url is not available anymore. Please let me know if you will have some question, or need a help to deploy resources or test it.

[multispark]

Hello @YuriyMorozyuk95, thank you for participating in RAG Hack!

The team is working hard to distribute badges. Please have each team member fill out this form: aka.ms/raghack/badge-dist

Thank you!