Project 1 - Data Cleaning and Transformation using Pivot Table and Charts
1. =UNIQUE
2.Syntax is not universal it means it changes with programming languages . But a formula is universal its always constant and same in every programming language.
3.OK
4.Open the Excel spreadsheet where you want to save the data and click the Data tab. In the Get External Data group, click From Text. Select the TXT or CSV file you want to convert and click Import.
5.M formula Language
6.
The data transformation process is carried out in five stages.
- Discovery. The first step is to identify and understand data in its original source format with the help of data profiling tools. ...
- Mapping. The transformation is planned during the data mapping phase. ...
- Code Generation. ...
- Execution. ...
- Review.