Giter VIP home page Giter VIP logo

pysilzila's Introduction

Silzila - Data Exploration and Dashboarding App

License

silzila logo

Silzila is an open source desktop/web application which enables you to analyze data, create meaningful charts and present the visuals as dashboard.

Preview

preview

1. Connect to your Database

DB Connection

2. Define your Dataset

Dataset

3. Visualize the data

Dataset

4. Present charts in dashboard

Playbook

Features

  • Connect to CSV & Databases
  • Wide variety of Chart Types
  • Cross Table
  • Rich Text Slides (Static content for now)
  • Filters (Chart Level)
  • View SQL of any visual
  • Arrange Charts into Dashboard

How to Install

Silzila requires Java 17

for Dashboard Developers

Coming soon... for a single executable Java .jar file

for Code Contributiors

Clone the repo and open in VS Code Editor. Backend - Install Java/Springboot/Maven Dependencies and run like a typical java project. Backend starts at port 8080. Frontend - Go to Frontend folder and npm install and npm start. Frontend starts at port 3000 and Silzila app opens in Browser.

Milestones

Silzila is in active development. Right now, it may not have all the features you expect in a commercial tool. The below features are our priority and the tentative timelines are given below:

  • Chart Filter (Jan 2023)
  • Installer File (Feb 2023)
  • Dashboard Filter (Feb 2023)
  • Revamp silzila.org (Feb 2023)
  • Live Demo in silzila.org (Feb 2023)
  • Download PDF, Image (Mar 2023)
  • Snowflake Connectivity (Mar 2023)
  • Redshift, Big Query Connectivity (Apr 2023)
  • Stable Release (May 2023)
  • Online Version of tool in silzila.org (May 2023)
  • Window Functions (June 2023)
  • Calculated Columns (July 2023)

pysilzila's People

Contributors

gnkasthuri avatar prakash-npm avatar sarvanrb avatar silzila avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar

pysilzila's Issues

DataSet Edit - Rename Table Name

In Dataset edit page, when I try to rename a table name, it is asking in pop-up that if I really want to rename. This is unnecessary.
A desired behaviour is: after clicking rename, it should go to name edit mode with the existing name pre-populated & selected in it. (just like how renaming in tile or tab name).

Make sure when user doesn't give anything or just gives blank spaces, we should give warning "at least one letter should be provided" in pop-up

Also check inn Dataset Create page.

Go to home from opened Dashboard saves automatically

If we open existing Dashboard and do some modification, then while clicking home button it automatically saves the new Changes. Sometimes user don't want to add the changes to the dashboard.
The correct behaviour would be to prompt the user if he wants to preserve newly added things.
Prompt like "There are some unsaved changes to the dashboard. Do you want to save or discard changes?
with 2 buttons Save & Discard.

Add Tooltip for Icons in Graph Title area

When mouseover in Graph Title area (<GraphArea> Component), show description of MUI icons

  • BarChartIcon: view graph
  • CodeIcon: SQL Code
  • OpenInFullIcon: Show full screen

Chart Controls Restructure

Re-design chart controls area on the right side of graph. Have a small bar with icons for
Charts
Chart Controls
Filters

On Clicking these icons, render relevant options/ controls

Add More Charts

Add the following charts - Pie, Donut, Line, Area, ScatterPlot. Edit options of these chart to reflect changes made in store under chartControls

Menu Items

Add "Close PlayBook" under File in File Menu. Once clicked Pop up should come asking there are unsaved things in Dashboard. Are you sure want to close PlayBook Yes & No bottons.

Also Add "About" with some text about Silzila should come in Popup. Under Help, have "Go to Silzila Websiite" & "Bug Reporting" (GitHub) menu.

"react-tiny-popover": "^5.1.0"

We have added old version on "react-tiny-popover": "^5.1.0", current version is '7.0.1'. This issue cause npm install error. Need to change the package.json with latest version.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.