AIV Hub - Business Intelligence Platform

AIV Hub is a modern, self-service business intelligence and data analytics platform that empowers organizations to transform raw data into actionable insights. Built for Azure, AIV Hub enables business users, analysts, and data teams to connect to their data sources, build interactive dashboards, and share insights across the organization—all without requiring deep technical expertise or reliance on IT resources. **Intended Audience** AIV Hub is designed for organizations of all sizes seeking self-service analytics capabilities: - Business Analysts who need to create ad-hoc reports without IT support - Marketing Teams tracking campaign performance and customer analytics - Finance Departments building dashboards for budgeting and forecasting - Operations Managers monitoring KPIs and efficiency metrics - Executives requiring high-level dashboards with drill-down capabilities - Data Teams providing governed self-service analytics across the organization **Unique Value Proposition** Traditional BI solutions require extensive IT involvement, lengthy implementation cycles, and specialized skills. AIV Hub bridges this gap with an intuitive, web-based platform that puts analytics directly in the hands of business users while maintaining enterprise governance. Deploy in minutes with pre-configured Azure VM images and start building dashboards immediately with our drag-and-drop interface. **Supported Microsoft Products and Data Sources** AIV Hub integrates seamlessly with the Microsoft Azure ecosystem: - Azure SQL Database and Azure SQL Managed Instance - Azure Synapse Analytics - Azure Database for PostgreSQL and MySQL - Azure Blob Storage and Azure Data Lake - Azure Active Directory for SSO authentication - Microsoft SQL Server (on-premises and Azure VM) Additional supported data sources include PostgreSQL, MySQL, MongoDB, BigQuery, Snowflake, Amazon Redshift, Oracle, and 40+ connectors total. REST API support enables integration with virtually any data source. **Key Capabilities** - 50+ visualization types: charts, maps, gauges, pivot tables, and more - Real-time data refresh with configurable intervals - Role-based access control (RBAC) and row-level security - Export to PDF, Excel, and CSV formats - RESTful API for custom integrations and embedding - Built-in caching and query optimization for fast performance **Prerequisites and Requirements** - Azure subscription with permissions to create Virtual Machines - Azure Virtual Network with subnet for VM deployment - Database server: Azure Database for PostgreSQL (recommended), existing PostgreSQL, or use the embedded PostgreSQL for evaluation - Recommended VM size: Standard_D2s_v3 (2 vCPUs, 8GB RAM) or higher - Network: Port 443 (HTTPS) for web access, port 22 (SSH) for administration **Limitations and Considerations** - Single VM deployment; for high availability, consider load balancer configuration with multiple instances - Embedded PostgreSQL is suitable for evaluation only; production deployments should use Azure Database for PostgreSQL or external database - Maximum concurrent users depends on VM size: ~25 users on D2s_v3, ~50 users on D4s_v3, ~100+ users on D8s_v3 - Some advanced features may require Professional or Enterprise tier **Getting Started** Deploy AIV Hub from Azure Marketplace in minutes: 1. Select your plan and VM size 2. Configure networking and database settings 3. Launch the VM and access the web interface 4. Connect your data sources and start building dashboards Comprehensive documentation, video tutorials, and email support are included. Take advantage of the free trial to evaluate the platform before committing to a paid plan.