About BI Studio

BI Studio (Business Intelligence Studio) is a powerful and innovative business intelligence, reporting and data analysis software for the MongoDB, Oracle, IBM DB2, IBM Informix, IBM Netezza, Ingres, SQL Server, SQL Azure, MySQL, PostgreSQL, FireBird, SQLite, MS Access, MS FoxPro, dBASE, EffiProz database systems. It supports R software for statistical computing, ODBC and OleDB connections to any database and direct connections to MS Excel, Pradox, IBM Lotus Notes, CSV, Text and XML files.

BI Studio simplifies reporting, analyzing, managing, editing, visualizing, exportig and importing data from databases and files.

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

BI Studio provides powerful and intuitive SQL query editor to execute query commands. Using dynamic SQL Query, 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.

The Report Designer is the core part of the BI Studio. BI Studio provides powerful and modern reporting system, which allows you to connect to your databases, design queries, create flexible and feature rich database reports, charts, data grids and pivot tables. The reports can be exported to PDF, XPS, XML, HTML, Word, Excel, RTF, TXT, CSV, EMF, BMP, JPEG, GIF, PNG, TIFF file formats.

BI Studio integrates the R statistical analysis software, combines LINQ, SQL and R statistical analysis with business intelligence to deliver easy and low cost data warehouse solutions. It can be used with the combination of SQL, LINQ and R statistical software. Using BI Studio with R combination, you can analyze your database data with R Scripts. R is a free software environment for statistical computing and graphics.
More about R Statistical software

BI Studio provides rich data export features. The data can be export in the most popular file formats like: XML, HTML, CSV, MS Excel, Word and PowerPoint, OpenOffice Calc and Writer, RTF, PDF, XPS, JSON, dBASE and PNG.

BI Studio allows you to import data from any database/file connection to the current connected database. Using this feature you can import data from different database engine or data source to current database. BI Studio also allows to advanced data import from CSV and XML files.

The Pack&Go feature allows you to export and import your database data as a data package, provides an easy way to export/import database data.

• Advanced Charting
• Rich Dashboards
• Advanced LINQ Query
• Advanced SQL Query
• Advanced Reports Manager : Desing/Generate/Edit Powerful Reports
• R Software for Statistical Computing
• Multiple Database Connections
• Table Manager: View/Export Tables
• View Manager: View/Export Views
• Data Visualizers: Text Visualizer, Chart Visualizer, Image Visualizer
• Table Data Editor: Create, Edit or Delete data Records.
• Rich Data Export: XML, CSV, HTML, MS Excel/Word, OpenOffice, PDF, XPS, JSON etc.
• Pack&Go Data Export/Import: Export and Import your data as a data package.
• CSV Data Import: Import any size of CSV file.
• XML Import: Import XML files into your database.
• Advanced Data View
• Data Search/Mining: Search your data without SQL and rich search features ( Fuzzy and RegEx).