A Card Chart is a visualization tool for KPI (Key Performance Indicators) and similar indicators. It can be used to create visualizations for several indicators of one object, such as a person, a product, a department, a project, a company or a set of indicators of many objects.
One card can visualize one or many indicators in the form of figures, symbols, or charts. Conditional formatting is used to create rich visualizations.
This is a great tool for top level managers to make insights visible at a glance. Cards can be added to dashboards or used as visualizations/reports in their own right.
As part of the BI platform, Cards are highly interactive. Users can filter data using any combination of dimensions, and pivot and drill through. And Cards are updated in a fraction of a second.
Cards can be a good tool for publishing domestic or international statistics. For example, Cards can be used to display key information about a given EU country, such as GDP, Growth in GDP, Population, Area, etc.
Another example is the use of Cards to publish information for cities. In this case each card can include: state name, state flag and seal, state nickname, number of cars, area of wild fires, etc. A click on a state card can bring up a detailed state dashboard.
Below we create an example to show the steps necessary to create a Card Chart.
In this example we use the SQL Server Public Database AdventureWorks2014.
To the project we add a Card Chart to display product sale volume, ordered quantity and rating (if such exists). An image of the product improves visualization.
We create a BI project containing a Chart View:
- Create a database to connect to SQL Server database; ours is downloaded from here.
- Create a query to get the necessary records
- In order to display an image of the sale products, we create a Reference-Transformation. The data is contained in the ProductPhoto table.
- In the Database field, apply the Transformation.
- Create an OLAP report with one dimension ProductName and three facts: Order Quantity (Quantity ordered per product), Total Due (Total due from customer) and Rating (Product rating given by the reviewer).
- We then create a Chart, setting type as Card. Some of the defined properties are:
The chart is sorted by Order Quantity in descending order.
- For the chart we set color and format styles for the facts.
- The product image appears in the card.
- The values in italic are product ratings.
The BI project for this example can be found here