Introducing Grafieks: An open-source Analytics tool

Introduction

Grafieks Analytics Ltd has just released its desktop analytical tool as an open source to the public which enables students, small teams, and organizations to get better insights from their data.

Let's learn about Grafieks and how it enables you to connect with various data sources and use the available tools to create beautiful graphs and share them with your colleagues.

What is Grafieks?

Grafieks is an open-source, simple Self-Service Business Intelligence tool that allows users to quickly and easily extract meaningful insights from data. With Grafieks, line-of-business professionals can connect to data sources, build data models or write SQL queries, and build reports independently, with minimal IT support.

Why Grafieks

Businesses could use Grafieks to create, analyze, and visualize their statistics from their data. Users can easily publish meaningful graphical data to their organizations. However, for viewing published data on our cloud, you need a premium plan.

Currently, desktop and charts are open sourced under GPL v3 license. You can check the code on Github. Grafieks Desktop is available for Windows Desktop only, for the time being.

Available data connectors

List of databases, files, and online storage drives that you can connect with Grafieks to analyze. For live connection, you need your data source to be hosted on a server

1. CSV
2. JSON
3. Microsoft Excel
4. Amazon Redshift
5. Microsoft Access
6. MySql
7. PostgresSQL
8. Sqlite
9. Snowflake
10. Micorosft Sql Server
11. Teradata
12. Mongodb
13. Box
14. Dropbox
15. Google Drive
16. Online Services
17. Github Gists
18. Google Sheets

Available charts

List of charts available that you can use to create your dashboards using the data sources mentioned above

1. Bar Chart
   • Bar Chart
   • Grouped Bar Chart
   • Stacked Bar Chart
   • Horizontal Bar Chart
   • Horizontal Grouped Bar Chart
   • Horizontal Stacked Bar Chart
2. Line Chart
   • Line Chart
   • Horizontal Line Chart
   • Multiple Line Chart
3. Area Chart
   • Area Chart
   • Stacked Area Chart
4. Pie Chart
5. Donut Chart
6. Radar Chart
7. Scatter Plot
8. Funnel
9. Gauge
10. Heat Map
11. Sunburst
12. Tree Chart
13. Waterfall Chart
14. Pivot
15. Table

How is Grafieks better?

Grafieks Desktop is completely open-source (GPL 3). You can use it to create your analytics for free saving up a lot on your budget. However, Grafieks do offer premium support for its services.

It seamlessly connects with data sources and lets you build many charts that are normally not available on other BI tools or require a lot of expertise on customizations and incur huge costs. Being open-source, you can easily raise bugs, fix them or speak to the developers for a feature request.

In short, the overall features have been designed keeping in mind the latest requirements for charts in an organization along with keeping cost consideration on mind.

Few Screenshots

Data connectors screen

Report designer screen

Dashboard designer screen

Closing

Grafieks is a simple business intelligence platform for data democratization while being completely open source. You are free to create your data analytics and save them for future analysis locally or live on the server.

Feel free to check out the code and contribute if you feel comfortable with the code. The code is written with QT5 (C++ 11), D3.js and Duckdb and available on Github for anyone to check and build on top of it. The core team constantly keeps adding new features.

Do let me know in the comments section below.