silzila / pysilzila Goto Github PK

View Code? Open in Web Editor NEW

8.0 4.0 4.0 80.76 MB

Silzila - An Easy App for Data Exploration and Dashboarding

Home Page: https://silzila.org

License: Apache License 2.0

Python 15.66% HTML 0.12% CSS 3.26% JavaScript 80.94% Shell 0.02%

business-intelligence data-visualization bi python react fastapi data-analysis chart

pysilzila's Introduction

Silzila - Data Exploration and Dashboarding App

Data exploration and dashboarding app

Installation | Demo

Silzila is an open source tool (License information here) which enables you to create meaningful visual charts in four easy steps

Connect to your Database
Define your Dataset
Visualize the data
Present charts in dashboard

Installation

Make sure you have Python version 3.7 or higher.
Open command line or terminal and check your version of python by using the following code python --version
Verify that you also have setupTools by typing pip list
Install virtual environment if you don't have it already pip install virtualenv
Navigate into the folder of your choice where you want to install silzila project
Create a new virtual envronment python -m venv <envName>
Install silzila package pip install silzila
Activate the new virtual environment .\<envName>\Scripts\activate
Once the environment is active, you can then start the silzila app by typing the following command in prompt silzila. A new browser window will open up with an instance of silzila app

Note: When connecting to Database please check if Database service is up and running. For MS SQL Server, please check if you have installed ODBC Driver and TCP/IP is enabled for the database.

Demo

1. Connect with Database

Create connections to the databases which you need

2. Define your Dataset

Select a subset of tables from one of the Data Connections, define relation between tables and create a dataset

3. Visualize the data

Visualize the data in one of the many charts available

4. Present charts in dashboard

Charts created in each of the tiles can be then displayed as required in the dashboard

pysilzila's People

Contributors

Stargazers

Watchers

Forkers

prakash-npm gnkasthuri shalevy1 sarvanrb

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.

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

Pie chart and Donut Chart - If dimension is year, chart not rendered properly

Data not rendering properly. Chart shows dimension value instead of measure when dimension is Year. If dimension is some category value, chart is rendered properly

"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.

CrossTab tooltip position in Dashboard

CrossTab tooltip position not near the cell/mouse pointer. Only happens in dashboard, not in tiles.

Add some Chart Controls for CrossTab

Add chart controls like Title, Tool tip on/off, Font colour and background colour for cross tab.

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.

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 More Charts

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

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

While switching between charts, charts showing old data not matching with Measures.

While switching from Bar chart to Pie, Measure reduced to 1 field. If you switch back to Bar it shows same chart, it previously did. Need to check keepOldData state while switching charts.