I have set up a simple API that does the following: provided an access token to Smartsheet, fetch data of a selected sheet and return graphs that display some analysis.
This video shows the whole operation: it can't be simpler.
This example is not sophisticated: it demonstrates the structure. Reports can be made sophisticated at will, later.
I think this small example perfectly illustrates the major paradigm shift that tools like Smartsheet and Wolfram Cloud achieve when linked together:
- Data capture in a shared environment on the one hand: Smartsheet
- Limitless analysis of data, small data and big data, with return of synthetic reports on the other hand: Wolfram Cloud
Strict separation between data capture and data analysis, using "best suited" tools; still only one single environment for the user.
The possibilities that this mechanism opens are limitless. Think of
- Engineering calculations,
- Financial analysis,
- Polls analysis,
- Marketing analysis,
to name just a few.
I wanted to share my enthusiasm with you.