What happened?

Forming Analytical Questions

Konstantinos Kattidis

Data Analytics Lead

Understanding descriptive analytics solutions

Workflow from business questions to analytical solutions

Descriptive analytics:

Industry applications:

Business question:

How can we improve patient satisfaction?

Analytical question:

What are the most common complaints of patients based on the last 3 months' data?

Technique:

Word cloud with patient complaints

Business question:

How can we improve the supplier delivery efficiency?

Analytical question:

Which suppliers have the most delayed deliveries based on the last 6 months' data?

Technique:

Pareto chart of delayed deliveries by supplier

Business question:

How can we develop customized products that meet our customer preferences?

Analytical question:

What are the distinct groups of customers based on their purchasing behavior and style preferences?

Technique:

Scatter plot comparing age and preferred style

Picture of supplements and organic food

An online store that sells health & wellness products such as supplements and organic foods.

How can we improve website engagement to increase sales?

Assumption: measuring website engagement by average session duration

Find out pages associated with higher session duration

Analytical questions:

Which product pages on the website have the highest and lowest session duration based on the last six-month traffic data?

What is the demographic profile of users who visit high session duration pages compared to those who visit for less duration during the same period?

Technique:

Bar charts with top and bottom products by session duration.

Forming Analytical Questions