Portfolio › AI-Enabled Analytics
AI-Enabled Survey Sentiment
& Theme Analysis
Turn thousands of open-text survey responses into actionable insight – automatically. AI scores every comment for sentiment and discovers the themes people actually talk about, so leadership can see what’s driving satisfaction (or frustration) at a glance. No manual coding. No six-week research cycle. Just filterable, decision-ready dashboards powered by Snowflake Cortex AI and Power BI. Built on synthetic data as a proof of concept.
7
Days to Prep
the Data
1
Day to
Actionable Results
100%
AI-Driven
Insight Coverage
Data source
Synthetic dataset
750 procedurally generated student survey records across 9 schools, 4 questions, 2 years (2023–2024). No student records, no institutional data, no identifiable information. Modelled on QILT survey structure.
IP position
Zero institutional data used
Built on PMPC infrastructure using only synthetic responses. Demonstrates Cortex AI SENTIMENT() and COMPLETE() pipeline capability without requiring access to any institution's survey platform or student data.
Coverage
750 records · 4 questions · 9 schools
Q1 Teaching Quality, Q2 Student Support, Q3 Learning Resources, Q4 Campus & Facilities. Domestic/International split. Undergraduate/Postgraduate. SES, GOS, and GOS-L survey types.
Loading dashboard...
Architecture
How the pipeline works
End-to-end architecture from survey data to executive dashboard - built inside existing government cloud infrastructure.
Data Preparation
Microsoft Excel
Extract Transform Load
Microsoft Azure
Gold
Analytics-ready
Silver
Cleansed · Validated
Bronze
Raw ingest
Cortex AI
Snowflake
Semantic Model
Access Tiers
Executive Dashboard
Outputs
Executive benefits
Speed
Minutes vs weeks. Hours to build, minutes to refresh.
Consistency
Eliminates manual variability. Same model, every response.
Actionability
Quantified theme insights. Colour-coded by sentiment.
Need qualitative survey data analysed at scale?
Snowflake Cortex AI sentiment and theme extraction, Microsoft Fabric semantic model, Power BI dashboards with faculty-level filtering. Scoped, quoted, delivered.