From the course: Excel: Managing and Analyzing Data

Unlock this course with a free trial

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

The importance of checking data quality

The importance of checking data quality - Microsoft Excel Tutorial

From the course: Excel: Managing and Analyzing Data

Start my 1-month free trial Buy for my team

The importance of checking data quality

“

- [Instructor] Let's talk about the importance of checking data quality. This conversation needs to be had more. So let's say you finally got the data and you're ready to start doing some analysis and passing it off to colleagues and bosses. You're so excited and you just learned pivot tables and you just learned how to unpivot in Power Query, and I am going to say stop. Look, data can fall anywhere between trustworthy and worthless. Too many people assume that the data that they get is trustworthy and they dive in, start doing analysis, and inspiring decisions, but they haven't assessed where they are on the spectrum. So the first question you should ask yourself is, "Can I trust this data?" Why? Because there are people who are impacted by what we do with our data. They're impacted by our data management and data analysis. And yes, there are things like billing can be inaccurate, inventory data can be inaccurate, but I believe bigger than that is the people who suffer those…

Contents