Why did it happen?

Forming Analytical Questions

Konstantinos Kattidis

Data Analytics Lead

Understanding why something happened

Diagnostic analytics solutions help:

Identify the root causes of problems
Make data-driven decisions to:
- Optimize processes
- Improve efficiency
- Reduce costs

Business question:

Why is there a decline in program enrollments since last year?

Analytical question:

What specific factors are contributing to the decline in enrollment rates based on the last two years' enrollment data?

Technique:

Diagram with drill down analysis for the enrollment rates decrease.

Business question:

Why is the defect rate of our products increasing?

Analytical question:

Which manufacturing processes are contributing to the increase in defect rate?

Technique:

Diagram with root cause analysis for the defect rate increase.

Business question:

Why are our email open rates declining?

Analytical question:

Which factors are contributing to the decline in email open rates?

Technique:

Heat map comparing open rates

Business question:

Why is there a decline in sales in the past quarter?

Analytical question:

What is the relationship between the decline in sales and relevant variables?

Technique:

Scatter plots with regression line.

Forming Analytical Questions