Project 1 - Data Cleaning and Transformation using Pivot Table and Charts

 1. =UNIQUE(A1 : F2)

2. Syntax refers to the structure and order of a formula, including functions, references, operators, and parameters. If you’re a spreadsheet user, you’ll find much of the formula syntax in Honeycode familiar.

3. OK

5. M formula language

6. 

1. Discovery. The first step is to identify and understand data in its original source format with the help of data profiling tools. 
2. Mapping. The transformation is planned during the data mapping phase. 
3. Code Generation. 
4. Execution.
5. Review.