Skip to content

Mission 11 - Analytics

Learning Objective

In this mission we learn how to get a quick understanding of the data using the built in analytics tab.

Data

Please download the required dataset we will use: new_table_cars.xlsx

Steps

First, open the data that you want to search in.
And press on the analytics button

Image title — The analytics button.

After that you see the table overview.
You can click "Correlation" in the top menu.

Image title — Table overview

Image title — Correlation Chart.

CLick on the "Column Overview" Tab.
There you can select a column and see various charts and information about the specified column.

Image title — For each column we have access to more in-detail analytics such as their distribution.

Image title — The outlier visualizer allows us to investigate the outliers by clicking on them. Outliers can also be removed by clicking on the Remove Outliers button.

Image title — Numerical columns allows for box-plots which gives a overview of the outliers and distribution.

Image title — Depending on the column type different kinds of statistics are available. In this case it's a category variable and is thus shown in a histogram.

Well done! Now let's move on to the next module!