State of BI Questionnaire - Dear Watson Consulting

State of BI 2022

State of BI Questionnaire - v2

Follow-up/sign-in

Name

Email address (optional)

Design

How do you rate your organisation's design process?

Poor Excellent
0	1	2	3	4	5	6	7	8	9	10

What is your biggest design challenge/issue at present?

Do you agree or disagree with the following statements?

There is a detailed and thorough design process in place.

User experience is very important in the design of BI reports.

End users are consulted during the design process and their needs made central to the report design.

Our organisation’s reports are easy to use.

Mockups and sample reports are created before development begins.

Any final thoughts/additional comments?

KPI Definition

How do you rate your organisation's KPI definition process?

Poor Excellent
0	1	2	3	4	5	6	7	8	9	10

What is your biggest KPI challenge/issue at present?

Do you agree or disagree with the following statements?

The set of KPIs measured are all essential to the organisation.

The correct business rules are followed for all calculations.

Business rules around calculations and KPIs are clear, consistent, and logical.

There is widespread understanding of what the KPIs mean throughout the organisation.

There is an existing data dictionary or other documentation of KPIs and their definitions.

Any final thoughts/additional comments?

Engineering

How do you rate your organisation's data engineering process?

Poor Excellent
0	1	2	3	4	5	6	7	8	9	10

What is your biggest data engineering challenge/issue at present?

Do you agree or disagree with the following statements?

The data engineering process is stable and is functioning well.

Where possible, there is a single source of data.

Knowledge of the engineering process is shared amongst multiple team members.

Everything in the process is automated.

The data is of high quality.

The data accurately reflects what is taking place in the business.

The technology used is modern and fit for purpose.

Any final thoughts/additional comments?

Modelling

How do you rate your organisation's data modelling process?

Poor Excellent
0	1	2	3	4	5	6	7	8	9	10

What is your biggest data modelling challenge/issue at present?

Do you agree or disagree with the following statements?

The data modelling process efficiently produces consistent, quality data for business use.

A star schema approach is used for data modelling.

Data models refresh quickly and in a way that doesn’t cause any other business impacts.

Data models use dimensions where possible and do not keep any unnecessary columns.

IDs are used where possible instead of large text values.

Calculation numbers in reports always match other sources of data.

Knowledge of the data modelling process is shared amongst multiple team members.

Any final thoughts/additional comments?

Visualisation

How do you rate your organisation's data visualisation process?

Poor Excellent
0	1	2	3	4	5	6	7	8	9	10

What is your biggest data visualisation challenge/issue at present?

Do you agree or disagree with the following statements?

The visualisations tell a meaningful story about your organisation’s key business goals.

The way the visuals interact together in the reports add value.

The organisation’s reports look good.

It is easy to navigate between different views and pages.

The data can be sliced and diced in a number of ways.

Data can be extracted and analysed from the BI reports.

Any final thoughts/additional comments?

Integration

How do you rate your organisation's BI integration process?

Poor Excellent
0	1	2	3	4	5	6	7	8	9	10

What is your biggest integration challenge/issue at present?

Do you agree or disagree with the following statements?

The organisation’s reports are integrated within the business environment and are embedded into everyday processes.

It is easy to share the required reports with the relevant people.

The reports are used to identify issues and areas for improvement in the organisation.

It is easy to add licences and grant people access to the BI tool.

The use of the BI reports has been encouraged and pushed throughout the organisation.

The refresh schedule for your reports is at the appropriate frequency.

Any final thoughts/additional comments?

State of BI 2022

Follow-up/sign-in

Demographics

Design

Do you agree or disagree with the following statements?

KPI Definition

Do you agree or disagree with the following statements?

Engineering

Do you agree or disagree with the following statements?

Modelling

Do you agree or disagree with the following statements?

Visualisation

Do you agree or disagree with the following statements?

Integration

Do you agree or disagree with the following statements?