Idea 2 : User Friendly Dashboards
What do you do if you have a complex application with lots of data spread across multiple database tables and you have some users who need access to this data, don’t have the chops to pull the data and you don’t have a budget to hire someone to do this work for you? There are good tools on the market but what if we can make something simple, self hosted and all on your own systems or even your laptop?
How to do it
- Rails Application
- Running locally or inside a Docker container
- Connect the system to your database
- Explore the database and generate the views for each table
- Automate the foreign keys and relations between tables
- Provide a drag and drop system that allows non-technical users to build views of data
- Provide a way to bring multiple views in to a simple dashboard view.
- Provide an advanced option that allows you to build SQL data pulls
- Provide a way to alert based on the data