Read-IT

An open place to share expertise, information, opinions and insights on new trends in management control, corporate finance, business intelligence, analytics and web development. All screenshots © of their respective owners.

Tuesday, 21 January 2020 10:05

Ananas Analytics Desktop

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

Published in analytics
Thursday, 18 April 2019 17:51

Metatron Discovery

Metatron Discovery is an end-to-end big data self service analytics open source solution, developed by SK Telekom Co. Ltd., Seoul, Korea. Metatron is able to process huge data sets super fast, powered by an optimized Apache Druid (a very fast highly scalable columnar data-store). This open source application provides easy data analytics for everyone, with an intuitive user interface with full API support.

Some key Features:
integrated powerful interactive data preprocessing tool;
interactive dashboards with numerous preloaded charts;
supports query(SQL) based data exploration and GUI based data wrangling;
supports various data sources (e.g. DBs, Hive, PostgreSQL, MySQL, Presto or Kafka streams);
job and data usage monitoring;
metadata management;
supports 3rd party data analytics tool integration;
fine grain access control of users and workspaces;
overcomes druid weaknesses without performance degradation using Metatron optimized Druid;
full API support, enabling easy integration into your environment;
Docker support for distributed version deployment.

More information here: https://www.metatron.app
and here https://github.com/metatron-app/metatron-discovery

An on line demo is available here:
https://discovery.metatron.app/app/v2/user/login
Username: metatron and Password: metatron
Published in analytics
Wednesday, 31 October 2018 09:13

Smashing framework

Smashing is a Sinatra based framework, used to build beautiful and impressive dashboards. The project is a fork of Dashing, an excellent framework created by Shopify for displaying custom dashboards on TVs around their offices.

Smashing has a drag & drop interface for re-arranging the widgets positions and many premade widgest, ready to be used. Developers can also build custom widgets, to display data from multiple sources (Simple Ruby DSL for fetching data from databases or online resources).

The official Smashing page is here →.

Here is a live demo → of a simple dashboard with realtime update. You can host your Smashing dashboards on Heroku in less than 30 seconds.
Published in controlling
Friday, 19 October 2018 09:08

Grafana dashboards

Grafana provides a powerful and elegant way to create, explore, and share dashboards and data with teams and on the world wide web. It is most commonly used for visualizing time series data but many use it in other domains including business analytics, industrial sensors, weather forecasting and process control.

Grafana works with Graphite, Elasticsearch, Cloudwatch, Prometheus, InfluxDB & many more data sets, included MySQL, PostgreSQL, Microsoft SQL Server, etc. Grafana is open source software, but if offers some commercial plugins to add some useful features.

More info here.
Published in controlling
Wednesday, 10 October 2018 15:08

Free pivot tables

WebDataRocks is a free web reporting tool for data analysis and visualization. It is written in JavaScript and is not constrained by any external framework. This simple but enterprise-featured web-based pivot grid can be added to any website, application or project webpage within minutes. WebDataRocks easily displays every CSV or JSON data in an interactive pivot table, offers a number of data analysis features and provides reporting experience. You get the real-time reporting of your data on any device you prefer (PC, tablet, mobile etc.) with a responsive and modern visualization.

Here follows an interactive demo, based on sample data. This demo includes the files directly from WebDataRocks CDN, but you can also download and use the css and javascript files directly on your server.



More information here: https://www.webdatarocks.com
Download files here: https://www.webdatarocks.com/doc/download/
Published in controlling
Wednesday, 10 October 2018 13:46

Query2Report analytics

Query2Report is a simple opensource business intelligence solution that allows users to build reports and dashboards for data analytics or corporate reporting. The application transforms SQL queries to beautiful and very impressive Google charts. The application offers automatic refresh functionality for nearly real-time reporting.
The different elements in reports can pull data from multiple databases instance belonging to same or different vendor.

A role based security allows the administrators to create public reports and personal workspaces. Angular JS is used to build this application with a responsive user interface design. It run on laptops, mobiles and tablets.

These are the main features:
  • web based reporting and dashboard generator
  • auto refresh for real-time reporting
  • public and personal report workspaces
  • integrates with any database using JDBC connections
  • role based user access

More information available here:
https://sourceforge.net/projects/query2report/
where you can also find the download link.

Last version issued on August 4th 2018.
Published in analytics
Wednesday, 19 July 2017 08:12

Project management tool

Redmine is a flexible project management web application, written using the Ruby on Rails framework. It is cross-platform and cross-database. The main features of Redmine include:
  • multiple project and subproject support
  • role-based security
  • bug tracking system
  • Gantt charts and calendars
  • project- and work-based time tracking
  • custom fields and interface
  • document management
  • project-based wikis
  • SCM integration
  • web feeds and eMail support
  • lightweight directory access protocol (LDAP) support
  • multi-language support (34 languages)
Redmine is open source and released under the terms of the GNU General Public License v2 (GPL).

More information can be found here. Redmine software can be donwloaded here.

Redmine demo on line is here.
Published in other
Friday, 24 February 2017 21:19

Razorflow

An html5 open source dashboard framework. It's a mature solution with many features and well documented. Here the main features:

Complete set of dashboard elements
Includes all the components that you need to build dashboards in a single package.

Light and Fast
Built with mobile devices in mind, RazorFlow Dashboard Framework is engineered for the fastest load times.

Full-featured charting
Supports Industry-Standard Column, Pie, Bar, Line charts and more.

Real-time updates
Dashboards can be updated in real-time without having to reload the page, and are compatible with web sockets.

Powerful theme-builder
The theme-builder allows you to change the look of your dashboard in just a few clicks.

Built for touch
All dashboards work great on touch devices like smartphones and tablets, with no extra work.

Server-side wrappers
Build complete interactive dashboards in PHP with no JavaScript or HTML coding required.

Embed and integrate
Embed dashboards into existing pages and web applications, and integrate fully using a JavaScript API.

Razorflow has a well-designed set of APIs to build your first HTML5 dashboard in under an hour, which works across platforms and devices. A comprehensive documentation, pre-build dashboards and an extensive feature gallery help you get started fast.
More details here. The source code can be downloaded for free here.
Published in web
Wednesday, 22 February 2017 20:48

Metabase

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.
Published in analytics
Tuesday, 21 February 2017 07:54

Cyclotron dashboard

Cyclotron is a platform for creating and hosting dashboards, independent of any kind of data source. It permits to load and visualize data without programming skills.
It could be defined as the "CMS of dashboarding". Cyclotron is an open spurce project developed by Expedia Inc., one of the world's leading travel companies. Here at Freney we are testing Cyclotron, to understand if it could be used for our projects. We hope to publish some prototypes in our "playground" section.

More information here. The software can be dounloaded on GitHub.
Published in analytics