In this example, we assume you know your database and what it contains.
Open the Bouquet app for the first time.
You'll be automatically connected to your own team. The project creation popup should open as bellow.
Fill it with your database parameters. Don't forget to select at least a schema and click check connection
If you need more details see the guide : How to create a project ?
You can at any time use another database by modifying the current project or creating another one
Our zero-commute feature import schemas and directly populate the model. In case relations are already defined in your database, Bouquet can generate relations by itself.
Open your project, select a table you want to analyze and click the "barchart" action button.
- Select the information you need to analyze. These will be your pivots
- Select the metric(s) you need to calculate
- Select a period and set up filters if needed
- Run your analysis by clicking the "Refresh" button
Now that you are happy with your analysis, you can save it as a bookmark, by hitting "Save as".
The whole analysis configuration is saved now, for later use.
You can select default (Year to Date, Previous Month, ...) & comparison periods before saving the bookmark. Periods are then dynamically computed at query execution when coming from the bookmark. Otherwise, static dates are saved & won't change whenever the execution is.
The first possibility to review your bookmark is to open it from the Bouquets' native web application : the Viewer.
Select your bookmark int the "Bookmarks" section of the left panel and click the "barchart" action button.
It is also possible to embed this analysis directly into your own web application.
First, you have make public your bookmark by using the button "publish API" and click "Publish" in the popup window.
Publishing a Bookmark in Bouquet.
- Within Bouquet, a Bookmark is by default available to you and authorized members with whom youʼve already Shared this Bookmarkʼs project.
- Publishing a bookmark allows to access it by other users or applications via an access key.
Once published, you need to retrieve the API endpoint of the bookmark: Hit the "Explore API" button on top of the viewer. You have access now to the API request matching the bookmark definition.
If there is an access token, do not copy it.
This API request can be used into a java script page to show your data as a table
You'll find all the code you need to build your first page here : http://jsfiddle.net/openbouquet/2d777zd6/embedded/
In the java script code, copy your bookmark token in the function "update(accessToken)".
See more example of possible code for data visualisation on our demo page : https://openbouquet.io/bouquet-demo-ob/#try-now