---
title: SAP BW Survey Questions|Datawarehouse Diagnostic Tool
description: Does your organization suffer from siloed data? Is your financial and operational performance negatively impacted by untrustworthy data? Use our datawarehouse diagnostic tool and take our survey!
---

# Do You Need A Data Warehouse?

## Get Your [Data Warehouse Effectiveness Scorecard](https://www.sapbwconsulting.com/blog/5-kpi-design-best-practice-guidelines)

## Are your [systems](https://www.sapbwconsulting.com/blog/14-ways-to-write-better-sap-proposals) out of date?

 

- Self Assessment
- Process Focus
- Interpretation

Use this [data warehouse requirements](https://www.sapbwconsulting.com/enterprise-services/sap-industry-solutions/business-intelligence-consulting/what-is-sap-business-warehouse) questionnaire self [assessment tool](https://www.sapbwconsulting.com/enterprise-services/sap-industry-solutions/business-intelligence/what-is-sap-business-warehouse) to [rate yourself against other companies](https://www.sapbwconsulting.com/blog/inbound-marketing/how-do-sap-partner-websites-rank-benchmark-report).  This [business intelligence requirements](https://www.sapbwconsulting.com/understanding-sap-bw-in-5-minutes) questionnaire is designed to help you assign a numerical score to your [current use of data](https://www.sapbwconsulting.com/hubspot-salesforce-consulting-request) to inform and[ drive business process performance](https://www.sapbwconsulting.com/request-sap-business-planning-and-consolidation-sap-bpc-consulting-support).  Once you complete the [questionnaire](https://www.sapbwconsulting.com/salesforce-consultant), you'll [get your benchmark](https://www.sapbwconsulting.com/blog/sap-bw-tutorial-best-practice-on-requirements-gathering) results immediately which will look like the image below.

![SAP BW Diagnostic Tool Output](https://www.sapbwconsulting.com/hs-fs/hubfs/BW_Survey_Tool/BW%20Survery%20Results%20Image.png?width=897&name=BW%20Survery%20Results%20Image.png "SAP BW Diagnostic Tool Output")

When giving yourself a [rating](https://www.sapbwconsulting.com/blog/understanding-the-most-common-sap-data-warehousing-concepts) using this SAP survey tool, focus on the [business processes](https://www.sapbwconsulting.com/enterprise-reporting-strategy-development) you use within your companies.  This tool has been designed as a [data warehouse requirements](https://www.sapbwconsulting.com/blog/70-of-business-intelligence-projects-are-failing-worldwide) questionnaire[ as part of](https://www.sapbwconsulting.com/free-website-seo-audit-grader-serp-sem-amp) a comprehensive [requirements](https://www.sapbwconsulting.com/blog/business-reporting-requirements) gathering process.  When used by SAP BW/HANA architects, it can help you design a robust [analytic platform](https://www.sapbwconsulting.com/sap-fico-consulting) 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](https://www.sapbwconsulting.com/blog/ten-tips-for-improving-sap-dashboard-usability) 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](https://www.sapbwconsulting.com/blog/10-steps-to-developing-a-successful-business-intelligence-strategy) 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.

More Reading:

Top 10 Benefits for Financial Analysis in the [Latest SAP EP4](https://www.sapbwconsulting.com/blog/top-10-benefits-for-financial-analysis-in-the-latest-sap-ep4)

Take a [Deeper Dive](https://www.sapbwconsulting.com/blog/deep-dive-into-aircraft-cockpits-vs-dashboards) into Aircraft Cockpits Vs Dashboards

[Hire SAP Business Intelligence Consultant](https://www.sapbwconsulting.com/hire-sap-business-intelligence-consultant)

## 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. |
|  |  |  |

![SAP](https://googleads.g.doubleclick.net/pagead/viewthroughconversion/960101754/?value=0&guid=ON&script=0) 

![](https://www.facebook.com/tr?id=199270410761059&ev=PageView&noscript=1)

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.sapbwconsulting.com/bw-siloed-data-survey-questions#webpage",
  "@type" : "WebPage",
  "about" : [ {
    "@type" : "Thing",
    "name" : "siloed",
    "sameAs" : "https://en.wikipedia.org/wiki/Information_silo"
  }, {
    "@type" : "Thing",
    "name" : "financial",
    "sameAs" : "https://en.wikipedia.org/wiki/Finance"
  }, {
    "@type" : "Thing",
    "name" : "operational",
    "sameAs" : "https://en.wikipedia.org/wiki/Business_operations"
  }, {
    "@type" : "Thing",
    "name" : "performance",
    "sameAs" : "https://en.wikipedia.org/wiki/Performance_improvement"
  }, {
    "@type" : "Thing",
    "name" : "untrustworthy",
    "sameAs" : "https://en.wikipedia.org/wiki/Trust_(social_science)"
  }, {
    "@type" : "Thing",
    "name" : "datawarehouse",
    "sameAs" : "https://en.wikipedia.org/wiki/Data_warehouse"
  }, {
    "@type" : "Thing",
    "name" : "diagnostic",
    "sameAs" : "https://en.wikipedia.org/wiki/Diagnosis"
  }, {
    "@type" : "Thing",
    "name" : "tool",
    "sameAs" : "https://en.wikipedia.org/wiki/Tool"
  }, {
    "@type" : "Thing",
    "name" : "survey",
    "sameAs" : "https://en.wikipedia.org/wiki/Market_research"
  }, {
    "@type" : "Thing",
    "name" : "Warehouse",
    "sameAs" : "https://en.wikipedia.org/wiki/Warehouse"
  } ],
  "breadcrumb" : {
    "@type" : "BreadcrumbList",
    "itemListElement" : [ {
      "@type" : "ListItem",
      "item" : "https://www.sapbwconsulting.com/",
      "name" : "Home",
      "position" : 1
    }, {
      "@type" : "ListItem",
      "item" : "https://www.sapbwconsulting.com/bw-siloed-data-survey-questions",
      "name" : "BW Siloed Data Survey Questions",
      "position" : 2
    } ]
  },
  "description" : "Explore key diagnostic questions to identify and address issues with siloed data using SAP BW.",
  "isPartOf" : {
    "@id" : "https://www.sapbwconsulting.com#website",
    "@type" : "WebSite"
  },
  "mentions" : [ {
    "@type" : "Organization",
    "name" : "SAP",
    "sameAs" : "https://en.wikipedia.org/wiki/SAP_AG"
  }, {
    "@type" : "Thing",
    "name" : "data warehouse",
    "sameAs" : "https://en.wikipedia.org/wiki/Data"
  }, {
    "@type" : "Thing",
    "name" : "companies",
    "sameAs" : "https://en.wikipedia.org/wiki/Company"
  }, {
    "@type" : "Thing",
    "name" : "business intelligence",
    "sameAs" : "https://en.wikipedia.org/wiki/Business_intelligence"
  }, {
    "@type" : "Thing",
    "name" : "score",
    "sameAs" : "https://en.wikipedia.org/wiki/Rating"
  }, {
    "@type" : "Thing",
    "name" : "benchmark",
    "sameAs" : "https://en.wikipedia.org/wiki/Benchmarking"
  }, {
    "@type" : "Thing",
    "name" : "rating",
    "sameAs" : "https://en.wikipedia.org/wiki/Evaluation"
  } ],
  "name" : "BW Siloed Data Survey Questions",
  "publisher" : {
    "@id" : "https://www.sapbwconsulting.com#organization",
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "https://www.sapbwconsulting.com/logo.png",
      "width" : 600
    },
    "name" : "SAP BW Consulting, Inc.",
    "url" : "https://www.sapbwconsulting.com"
  },
  "url" : "https://www.sapbwconsulting.com/bw-siloed-data-survey-questions"
}
```

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.sapbwconsulting.com/bw-siloed-data-survey-questions#quiz",
  "@type" : "Quiz",
  "description" : "A quiz designed to identify and address issues related to siloed data within your organization.",
  "educationalAlignment" : {
    "@type" : "AlignmentObject",
    "alignmentType" : "Educational",
    "targetName" : "SAP BW Diagnostic Tool"
  },
  "isPartOf" : {
    "@id" : "https://www.sapbwconsulting.com/bw-siloed-data-survey-questions#webpage"
  },
  "name" : "BW Siloed Data Diagnostic Survey",
  "text" : "The quiz includes key questions related to financial, operational, and performance data silos to help diagnose challenges and recommend solutions."
}
```

```json
{
  "@context" : "https://schema.org",
  "@id" : "https://www.sapbwconsulting.com/bw-siloed-data-survey-questions#itemlist",
  "@type" : "ItemList",
  "description" : "A list of key questions to identify issues with siloed data and improve data governance.",
  "isPartOf" : {
    "@id" : "https://www.sapbwconsulting.com/bw-siloed-data-survey-questions#webpage"
  },
  "itemListElement" : [ {
    "@type" : "ListItem",
    "name" : "Does your organization rely on multiple unconnected systems for critical data?",
    "position" : 1
  }, {
    "@type" : "ListItem",
    "name" : "Do financial and operational teams struggle to align their data?",
    "position" : 2
  }, {
    "@type" : "ListItem",
    "name" : "Are there delays in generating reports due to data inconsistencies?",
    "position" : 3
  }, {
    "@type" : "ListItem",
    "name" : "How often do you encounter errors in performance reports?",
    "position" : 4
  }, {
    "@type" : "ListItem",
    "name" : "Does your organization have a data warehouse for centralized reporting?",
    "position" : 5
  } ],
  "name" : "Key Diagnostic Survey Questions"
}
```