Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Show the customer that you can upload and connect a variety of different data sources, including: Documents, Sites, email, Micorsoft Onedrive and Sharepoint, Google Drive and more.

Add a Collection

Show them that you can also create a collection of documents. For this demo, use the collection of documents here - .

Steps to Create a Collection:

  1. Login to the Private AI dashboard.

  2. Navigate to Collections.

  3. Select +New.

  4. Name the collection (e.g., "Medical Records Demo").

  5. Download the zip file here. Extract all the files and upload them to the new collection of documents. Note: do not upload the zip file, it will not be ingested.

Ask Questions on the Collection

Select the Collection and click on Chatbot.

image-20241117-080747.pngImage Added

Below are example questions you can use.

  • Basic Query Examples:

    • "What medications were prescribed to John Doe after his myocardial infarction?"

    • "What are the recommendations for Jane Doe's anxiety management?"

  • Advanced Queries:

    • "Compare the discharge instructions for John Doe's appendectomy and myocardial infarction." (Note:The answer requires analytical reasoning, not just finding the answer in a document)

    • "List all medications prescribed to John David Smith for hypertension." (Note:The answer requires understanding which medications are realted to hypertension and which are not)

Data Analysis

Connecting to the Chinook Database and Asking Questions

The Chinook database demonstrates Private AI's ability to interact with structured data.

Steps to Connect:

  1. In the Private AI dashboard, navigate to Data Sources.

  2. Select Database.

  3. Select +New

  4. Name of Database: Chinook Database

  5. Usage should be set to: For analysis

  6. Use the following Connection String : When Using BGD15: Driver={ODBC Driver 17 for SQL Server};Server=172.31.10.251 ,1433;Database=Chinook_AutoIncrement;Uid=bganalysis;Pwd=dev*112233;MultipleActiveResultSets=True;App=BGService; When Using BGD6: Driver={ODBC Driver 17 for SQL Server};Server=i-05c366f77b09ecb59.ec2.agatdemo.com, 1433;Database=Chinook_AutoIncrement;Uid=bganalysis;Pwd=dev*112233;MultipleActiveResultSets=True;App=BGService;

  7. Select Check, and you will see the tables of the database below.

  8. Select All the Tables and Save.

To see the actual data you can find it here

Ask Questions on the Database

Select the Database and click on Data Analysis.

image-20241117-081907.pngImage Added

Below are example questions you can use.

  • What are the top 5 customers by purchase amount?

  • List all tracks purchased in 2023.

  • What is the most purchased album in the database?

  • What are the top three genres with the highest revenue generated, and which artists contributed most to those revenues?

Semantic Search

Semantic search enables intuitive, meaning-based searches across unstructured text.

Steps to Perform a Semantic Search:

  1. Navigate to the Collections section in the dashboard.

  2. Select the collection created earlier ("Medical Records Demo") and select “Semantic Search

...

  1. Use the search bar to perform queries.

Query Examples:

  • "Show records mentioning mental health issues."

  • "Which patients have a history of hypertension?"