From the course: Learning Data Analytics: 1 Foundations

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Finding and removing duplicates

Finding and removing duplicates

From the course: Learning Data Analytics: 1 Foundations

Start my 1-month free trial Buy for my team

Finding and removing duplicates

“

- [Instructor] I don't really trust any dataset until I explore it just a little bit. That's because we often inherit the skills of the person who sent it to us. What if they didn't join it correctly? Or what if they didn't understand the ask? So when I work with data, I always do some exploration. What I found is that most people discover issues when they start to build calculations and something seems off. So if we look at our data here, we see we have a total order amount, and we want to vet that to make sure that it includes all of the items. Let's go take a look at our query. I'll go to data, query and connections. If I already see query and connections, I can just right click my table and choose edit. Let me scroll over and look at my fields here. I have price and quantity and discount and tax, and I have a sales amount. It's really easy to add a quick column in M code. So I'll go ahead and choose add, I'll do a custom column. So custom column. I'll go ahead and name this test…

Contents