Pentaho (Community version) will suit your purpose perfectly.
Pentaho has separate software programs for each aspect of BI (ETL, cubes creation, drilling/MDX, reports, dashboards, automation, etc), making it easy to understand the various activities of Business Intelligence.
Each of the entities is Open Source. That means that not only it is free, but in ...
I have used and recommend Saiku.
It is a Pentaho plugin, you have to install it from Marketplace after you have installed and launched the Pentaho BI server.
Saiku allows you to explore and drill down data with a nicer interface than Pentaho's default.
It also allows you to quickly create graphs:
To create more advanced reports/dashboards, Saiku also ...
You can use Talend ETL:
free and open source. It was actually the first major open source ETL, founded in 2005.
supports all major DBMSs like PostgreSQL, SQL server and so on.
last time I use it a few years ago I and a few other friends who had tried found it pretty user-friendly (but it might be a bit biased as at that time I was in France and Talend was ...
To build simple and complex Etl processes I recommend Kettle. Currently named Pentaho Data Integration. Written in Java with nice GUI and easy to integrate in Java software. Source available. See website.
You can use Pentaho:
free and open source
supports all major DBMSs like PostgreSQL, SQL server and so on (even NoSQL databases).
when I was reviewing ETL open source solutions a few years ago it was the most mentioned one along with Talend.
UI pretty similar to Talend (Spoon is the design interface for building ETL jobs):
The only open source framework I know(and used) for ETL processing in java is Spring-Batch and it's the only implementation(AFAIK) of the jsr-352. I'm not sure if it suits you because in a simple google search I found some pure ETL frameworks like CloverETL but I haven't tried them yet so I can not have an opinion. So far I've been using Spring-Batch for ...
I recommend Power Bi Desktop. It is a free application to download and free to use. It has a very robust community users helping others and has a trove of open source visuals to use to build reports. It fulfills all of your requirements (except the PHP one):
retrieve data stored in a database or similar
Power Bi Desktop can pull from a wide variety of ...
Try Power Pivot (previously PowerPivot).
Power Pivot is an Excel add-in for Excel 2010 and 2013 that allows you to efficiently analyze and report on millions of rows of data.
It's not technically OLAP, but I think it meets your primary business goals. When you connect Power Pivot to a data source, such as Microsoft SQL Server, you do it in much the same ...
I have used Palo OLAP with Palo for Excel. Wasn't very practical or fast tho.
I have tried Pentaho also. Until version 4.8, not practical at all - too many configs, a simple change in the underlying data structure (or DBMS config) required lots of changes on the software config. Pentaho 5 simplified this very much, but I still feel like having too much work ...
Syncfusion provides an end to end Dashboard solution that can be used for Enterprise Dashboards and Analytics.
Visualize data in form of gauges, charts, data tables, etc.: Yes
Integrate with database sources like MySQL and MongoDB: Yes
Perform analytics in the back-end to generate analyzed results from datasets as cron jobs do: Can be done with the ...
Back in the lost days of programming without resources (three months ago), I used ART - A Reporting Tool (http://art.sourceforge.net/) to build quick and dirty data visualizations. It's a open-source, cross-platform reporting solution.
It's the lightweightEST solution around (there is a version that takes only 2.5mb of disk space, compare with 1.8 gigs of ...
Actually there are a lot of apps with some similar features and with some differences. I'd made a short presentation for inner clients during my work to choose an app for us. As a user of BI, not a developer, I looked at app from simple point of view. I wish it works fine, do what I need for the cost we can pay. As i understood there is no full web-analog ...
You could have a look at Phase which initially only supports Mondrian 3.
(Mondrian 4 is still not production ready. But don't worry about this because it will read a 3 schema and write out a converted 4 schema automatically. so upgrading is simple.)
It's also in the marketplace:
First of all, you may want to split your data set into cities. This will probably yield better results than keeping everything together.
Then the tool of choice probably is ELKI:
It contains lots and lots of algorithms for outlier detection. In particular, it has the Local Outlier Factor (wikipedia), which exactly tries to capture local differences in ...
Syncfusion provides an end to end Business Intelligence Solution.
Need a BI solution that allows me to create web reports templates and return the data according to the branch: Yes. Can be implemented using user based filters
The company have + 800 branches so it's impossible to create each report 800 times - You only need one report/Dashboard for all the ...
You can use Talend ETL:
free and open source
founded in 2005.
supports all major DBMSs like PostgreSQL, SQL server and so on, as well as Microsoft Excel files.
can export jobs as web pages and can even expose an ETL Job as a Web Service using Talend ESB.
Pentaho CE is the perfect tool for this.
It allows you to define sources (for instance Excel, a database, etc), then draw reports and graphs, which are presented on a web interface, and can be embedded in your website.
It is free and open source.
It also does ETL, cubes, dashboards, etc if you need.
Syncfusion Dashboard is an end to end Dashboard and Business Intelligence solution.
Dashboards can be deployed with the dashboard server or embedded in your web application.
The Dashboard Platform available for free through the community license if you qualify (less than 1 million USD in revenue) and flat licensing is available even otherwise (...
I had been myself searching for this for a long time. Although the following did not suffice my use-case, probably, they might for you.
Kool Report should be most relevant to you use-case
I would suggest looking into using Jupyter and Pandas. Jupyter notebooks let you work inside a browser window with the full power of python, and other kernels, and with plots, graphs, etc. while Pandas is great for manipulating the data that you have to generate the sort of displays that you are talking about.
I think you should try DBxtra, it's a BI tool that is easy to use and lets you design reports mainly by drag and drop from the the query to the final design, but it also lets you modify the query manually so you can tweak it to your liking; answering to your requirements:
Provide users with an ad-hoc reporting tool
Currently, only Designer users can design ...
What you are looking for is Metabase.
It can be install in 5 minutes on any Windows, Linux server or Docker.
It's installed on premises so no data goes outside of your network.
It allows connections to multiple Databases. (Postgres, MySQL, Druid, SQL Server, Redshift, MongoDB, Google BigQuery, SQLite, H2, Crate, MariaDB)
It's Open Source so no license ...
I'm currently working on a startup for just this purpose: https://mydash.io.
It's completely free during beta so come and check it out :)
Unfortunately, I don't have all of your networks connected yet, but if you ping me on the inapp chat I'll try to connect the rest asap. It's demand and supply basically. :)
It's important to customize the business plan's block
This may not be a direct answer, but cloud tools such as kintone or Zoho Creator are flexible online databases (aPaas) that can be built up with drag and drop. They are not out-of-the-box-business-planning-apps, so it's not going to immediately solve what you need. These tools are more like lego blocks ...
Pentaho can do that. It is free and open source.
The steps would be:
Add your MySQL database details to the Pentaho data sources
Using Pentaho Report Designer, design your report using parameters and getting data from MySQL
Every X days, call Pentaho Report Designer with the parameters you want, either from the command-line or from the Pentaho web ...
By what you describe i think you need to take a look at DBxtra, this is a BI tool that can generate reports easily and send them in an automated fashion every certain time (like daily, weekly monthly, and so on), regarding your requirements it can:
Take arguments (parameters)
Access the database directly (Direct connection to MySQL)
Generate multiple ...
A useful accounting software for small businesses is Billbeez. Billbeez gives you a comprehensive overview of all of your financial data which allows you to easily track your payments and even alerts you in the case of missing and unpaid bills. This software essentially renders a bookkeeper useless.https://billbeez.com/?utm_source=stack_exchange&...
Here are the most popular:
More expensive than QuickBooks, but it offer a lot of more features.
Fairly cheap for start-ups.
Sage (formerly Peachtree)
Online (cloud-hosted) accounting software for your small businesses.
I think they all offer on-line access, software and mobile apps.
Personally I would recommend FreeAgent, as I ...
From what you describe i believe you're looking for something that requires minimal IT knowledge, if that's the case, you can try DBxtra, which lets you create a report from query to final design by pure drag and drop, although if you want to fiddle with the SQL code to optimize it or improve it, you can do so.
Also, with DBxtra you can connect to your ...
I would suggest taking a look at Python + Pandas. Both are free, open source and have a lot of references available including very active communities. Python has a relatively shallow learning curve and Pandas has a lot of capability to handle disparate data.
Reports could be produced on a schedule or on demand if you set up a server to do so.