Challenge

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

2. ans: Syntax refers to the structure and order of a formula, including functions, references, operators, and parameters.

3. ans: The output will be "OK".

4. ans: Convert the SMSA.TXT File into excel SMSA.XLSX.

5. ans: the Power Query M formula language, also known as M.

6. ans: Step 1: Data interpretation. Step 2: Pre-translation data quality check. Step 3: Data translation. Step 4: Post-translation data quality check.

Your portfolio, next

Ship work like this
in your own course.

Talk to a career counsellor

Free 20-minute call. We'll map the right course to where you want to work.

By submitting you agree to our Terms and Privacy Policy.