Member-only story
Visualizations are still hot topics across industries of finance, manufacturing, construction, e commerce and so on. During four years of my short career life, I have evaluated many visualization tools. Here I will write down everything I know about to help you draw a baseline among those tools.
Excel
Excel is widely used in traditional industries due to the fact that Microsoft Office is a popular tool suit and Excel is used for reporting and dashboards. Except that, traditional industries also use Excel to automate works by writing macro.
Popular excel charts:
Pivot table
Pivot table is easy for aggregation. Basic statistics functions are provided such as count, sum, min, max, standard deviation. It also allow you to filter based on the columns you have predefined.
Data bar
Data bar is one of the easiest and nicest function that Excel provides. By simply formatting you data with the gradient fill or solid fill option, the whole data column is filled with…
