Transform SQL Data into a Powerful Self-Service BI

Kyubit is a streamlined self-service BI tool that empowers users to instantly transform raw SQL data into high-performance multidimensional analytic models. By bridging the gap between static databases and interactive insights, Kyubit allows you to build a sophisticated, web-based analytics environment without the complexity of traditional OLAP cube development.

Self-Service BI Tools for SQL

Unlock your data’s potential with Kyubit’s Self-Service BI tools. Skip the complex process of building data warehouses and OLAP cubes. With Kyubit, business professionals can swiftly import data from SQL queries, Excel, or CSV files to create powerful Analytic Models in minutes.

These models provide multidimensional analysis capabilities similar to traditional OLAP cubes, making your data immediately available for interactive reports and dashboards. To ensure your insights stay fresh, you can automate data reprocessing and schedule updates directly from your sources.

Experience the ease of professional data analysis and real-time reporting with Kyubit.

Prepare SQL Data for Self-Service Analytics

If you can write a simple SQL query, it will return the results that you can use to create an analytic model for self-service analytics and business intelligence dashboard visualizations and management. Also, if your data is stored in Excel/CSV files, it could be quickly utilized and transformed into analytics models.

Transform SQL query to a beautiful Dashboard analytics

Kyubit's business intelligence platform enables its users to smoothly transform relational databases into business intelligence dashboards and self-service analytics for data exploration and quickly isolate business important data and insights. The created analytical dashboards could be shared by URL to all authorized users. The dashboards are not one-time created static objects but could be scheduled for reprocessing with the new data from SQL databases data which would automatically refresh all dashboards and other objects based on the same analytic model.

Excel to Dashboard and self-service analytics

Launching SQL Data Analytics...

Once the self-service data model (Analytic Model) is created with Kyubit BI tools, the same user, as well as other authorized users, can quickly create self-service analytics, charts, and reports based on the same Analytic Model with the simple and comprehensive approach (drag-and-drop) that does not require special skills or training. Furthermore, created analysis/report could be used while creating dashboard charts, tables, and KPIs, to visualize prepared data insights by the regular end-user. Kyubit BI includes features to quickly design dashboard layout by drag-and-drop various charts, connecting with previously prepared queries or analyses, positioning and resizing dashboard elements, setting display options for individual dashboard elements, and setting overall dashboard style.

Self-Service BI Tools Tutorials

After Kyubit Self-Service BI 'Analytic Model' is processed, authorized end-users can start the self-service analytics, which will look almost the same as if they are analyzing OLAP cube structures (very similar). End-users can create analyses, reports, and dashboards based on created analytics the same way they are doing with OLAP-based analyses. Most features, like drill-down, drill-through, expanding, slicing, ordering, and data isolating are included in the Analytic model analysis.

Read Step-by-Step tutorials on creating and using Kyubit Self-Service BI 'Analytic Models'...

Self-Service BI Tutorial

How it Works

After you import your data from SQL query results or Excel/CSV files and process 'Analytic Model', Kyubit creates special data structures in Kyubit's internal "KyubitAnalyticModels" database, that is suitable for quick analytic SQL queries. While analyzing data Kyubit is creating SQL queries to bring analytic results from the Kyubit Analytic Models database. In other words, Kyubit is using SQL technology, combined with 'ColumnStore indexes' and some smart caching to deliver data analytics. The only technology prerequisite is the MS SQL Server, which is a prerequisite for the whole Kyubit BI platform product anyway.

Pros

The main reason to use the 'Analytic Model' is for a regular user to quickly add a set of data for analysis, dashboard usage, scheduled subscriptions, and sharing with other users.
Excel/CSV data format should be friendly to all users while preparing data to be used. Any set of data could be exported from Excel to a CSV file (semicolon (;) delimited).
Great usage of Date filters (if data contains date values) that are much friendlier to be used than OLAP ‘date’ structures. Quickly select absolute or relative date filter values in the analysis, report, or dashboard filters.

Limitations

There are some limitations to Kyubit's self-service BI 'Analytic Model' usage, that should be known before using this Kyubit's technology. Kyubit 'Analytic Model' data sources are not created in mind to replace more robust analytic engines, like OLAP or Tabular technology, but to bring a simple solution for smaller data sets that should be analyzed quickly with very little knowledge of data analysis and structures.

'Analytic Model' will perform great with hundreds of thousands of rows of data, even a couple of millions, while we would not recommend being used with tens of millions of rows of data. This question also greatly depends on the hardware on which the SQL server is running.
There are no limitations to the number of category members (rows) in grid analysis and reports, while analytic grid and report can contain a maximum of 128 series (columns) of values in the analysis for each measure in the analysis.
On the category axis, there could be multiple category levels expanding (drill-down) to explore data in more detail, while series members cannot be expanded.