From the course: Excel: Managing and Analyzing Data

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Challenge: Checking data quality in Excel

Challenge: Checking data quality in Excel - Microsoft Excel Tutorial

From the course: Excel: Managing and Analyzing Data

Start my 1-month free trial Buy for my team

Challenge: Checking data quality in Excel

“

(funky music) - [Instructor] Time for the data quality chapter challenge. We've got two here for you. The first one, you just received about 8,000 rows of data, and it is full of duplicates and missing data, and it's going to take at least 20 hours to get this data cleaned up, and you're not going to be able to start it until next week. So the decision has been made to go ahead and use the data as it is. And the question for you is, is there any way in the world that this decision is the responsible one to make? Think about that. Think of some scenarios. Or no, you don't use this data at all, and this is the bad decision. Second challenge, we have these meetings for the Peanut Brittle Connoisseurs International, the Denver, Colorado branch, and we want to upload our data to the club's national directory, but we have to check it first. Over here we have a list of people who are hosts. And here, we say that this list is complete and accurate. And the data, we have members, the dates…

Contents