All Projects โ†’ mariusandra โ†’ Insights

mariusandra / Insights

Licence: mit
Open Source Self-Hosted Business Intelligence Platform

Programming Languages

javascript
184084 projects - #8 most used programming language

Projects that are alternatives of or similar to Insights

Metatron Discovery
Powerful & Easy way for big data discovery
Stars: โœญ 297 (-67.61%)
Mutual labels:  business-intelligence, data-analytics, dashboard
Mprove
Open source Business Intelligence tool ๐ŸŽ‰
Stars: โœญ 212 (-76.88%)
Mutual labels:  business-intelligence, dashboard
Swiv
For the open source UI formerly know as Pivot
Stars: โœญ 165 (-82.01%)
Mutual labels:  business-intelligence, dashboard
Cboard
An easy to use, self-service open BI reporting and BI dashboard platform.
Stars: โœญ 2,795 (+204.8%)
Mutual labels:  business-intelligence, dashboard
Just Dashboard
๐Ÿ“Š ๐Ÿ“‹ Dashboards using YAML or JSON files
Stars: โœญ 1,511 (+64.78%)
Mutual labels:  business-intelligence, dashboard
Poli
An easy-to-use BI server built for SQL lovers. Power data analysis in SQL and gain faster business insights.
Stars: โœญ 1,850 (+101.74%)
Mutual labels:  business-intelligence, dashboard
Widestage
Lightweight Open Source Business Intelligence and reporting tool for mongodb, postgresql, Mysql, MS sql, oracle, & google bigQuery allow users create their own reports just dragging and dropping, widestage also has a data governance layer AKA semantic layer
Stars: โœญ 246 (-73.17%)
Mutual labels:  business-intelligence, dashboard
Mining
Business Intelligence (BI) in Python, OLAP
Stars: โœญ 1,128 (+23.01%)
Mutual labels:  business-intelligence, data-analytics
lightdash
An open source alternative to Looker built using dbt. Made for analysts โค๏ธ
Stars: โœญ 1,082 (+17.99%)
Mutual labels:  business-intelligence, data-analytics
tellery
Tellery lets you build metrics using SQL and bring them to your team. As easy as using a document. As powerful as a data modeling tool.
Stars: โœญ 219 (-76.12%)
Mutual labels:  business-intelligence, data-analytics
Grafana
The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.
Stars: โœญ 45,930 (+4908.72%)
Mutual labels:  business-intelligence, dashboard
Abixen Platform
Abixen Platform
Stars: โœญ 530 (-42.2%)
Mutual labels:  business-intelligence, dashboard
Superset
Apache Superset is a Data Visualization and Data Exploration Platform
Stars: โœญ 42,634 (+4549.29%)
Mutual labels:  business-intelligence, data-analytics
Expand
DevExpress XAF extension framework. ๐—น๐—ถ๐—ป๐—ธ๐—ฒ๐—ฑ๐—ถ๐—ป.๐—ฒ๐˜…๐—ฝ๐—ฎ๐—ป๐—ฑ๐—ณ๐—ฟ๐—ฎ๐—บ๐—ฒ๐˜„๐—ผ๐—ฟ๐—ธ.๐—ฐ๐—ผ๐—บ, ๐˜†๐—ผ๐˜‚๐˜๐˜‚๐—ฏ๐—ฒ.๐—ฒ๐˜…๐—ฝ๐—ฎ๐—ป๐—ฑ๐—ณ๐—ฟ๐—ฎ๐—บ๐—ฒ๐˜„๐—ผ๐—ฟ๐—ธ.๐—ฐ๐—ผ๐—บ and ๐˜๐˜„๐—ถ๐˜๐˜๐—ฒ๐—ฟ @๐—ฒ๐˜…๐—ฝ๐—ฎ๐—ป๐—ฑ๐—ณ๐—ฟ๐—ฎ๐—บ๐—ฒ๐˜„๐—ผ๐—ฟ๐—ธ and or simply ๐—ฆ๐˜๐—ฎ๐—ฟ/๐˜„๐—ฎ๐˜๐—ฐ๐—ต this repository and get notified from ๐—š๐—ถ๐˜๐—›๐˜‚๐—ฏ
Stars: โœญ 158 (-82.77%)
Mutual labels:  business-intelligence, dashboard
Tabix
Tabix.io UI
Stars: โœญ 1,152 (+25.63%)
Mutual labels:  business-intelligence, dashboard
Helicalinsight
Helical Insight software is worldโ€™s first Open Source Business Intelligence framework which helps you to make sense out of your data and make well informed decisions.
Stars: โœญ 214 (-76.66%)
Mutual labels:  business-intelligence, dashboard
datart
Datart is a next generation Data Visualization Open Platform
Stars: โœญ 1,042 (+13.63%)
Mutual labels:  business-intelligence, data-analytics
Redash
Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
Stars: โœญ 20,147 (+2097.06%)
Mutual labels:  business-intelligence, dashboard
Metabase
The simplest, fastest way to get business intelligence and analytics to everyone in your company ๐Ÿ˜‹
Stars: โœญ 26,803 (+2822.9%)
Mutual labels:  business-intelligence, dashboard
Openfaas Cloud
The Multi-user OpenFaaS Platform
Stars: โœญ 744 (-18.87%)
Mutual labels:  dashboard

Insights

Insights is a tool to visually explore a PostgreSQL database, with an emphasis on generating graphs that show business performance over time.

Think of Google Data Studio or Google Looker, but totally free, self-hosted and without the "Google" part.

See a live demo for Widgets Inc, a fictional e-commerce site.

Insights Explorer

Important Disclaimer and Security Notice!

Please be aware that is an extremely early BETA release of Insights, which has not gone through any kind of security audit.

Use on a live server at your own risk!

Installing

To install, make sure you have Node 10+ installed and then run:

npm install -g insights
insights init
insights start

This creates a folder .insights which contains all the config and runtime data.

Implemented Features

  • Self Hosted, installed via NPM
  • PostgreSQL connection support
  • Auto-detect your database schema, including all foreign keys!
  • Connect to multiple databases
  • Edit the schema and add custom SQL fields right there in the interface!
  • Create subsets of your data (e.g. share only a few fields with marketing)
  • Data explorer
  • Filters on the data
  • Time-based graphs
  • Split the graph by some column (e.g. new users by country name)
  • Keyboard navigation in the sidebar
  • Saved views
  • Pinned fields

Coming Soon

  • Embed React or <iframe> components and get data through the insights API
  • Decent mobile support
  • Log in with your Google Account
  • Manage users in the interface
  • Access control for subsets
  • PDF and XLSX exports
  • Way more and better graphs
  • View generated SQL
  • Dashboards
  • Multiple lines from different sources on one chart in the dashboard
  • Plugins?

Support

Insights is MIT-licensed Sponsorware. If you use it in your business, please contribute towards its development!

To stay in touch and receive news when we release a significant update, please sign up here.

You can also follow me on Twitter to receive the latest updates.

Development

If you want to help with development, run these steps:

# 1. fork the repo in github

# 2. clone it
git clone [email protected]:<YOUR_NAME_HERE>/insights.git

# 3. install all dependencies
cd insights
yarn

# 4. start the app
yarn run init
yarn start

# 5. open http://localhost:3000/ and hack away
Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].