SAP BW Survey Questions|Datawarehouse Diagnostic Tool

Get Your Data Warehouse Effectiveness Scorecard

Are your systems out of date?

Self Assessment
Process Focus
Interpretation

Use this data warehouse requirements questionnaire self assessment tool to rate yourself against other companies. This business intelligence requirements questionnaire is designed to help you assign a numerical score to your current use of data to inform and drive business process performance. Once you complete the questionnaire, you'll get your benchmark results immediately which will look like the image below.

SAP BW Diagnostic Tool Output

When giving yourself a rating using this SAP survey tool, focus on the business processes you use within your companies. This tool has been designed as a data warehouse requirements questionnaire as part of a comprehensive requirements gathering process. When used by SAP BW/HANA architects, it can help you design a robust analytic platform that allows you predict and achieve business success.

Information is a key asset of every company. Many companies have spent years investing in the development of their data warehouse, yet may not have much to show for it.

Using this SAP BW self assessment tool, you should ask yourself if your information management capabilities are truly designed to deliver insight to your business as and when needed.

Depending on your results, you may find that your information is siloed, and that many of your business processes could be substantially improved by using a datawarehouse.

KPI Design Key Input

This survey is also typically used as part of your business reporting requirements definition process. It's also a key input developing your SAP reporting strategy. Ultimately it should be a key input into developing your SAP BW technical specification. It will also point you in the right direction when it comes to designing your business ratio formulas. It will surface dashboard usability issues in that an honest assessment reveals user satisfaction with existing systems and performance. It is also useful as a CRM diagnostic tool input in that your SAP BW datawarehouse is a key component of successfully using SAP CRM or Hubspot or Salesforce CRM.

Take BW Survey Quiz

First Name

Last Name

Email

Phone

Company

Question 1
Our Data is Siloed	1 2 3 4 5 6 7 8 9 10	Our Data is Not Siloed

Question 2
We don't know the cause of the siloed data	1 2 3 4 5 6 7 8 9 10	We know the cause of the siloed data

Question 3
All departments do not agree on the numbers	1 2 3 4 5 6 7 8 9 10	All Departments agree on the numbers

Question 4
Management has not fully defined all Relevant KPIs	1 2 3 4 5 6 7 8 9 10	Management has fully defined all Relevant KPIs

Question 5
IT Has Not Engineered the IT Systems so all Stakeholders can answer the business questions they have to answer	1 2 3 4 5 6 7 8 9 10	IT has Engineered the Systems so all Stakeholders can answer the business questions they have to answer

Question 6
We cannot tell what we made, who we sold it to, and what we sold when.	1 2 3 4 5 6 7 8 9 10	We can tell what we made, who we sold it to, and what we sold when.

Question 7
All Dashboards in all departments do not report the same numbers.	1 2 3 4 5 6 7 8 9 10	All Dashboards in all departments report the same numbers

Question 8
CRM is a stand-alone system	1 2 3 4 5 6 7 8 9 10	CRM is not a stand-alone system

Question 9
Financial results are not auditable	1 2 3 4 5 6 7 8 9 10	Financial Results are Auditable

Question 10
Sales results vary depending on which system you look at.	1 2 3 4 5 6 7 8 9 10	Sales results do not vary depending on which system you look at.

Question 11
We are excel dependent	1 2 3 4 5 6 7 8 9 10	We are not excel dependent

Question 12
Inventory forecasting is not accurate and we experience shortages	1 2 3 4 5 6 7 8 9 10	Inventory forecasting is accurate and we do not experience shortages

Question 13
We do not have the ability to listen to the voice of the customer	1 2 3 4 5 6 7 8 9 10	We have the ability to listen to the voice of the customer

Question 14
We do not have budget to invest in new systems	1 2 3 4 5 6 7 8 9 10	We have budget to invest in new systems.

Question 15
We cannot adjust prices in real time	1 2 3 4 5 6 7 8 9 10	We can adjust prices in real time

Question 16
Our strategy is not fully supported by a datawarehouse	1 2 3 4 5 6 7 8 9 10	Our strategy is supported fully by a datawarehouse

Question 17
All departments do not operate a common database	1 2 3 4 5 6 7 8 9 10	All departments operate a common database

Question 18
Master data definitions are not agreed upon across all departments	1 2 3 4 5 6 7 8 9 10	Master data definitions are agreed upon across all departments

Question 19
We cannot report on what did happen	1 2 3 4 5 6 7 8 9 10	We can report on what did happen

Question 20
We cannot predict what will happen	1 2 3 4 5 6 7 8 9 10	We can predict what will happen

Question 21
We do not know what is happening in the business right now	1 2 3 4 5 6 7 8 9 10	We know what is happening in the business right now

Question 22
Finance frequently has different revenue figures than Marketing	1 2 3 4 5 6 7 8 9 10	Finance and marketing fully agree upon all revenue figures

Question 23
Political and technical silos exist in the company	1 2 3 4 5 6 7 8 9 10	Political and technical silos do not exist in the company

Question 24
People are building kingdoms based on withholding information	1 2 3 4 5 6 7 8 9 10	No kingdoms exist based on withholding information

Question 25
I am not responsible or empowered to research new technology solutions	1 2 3 4 5 6 7 8 9 10	I am responsible for researching new technology solutions

Question 26
IT does not drive change	1 2 3 4 5 6 7 8 9 10	IT is driving change

Question 27
I am neither tasked nor equipped to find and evaluate new systems and solutions	1 2 3 4 5 6 7 8 9 10	I am tasked and equipped to find and evaluate new systems and solutions

Question 28
Finance requires at least 3 different proposals for any system acquisitions	1 2 3 4 5 6 7 8 9 10	Finance is flexible on new proposals.

Question 29
I am not expected to only use systems provided by my company.	1 2 3 4 5 6 7 8 9 10	I expected to only use the systems provided by company

Question 30
We still use flat files for reporting	1 2 3 4 5 6 7 8 9 10	We do not use flat files for reporting.

Do You Need A Data Warehouse?

Get Your Data Warehouse Effectiveness Scorecard

Are your systems out of date?

KPI Design Key Input

Take BW Survey Quiz