Using bipp



bipp takes your data from a starting database to a finished dashboard. You easily manage your database connections, create and manipulate complex data models, visualize and analyze your data, and create interactive custom dashboards to present your visualizations.

Hit the Ground Running

There are several resources to help you learn bipp and expand your SQL knowledge:

bipp Tutorial

Hands-on is the best approach to see how bipp can transform a database into usable information customized for your users. This set of tutorials starts from creating your free bipp account and finishes with a custom dashboard incorporating enhanced features.

Why bipp?

Explore how bipp streamlines common tasks to save you time. Instead of starting each task from scratch, you use the intuitive bipp interface to logically create your dataset, visualizations, and dashboards. bipp generates the SQL for you.

SQL Tutorial

Brush up on your SQL skills, or learn new ones. There are tutorials and examples for Basic, Intermediate and Advanced SQL concepts.


Account and Profile is your bipp identity and settings when you create your forever free bipp account.

Tenants and Spaces are your bipp workspace structures for organizing your projects and information.

Development Mode is used for bipp setup and certain editing tasks. For most tasks, users are in the standard Production mode.

Datasources are essentially the connected databases where the model gets the data. Projects and models can connect to multiple data sources.

Databases are connected to bipp as a datasource. bipp suports a wide array of databases and dialects.

Projects structures 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 with datasets. The project serves as a unit for source control.

Datasets are logical groups of tables, columns, relationships and operations that are likely to be accessed or reused in the future. Use bipp's Sheets to view and visualize your dataset.

Visualizations are graphical insights into your dataset, including tables, charts and maps. They can use filters, aggregates, parameters and other features to organizae your data.

Dashboards group and present your visualizations. They can use filters and parameters to enable user selection of the the data to display.

Advanced Features are available if you want to customize and power up your data analysis and visualization solutions.