Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database System

Authors: Elmasri Ramez And Navathe Shamkant

7th Edition

978-9332582705

More Books

Students also viewed these Databases questions