A quick overview of salient Sprinkle features
This page covers all the basics you need to know before starting to use Sprinkle.
List of all supported data warehouses and the setup instructions are given below:
Incase you don't have a data warehouse, or your data is fragmented in different systems, Sprinkle helps you unify all your data into your data warehouse using the Datasource connectors. The datasource connectors ingest data into your data warehouse. The ingestion pipeline can be setup in just a few clicks via Sprinkle web console.
Ingest data in realtime into your data warehouse using incremental mode where only changed or new data is ingested.
Sprinkle automatically maps the source schema to the destination (data warehouse) schema.
Sprinkle console will show live replication stats like the number of rows and data size moved.
Live monitoring of data ingestion
List of all supported datasources and the setup instructions are given below.
Got 2 mins? Check out the video:
No-code Analytics Product Tour
Sprinkle helps Data Analysts to build business metrics and dimension via visual interface. Analysts can join tables and create custom expressions, validate data, all from the visual console. Sprinkle reduces the manual work needed to be done by Analysts for building reports. You can create models directly on warehouse tables, without any data loading unlike traditional BI tools.
Join warehouse tables visually without any coding
Define business measures and dimensions directly on warehouse table
Sprinkle Reports help data consumers to analyse data with drag and drop functionality and build visualisations. Unlike traditional BI tools, you can analyse data at any granularity without being a data expert. Data consumers can dive deeper into the data by building their own custom analyses and reports.
Drag an Drop Interface
Funnels allow you to examine how events are performed in a series. Funnels help you to calculate the conversion counts from one event to another to identify where they get converted most of the time, where there are drop-offs.
Create Funnels dynamically by putting events in series
Sometimes you may quickly want to build a report for which there isn't a Model defined yet. In that case, you can use SQL to build the report and create visualisation. You get a powerful SQL editor with inbuilt Schema browser.
Sprinkle SQL Explore: SQL Report Builder
You can combine multiple Segment or Explore reports to create Dashboards. You can filter the data in one go easily across all the reports within a dashboard. You can download data in excel, share dashboard with others, schedule refresh and do drill-downs/drill-ups.
Before the data is used for analysis, we sometimes need to transform it to make it more analytics friendly. Transforming your data means, creating a derived table from the set of input (mostly raw data) tables.
Sprinkle provides two ways to do Data transformations:
Sprinkle SQL Transform
In certain cases, you want to use python libraries for data manipulation and preparation. Sprinkle provides a Notebook feature, via which you can write Python code and do data exploration within the Notebook editor itself. The python code gets executed on the Kubernetes cluster in the Data Plane. You can schedule the entire Notebook to run your python code at regular intervals.
You could have 100s of objects in your data ecosystem like Warehouse Tables, Reports, and Dashboards. Sprinkle helps you organise all these objects, so that you can easily find relevant data with ease.
- WIP (Work In Progress)
- Has Issues
Simple text search to search tables, dashboards etc. You can apply filters based on Folders, Owners, Status
Sprinkle creates a Catalog of all the data warehouse tables. Catalog helps you find and understand warehouse tables. You can add metadata like table and column description descriptions for other users to find and understand the relevant tables with ease. You can also generate table stats like missing values, and frequency charts.
Sprinkle helps you organise all your objects like Tables and Dashboards based on certain attributes using Business Metadata. For example, if you have 3 different functions - operations, marketing, finance; and you want to tag all your entities to a specific function, then you can easily do so using Business Metadata.
Sprinkle lets you schedule your data ingestion or report refreshes as per the desired frequency interval. You can schedule Datasource, Segment, Explore etc entities to run periodically.
Sprinkle finds out all the dependencies across different transformations and reports automatically, and schedules all the data refreshes in a pipeline. You can learn more about Data Dependencies here.