Question: Assignment Deliverables The deliverable for this assignment will be one Power BI file (.pbix), which shows the work you did, and one MS Word file

Assignment Deliverables

The deliverable for this assignment will be one Power BI file (.pbix), which shows the work you did, and one MS Word file that shows your explanation of the cleaning techniques implemented in a three-column table, as shown below. The .PBIX file should show all work you did to derive the answers to the questions.

To document the data quality issues, a three-column table should be used in the below format (the example is not applicable to the assignment):

Column in the clean data

Issue found

Cleaning technique applied

First_name

First name was included as part of the name column where first and last names were separated by a space.

I split the name column into two columns using the space as the delimiter.

I have trimmed text, capitalized each word, added custom column and renamed it, removed duplicates and removed blank rows.... how can i put them in 3 column table.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!