Complete Platform Tour

Kyubit BI Tools & Platform Features Overview

Take a comprehensive tour of the Kyubit Business Intelligence suite. Built specifically for on-premise Windows/IIS environments, Kyubit delivers native SSAS OLAP exploration, self-service SQL reporting, semantic data modeling, and automated report distribution—all fully managed on your private servers.

Semantic Data Modeling

Agile Semantic Layer & Data Models

Abstract complex SQL schemas and Excel workbooks into governed, user-friendly business models. Define measures, dimensions, hierarchies, and relationships without writing complex MDX or backend data transforms.

Explore Semantic Modeling →
SSAS OLAP Analysis Tools

Web SSAS OLAP Analysis & MDX Engine

Deliver a fast, browser-based OLAP client for Microsoft SQL Server Analysis Services (both Multidimensional cubes and Tabular models). Business users can slice, dice, drill down, and calculate variances without MDX code.

Explore SSAS OLAP Tools →
Interactive BI Dashboards

Interactive BI Dashboards & KPIs

Create real-time operational and analytical dashboards. Leverage full drill-through paths, balanced scorecards, animated time-series charts, and gauge meters with live SQL and SSAS query feeds.

Explore BI Dashboards →
Kyubit BI Platform Tools and Visualization Interface
Infrastructure & Security

Secure, Self-Hosted BI Architecture with Active Directory

Kyubit installs directly on your local Windows Server / IIS infrastructure, ensuring your data never leaves your corporate perimeter. It provides native Windows Authentication and Active Directory (AD) integration, allowing seamless single sign-on (SSO) and role-based permissions management.

Administrators can define row-level data access filters, manage user folders, and securely expose dashboards over HTTPS for intranet users and remote field teams through an on-premise dashboard server.

  • Key Features: Native Active Directory syncing, Windows Integrated Authentication, row-level data security, detailed audit logs.
  • Who It's For: IT Security Officers, Systems Administrators, and enterprise infrastructure teams.
  • Why Use It: Full data sovereignty on your private server without cloud exposure or compliance risks.
Kyubit On-Premise Architecture and Active Directory Security
Modernizing SSAS Multidimensional Cube Analytics
Legacy Modernization

Modernize Legacy SSAS Multidimensional & SSRS Reports

Organizations with mature SSAS Multidimensional cubes often struggle with outdated client tools or complex SSRS environments. Kyubit replaces legacy web viewers with a modern, high-speed HTML5 pivot grid and visual analysis client.

Without altering your underlying OLAP cubes or writing complex queries, users gain instant ad-hoc slice-and-dice exploration, automated time-intelligence calculations (YoY, MoM, YTD), and a lightweight alternative to SSRS reporting.

  • Key Features: Web-based MDX cube browsing, visual drill-down, automated YoY/MoM time intelligence, ad-hoc slice & dice.
  • Who It's For: Microsoft BI developers, SQL DBAs, and reporting analysts using SSAS cubes.
  • Why Use It: Modernize existing SSAS cube infrastructure with a web UI without rebuilding data models.
Licensing & TCO

Dedicated On-Premise Alternative to Power BI

If you require enterprise analytics without recurring cloud subscription costs or external data residency risks, Kyubit offers the dedicated on-premise alternative to Power BI.

With transparent unlimited user licensing models, you can distribute reports and dashboards across thousands of internal employees without per-seat licensing penalties or expensive premium server tier lock-in.

  • Key Features: Unlimited user server licensing, perpetual or low-TCO subscription options, direct on-premise connections without cloud gateways.
  • Who It's For: CIOs, CFOs, and IT directors evaluating budget-conscious, scalable BI alternatives.
  • Why Use It: Eliminate monthly per-user licensing costs while retaining private on-premise infrastructure.
Kyubit vs Power BI On-Premise Comparison
Self-Service Analytics

Self-Service SQL & Excel Ad-Hoc Reporting

Empower non-technical business teams to query live relational databases independently. Through self-service SQL reporting, users can connect directly to SQL Server views and tables, aggregate metrics, and design ad-hoc reports without IT intervention.

Have critical business data locked in spreadsheets? Kyubit’s Excel web dashboard integration allows users to import, model, and automate data refreshes directly into interactive visualizations.

  • Key Features: Direct SQL table/view queries, visual report designer, Excel/CSV spreadsheet imports, automated data refresh.
  • Who It's For: Business analysts, departmental teams, and power users who need ad-hoc data insights.
  • Why Use It: Enables self-service reporting without writing complex SQL scripts or waiting for IT backlog queues.
Visual Semantic Model Pipeline from Raw SQL to Web Analytics
Multitenant Business Intelligence and Embedded Analytics
OEM & Multi-Tenant

Isolated Multi-Tenant BI & Embedded Portals

Software vendors (ISVs) and service providers can run a unified Kyubit instance to serve multiple clients with complete multi-tenant data isolation. Each client organization accesses a partitioned environment with bespoke branding, users, and datasets.

Easily integrate dashboards and charts into existing web portals and intranets with white-labeled embedded BI features or through our embedded analytics guide.

  • Key Features: Isolated tenant workspaces, custom tenant branding, cross-tenant dashboard templates, IFrame embedding.
  • Who It's For: SaaS providers, ISVs, and multi-branch enterprises providing client-facing analytics.
  • Why Use It: Embed and deliver customer-facing analytics quickly without building custom charting infrastructure.
Automation & Distribution

Automated Scheduled Reports & Email Delivery

Eliminate manual report assembly. Set up automated distribution schedules to deliver live SQL and SSAS reports as attached PDF or Excel files directly to internal stakeholder inboxes.

Customize outgoing emails with the built-in HTML editor, configure mass recipient distribution groups, and trigger automated threshold alerts when metrics deviate from KPI goals.

  • Key Features: Automated recurrence schedules, dynamic recipient contact groups, PDF/Excel attachments, metric threshold alerts.
  • Who It's For: Operations managers, executives, and team leads who need periodic report updates delivered to inbox.
  • Why Use It: Keeps decision-makers updated automatically on schedule without requiring manual report preparation.
Learn more about scheduled reporting →
Scheduled Report Delivery and Email Automation
Deployment Planning

Planning Your On-Premise BI Environment

Deploying Kyubit requires zero specialized hardware or proprietary cloud connectors. It installs as a standard IIS Web Application connecting directly to your existing SQL Server databases and SSAS instances via standard OLE DB / ADOMD.NET data providers.

Read our technical setup documentation and frequently asked questions to review prerequisites for authentication, IIS application pools, and load-balanced multi-server clustering.

  • Requirements: Windows Server with IIS, .NET Framework, SQL Server / SSAS database instance.
  • Deployment Model: 100% on-premise or private cloud infrastructure (Azure VM / AWS EC2).
  • Setup Time: Quick setup and configuration with direct connection to your existing databases.
Plan On-Premise BI Architecture

Typical On-Premise Deployment Architecture

Kyubit operates as a secure intermediary layer, allowing analysts, managers, and remote executives to interact with corporate SQL and SSAS databases through modern desktop and mobile browsers.

On-Premise BI Tools Architecture Diagram

Experience Kyubit BI Features on Your Own Server

Download the fully functional 30-day evaluation version. Simple 5-minute setup on Windows Server / IIS with instant connectivity to your SQL databases and SSAS cubes.

Download 30-Day Free Trial