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

1.The by_col argument is a logical value indicating how to compare.

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.good

4.a.Save the text file to a folder on your computer. Open Microsoft Excel 2. Select File > Open

b.In the Text Import Wizard – Step 1 of 3 Pop-Up Box, choose Delimited. Click Next.

c.In the Text Import Wizard – Step 3 of 3 Pop-Up Box, keep all fields the same. Click Finish.

5. M formula language.

6.a.Step 1: Data interpretation.

b.Step 2: Pre-translation data quality check.

c.Step 3: Data translation.

d.Step 4: Post-translation data quality check.