# BI

* [Sample data](#sample-data)
* [Diagram image generator online](#diagram-image-generator-online)
* [view & analyze Pandas](#view--analyze-pandas)
* [plotly - for Math](#plotly---for-math)
* [plot time series data](#plot-time-series-data)
* [Math graph](#math-graph)
* [bokeh- Python](#bokeh--python)
* [HoloViews](#holoviews)
* [Superset vs Redash vs Metabase](#superset-vs-redash-vs-metabase)
* [Apache Superset (Caravel/Panoramix)](#apache-superset-caravelpanoramix)
* [Redash](#redash)
* [ELK](#elk)
  * [My `docker run` scripts](#my-docker-run-scripts)
  * [Snapshot And Restore](#snapshot-and-restore)
    * [Backup](#backup)
    * [Check](#check)
* [ETL](#etl)
  * [kettle -JAVA](#kettle--java)
* [Excel](#excel)
  * [xlwings](#xlwings)
  * [django](#django)
  * [.Net](#net)
* [Word](#word)
* [highcharts](#highcharts)

## Sample data

python: <https://github.com/altair-viz/vega\\_datasets>

## Diagram image generator online

<http://blockdiag.com/en/>

## view & analyze Pandas

<https://github.com/man-group/dtale>

## plotly - for Math

<https://plot.ly/api/\\>
<https://plot.ly/python/\\>
<https://github.com/plotly/>

## plot time series data

<https://stackoverflow.com/questions/44964346/matplotlib-plot-time-series-graph\\>
<https://stackoverflow.com/questions/19079143/how-to-plot-time-series-in-python\\>
<https://stackoverflow.com/questions/38837421/simple-way-to-plot-time-series-with-real-dates-using-pandas>

## Math graph

<https://www.geogebra.org>

<https://github.com/mwaskom/seaborn> <https://github.com/mwaskom/seaborn-data>

## bokeh- Python

<https://github.com/bokeh/bokeh#interactive-gallery\\>
Interactive Web Plotting

## HoloViews

<https://github.com/ioam/holoviews\\>
annotate your data and let it visualize itself

## Superset vs Redash vs Metabase

<https://www.pervasivecomputing.net/data-analytics/superset-vs-redash-vs-metabase>

## Apache Superset (Caravel/Panoramix)

<https://github.com/apache/incubator-superset> ![](https://cloud.githubusercontent.com/assets/130878/20371438/a703a2a0-ac19-11e6-80c4-00a47c2eb644.gif)

## Redash

<https://github.com/getredash/redash> ![](https://cloud.githubusercontent.com/assets/71468/17391289/8e83878e-5a1d-11e6-8938-af9054a33b19.gif)

## ELK

### My `docker run` scripts

<https://github.com/fzinfz/docker-images/>

### Snapshot And Restore

<https://www.elastic.co/guide/en/elasticsearch/reference/current/modules-snapshots.html>

#### Backup

```
PUT /_snapshot/bak_1
{
   "type": "fs",
   "settings": {
       "compress" : true,
       "location": "/usr/share/elasticsearch/data/backup"
   }
}

PUT /_snapshot/bak_1/snapshot_1?wait_for_completion=true
```

#### Check

```
GET /_snapshot/bak_1
```

## ETL

### kettle -JAVA

<https://github.com/pentaho/pentaho-kettle>

## Excel

<https://docs.wso2.com/display/DSS301/Excel+Sample>

### xlwings

<http://docs.xlwings.org/en/stable/converters.html#pandas-dataframe-converter>

### django

django-excel: <http://django.pyexcel.org/en/latest/> django-import-export: <https://django-import-export.readthedocs.io/en/latest/>

### .Net

<https://github.com/tonyqus/npoi\\>
<https://github.com/JanKallman/EPPlus/wiki/Getting-Started>

## Word

<https://github.com/xceedsoftware/DocX>

## highcharts

<https://www.highcharts.com\\>
Free for non-commercial