The Instant Analyst: Using AI to Help Convert Qualitative Text into Structured Data Tables

AI Skill Booster

Important note: This training may demonstrate AI tools that are not approved for use with Stanford data. Inclusion in this session does not imply institutional approval. Participants should refrain from entering Stanford data into unapproved tools. An up-to-date list of approved and reviewed tools is available on the GenAI Evaluation Matrix page.

Code	Date	Delivery	Cost
ITSB-1021	Tue Jun 16, 1:00 pm to 2:30 pm	Live Online : 1 session	$150

Before each live online session, Tech Training will provide a Zoom link for live online classes, along with any required class materials.

Explore how AI transforms unstructured text into organized data tables. Practice prompting AI to analyze reviews, reports, and feedback and generate structured comparisons and actionable summaries.

Program Description

Qualitative data locked inside reports, reviews, and survey responses is often underused because it takes too long to organize manually. This session explores how to prompt AI to extract, categorize, and structure text-based information into usable tables and comparisons. Participants practice generating competitive analyses, feedback summaries, and sentiment breakdowns from raw text inputs.

Learning Objectives

Learners will have the opportunity to:
1. Explore how AI processes unstructured text and converts it into structured data
2. Practice prompting AI to extract categories, themes, and attributes from qualitative sources
3. Work with table generation to create side-by-side comparisons and feature matrices
4. Experiment with sentiment analysis and priority ranking from survey or review data
5. Apply structured output prompting to a qualitative dataset from your own work

Topic Outline

Topics:
- How AI converts unstructured text into structured data
- Prompting techniques for data extraction and categorization
- Building comparison tables and feature matrices
- Sentiment analysis and thematic tagging
- Practical applications in marketing, HR, and operations

Tools used: Stanford AI Playground and free versions of other AI models (ChatGPT, Gemini, or Claude)

Custom training workshops are available for this program

Technology training sessions structured around individual or group learning objectives. Learn more about custom training

Special Group Rates

For groups of 5 or more within the same team or department, special rates are available. Please contact techtraining@stanford.edu for more details.

University IT Technology Training sessions are available to a wide range of participants, including Stanford University staff, faculty, students, and employees of Stanford Hospitals & Clinics, such as Stanford Health Care, Stanford Health Care Tri-Valley, Stanford Medicine Partners, and Stanford Medicine Children's Health.

Additionally, some of these programs are open to interested individuals not affiliated with Stanford, allowing for broader community engagement and learning opportunities.