From the course: Business Analytics Foundations: Descriptive, Exploratory, and Explanatory Analytics
Join today to access over 24,600 courses taught by industry experts.
DEA tools and techniques
From the course: Business Analytics Foundations: Descriptive, Exploratory, and Explanatory Analytics
DEA tools and techniques
- [Instructor] What are the tools and techniques, that are used in descriptive analytics? The first common technique used in descriptive analytics, is aggregation. This is the same as an SQL GROUP BY or an Excel pivot. An example of aggregation is shown here. Where the heart health data, is grouped by age group, to show the total number of patients and their average cholesterol level by the age group. It is based on a segment, or a time period, or both. This example uses the segment, age group, to aggregate the data. It typically contains totals and subtotals, for profiling variables. The profiling variables in this report, are total patients and average cholesterol. And it has totals for both. Analysts could also include percentage values, to indicate what percentage of a given segment actually counted for the profiling variable. The next technique, is time range comparisons. The goal for time range comparisons is to…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.