Quick Go Through
Complete flow from ingestion to insights
1. Connect all your data
Sprinkle builds the data lake by connecting data from different data sources.
Data that is imported from various data sources is imported in Sprinkle as tables. These tables are further joined to create flow tables from which the cubes are created. Using Flows you cast the data type of columns and create new measures. In this flows you can clean and enrich data.
3. Cube modelling
Cube represent multi-dimensional view of data. It comprise of measures and dimensions. Measures are facts of data for e.g. total sales. Measures or facts represent data that can be aggregated. Dimensions are used to bucket or group the measures for e.g. by country, city, and region. The main task is you need to segregate measures, dimensions and date dimensions. Here you can create new Business metrics.
4. Exploring Insights
Can generate insights and do deep analysis by three ways.
a) by Explores
Sprinkle provides a consolidated view of your data from multiple data sources. Using explore you can write sophisticated SQL queries on the data that you have imported from multiple data sources thereby revealing insights from your business data. It’s a query platform where you can run ad hoc queries.
b) by Segments
Segment is a report that gives deep analysis on dimension. Cube needed to create segments. By choosing dimensions and measures on your cube can create segments. Dimensions are used to bucket or group the measures for e.g. by country, city, and region.
c) by Search Interface
By simple English words you can create knowledge graphs. You need to define your business metrics and dimensions in meaningful way in cubes. Users can find insights on their own using “Google-like Text Search" on Business Data.
A business intelligence dashboard is a data visualization tool that displays the current status of metrics and key performance indicators (KPIs) for an enterprise. Dashboards consolidate and arrange numbers, metrics and sometimes performance scorecards on a single screen. They may be tailored for a specific role and display metrics targeted for a single point of view or department. The essential features of a dashboard product include a customizable interface and the ability to pull real-time data from multiple sources.