📈
Data Visualization
Walkthrough of various visualization charts, and advanced options in table view like Pivot, Aggregates & Transpose. Along with various options to customize charts.
Building visualizations using your data is super easy & intuitive on Sprinkle. Choose from an exhaustive list of visualizations on Sprinkle and present your data in a more interesting & engaging way.
🎉
Through the left navigation panel, click on the Reports or SQL Explore Section on the Sprinkle to use the visualization features.
🖱
You can select between the Table and the Chart view. While the Table view gives you tabular data in terms of columns and rows, the Charts View has rich Visualization. The Table and Chart views are discussed below in detail.
To know about the advanced options like Pivot, Transpose, Aggregates, and Freeze Columns in Table View click here
2
🛠
🖱
Read on to gain complete insight into creating various visualization available on Sprinkle.
🤓
🎉
✨
The chart view has rich visualization graph options that empower you to present the tabular data into interactive graphs. Let us go through these graphs one by one.
In the Charts View, click on the Line Graph Icon. Select the X & Y-Series on the right, to be displayed on the graph. Through the Labels tab, add the x & y-axis labels. From the Colours Tab, assign customized colours to the graph. Click on Plot, to plot the graph.
🖱
🖱
The below example displays the trends in the number of successful & cancelled orders against the order months timeline.
🔽
Line Graph: Successful/Cancelled Orders vs Order Month
In the Charts View, Click on the Column Graph Icon. Select the X & Y-Series on the right, to be displayed on the graph. The below example displays the columns, Y-series, successful & cancelled orders plotted against the product lines.
🖱
🔽
Column Graph: Successful/Cancelled Orders vs Product Line
In the Charts View, Click on the Bar Graph Icon. Bar Graph can be created in a similar way as the column graph, by selecting the X & Y-Series on the right, and plotting it. The below example displays the Bars, Y-series, and successful & cancelled orders plotted against the product lines.
🖱
🔽
Bar Graph: Product Line vs Successful/Cancelled Orders
The Combo graph lets you combine two or more graphs and display them on the same chart. In the below example, the Total Cancelled Order is displayed as a line graph, with a y-axis on left. while the Total Successful Orders are displayed as a bar graph, with the y-axis on the right.
🔽
Combo Graph: Cancelled Orders - Line Graph & Successful Orders - Bar Graph
Click on the Scatter Plot Icon. Select the X & Y-Series on the right, to be displayed on the graph. In the below example scatter plot is plotted between the Average quantity ordered and the number of days it takes to deliver the order, to see if there is any relationship between the two.
🖱
🔽
Scatter Plot: Avg Quantity Ordered vs Delivered In Days
Click on the Pie-chart Icon, to plot a Pie-Chart. Select the SIice Labels according to the dimension, and select the Slice Values, which are the measure that is to be displayed.
🖱
In the below example, the Total Cancelled Order is displayed for different product lines. We can observe that the Classic Cars have the highest percentage of Cancelled Orders.
🔽
Pie Chart: Total Cancelled Orders vs Product Lines
A Bubble Chart is a multi-variable graph that is a cross between a Scatterplot and a Proportional Area Chart. It contains information in the two axes, also the size & colour of the circles can represent some value.
Click on the Bubble Graph Icon. Select the value to be represented on the x and y-axis. Select the measure/numerical dimension to represent the colour and size of the circles plotted.
🖱
In the below example, the Total Quantity Ordered is displayed on the x-axis. On the y-axis, the Total number of Orders is represented. The colour indicates the number of days taken for the delivery, ranging from 1 to 8.
🔽
Bubble Graph
A histogram is a bar graph-like representation of data that buckets a range of outcomes into columns along the x-axis. The y-axis represents the number count or percentage of occurrences in the data for each column and can be used to visualize data distributions.
Click on the Histogram Plot Icon. Select the Y-Series on the right.
🖱
In the below example, the number of orders is bucketed based on the buckets in terms of delivery in days.
🔽
Histogram Distribution of Orders in terms of delivered in number of days
A funnel chart helps you visualize a process like online shopping that has sequential stages, like, search, view product, add to cart, payment, and purchase.
Click on the Funnel Plot Icon. Select the value & per cent relative to, in the right form.
🖱
In the below example, the number of users across each stage in the online-purchase transaction is represented.
🔽
Funnel Graph: Online Shopping Process
Sprinkle also has Geo Charts to enable you to plot your geographical data. Click on Geo Plot Icon to get started. Various types like points, arc, Line, Cluster, Hexabin, Polygon, Cluster, Icon, Heatmap, H3, 3D, and trips format are supported.
🖱
In the below example, 406 Indian cities are plotted according to their latitude and longitude data.
🔽
Geo Map: Cities
Sprinkle also has a feature to download all these visualization charts as PDFs from Reports and SQL Explore.
Also, the tables can be downloaded as CSV.
Just click on the dropdown Download button, and chose to download it as CSV or PDF and it will download the table and chart respectively.
The Table view has advanced features like Pivot, Transpose, Aggregates & Freeze Columns. These features enable you to create advanced reports while working with tabular data.
Pivot lets you quickly analyse & summarize data in the way you want, which enables you to answer various questions with the help of data.
🤔
Sprinkle's Pivot Option in the Report helps you dig deeper into your data, and analyse data in terms of various dimensions.
To use the pivot chart option, open the Report, go to the Results section, and click on the Pivot icon.
🖱
In the Pivot Modal: Select the column to be pivoted on from the drop-down. According to the measures selected new columns will get created.
In the below example, the Orders report is pivoted on the Shipped Month Column. The aggregates selected are the column & row sum. The Product Line column has been fixed, in order to enable the user to see the total orders data corresponding to the product lines easily.
On clicking Ok, the required pivot is generated based on the shipped month column.
🖱
Pivot Output
The pivoted columns can be grouped together in the UI.
The pivoted columns that are based on Date dimensions can be grouped together based on Quarterly, Half-Yearly, and Yearly basis.
If you want to group columns of other types, then define it in hierarchies. For example, you define the hierachies as city that rolls to state. The pivoted columns pertaining to say Revenue of Each of the cities can be grouped together in the UI into States.
Sub-Total enables you to get the total across each distinct category in the dimensions.
Click on the Pivot Icon, Select the Column to Pivot On, and then select the column to whcih the sub-total is to be applied.
🖱
In the below example, we have pivoted the data on Product Line, and have enabled sub-total for Status. Thus, Subtotals for Cancelled and Disputed can be viewed.
⬇
Transpose is the process of swapping rows into columns and vice versa. This can be performed on some particular column or row as per your preferences. This gives a varied three-dimensional view of the records.
To transpose, click on the Transpose icon and update the "Transpose On" field.
🖱
In the same example as above, the Row Sum & Column Sum has been enabled to provide the row-level & column level sum of total orders, along the shipped month. The same was achieved by adding the aggregates fields as below. Click on the Aggregates Icon and select the Aggregation type and then the measure on which the aggregation is to be applied.
🔽
🖱
The format of the values in the columns can be customized as needed. The available options are, the entries denoted as values, per cent & value(per cent).
At times when the number of columns is large or there are many measures across a dimension and we want to fix a dimension (column) to view values corresponding to it. It is when the Fixed Columns feature option comes in handy.
Using this feature, select the columns which need to be static. Click on Freeze Column Icon in the Table view and select the columns to be frozen. In the below report, data is pivoted on the “Shipped Date Month” column and the “Product Line” column is fixed, to enable viewing the monthly data which are in the following columns.
The “Product Line” column is fixed and other columns are movable. Now you can easily view and check the measure values for corresponding dimensions. In a similar way, multiple dimension columns can be fixed as well.
Plot any kind of chart and enable Show Labels Annotations, to show the labels on the plotted chart.
In the below column chart Total GMV is plotted against each product line. Now you can enable Label Annotations and see the Total GMV value on the top of each bar.
🔽
To save the changes, click on Plot and then click on Save to save the changes.
🖱
To see other legends on the plotted chart when the user's mouse hovers on a particular point or on a particular bar then the user needs to select those legends in the Other tooltips.
You can also see other data in form of legends by hovering over the graph. To enable data to be displayed as a tooltip, select the measure in the Other Tooltips.
The below column chart hovering over a column by default shows the legends of Product Line (x-axis) and Total successful GMV (y-axis). By selecting other dimensions and measures in Other Tooltips you can see other Legends as well. In the below chart “Total Cancelled GMV” & "Total Orders" are selected in other tooltips.
🔽
To save the changes, click on Plot and then click on Save to save the changes.
🖱
Other Tooltips
After putting the Benchmark line into the chart, you can also colour the bars based on the benchmark line. Click on the Colors tab, and check the Show Colors on the basis of Benchmark? option, select the colours for Above Benchmark and Below Benchmark values from the colour palette and click on Plot.
🖱
Benchmark Coloring
During an analysis using visualizations, a benchmark line for the charts is very useful. These benchmark lines can be drawn at the average point, and also given an option to set this value on any predefined point/value which is given by the user.
Average Value: When selecting the Average option in the Benchmark section, the average value of the data is calculated and acc. to that value a benchmark line is drawn on the graph.
Benchmark Line: Average Value
User Given Value: When the user gives the benchmark value, then the benchmark line is drawn on the graph as per the user-specified value.
Benchmark Line: Constant Value
Stacked charts are charts where users can view the whole, parts of the whole, and part-to-whole comparisons. It helps to view numeric values across one categorical variable to two.
In the below example, On the X-axis shipped month, the total sales values are plotted on the y-axis. And the individual contribution of Cars, Motorcycles, Planes, Ships, and Trains to the Total Sales is plotted with the help of the stacked chart option.
Stacked Charts
Last modified 7mo ago