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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started