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.
Dealing with the data you don't have
From the course: Learning Data Analytics: 1 Foundations
Dealing with the data you don't have
- [Instructor] I discovered early in my career with data that there was a fair amount of data that was collected in what we call source systems. These systems we use at organizations were built to capture data that was important to them anywhere from HR information on employees, accounting information or even sales data. I started to see a trend in most organizations that I supported that all the data we needed to achieve a certain report or monitor a process did not always exist naturally in their systems. We may see a calculation on a screen but it wasn't stored in the data. Also businesses grow, pivot and change and the information they need today, may not have been needed when the systems were created. Or sometimes that information is only valuable for decision making and not important for the system itself. The impact to you as an analyst is that not all data we need for measurement or decision-making is available. This is where understanding functions and how to use them for…
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.