- Concerning the dataset
- Stacked combo chart
- Pie chart
- Pivot desk with heatmap
- Smoothed line chart
This newsletter is part of a chain on an academic of the whole thing Google Data Studio (GDS) . The primary article of this sequence can also be discovered here . As the second one a part of the GDS sequence, this educational will cross over explicit varieties of visualizations. With every chart, there are dimensions, metrics, type, date vary, interactions, and magnificence menus which might be changeable. Along with those charts, there’s the textual content you’ll upload, in addition to knowledge and filter out controls. The dataset underneath this is used for this educational and chart spotlight has a filter out regulate to show sure classes over others. The date vary filter out, additionally consisting of a drop-down menu, comes in handy if you wish to zoom in or from your knowledge. The most efficient a part of those options is that while you edit a filter out within the dashboard view, the knowledge is, subsequently, adjusted as neatly with its respective charts.
The dataset is dummy knowledge created in a Google Sheet. It used to be advanced to imitate equivalent fields of the coronavirus pandemic dataset of 2020. The fields come with the date, area, document counts, and dummy classes. When following this educational, a distinct dataset, reminiscent of the actual coronavirus dataset  can be utilized for tutorial and educational analysis functions most effective.
The treemap chart is a superb method of visualizing the gap of your size. Easiest used for express knowledge, the chart works via expanding or lowering the quantity of its dimension of the metric of your selection. For instance, the chart underneath describes no longer most effective essentially the most impactful classes of the knowledge on the subject of dimension, but in addition provides a heatmap layer that aides in emphasizing sure classes. Every other helpful characteristic of this chart is that, as soon as you might be in dashboard mode, the knowledge used within the treemap can also be downloaded in quite a lot of techniques.
The stacked combo chart comes in handy in that it combines each the preferred bar chart, with a line chart layered over. If you wish to describe two equivalent metrics whilst layering over a line for emphasis, this chart works neatly. Along with the multilayered manner, the knowledge can also be described via soaring over the precise date vary.
Whilst the pie chart might appear previous information, in GDS, the quantity of specification is outwardly unending. For instance, for the metric selected to be charted, the kind manner, which is utilized in maximum charts in GDS, other aggregations can also be displayed. One of the most aggregations come with sum, moderate, depend, depend distinct, min, max, median, usual deviation, and variance. As soon as a type is selected, you’ll both come to a decision to descend or ascend your knowledge. Within the pie chart underneath, I selected to make use of just one colour gradient, however you’ll simply transfer to multicolored for a distinct impact.
In GDS, there are if truth be told three sub sides of the overall pivot desk: pivot desk, pivot desk with bars, and the pivot desk with heatmap. The use of your size because the index and the date vary because the column, the metrics would be the values the place the min and max values are coloured in heatmap shape to turn the significance of your metric (this impact is quite very similar to conditional formatting in Excel, however can show gradients).
The smoothed line chart is most often used for exhibiting time sequence, however I sought after to turn how express knowledge might be expressed. Within the chart underneath, the areas (US states) are at the X-axis, whilst the price of the metric is the Y-axis, with all metrics charted to their respective colours. I consider this chart is without doubt one of the very best GDS has to provide as a result of it will possibly display quite a lot of knowledge out of your knowledge. Beneath, you’ll see each express and numeric knowledge all whilst in comparison to each other.
GDS has numerous other visualizations to explain your knowledge and metrics. They end up to be an invaluable manner of unveiling off your exploratory knowledge analytics, whilst additionally for exhibiting your ad-hoc knowledge science metrics. This educational is part of a chain on GDS, please remark underneath you’ve any questions or specialised requests for additional articles on this sequence.
My Google Knowledge Studio dashboard used to be created the usage of a dummy dataset. The options/fields/columns are dummy attributes as neatly. The photographs are my very own screenshots of the GDS dashboard. The knowledge and metrics visualized in my dashboard screenshots are not to be used for any scientific reason why. It’s static, non-real, and does no longer have any reliance on accuracy. It used to be purely advanced for academic functions.
 M.Przybyla, Google Data Studio (2020)
 M.Przybyla, Google Data Studio Tutorial Intro (2020)
 Ok.Sudalairaj, Novel Corona Virus 2019 Dataset (2020)