NUCLEON BI STUDIO

Nucleon BI Studio is a powerful and innovative business intelligence software, reporting, visualization, mining and data analysis for relational systems and NoSQL. 

Learn more about NUCLEON BI STUDIO

Request a Quote

What is NUCLEON BI STUDIO?

Analyze and visualize your data

Nucleon BI Studio is a powerful and innovative business intelligence software, reporting, visualization, mining and data analysis for relational systems and NoSQL. Use BI Studio, and easily connect to any data source by analyzing and viewing the modules and features provided.

Connections

Nucleon BI Studio supports MongoDB, NuoDB, Oracle, IBM DB2, IBM Informix, IBM Netezza, Ingres, SQL Server, SQL Azure, MySQL, PostgreSQL, FireBird, SQLite, Apache Hive, OData, Esri GeoDB (SDE, Personal, and FileGDB), MS Access, and EffiProz database systems. BI Studio also connects to any database system via OData, ODBC, OleDB, MS Excel, MS FoxPro, dBASE, REST, XML, JSON, SharePoint, WordPress, and AutoCad Plant3D data connections.

Powerful resources

Nucleon BI Studio is the only BI product to offer the full range of business intelligence features such as: Reports, Dashboards, Charts, PivotTables, Advanced Visualizations, Statistics, R Statistics, SQL Query, JSON Query (MongoDB), C# (LINQ), and F#Scripting. Consolidate, prepare, browse, visualize, query, and analyze data from any source or database system with Nucleon BI Studio

Installation and Work

Easy to use, it has simplified integration and automation, offering a clear business intelligence environment that improves user adoption and enables better decision making. Nucleon Software offers BI products for technical and non-technical users. In this way the client is able to simplify their tasks with correct and modern functionalities according to their analytical needs. Thanks to BI modules, you increase productivity by allowing your organization to make immediate and correct decisions.

Dashboards

Business dashboards transmit complex information quickly. They translate information from your various systems and enterprise data into visually rich presentations. They use reports, maps, charts, and other graphics to demonstrate various results together. BI Studio provides an easy-to-use dashboard designer with rich components. With dashboard components, add reports, charts, query results, images, text components for viewing data from any source.

Report

It is a key feature within Nucleon BI Studio. BI Studio provides a powerful and modern reporting module, allowing you to connect to any database or data source system. It allows you to create queries, flexible reports and full of features, charts, data grids and pivot tables. Reports can be exported to MS Excel, Word, Open Office, PDF, XPS, XML, HTML, CSV, and Image formats.

Graphics

Nucleon Charting provides a visual graphics designer and supports 2D and 3D graphics.  Bar, Line, Spline, Area, Pizza, Point, Bubble, Stock and Floating Bar. It supports an unlimited number of chart areas, titles, captions, annotations, data series, points, dates, times, coins and more. Nucleon Charting has more than 50 financial and statistical formulas for data analysis and transformation.

PivotTable

The PivotTable module provides a pivot table similar to MS Excel (crosstab) designed for multidimensional data analysis and cross-table reporting. The Table dissects sets of information into compact and summarized visual reports.

Statistics R

The R module connects to the R statistics engine, running R scripts and calling the plot to the GUI output. Today, the R language is used by data scientists and programmers for statistical computing. The R language is a GNU project and is free software.

LINQ Queries

BI Studio provides the LINQ query editor, enabling dynamic queries (LINQ to Dataset and LINQ to XML) to run on database systems and data sources. Write advanced data analysis scripts using the LINQ feature and powerful .Net C# programming language.

SQL and JSON queries

BI Studio provides a powerful and intuitive SQL query editor for running SQL query commands. Using SQL Query Editor, the user can edit SQL commands or scripts on any database system. The query editor supports code highlighting, code padding (IntelliSense), and text location/replacement features.

Data Export

BI Studio allows your users to export data from one or more database tables or views to common file formats. The Data Export feature allows export to these file formats: SQL, XML, HTML, CSV, MS Excel, MS Word, OpenOffice Calc, and Writer, RTF, PDF, XPS, JSON, dBASE, and PNG. The export of all database data and the structure (Table, Preview, Procedure, etc.) will be possible thanks to SQL Script for backup.

Data import

BI Studio allows users to import data into database tables from XML, CSV, and SQL files. It also allows you to import data from another 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.

Main modules and features

  • Multiple Database Connections
  • Database Explorer: View and export tables, views, or collections.
  • Relatórios: Advanced Reporting Designer e Viewer
  • Gráficos: Chart Designer e Viewer
  • Dashboards: Dashboard Designer e Viewer
  • Pivot Table: Design and Display OLAP Pivot Tables
  • Search: data search and mining
  • C # Scripting: Advanced .Net C # Scripting com LINQ.
  • Distributed computing: .net-based mapping and reduction and computation structure
  • Queries: SQL and JSON queries as data source
  • Ad-Hoc Query: SQL, JSON Query Editors with .Net Extensions
  • R Statistics: R Software for Statistics.
  • Mathematical Computing: Math.Net for Mathematics
  • Scripting F#: Support F# languages for scripts.
  • Data Viewers: Text Viewer, Graphics and Images
  • Table Editor: Create, edit, or delete data records.
  • Data export: Export data to XML, CSV, HTML, HTML5, MS Excel, MS Word, OpenOffice, PDF, XPS, JSON, SQLite, and MS Access file formats.
  • Data import: SQL, CSV, and XML data import, Import data from other database systems.
  • Data package: Export/import data packets.
  • Data Visualization: Table View, Tree View

Planned resources

  • ETL and Data Transformation Features
  • Google / Bing Maps support
  • Task and WinService Support

Supported fonts

  • Esri GeoDB (FileGDB, PersonalGDB, Oracle, SQLServer, DB2, Informix, PostgreSQL)
  • MongoDB
  • NuoDB
  • IBM DB2, IBM Informix, IBM Netezza
  • Ingres 9 or higher
  • Oracle 7 ou superior
  • MS SQL Server, MS SSAS, SQL Server CE e SQL Azure
  • MySQL 4 or higher
  • PostgreSQL 8 or higher
  • FireBird 1.5 or higher
  • SQLite Dice Bank
  • MS Access database
  • Microsoft Excel and FoxPro connections
  • Conexões OData, ODBC e OleDB
  • dBASE, IBM Lotus Notes, Pradox, CSV, plain text and XML files
  • Apache Hive
  • SharePoint, Esri ShapeFile, XML, Json, API de descanso
  • ESRI GeoDB e ESRI ShapeFile
  • AutoCAD Plant 3D and AutoCAD P & ID Database
  • WebDBBridge for remote database connection
  • WebDbProxy for connecting to a data source

System Requirements

Windows XP / Vista / Windows 7 (32/64 bits)

You don't know what software you need or you haven't found what you were looking for?

You don't know what software you need or you haven't found what you were looking for? We have a team ready to help you choose the right software for your company.