Open the Bouquet app for the first time.
There are two possible choices :
- You know how to connect to your database so you create your own project. The left side is for you.
- You don't have any database of your own to connect t. Click "use our demo project" on the right side.
A default project is automatically created in your project list.
Double click on it and after a loading moment it will display the list of the available tables.
At any time, you can connect to your own database by clicking on "Add a project" in the left panel.
Click to add a project
A connection popup displays
Fill it with your database parameter and click "check connection".
In the next screen, don't forget to select at least a schema.
You can now save your project and select it in the project list. 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.
Double click on your project name and after a loading moment it will display the list of the available tables.You can at any time use another database by modifying the current project or creating another one.
If you need more details see the guide : How to create a project ?
Open your project and double click the table you want to analyze. You'll open the Query Builder. In this example we are using the demo project.
In the demo project, you can select, "Sales" table as an example.
The left part is your query configuration. The right part is the material from your project and from Bouquet. Switch between tabs to access :
- Dimensions are the possible quantitative column values
- Metrics are calculated outputs
- Functions are the existing SQL built-in operations. You can use them as aggregates.
For more details about the Query Builder and its possibilities see see Query a bookmark or a domain
Select a period and click the "Query" button.
The result of your query is now visible at the bottom of the page. You can note that the first metric is already selected for you by the zero-commute.
As interesting as the total of one month can be, we now want to split this result by day of the month.
Click the tab "Dimensions" to display the possible columns information.
Look for a date, like "Saletime" in the demo then drag and drop it to the "groupBy" text area.
Now the result is displayed by date. To order it, drag and drop "Saletime" in the "orderBy" text area, the same way you did for the group by.
For more details about the Query Builder and its possibilities see Query a bookmark or a domain
Now that you are happy with your query, you can save it as a bookmark, by hitting the "Bookmark" button bellow the result table.
Just gives your Bookmark a name. You can now re-open it from the "Public" folder of the "Bookmark" navigator.
With Bouquet, you can easily embed your query into any application. You'll find bellow the steps.
Go back to the project list and select your project. Then click the "Get API key" button.
For all details about the API key and its attributes.
The generated API key will have access to all public bookmarks of this project.
You can now follow the first simple tutorial to help you build your first app and embed your new bookmark in it.