Nucleon BI Studio

Analyse and Visualize Your Data

Nucleon BI Studio is a powerful and innovative software for business intelligence, data science, reporting, visualization, mining, and analysis, designed to work seamlessly with both relational and NoSQL systems.

With the Nucleon BI platform, you can easily connect to any data source, analyze and visualize your data using the platform’s robust business intelligence modules and features.

Powerful Features

Nucleon BI Studio is the only BI product that offers a comprehensive suite of capabilities, including:

  • Data Management: DataSets, Data Integration, and Data Searches.
  • Reporting and Visualization: Reports, Dashboards, Charts, Power Views, and Cross Tables.
  • Advanced Analytics: Statistics, R-Statistics, SQL Queries, MongoDB Queries, Arango AQL, Couchbase N1QL, and C# Scripting.

With Nucleon BI Studio, you can rapidly consolidate, prepare, browse, visualize, query, and analyze data from diverse sources and database systems—all on a single proven architecture.


Installation and Usability

Easy to install, integrate, and use, Nucleon BI Studio provides a simplified business intelligence environment that enhances user adoption and empowers better decision-making.

Our BI solutions cater to both technical and non-technical users, ensuring a modern architecture and user-friendly interface tailored to your unique data analytics needs.


DataSets

Nucleon BI DataSets allows you to build your virtual data model using data source native query languges. DataSets are base for the charts, reports, cross tables, web pages and scripts.

Every datasource supports its own data query language. You can build virtual DataSets with SQL, JQL( NoSQL), MongoDB , OData, GraphQL, ArangoDB , REST API, GraphQL Query languages. You can build parameters and filter for dashboards.

DataSet List

You can combine more the one datasource in a DataSet list, which allows you to combine data more then one daasources connections in a data model.


Dashboards

Nucleon BI Studio offers an intuitive dashboard designer and powerful components for data visualization, enabling you to explore your data with ease. Build compelling visualizations quickly using a user-friendly interface and a wide array of advanced components.

Deliver Insights Through Dynamic Dashboards

Transform complex information from various corporate systems into visually rich, interactive dashboards. Use reportsmapscharts, and other graphical elements to present multiple results cohesively, ensuring your audience can understand and act on the insights effectively.


Reports

Nucleon BI Studio features a powerful and advanced report designer and viewer for all data sources. The reporting module is a core component of Nucleon BI Studio, offering comprehensive business intelligence reporting capabilities within a single, proven, and modern architecture.

Flexible and Feature-Rich Reporting

Design queries effortlessly and create versatile, detailed data reports, charts, data grids, and cross tables. With Nucleon BI Studio, you can deliver insights through dynamic and visually rich reports.

Export with Ease

Reports can be easily exported to a wide range of formats, including:

  • Microsoft Excel and Word
  • OpenOfficePDFXPS
  • XMLHTMLCSV, and Image formats.

This flexibility ensures seamless integration with your workflows and enhances collaboration across teams.


Charts

Nucleon BI Studio provides powerful and rich charting components for data visualization and visual chart designer. It supports both, 2D and 3D charting and line, spline, area, pie, point, bubble, stock and float bar chart types.

An unlimited number of chart areas, titles, legends, and annotations as well as data series and data points are possible. The charting component moreover supports data copying, merging, splitting, sorting, searching, grouping, and filtering.


Web Pages

Today Web technologies give us the option to visualize with powerful components. Nucleon BI is able to render and visualize Web pages which include HTML, CSS and JavaScript code. It allows to design and to bind data using binding technology to the Web components like table, list, image and other HTML Elements.

Data Binding

With binding technlogy you are able to bind your data to the html components and visualize  on the desktop and web.


Cross Tables

Nucleon BI Studio includes robust OLAP Cross Table features, designed for efficient data mining and analysis. The Cross Table module offers an intuitive, MS Excel-like experience, making it easy to create pivot tables for multi-dimensional data analysis and cross-tab report generation.

Simplify Complex Data

With Cross Table, you can transform complex, hard-to-read datasets into compact, summarized visual reports. This feature provides the power to:

  • Identify patterns and trends in large datasets.
  • Generate actionable insights with interactive, summarized views.
  • Enhance decision-making with clear, visual representation of data.

Nucleon BI’s Cross Table module is a game-changer for anyone looking to simplify and visualize their data effectively.


Scripting

Nucleon BI Studio offers seamless integration with scripting languages, enabling advanced data analysis and customization. It natively supports PythonRJulia, and C# scripting languages.

Run Scripts Directly

With Nucleon BI Desktop/Web, you can execute Python, R, Julia, and C# scripts directly within the platform. This allows you to:

  • Generate datasets dynamically.
  • Create plots and visualizations.
  • Integrate the results into the Nucleon BI data model for further analysis and reporting.

This powerful scripting capability bridges the gap between data science and business intelligence, making it easier to leverage advanced analytics within your BI environment.


Application Integration

Nucleon BI Studio supports integration to third party desktop, web and cloud applications.  It can call any executable application, bat file and or web service as an module.

You can call any applcation and integrate it to your business intelligence project. This feature gives you the option build your data platform wit hyour existing applications.


Slide and Presentation Mode

Nucleon BI Studio supports slide and presentation mode for dashboards. It allows to build easyl dashboards presenations and data monitoring options.

Slide Mode 

Dashboards are sliding by timer and will be updated

Presentation Mode

You are able to show your dahsboards in a presentation (like power point) mode.


Queries

LINQ (C#) Queries

BI Studio provides LINQ query editor which allows you to execute dynamically LINQ to Dataset and LINQ to XML queries against database systems and data sources. Using LINQ feature you can write advanced data analysis scripts using powerful .Net C# programming language.


SQL and JQL Queries

BI Studio provides powerful and intuitive SQL and JQL query editor to execute SQL query commands. Using SQL Query editor, you can execute SQL commands or scripts against any database system. The Query editor supports code highlighting, code completion (IntelliSense) and text find/replace features.


Data Export

BI Studio allows users to export data from single or multiple database tables or views to common file formats. Data Export feature allows you to export into these file formats : SQL, XML, HTML, HTML5, CSV, CSV2, MS Excel, MS Word, MS PowerPoint, OpenOffice Calc and Writer, RTF, PDF, XPS, JSON, dBASE and as PNG images. Users can export all database data and database structure (Table, View, Procedure etc.) as a SQL Script for database backup.


Data Import

BI Studio allows users to import data into database tables from XML, JSON, CSV, CSV2 and SQL files. It allows also data import from other database system using database connections. It provides bulk SQL-Script import without any size limit. The import results will be reported in a log file.

Nucleon BI Studio: Key Features

Database Connectivity

  • Support for multiple database connections.
  • Data Source Explorer: View and export tables, views, or collections.

Query and Data Management

  • DataSets: Build SQL, JQL (MongoDB), and GraphQL queries for data sources.
  • Ad-Hoc Query: SQL and JQL editors with .NET extensions.
  • Data Import: Import data from SQL, CSV, XML, and other database systems.
  • Data Export: Export to XML, CSV, HTML (HTML5), MS Excel, MS Word, OpenOffice, PDF, XPS, JSON, SQLite, and MS Access file formats.
  • Data Package: Export/import compact data packages for seamless data sharing.

Reporting and Visualization

  • Reports: Advanced report designer and viewer.
  • Charts: .NET-based chart designer and viewer.
  • Dashboards: Design and view interactive dashboards.
  • Web Dashboards: Create and view web-based dashboards.
  • Cross Tables: Design and view pivot tables.
  • Power Views: Custom data view designer and viewer.
  • Data Visualization: Combine text, charts, images, and web visualizations into a cohesive presentation.
  • Web Visualization: Create and view web pages using HTML, CSS, and JavaScript.

Advanced Analytics and Scripting

  • Data Search: Perform advanced data searches and mining.
  • Scripting Support: Python, R, Julia, and C# scripting integration.
  • Atomic Framework: .NET-based MapReduce framework for distributed computing.
  • Statistics: Integration with SPSS and R for statistical analysis.

Data Views

  • Explore and display data in various formats:
    • Data Table
    • Tree View
    • XML View
    • JSON View
    • HTML View

With Nucleon BI Studio, you gain access to a comprehensive suite of tools for database connectivity, data analysis, and reporting—empowering both technical and non-technical users to transform data into actionable insights.

Supported Data Sources

Geospatial Systems

  • Esri GeoDB: FileGDB, PersonalGDB, Oracle, SQL Server, DB2, Informix, PostgreSQL
  • Esri ShapeFile
  • AutoCAD® Plant 3D and AutoCAD P&ID Database

NoSQL Databases

  • MongoDB (v2.6 or higher)
  • NuoDB (v1.0 or higher)
  • ArangoDB (v1.0 or higher)
  • Neo4j (v3.0 or higher)
  • Couchbase (v1.0 or higher)

Amazon

  • AWS Redshift

IBM

  • IBM DB2
  • IBM Informix
  • IBM Netezza

Relational Databases

  • Ingres (v9 or higher)
  • Oracle (v8 or higher)
  • MySQL (v4 or higher)
  • PostgreSQL (v8 or higher)
  • Firebird (v1.5 or higher)
  • SQLite
  • Microsoft Access
  • Microsoft SQL Server
  • SQL Server CE

Microsoft

  • Azure Databricks
  • Azure Synapse
  • Azure SQL Database
  • Azure CosmosDB
  • MS SSAS (SQL Server Analysis Services)
  • Microsoft Excel and FoxPro

Data Integration Protocols

  • OData (v2.0, v3.0, v4.0)
  • ODBC and OleDB Connections
  • dBASE, IBM Lotus Notes, Paradox, CSV, CSV2, TAB, Simple Text, and XML Files

Big Data Systems

  • Apache Hive
  • Apache Cassandra
  • Apache Spark

Google

  • Google Analytics
  • Google BigQuery

Web Data Sources

  • GraphQL
  • REST API
  • ODATA
  • SOAP
  • WebDBBridge: Connect to remote databases
  • WebDbProxy: Connect to data sources

Data Warehouse Solutions

  • SAP HANA
  • Snowflake
  • ClickHouse

Other

  • Redis Database
  • SharePoint