The idea behind this prototype is to create a user-friendly basic inventory system for SME's harnessing the power of Airtable relational database and connecting it with Google Data Studio to derive Data Insights in realtime.
Recent product updates of sync and automation now available natively within Airtable encouraged me to explore this opportunity of connecting two powerful platforms, without the use of any third-party software.
The entire process in this prototype is automated after the entry of 6 required data fields per transaction.
Depending on the use-case, even these 6 steps could be further reduced using a barcode, POS or e-commerce platform integration.
If you are in the process of understanding/defining your business data or automating workflows, perhaps I could be of assistance.
In the meantime, experience the interactive dashboard on https://datastudio.google.com/s/u2sw1...
Connect to find out more / sanjayadnani