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
From the course: Learning Data Analytics: 1 Foundations
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.