Survey Data Vault Modelling & Data Governance Conference For consultants: use the information of your current assignment. Survey If you are human, leave this field blank. Architecture & Methodology Please choose your preferred architecture and methodology * Kimball Bus & Star Schema & Landing Zone PSA Data Vault Virtualization Tool Other, If other, please describe your alternative choice. Other: Do you know what Data Vault Methodology and Data Vault Modeling are? * Yes No If yes: Are you using Data Vault 2.0? * Yes No Are you using Ensemble Modeling? * Yes No Scoring Questions Identifying true business keys as an important step. * Strongly disagree Disagree Neutral Agree Strongly agree Not applicable Identifying DELTAS on data sets is important to Analytical BI * Strongly disagree Disagree Neutral Agree Strongly agree Not applicable Identifying DELTAS on data sets is important to Data Science * Strongly disagree Disagree Neutral Agree Strongly agree Not applicable Data should be normalized/broken out when in JSON and XML formats * Strongly disagree Disagree Neutral Agree Strongly agree Not applicable Machine learning, AI, Metadata Mining will take over the need to manually build data models * Strongly disagree Disagree Neutral Agree Strongly agree Not applicable General Questions Please choose all architectural components you leverage * Landing Zone / Data Dump Persistent Staging Area Raw Data Warehouse Dimensional Data Warehouse Virtualization Tool (instead of a data warehouse) BI Query Tools (Tableau, Qlik, Looker etc.) instead of a data warehouse Other Please describe the tooling you are leveraging for data warehouse? Include: BI-tools, ETL/ELT tools, Automation Tools, Virtualization Tools, Wrangling Tools and Data Science, and data modeling tools, conceptual modeling tools, mind mapping tools. Business Process * Strongly disagree Disagree Neutral Agree Strongly agree Not applicable Ontology/Taxonomy * Strongly disagree Disagree Neutral Agree Strongly agree Not applicable Concept by Business * Strongly disagree Disagree Neutral Agree Strongly agree Not applicable Logical * Strongly disagree Disagree Neutral Agree Strongly agree Not applicable Physical * Strongly disagree Disagree Neutral Agree Strongly agree Not applicable Types of Data Utilized in BI Solution. Please choose ALL types of data that (on average) you have used in the data warehouses you’ve built over the past 2 years * Structured (row/columns) Semi Structured Text, Documents Images Audio Video Size of raw data sets used * 0 – 250 GB 251 – 500 GB 501 GB – 1 TB +1 TB Can a DB+ Virtualization tool replace the need for a Data Warehouse? Databases like Snowflake + Looker for example, and by data warehouse we mean: traditional physical data model for your data warehouse with data moved to a normalized physical model. * Yes No A Persistent Stage Area/Fill Landing Zone is all I need as my data warehouse Yes No What reasons do you still have for building a physical data warehouse? Volume Real-Time stream handling Delta Processing Performance (indexing, partitioning) Other Automating Tool Do you currently use automation tooling? * Yes No Select any tools you have used in the past 2 years WhereScape AnalyixDS/ErWin Edge Vaultspeed (Agile Information Factory) Varigence = BIML Flex IRI – Voracity Datavault Builder Other How important is BI / EDW automation tooling in the coming 2 years? * Not important at all A little important Neutral Important Extremely important Comments and Feedback What do you see as your #1 job in the data warehousing space going forward? Comments or feedback about the Data Warehousing Industry? What is the current status of your business intelligence investment? * Unknown No plans Within 3 years Exploration phase Ongoing, planning-design phase Ongoing, construction phase At least one project finished Identification Which function best describes your position within the company? * Consultant Information Worker Manager Director Executive On the Business side: Chief Executive Officer (CEO) Chief Financial Officer (CFO) Chief Marketing Officer (CMO) Controller Accounting Manager Financial & Business Analysts President Executive VP VP HR Managers Management Consultants Procurement Managers Manufacturing Manager Supply Chain Manager Decision Support Managers Marketing Manager Database Marketing Manager Other (please specify) Other: On the IT side Chief Operating Officer (COO) Chief Information Officer (CIO) IT Director IT Manager Data Warehouse Manager Application Development Manager System Architect Technical Analyst Programmers IT Consultant Database Administrator/Developer Business Intelligence Managers Other (please specify) Other: Industry * Aerospace, Defense Accounting, Banking, Financial Serv., Insurance, Real Estate, Legal Agriculture, Mining, Construction, Architecture, Engineering Communications, Telecommunications, Cable Computer Software, Hardware, Service Consulting, Business Integration, VAR, Solutions Provider, ISP, SP Education Government (Federal, State, Local, Military) Healthcare, Medical, Pharmaceuticals, Biotech, Biomedical Manufacturing, Chemicals Media, Publishing, Broadcast, Advertising, PR, Marketing Retail, Consumer Packaged Goods, Distribution, Trade, Wholesale Transportation (Air, Rail, Auto), Logistics Travel, Hospitality, Recreation, Entertainment Utilities, Gas, Electric, Water, Energy, Oil, Petroleum Other How many employees are there in your organisation? * Less than 50 Between 50 and 250 Between 250 and 500 Between 500 and 1000 Between 1000 and 2500 More than 2500 Yearly turnover: Personal Information Email (required if you want the results of the survey) Phone (mobile) Phone Website Are you interested to speak at the Data Warehouse Automation day on Feb 13, 2020? Yes No reCAPTCHA Send Tags: survey Berichtnavigatie Previous
