Working with Charts and Reports

bipp Tutorial

Data Models

Data Model Quick Start:

Add a Datasource
Create a project
Create the data model
Deploy the data model

Managing Projects

Projects structure your data resources and business information enabling you to build models and visualize your data. A project may consist of several files and artifacts compiled to create a data model. The project serves as a unit for source control.

Creating a Project

Select Develop > Data Models from the Home Navigation pane to open the Projects page.
Click New Project.
Enter the Project name.
Click Create. Your project is created.

Managing Data Models

Here are the available data model controls within your project:

Files is the default view. Use + Add to add information to your data model. Use Search to find file names matching your search string. The files are listed in categories: Data Models, Tables and Others.
- Edit icon is available next to an item to edit the name.
- Delete icon is available next to an item to delete it.
Find and Replace searches for a string
Share shares the project with other bipp users.
Project Settings accesses options for the project.
Save saves the project.
Validate checks the SQL.
Deploy deploys the model so you can explore the data.
displays the datasource Options menu.
- Revert to a previous version displays a list of versions. This option reverts the changes to the entire project.
- View Datamodel displays the current data model.

There are several methods to populate your data model:

Create datamodel
Create table from datasource
Create table

Creating a Data Model

Click Create datamodel from a new project or + Add > Add data model.
Enter a name. Only letters, numbers and underscores (_) are allowed.
Click the green check mark or use the Enter key.
Create your SQL using the Visual Editor or the Code Editor.

Creating a Table from a Datasource

Click Create table from datasource from a new project or + Add > import table from datasource
Select Datasource from the drop down. Refer to Datasources if you do not see your datasource.
Search for a table to add, or expand the datasource and select the tables.
Click Import.
Create your SQL using the Visual Editor or the Code Editor.

Creating a Custom Table

Click Create table from a new project or + Add > Add custom table.
Enter a name. Only letters, numbers and underscores (_) are allowed.
Click the green check mark or use the Enter key.
Create your SQL using the Visual Editor or the Code Editor.

Editing the Data Model

Data model files are opened in tabs. Click on any file to open it. A red dot in the tab indicates unsaved changes.

Unsaved changes

Click on a Data Model to open it. There are two editors: Visual and Code.

Here is the data model in the Visual editor tab:

Visual Editor

Here is the same file in the Code editor tab:

Code Editor

Using the Data Model Visual Editor

Open the Visual editor tab. You see the Name- and **Label of your data model. These steps create a simple join. Refer to Visual SQL for detailed information on the Visual SQL editor.

Click Tables + Add.
Select stocks and transactions. Click outside the selection box to close it.
Click Joins + Add.
Select stocks for the left side and transactions for the right side.
Click the join icon. The join icon is red, indicating the join is undefined.
Inner join is the default. For this example, select stocks.code from the left table and transactions.stock_code from the right table. Click outside the selection box to close it.

The join icon is now purple instead of red.
Click Validate to check your SQL. The editor reports any SQL errors.
Click Save.
Click Deploy. This step deploys your SQL to enable exploring the data model.
Enter a Commit Message.
Click Deploy.

Continue with Deploying the data model.

Using the Data Model Code Editor

Open the Code editor tab. There are commented lines to help you get started.

bipp helps you with query shortcuts:

Keyword Completion: As you type in the editor, bipp provides the relevant commands to assist you in creating your query. You can enter enough unique characters and use Tab or select it from the list with the mouse.
Keyword Suggestion: bipp suggests keywords where possible.

Write your query. Here is a simple example:

    dataset retail_demo  
      table stocks transactions  
      join stocks inner join transactions  
        on stocks.code = transactions.stock_code

Code editor example