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 reports, maps, charts, 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
- OpenOffice, PDF, XPS
- XML, HTML, CSV, 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 Python, R, Julia, 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 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