{"repo":"mariusandra/insights","free":true,"listed":false,"github":"https://github.com/mariusandra/insights","clone":"git clone https://github.com/mariusandra/insights.git","description":"Open Source Self-Hosted Business Intelligence Platform","language":"JavaScript","stars":1122,"topics":["business-intelligence","visualization","data-analytics","kea","react","insights","dashboard","feathersjs"],"license":"MIT","category":"dashboards-admin","readme_excerpt":"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. 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: 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 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 ","default_branch":null,"files":null,"tree":[],"storefront":"/r/mariusandra","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/mariusandra/insights/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}