Creating and saving a chart
On this page you'll learn how to create and save charts in the Data Visualization Tool inside the Business Intelligence Module
Creating a dataset
In order to create a chart, first you will be prompted to create a dataset, choosing what data you want to populate your chart with.
After logging into the SlicingDice Control Panel, navigate to the Business Intelligence model on the left. Access the Data Visualization tool. You'll see your databases listed there. Choose the one with the data you want to use.
Click on Browse datasets, and then click on write SQL Query.Type the SQL query
SELECT * FROM [dimension name].
Dataset creation tip
Although you could write a SQL Query to filter your data for its visualization, it can be done during the charts / dashboards creation / edition in a visual manner (without the need for SQL).
Creating a chart
Access the Data Visualization Tool inside the BI Module. Click on the + signal button at the bottom right of the screen and choose Saved Chart. Choose the dataset you will use to create your chart.
Choose a chart type among the list of options presented that best suits you data visualization needs.
Your carts will show data based on the parameters you choose. There are three types of parameters:
- Measures (quantitative) define the numeric aspects of data to be shown, like product values and revenue.
- Dimensions (qualitative) define the non-numeric aspects of data, by which the Measures will be grouped, like region or vendor name.
- Calculations can be used to create new measures using existing measures or dimensions
- You can also use aggregations of those, such as distinct count or min/max.
You will need to insert a different number of those parameters, according to the chosen chart type. Click on DONE to finish the chart creation.
"There are too many columns/sectors/bubbles" Error
The number of elements inside a chart are limited, according to its type. Check ou the charts limitations.
Dimensions mentioned inside the chart creation are not the same as the concepts of database dimensions of SlicingDice (which are groups of columns). Check the Measures, dimensions & calculations section for detailed information on dimensions, measures and calculations
In the Data Visualization tool there are plenty of options for your charts, such as conditional formatting, enabling drill-down, selecting colors and so on. You can find all these custom options on the BI Module References. For now, the 2 most used options will be presented: data filtering and data sorting.
Using the data filtering option enables you to select what data you want to show (or not) in your charts. Click on the Filters tab during chart creation or edition to start filtering your charts. Select type of filter you want to apply to your data by clicking on the corresponding item:
- Measure: filter according to rules set to the quantitative values, like greater than, not equal, between and so on.
- Dimension: filter according to rules set to the qualitative values, like wildcard (string) matches or top X values.
- Date: filter according to rules set to time and date by periods, like fixed periods(years 2015 to 2019) or floating ranges (last X months).
When you're done, click on Apply at the top right corner to apply the filters.
By default, filters use aggregated values which are displayed on the chart. To use raw values from the dataset,enable the Apply filter to raw data option.
Using the data sorting option enables you to order your data shown in your charts. To sort your charts, click on the Sort tab during chart creation or edition and select the dimension you want to sort your data by. Then, select the sorting you want to apply:
- Data source order: the default sorting of elements of a selected dimension, appearing as they come from the dataset.
- Alphabetic: orders the elements by alphabet ascending (A to Z) or descending (Z to A).
- Measure: orders the elements by the measure value, ascending or descending.
- Manual: order the data as you want, by moving the elements up and down the list.
When done, click on Apply at the top right corner to apply the sorting.