DEV Community

Cover image for Introducing Grafieks: An open-source Analytics tool
Chilarai
Chilarai

Posted on • Updated on

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 Features

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

Data connector screen - Grafieks

Report designer screen

Report designer screen - Grafieks
Dashboard designer screen

Dashboard designer screen - Grafieks

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.

Top comments (0)