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

a,b,c,d,e,f,g,h,i,j [file name: sales_data.xlsx]

1. Syntax of Unique function: =UNIQUE(array,[by_col],[exactly_once])

2. The difference between Syntax and Formula are:
Syntax: Syntax refers to the structure and order of a formula, including functions, references, operators, and parameters.

On the other hand

Formula: Formulas are expressions or equations that can be used to perform calculations and return information. They can range from basic math calculations to complex data manipulation.

3. OK

4. [file name: SMSA.xlsx ]

5. Power Query M formula language is used for power query.

6. Steps to transform the data (SMSA.TXT):
Step 1: Open Excel and create a blank workbook
Step 2: Go to data tab and click on get data
Step 3: From file and click the option - From Text/CSV
Step 4: Choose The file and Import
Step 5: Click the Load button to load the data on worksheet

1,2 [file name: powerPivot.xlsx]