From the course: The Data Skills Survival Kit

Unlock this course with a free trial

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

Creating aggregated datasets

Creating aggregated datasets

From the course: The Data Skills Survival Kit

Start my 1-month free trial Buy for my team

Creating aggregated datasets

“

- [Instructor] When we're trying to make a large-scale decision based on data, we will use aggregate data as a way to provide valuable totals without providing all the raw data. Generally with this type of analysis, people really don't care about that one individual record or that one data point. They want to see the aggregated totals. We have a new project from our executives, and they want to show the variation of credit values across our client list. They want to show that we have a wide variety of customers and various credit limits. We can show this information without disclosing the actual customer list and the individual credit values. Let's start by looking at our credit authorizations file. As a data analyst, we have access to each record for our customer and their individual credit limits. I'll go to get Data, from file and from Excel Workbook, and I'll choose my credit authorization file here. I'll use…

Contents