Connect to data sources
Perform transformations
Cleanse data
- May include: Connect to databases, files, folders; import from Excel; connect to SQL Azure, Big Data, SQL Server Analysis Services (SSAS)
Perform transformations
- May include: Design and implement basic and advanced transformations; apply business rules; change data format to support visualization
Cleanse data
- May include: Manage incomplete data; meet data quality requirements