Vendors often focus on showcasing their front-end capabilities, i.e. dashboard reporting and data visualizations, while ignoring the vital aspect of analytics, namely data preparation: cleansing, structuring and integrating data to make it ready for analysis. The typical scenarios include using more than one type of data source, working with large datasets, working with messy, unorganized data. This is where your business intelligence tools come in. These tools are meant to automate or simplify the bulk of the data preparation process by using pre-programmed adapters that connect into different types of data sources, and restructuring the data into a single centralized repository. Here are 3 crucial aspects of data preparation one should be aware of when evaluating business intelligence software: Access to the original data, joining multiple data sources and data management. Choosing the wrong software could skew your initial price estimate when you are forced to allocate technical resources or purchase additional programs to handle data preparation.

Read more at:

http://www.sisense.com/blog/data-preparation-checking-hood-analytics-software/