$1.$ Work in groups of two $(2).$

$2.$ Follow the instructions listed below.

$3.$ Complete the whole lab within one $(1)$ Power BI file.

$4.$ Ensure the first and last names for both group members are included in Power BI filename.

$5.$ One $(1)$ group member must upload the Power BI file to "Lab $1"$ within Meskanas $($Moodle$).$

Step $1$ Download $(1$ Mark$)$

$1.$ Create one $(1)$ new folder on drive c: called "data".

$2.$ Download all four $(4)$ files from $$Lab $1-$ Data$$ into the $$c:$\backslash$data$$ folder. An example is provided in the image below.

Step $2$ Load Data $(4$ Marks$)$

Load all four $(4)$ files into Power Query. An example is provided in the image below.

Step $3$ Headers $(3$ Marks$)$

$1.$ Within the $$Products$$ query, make the first$-$row header. An example is provided in the image below.

$2.$ Within the $$Invoice$$ query, delete the first row.

$3.$ Within the $$Invoice$$ query, make the first$-$row header. An example is provided in the image below.

Step $4$ Remove Errors $(4$ Marks$)$

$1.$ Within the $$Business$$ query, remove all error rows and blank rows.

$2.$ Within the $$Products$$ query, remove all error rows and blank rows.

$3.$ Within the $$Invoice$$ query, remove all error rows and blank rows.

$4.$ Within the $$Details$$ query, remove all error rows and blank rows.

Step $5$ Remove nulls $(2$ Marks$)$

Within the $$Details$$ query, replace all null values with zero $(0).$ An example is provided in the image below.

Step $6$ Transform Data $(3$ Marks$)$

$1.$ Within the $$Details$$ query, remove $$BU$-$ from the $$Reg$.$ No$.$ column. An example is provided in the image below.

Before

After

$2.$ Within the $$Details$$ query, split the $$GL Code$$ column into three $(3)$ columns. An example is provided in the image below.

Before

After

$3.$ Within the $$Invoices$$ query, split the $$Filing Period$$ column into two $(2)$ columns. An example is provided in the image below.

Before

After

Step $7$ Remove Columns $(2$ Marks$)$

$1.$ Within the $$Invoices$$ query, remove the $$Total Fee$$ and $$Total Taxes$$ columns.

$2.$ Within the $$Details$$ query, remove the $$Business Type$$ column.

Step $8$ Add Columns $(6$ Marks$)$

$1.$ Within the $$Details$$ query, add a conditional column based on the $$Tax Code$$ column; conditions:

a$.$ G $=$ GST

b$.$ P $=$ PST

c$.$ H $=$ HST

$2.$ Within the $$Details$$ query, add a custom column called $$Base Fee$$ which multiples the $$Quantity$$ and $$Fee Rate$$ columns.

$3.$ Within the $$Details$$ query, add a custom column called $$Total$$ which adds the $$Base Fee$$ and $$Tax Amount$$ columns.

$4.$ Within the $$Details$$ query, add a column called $$Year$$ which extracts the year from the $$Date$$ column.

$5.$ Within the $$Details$$ query, add a column called $$Month$$ which extracts the month name from the $$Date$$ column.