Why is Excel not suitable for data preparation in the enterprise? - Expert view

Microsoft Excel is a powerful tool for creating spreadsheets, charts, graphs, OLAP analyses and reports. It is easy to use, widely available, and provides users with self-service analytical functions. Despite its advantages, Excel was not designed for data preparation tasks. Excel users often spend too much time investigating and preparing data for their analytics needs by using filters to find faults in data, creating pivot tables to discover outliers, writing VLOOKUPs to connect datasets, writing complicated formulas, and so on. This Expert View discusses Excel’s most critical limitations in terms of data preparation, and describes how specialist data preparation tools can help users obtain reliable and sustainable results faster.


 
Niveau d'Expert View : Operational, Forward-Looking
 
Secteurs concernés : All
 
Catégories : Data Preparation, Innovation, Big Data, Advanced Analytics, Digitalization, Organization
 
Degré d'urgence de s'y intéresser : 5 *
 

 

Voir l'étude : CxO Advisor