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.

Learning Excel datasets

Learning Excel datasets

- [Instructor] I've noticed over the years that people focus on the technical skills needed to work with data, but there is another learning curve to consider, and that's learning the actual data. When you get new-to-you data, be sure that you spend time looking at the data. Let me show you a few of my tricks. I've got a spreadsheet open here called Learn Data. One of the very first things that I note is that the sheet tab is called Order Data. This makes me wonder, Is there a query called Order Data or did someone name this? I would probably ask that question. Okay, I see things like employee ID, last name and first name, and they're together. So I believe that this employee ID and this last name and first name are probably the employees. And because I work at this company, I would likely know that Nancy is actually an employee. I also see things like customer ID and order ID. This tells me I'm looking at data about orders. I know this even more when I see things like quantity, price…

Contents