$$ Lab $2-$ Instructions

Total Marks $30$

Work in groups of two $(2).$

Follow the instructions listed below.

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

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

firstname lastname $-$ firstname lastname

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

Step $1-$ Download $(2$ Marks$)$

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

Download all seven $(7)$ files from "Lab $2-$ Data" Into the $"$c:ldata" folder.

Step $2-$ Load Files $(3$ Marks$)$

Load all the files into Power BI$.$

Step $4-$ Clean the Data $(5$ Marks$)$

Ensure all the Queries are:

Error free

No blank columns exist

No blank rows exist

No duplicate column headers, for example columns headers are A$,$ B$,$ C with the first row containing descriptive text.

An example is provided in the image below.

An example is provided in the image below.

Step $7-$ Add Unit Price Column $(2$ Marks$)$

Rename the "Total Price" column to "Total", and then add a calculated column for unit prict Price".

An example is provided in the image below.