Ananas Analytics is a data analytics desktop application, built for non-technical users, but also very useful for skilled users. It keeps the technical barriers very low, by providing a visual interface to build ETL and data analysis that usually requires the expertise of data engineering.

Extracting, transforming, join, concatenate data and loading to a wide range of data source can be easy for non-technical users.

On the other side, Ananas Analytics Desktop is an open source project, provides the possibilities for engineers to customize the code, add new functionalities to adapt non-technical users' special use cases. It also provides several development tools to help engineers build, test, deploy, and run traditional data ETL systems easily.

Some key Features:
offline mode: run analysis jobs on your own computer, without internet connection;
query, transform and analyze with standard SQL, also for non relational database;
support both structured and unstructured data;
minimal knowledge required for Simple SQL;
explore data with built-in charts. Easy to use chart configuration;
execute your job with your existing data platform: Spark, Flink, Google Dataflow. etc.;
privacy and security: data is processed on your computer or your infrastructure.

More information here: https://ananasanalytics.com/
and here https://github.com/ananas-analytics

Leonardo by Paris Technologies Inc. delivers dashboards that are not only visually beautiful, but also alive. This means that all information from Leonardo are connected to the actual source of data (OLAP or 3rd party systems). Therefore, data is dynamically refreshed in real-time, from the source.

Leonardo is a web application that is installed on any Windows operating system machine that includes a web server, which delivers Business Intelligence content for your Microsoft-based BI environment to authorized users.

Users can access Leonardo from intranet or internet, depending on environment configuration.Leonardo is a web application that is installed on any Windows operating system machine that includes a web server, which delivers Business Intelligence content for your Microsoft-based BI environment to authorized users.

It takes 5 minutes to download and install Leonardo, for the first time or as a software upgrade.Leonardo is a web application that is installed on any Windows operating system machine that includes a web server, which delivers Business Intelligence content for your Microsoft-based BI environment to authorized users.

Leonardo is accessible from various web browsers and has an intuitive interface that is easy to adopt.Leonardo is a web application that is installed on any Windows operating system machine that includes a web server, which delivers Business Intelligence content for your Microsoft-based BI environment to authorized users.

Interactive dashboards can be accessed from desktop or mobile devices.Leonardo is a web application that is installed on any Windows operating system machine that includes a web server, which delivers Business Intelligence content for your Microsoft-based BI environment to authorized users.

Leonardo is also an OLAP client that can access, browse, and analyze OLAP data and create OLAP reports for multidimensional Olation™ models. Users quickly create interactive business dashboards using already created OLAP analysis or using MDX and SQL queries. Leonardo has features to create and maintain your organization’s KPIs. Users can subscribe to receive dashboard and OLAP analysis at scheduled times.

More details here. Leonardo is offered in the Leonardo suite V18.

Metabase is a new and interesting project. It is a powerful analytics tool which lets anyone learn and make decisions from their organization’s data. No technical knowledge is required, even if you can also use a SQL query editor to answer to your questions.

Metabase is built and maintained by a dedicated team, and is open source, so the community can help improve it too. You get new features, interface improvements, and bug fixes for free, and can forget about building or maintaining your own analytics platform.

More information on the GitHub page or on the official website.