Getting Started
  • 28 Jun 2022
  • 3 Minutes to read
  • Contributors
  • Dark
    Light
  • PDF

Getting Started

  • Dark
    Light
  • PDF

Preset is a cloud-hosted data exploration and visualization platform built on top of the popular open source project, Apache Superset™. Our fully managed service makes it easy to run Superset at scale with enterprise-ready security, reliability, and governance, enabling your entire organization to quickly and easily draw insights from your data.

This Getting Started guide will give you the guidance you need to quickly get your organization up and running with Preset.

You will learn how to do the following:

  • Build your first chart using intuitive drag & drop technology without writing any code
  • Connect Preset to your organization's critical SQL databases
  • Quickly bring data into Preset with familiar tech such as Google Sheets and CSVs
  • Select from over 40 types of charts and build stunning visualizations
  • Deploy multiple Workspaces and scale up as many invited users on the platform as you need
  • Use our collaborative SQL IDE to define dimensions, metrics, & virtual datasets in our semantic layer

Connect your Data

After logging on to Preset as an Administrator, your first step is to connect your organization's database to Preset. Preset supports a wide variety of databases and the connection process is streamlined via an intuitive connection wizard. Detailed walkthroughs for popular databases are available, we support database imports, and you can even upload data from familiar technology like Google Sheets and CSV files.

Database_List

Create a Dataset

After your organization's Admin has connected your data source, users can start building charts by selecting datasets. But what is a dataset?

A dataset is a Preset abstraction that points to data in your database. This data is used to create charts in Preset. Datasets offer a simple and safe "dimensional" playground — all charts that are built from datasets contain a comprehensive collection of relevant dimensions and metrics.

This enables users to self-serve within that context. Your team members can typically slice and dice, which entails superpowers like applying arbitrary filters, drilling into dimensional details, drilling through to atomic rows, and choosing the right visualization.

Preset offers two varieties of datasets: physical and virtual. A physical dataset points to a table in a connected database, and a virtual dataset is a view of data that is created using Preset's collaborative IDE, SQL Lab.

Create a Chart

A wide variety of Preset charts are available for selection, from popular table, line, and pie charts to pivot tables and sankey diagrams. The chart building process is built on the concept of no-code data exploration. The intuitive drag & drop environment facilitates unique combinations of metrics & columns designed to create complex and visually-stunning charts.

A handful of the 40+ charts available in Preset:
Chart_Sample_List

Create a Dashboard

At the heart of the Preset data visualization experience is the dashboard — your opportunity to tell a story with your data via a collection of charts. a dashboard can empower teams to present powerful data-based presentations as well as enable organizations to monitor information based on dynamic data.

After creating a chart, you can immediately save your visualization to an existing dashboard or create a new one. Like the chart creation environment, dashboard creation uses drag & drop technology to facilitate the customization of your data story.

The type of information you convey in a dashboard can be fine-tuned for different audiences using powerful native filtering, with support for filtration of values, numerical ranges, and a number of time-based filter options.

Sample_Dashboard

Sharing and Collaboration

Sharing charts and dashboards in Preset is straightforward, with unique permalinks to both that can be copied or sent via email to your colleagues.

Receiving meaningful and relevant information is critical in any organization, and Preset supports that with robust alerts, reports, and report scheduling. Email or Slack-based notifications can be event-triggered—based on a query-defined and data-based alert condition—or sent on a schedule.


Was this article helpful?