Key Achievements

• Integrated LLM-powered querying for Google Analytics data using Google Gemini

• Developed real-time data visualizations with automated natural language trend analysis using Gemini

• Implemented custom REST APIs with documentation and automated unit tests in Jest

• Containerized application with a multi-stage Dockerfile using Node.js on Alpine for minimal image size

Partner Background

ARGO Data is a company in Richardson, TX; which provides data technology and analytics solutions to financial services and healthcare organizations.

Project Proposal

1. Frontend

   • React in TypeScript, Material UI and QUADS for User Interface
   • Charts and graphs powered by Highcharts
   • Widget-based design so users can customize based on their need
   • REST for HTTP requests and Websocket

2. Backend

   • Express in TypeScript, support both HTTP and Web Socket Protocol
   • Integrate Google Analytics 4, Microsoft Clarity, and Looker Studio API to retrieve data from the server
   • Middleware to fetch, process, and cache data for efficient access
   • Store user preferences and data in PostgreSQL, using Prisma as ORM for schema management and efficient querying

3. AI Powered Insights

   • LangChain to support multiple models (ChatGPT, Gemini, etc.)
   • Predictive analytics and anomaly spotting historical data to identify patterns over time and detect unusual behaviors or data points

4. Testing

   • Unit testing (Jest), end-to-end testing (Cypress), linting testing (eslint)
   • Static analysis and vulnerability scan using SonarQube
   • Tested automated using CI/CD pipeline, requiring passing tests to merge with main branch

5. Deployment

   • Built using multi-stage Dockerfile, building the frontend and backend separately
   • Docker Image Build Automated using CI/CD Pipeline

Issues and Pull Requests