Empower Your Business with Data-Driven Insights

Medial-AI seamlessly connects with your Xero data, enabling smarter decision-making through AI-powered analysis and an intuitive chatbot interface.

Project Industry

Finance & Accounting Software

Media & Links:

Project Link: https://medial-webapp-dev.azurewebsites.net/

Loom Video: https://www.loom.com/share/08cd4fe47bc84263b8bd2e107430442b?sid=f94e0e56-63ee-45bb-96d8-a0c8b86f6518

Overview Image:

High-Level Architecture

The solution integrates OpenAI's ChatGPT-4 with Azure AI Search to interact with Xero Data. Data is sourced from Files, Xero, and processed through AI models and SQL Server for seamless data integration, with Django Web App providing an intuitive interface for end-users.

Project Overview

Challenge Managing and analyzing large volumes of financial data from Xero can be complex and time-consuming, especially when trying to gain actionable insights quickly.

Solution Medial-AI automates the retrieval and processing of your Xero data, providing real-time insights and simplifying data management through a user-friendly platform.

Key Features

• AI-Powered Insights: Utilize OpenAI’s GPT-4o model to ask questions and receive instant answers based on your Xero data.
• Seamless Data Integration: Automatically fetch and process data from Xero, including Accounts, Invoices, Payments, and more.
• Effortless Payments: Integrated with Stripe for smooth and secure transactions.
• Comprehensive Reporting: Access detailed financial reports like Profit and Loss, Balance Sheet, and more.

Tech Stack

• Data Engineering & Pipeline

  • Python & Azure Serverless Architecture
  • Azure Data Factory: terabytes of file data and millions of Xero records

• Web Application

  • Azure Web App
  • SQL Server
  • Azure Application Insights

• AI & Data Integration

  • Azure AI Search (Semantic Search, Vector Search, Hybrid Search)
  • Azure OpenAI (adda-text002, GPT-4o)

• Deployment & CI/CD

  • Azure Containerized Web App
  • GitHub
  • GitHub Actions

Screenshots

• Medial AI Landing Page: User can see the main landing page of Medial AI, providing an overview of its features and functionalities.

---

• Medial AI Accounting Setting: User can access and configure accounting settings specific to Xero integration.

---

• Medial Chat with Xero Content: User can engage with the Medial AI chatbot, interacting with Xero data for insights and analysis.

---

• Medial AI Chat Default without selecting any connector: User can view the default chat interface, awaiting connector selection.

---

• Medial Connectors: User can manage and configure various connectors available within Medial AI for seamless data integration.

---

Empower your business with Medial-AI—your partner in data-driven financial management.