Media

Business questions, answered through a Snowflake application

Client profile

a media company · Data and analytics · Application and data engineering · Snowflake Cortex Analyst and Streamlit

Media · Snowflake · Applied AI

Book a meeting

01 / Inside the engagement

Situation

The client was developing a natural-language way to explore its analytics data. The application needed to connect business questions to the right data, preserve useful work between sessions and turn results into views people could use.

Conceptual delivery summaryDelivery confirmed by client

Context

  1. Business questions
  2. Data definitions
  3. Analytics data

UTIS contribution

  1. Semantic models
  2. Cortex Analyst application
  3. Reusable queries

Simplified workflow. The case text describes the contribution, delivery stage and evidence.

Explore the full conceptual diagram
Business questions, answered through a Snowflake applicationConceptual delivery summary. Context: Business questions to Data definitions to Analytics data. UTIS contribution: Semantic models to Cortex Analyst application to Reusable queries. Delivery confirmed by client. CONTEXT Business questions Data definitions Analytics data UTIS CONTRIBUTION Semantic models Cortex Analyst application Reusable queries
Conceptual illustration of the engagement. The delivery stage and measurement scope are described in this case study.

02 / Inside the engagement

What UTIS did

  • Developed a Streamlit application using Snowflake Cortex Analyst, with semantic models that map business terms to the underlying data.
  • Implemented saved queries, persistent sessions and chart presentation improvements in response to client feedback.
  • Reviewed prompts and outputs, tested edge cases and documented issues and follow-up changes.
  • Prepared deployment and handover documentation, working with the client on demonstrations and the next set of enhancements.

03 / Inside the engagement

Results

  • The application and Snowflake integration were delivered, with deployment and QA recorded in the engineering work history.
  • The client separately confirmed UTIS had developed the Snowflake integration and Cortex AI work.
  • Saved queries, session persistence and documented handover supported continued development of the application.

Why it matters to you

A useful AI interface needs more than a chat box. The data definitions, query behavior, session handling and testing all need attention before a team can evaluate it in its own business context.

Stack

SnowflakeCortex AnalystStreamlitPythonSemantic modelingApplication testing

Evidence basis: client confirmation of UTIS development, supported by delivery, deployment and QA records. These records establish the work delivered; they do not establish adoption, answer accuracy or financial return.

Meet with UTIS

Discuss a similar project.

Tell us what you need to improve. We’ll discuss the relevant experience, the constraints and a practical next step.

Choose a preferred time

Book a meeting

UTIS will review your preferred time and confirm the meeting by email.