BI Studio

BI Studio is a powerful and innovative business intelligence, charting, reporting and data analysis software for the relational and not relational database systems. BI Studio supports MongoDB, Oracle, IBM DB2, IBM Informix, IBM Netezza, Ingres, SQL Server, SQL Azure, MySQL, PostgreSQL, FireBird, SQLite, MS Access, MS FoxPro, dBASE and EffiProz database conenctions. It supports ODBC and OleDB connections to any database and direct connections to MS Excel, CSV, Text and XML files. Reporting:The Reporting tool 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. Charting:Nucleon Data Charting supports 2D/3D Charts and provides Bar(Standard, Manhattan, Cylinder etc.), Line, Area, Pie, Point, Buble, Stock and Float Bar charts. BI Studio provides a chart designer and viewer for the charting. Dashboards:BI Studio providers an easy to use dashboard designer and rich dashboard components. It provides Report, Chart, Web, SQL/JSON Query, Image, Parameter and Text components fo the dashboard. Using this components you can add reports, charts, query results, images, texts to visualize your data easly from any data source. R Statistics: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. LINQ Query: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 Query: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. Data Export/Import: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.

Requirements:

.Net Framework 4