Nucleon BI Studio (Business Intelligence Studio) is a powerful and innovative business intelligence, data reporting, data visualization, data mining and data analysis software for the relational and NoSQL systems. Using Nucleon BI Studio, you can easily connect to any datasource, analyse and visualize it using provided business intelligence modules and features.

Datasource Connections
BI Studio supports MongoDB, NuoDB, Oracle, IBM DB2, IBM Informix, IBM Netezza, Ingres, SQL Server, SQL Azure, MySQL, PostgreSQL, FireBird, SQLite, Apache Hive, OData, MS Access, MS FoxPro, dBASE, Http-REST, Http-Xml, Http-Json, SharePoint, AutoCad Plant3D and EffiProz datasources. BI Studio can connect to any database system via OData, ODBC and OleDB technologies.

Powerful BI Features
BI Studio is the only BI product to deliver the complete range of business intelligence capabilities like: Reporting, Dashboards, Charting, Workflows, OLAP (Pivot Table), Scripting, Queries, data analysis as well as data integration, on a single proven architecture. It supports R software for statistical computing, plotting and data analysis. Using BI Studio, you can rapidly consolidate, prepare, browse, visualize, query and analyze data from any data source.

Install and Work
Easy to integrate, easy to use and deploy, Nucleon BI Studio delivers a simplified business intelligence environment that improves user adoption and enables better decision-making. We offer BI products for both technical and non-technical users, so you can simplify your tasks with the right modern interface and functionality for your unique data consumption and analytic needs. With our BI modules(reporting, charting, dashboarding, workflows, SQL and LINQ Queries, OLAP Module, Data Search Module etc...), you’ll increase your productivity and enable your organization to make the right business decisions, right away.

Dashboard Module
Business dashboards communicate complex information quickly. They translate information from your various corporate systems and data into visually rich presentations using reports, maps, charts, and other graphical elements to show multiple results together. BI Studio providers an easy to use dashboard designer and rich dashboard components. Using Dashboard components you can add reports, charts, query results, images, texts components to visualize data from any data source. It supports multiple database connections; which means you can add different data source connection for every dashboard component as a data source.

Reporting
Reporting Module is a key capability within Nucleon BI Studio, a single product that provides complete BI Reporting capabilities on a proven and modern architecture. BI Studio provides powerful and modern reporting module, which allows you to connect any database or datasource system. It allows you to design queries, create flexible and feature rich database reports, charts, data grids and pivot tables. It supports all MS Office products and the reports can be exported to MS Excel, MS Word, MS PowerPoint, Open Office, PDF, XPS, XML, HTML, CSV, JPEG, GIF, PNG formats.

Charting
Charting is important and core data visualization method for the business intelligence solutions. Nucleon Charting supports 2D and 3D Charts and provides Bar (Standard, Manhattan, Cylinder and more...), Line, Spline, Area, Pie, Point, Bubble, Stock and Float Bar charts for data visualization. BI Studio provides an easy to use chart designer and viewer for relational and not relational (NoSQL) database systems.

Pivot Table
BI Studio provides OLAP Pivot Table features for easy visual data mining and analysis. The OLAP module provides MS Excel-like pivot table engineered for multi-dimensional data analysis and cross-tab report generation. Pivot Table has the power to visualize hard to read and difficult to dissect dataset information into compact and summarized visual reports.

Pivot Table
BI Studio provides OLAP Pivot Table features for easy visual data mining and analysis. The OLAP module provides MS Excel-like pivot table engineered for multi-dimensional data analysis and cross-tab report generation. Pivot Table has the power to visualize hard to read and difficult to dissect dataset information into compact and summarized visual reports.

Workflows
BI Studio provides Windows Workflow Foundation, which is a Microsoft’s technology for modelling implementing and executing business intelligence workflows and processes. Windows Workflow Foundation is the programming model, engine and tools for building workflow enabled applications on Windows. Using Workflow designer, you can create workflows and add data export, import and report activities to your workflow.

LINQ 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 Queries
BI Studio provides powerful and intuitive SQL 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
Database Master 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, 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
Database Master allows users to import data into database tables from XML, CSV 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.

Data Package Export/Import
Data Package feature allows you to easily bundle and export your database or table data as a data package and share them with other users or applications. Data Package feature is allows you to export and import your sensible data without data corruption and data loss. The data package can be protected with a password for data security and protection.

Main Modules and Features

Multiple Database Connections to Dtabase Systems
Database Explorer Module: View and Export Data Tables, Views or Collections.
Reporting Module : Design/View/Edit Powerful Database Reports
Charting Module : Chart Designer and Viewer
Pivot Table Module: Design and View OLAP Pivot Tables
Dashboard Module : Dashboard Designer and Viewer
Workflows Module: Workflow Designer and Viewer
Data Search and Data Mining Module
Scripting Module: Advanced .Net C# Scripting with LINQ.
Query Module: Advanced SQL Query and SQL Editor with Intelle-Sense.
R Module: R Software for Statistics.
Data Visualizers: Text Visualizer, Chart Visualizer, Image Visualizer
Table Data Editor: Create, Edit or Delete data records.
Data Export: Export to XML, CSV, HTML, HTML5, MS Excel, MS Word, OpenOffice, PDF, XPS, JSON etc.
Data Package Export/Import data packages.
Data Import: SQL, CSV and XML Data Import, Data Import from other database systems
Table View, Tree View and Advanced Data View

Home:

http://www.nucleonsoftware.com/Products/Nucleon-BI-Studio

[/b]

[b] Only for V.I.P

Warning! You are not allowed to view this text.