Jacob’s Intern Experience at Continuum

My first stint at Continuum has got off to a busy start- here's what I’ve been working on so far.  

I quickly achieved my Alteryx Designer Advanced and Savant Core Certifications and was keen to start applying them.  

Spatial Mapping

In my first project, I utilized Alteryx’s spatial mapping features to analyze voter turnout data from the 2022 Jersey election. I created a heat map of Jersey, visualizing voter turnout across different parishes. This tool provided valuable insights to government representatives, helping them strategically plan campaign efforts for future elections by identifying areas of high and low voter engagement. 

Risk Assessments with ChatGPT

In my next project, I developed a solution for a company's risk department, which needed an automated system to assess the reputational risk of potential clients. I designed an Alteryx workflow that scanned RSS feeds from financial regulators for relevant news articles. The data was then cleaned, and the ChatGPT connector summarized the articles, assigning a severity rating to each individual. We integrated a custom chatbot into the workflow, enabling easy queries. This system allowed the Head of Risk to proactively address potential issues with new clients, safeguarding the company's reputation. 

Sentiment Analysis

I faced a similar challenge with a local art charity. The client wanted to use social media to identify how to attract new people to the arts with a data-driven approach. Typically, this involved manually sorting through reviews and comments online before analysing them for campaigns—a tedious and sometimes insurmountable process when dealing with thousands of comments. We scraped Facebook comments using Python and Selenium and prepped the data in Alteryx. Using a ChatGPT connector, we then performed sentiment analysis, rating each comment out of 10 based on custom standards. The client could also view ratings via keywords such as accessibility and music. The workflow finally provided an overall review of the event. This massively reduced human administrative work, allowing the client to refocus on future campaigns. 

Overall, I’ve been able to use Alteryx and Savant in a diverse and fascinating set of projects. I’m excited to do more!