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.

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.

Some samples are available in our playground section.
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