© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2021
D. SarkaAdvanced Analytics with Transact-SQLhttps://doi.org/10.1007/978-1-4842-7173-5_3

3. Data Preparation

Dejan Sarka1  
(1)
Ljubjana, Slovenia
 

In any analytical or business intelligence (BI) project, data preparation is crucial. It might also be the longest part of a project—exhausting and sometimes tedious. However, the success of a project heavily depends on data preparation.

To appropriately prepare it for the project target, you need to know your data. Besides knowing the variables’ distributions, you need to know the business meaning of your variables. It is always a good idea to have a subject expert available. Only with subject knowledge can create ...

Get Advanced Analytics with Transact-SQL: Exploring Hidden Patterns and Rules in Your Data now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.