Free Open Source Windows Business Intelligence Software

Jaspersoft® Studio is editing software for JasperReports®. It will help you design and run report templates; build report queries; write complex expressions; layout components like 50+ types of charts, maps, tables, crosstabs, custom visualisations. It integrates JasperReports® Server to create powerful report workflows. You can build documents of any complexity from your data. Print-ready PDFs to interactive dynamic HTML with navigation inside or outside the report. High quality PowerPoint, RTF, Word, spreadsheet documents or raw CSV, JSON, or XML. It's not difficult to build custom exporter to suit any need. Different types of data sources are accessible, big data, CSV, Hibernate, Jaspersoft Domain, JavaBeans, JDBC, JSON, NoSQL, XML, or custom data source. Available as an Eclipse plug-in or a standalone application, it comes in two editions: Community and Professional. The Professional edition includes additional features, maps, advanced HTML5 charts and professional support.

Pentaho tightly couples data integration with business analytics in a modern platform that brings together IT and business users to easily access, visualize and explore all data that impacts business results. Use it as a full suite or as individual components that are accessible on-premise in the cloud or on-the-go (mobile). Pentaho Kettle enables IT and developers to access and integrate data from any source, and deliver it to your business applications, all from within an intuitive and easy to use graphical tool. Need help installing PDI? Access the installation guides for the following operations systems: Windows: https://www.hitachivantara.com/en-us/pdf/white-paper/pentaho-community-edition-installation-guide-for-windows-whitepaper.pdf Linux: https://www.hitachivantara.com/en-us/pdf/white-paper/pentaho-ce-installation-guide-on-linux-operating-system-whitepaper.pdf Mac: Coming Soon

JasperReports Library is the world's most popular open source business intelligence and reporting engine. It is entirely written in Java and it is able to use data coming from any kind of data source and produce pixel-perfect documents that can be viewed, printed or exported in a variety of document formats including HTML, PDF, Excel, OpenOffice and Word. The project is also available at: https://github.com/TIBCOSoftware/jasperreports Jaspersoft Studio is the open source report designer for the JasperReports Library. https://community.jaspersoft.com/project/jaspersoft-studio JasperReports Server is the most popular open source interactive reporting and analytics server built-on JasperReports Library. https://community.jaspersoft.com/project/jasperreports-server JasperReports IO is for reporting and data visualization in a world of cloud, microservices, and DevOps. https://community.jaspersoft.com/project/jasperreports-io

JasperReports Server is a powerful, yet flexible and lightweight reporting server. Generate, organize, secure, and deliver interactive reports and dashboards to users with a web based BI Platform. Available as an open source community edition download as well as a commercially licensed, enterprise-grade business intelligence solution.

SOFA is a statistics, analysis, and reporting program with an emphasis on ease of use, learn as you go, and beautiful output.

ART (pronounced art) is a reporting and business intelligence solution. It enables quick deployment of SQL query results. Supports tabular, crosstab, charts, scheduling, dashboards, export to spreadsheet and pdf. Commercial Support Email: timothy.anyona ( a t ) halogen.co.ke

Quick start your SOA project with a free open source ESB tool to connect applications and data resources. Based on extensible open source technology, Open Studio for ESB enables you to service-enable applications and legacy systems to build a powerful service-oriented architecture (SOA). An Eclipse-based tooling environment with pre-built connectors and components, and built-in enterprise integration patterns simplifies integrating business applications, SaaS, web services, and APIs. Open Studio for ESB is fully open source, so you can see the code and extend it. Thousands of developers use Talend Open Studio to integrate easily with any application, database, API, or web services. Embed existing Java code libraries or leverage community components and code to extend your project. With millions of downloads and a full range of robust, open source integration software tools, Talend is an open source leader in cloud and big data integration.

This material enables IBM SPSS Statistics users to run code written in the R language inside Statistics. Additional free items for R in Statistics and other materials are available from the SPSS Community at www.ibm.com/developerworks/spssdevcentral

JasperStarter is a command line launcher and batch compiler for JasperReports.

DataCleaner is a data quality analysis application and a solution platform for DQ solutions. It's core is a strong data profiling engine, which is extensible and thereby adds data cleansing, transformations, enrichment, deduplication, matching and merging. Website: http://datacleaner.github.io

BIRT is an open source technology platform used to create data visualizations and reports that can be embedded into rich client and web applications. Developers who use BIRT Designer are able to access information from multiple data sources easily and quickly in order to create reports and applications with stunning data visualizations. Actuate now provides a free report server, BIRT iHub F-Type, to deploy BIRT content so developers don't have to build their own infrastructure. With a flexible Open Data Access framework, developers can write custom data drivers to access data from any source, including Big Data sources like Apache Hadoop, Cassandra, and MongoDB, along with all traditional relational databases, Flat Files, XML data streams, and data stored in proprietary systems. Built for embedding, BIRT includes APIs for data access, chart generation, output formats, content execution, and integration within larger applications.

"Estimate" is an Open Source web based Construction Cost Estimating Software designed for medium and large Civil Construction and EPC (Engineering Procurement and Construction) companies. Features include Management of Schedule of Rates, Analysis of Rates, Project Estimation (Definitive and Control), Tender Evaluation, Cost Sheet preparation, BOQ Generation, Audit and Projection. Estimate is suitable for a wide variety of trades and businesses, including but not limited to: General/Industrial Construction, Carpentry, Plumbing, Electrical, Tile Work, Concrete Work, Landscaping, Maintenance & Repair. Building an accurate and comprehensive estimate, for a commercial construction projects can be a long gruelling process. Use Estimate to take full control over the three most important variables in your project i.e. Time, Finance and Resources (Man, Material, Equipments).

Understand and enhance your customers' journey on your web, mobile or desktop application through Countly. Countly is an innovative, real-time, open source mobile & web analytics platform, with rich push notifications and crash reporting tools. Countly securely processes billions of data points every day from mobile, desktop and web apps to help thousands of companies visualize their data, analyze and use it to grow their business. Countly is made up of two main parts: the server collecting and analyzing data, and an SDK (mobile, web or desktop) that sends this data. It comes with several great features: a single secure dashboard where you can access all user profiles, notifications, analytics and other tools; a wealth of plugins; and the option to install Countly on premises or securely in the cloud. Countly is being used by numerous companies the world over, including Apple, AT&T, BMW, SAP, Coca Cola, Sprint and many more.

Snowplow is ideal for data teams who want to manage the collection and warehousing of data across all their platforms and products.

The XMLA Connector provides seamless data connectivity between OLEDB for OLAP (ODBO) clients and XMLA data sources. The connector is designed to interface with XMLA compliant data sources such as Mondrian, SAP, ARQUERY as well as other data sources. The connector was released in 2014 and it is used all around the world, from small businesses to large coorporations. The connector is ODBO compliant and, as such, it loads seamlessly into ODBO clients. The connector is used mostly with Excel (ODBO). Starting with version 1.0.0.58 SharePoint 2013 is supported as Front-End. The connector exposes the IMDDataset interface for classical connectivity. This interface allows axis retrieval and sequential access to data. In addition, bulk access to data is provided through IMDRangeRowset implementation. This allows writing more effective clients that are ultimately faster.

Foswiki is an Enterprise wiki, typically used to run a collaboration platform, knowledge base or document management system. Users can create wiki applications using the Topic Markup Language, and developers can extend its functionality with plugins. Foswiki stands for "Free and Open Source" wiki to emphasize its commitment to Open Source software.

ReportServer is a modern and versatile open source business intelligence (BI) platform with powerful reporting features. With ReportServer you are not limited to one provider's solutions. ReportServer integrates Jasper, Birt, Mondrian and Excel-based reporting: choose what best suits your needs! The source code is also available in GitHub: https://github.com/infofabrik/reportserver ReportServer scripting samples: https://github.com/infofabrik/reportserver-samples

A set of User Defined Functions for Excel to create in-cell charts : Sparklines. Sparklines are the simple, intense, word-sized graphics invented by Edward Tufte. Coded in Visual Basic for Applications.

JaCoP is a Java Constraint Programming solver. It provides a significant number of (global) constraints to facilitate efficient modeling of combinatorial problems, as well as modular design of search. Documentation is available at project Web site. Please, note that the sources from version 4.0 are only available at GitHub.

Fleetco is a web based vehicle fleet maintenance management system written in PHP with MySQL database back-end. Fleetco was initially designed for trucking companies in mind but it can be useful for any person or company having a fleet of vehicles. It will allow the owners to have full control of the maintenance of a vehicle fleet. Download here: https://www.fleetco.space/fleetcodownload/ Fleetco v 1 DEMO (No admin rights) https://www.fleetco.space/fleetcov1/ Username: User Password: user123 Fleetco v 2 DEMO (No admin rights) https://www.fleetco.space/fleetcov2/ Username: User Password: user123 Manual: http://www.fleetco.space/manual/ Version 2 - Features - Multilanguage - Bootstrap responsive theme - Customizable columns - Hide/view columns - Miscellaneous improvements & bug fixes Version 2 Requirements: Web server with PHP 5 to 7.0 with mcrypt extension (PHP 7+ may not have mcrypt extension by default) MySQL Database

SplitPDF -SplitPDF.jar- is a ‘command-line driven’ Java-program, it splits a PDF-file by bookmarks into separated PDF’s. The bookmark is used as title for the newly created PDF. Extremely usefull and fast in a batch processing environment.

ADaMSoft is a free and Open Source Data Mining software developed in Java. It contains data management methods and it can create ready to use reports. It can read data from several sources and it can write the results in different formats.

OpenI plugin for Pentaho CE provides a simple and clean user interface to visualize data in OLAP cubes. It supports both direct Mondrian and xmla based connections like Microsoft SQL Server Analysis Services (SSAS), plus provides add-on features like Explore Cube Data, custom SQL for drillthrough data, publishing drillthrough data to external web services etc.

Query2Report provides a simple opensource business intelligence platform that allows users to build report/dashboard for business analytics or enterprise reporting. The application transforms bunch SQL queries to beautiful google charts. The application caters to real time reporting with automatic refresh functionality. Refer to video tutorials Concepts - https://youtu.be/NdEUZ2suiv8 Data Analytics Demo - https://youtu.be/evCf74Ou7kg Data Forecast Demo - https://youtu.be/Nmi1UIDpFpM Report Showcase - https://youtu.be/gxlEGq5iSm8 Getting Started - https://youtu.be/vyU7BUE5rbs Building First Report - https://youtu.be/MZm6rhf2_Ts Source Repo GitHub : https://github.com/yogeshsd/query2report

csv2odf can create business intelligence reports from csv data sources with output to ods, odt, html, xlsx, or docx documents. It uses a template file that you design to control the layout, fonts, and colors. Just query your database with output to csv (or tsv), then use csv2odf to insert the data into your template to produce a nice looking formatted output. It is a command line tool and you can automate the generation of reports by using scripts and cron. It can be used to create spreadsheets and documents for LibreOffice, OpenOffice, Microsoft Office Excel and Word. It is open source GPL v3 and crossplatform, it can run on most operating systems that can run Python (Python is required). More details, example files, and online manual at http://csv2odf.sf.net.