[03/MSSBI/01]

Data warehouse team

To transform organizations into data-driven organizations

Developing custom-built solutions

Managed self-service BI

To make informed decisions

Data Vault 2.0

To build solutions without any time limitation

All of the above

Lack of management

To enforce data and information security

All of the above

All of the above

All of the above

All of the above

All of the above

E-

It allows for easy monitoring of power user adherence to guidelines.

To check resource consumption and security violations.

The solution is analyzed and redesigned in the IT controlled area.

To implement new data-driven solutions following standards.

To help casual users distinguish between standard reports and power user reports

To empower traditional organizations to become data-driven

Add any footnote they want

It helps make data widely available within limits set by the security team

To consult on Big-Data solutions

The power user is not executing any more DDL statements

The data does not fit into the spreadsheet application

Create a new computed satellite in the user space

To fine-tune the growth of the user base

It ensures the solution is industrialized

Data warehouse team

To extend the data analytics platform

Improved data governance

Reduced data storage requirements

Managed self-service BI

To provide a green field for power users to build their own solutions

Prototyping and experimentation

To enforce data and information security, privacy, and auditability guidelines

Manual and error-prone activities

Messy and unmanaged user space

To extend the solution provided by the data warehouse team

Provides a separate area for power users to create their own solutions

To increase re-usability of business logic

Users have to reinvent the same business logic over and over

Augmented data analytics platform

Scalefree International GmbH

To distinguish between standard reports and power user reports

Allows power users to create dimensions

Enhanced data availability within set limits

To ensure data privacy and security

To upload and join data for analytical purposes

They ensure data quality and consistency

The data from web servers didn't fit into the spreadsheet application

The solution is industrialized and becomes part of the IT controlled area

To customize existing standard solutions

Limiting potential applications

To check resource consumption

To redesign solutions in the IT controlled area

To identify tables referring to contacts, leads, and employees

Increased resource consumption

True

True

True

True

False

True

True

True

True

True

True

True

False

False

True

True

False

True

True

True

True

False

True

True

True

True

False

True

False

True

True

True

True

True

False

True

True

True

True

False

False

True

True

True

True

True

True

True

True

True

True

True

False

True

True

True

True

True

True

True

Data Vault 2.0 = A concept for designing data analytics platforms Managed Self-Service BI = A concept used to transform organizations into a data-driven organization Power Users = Individuals who drive the data warehouse team and use the infrastructure and capabilities provided User Space = An area where power users can create their own solutions without any limitations

Number of decision-makers in an organization according to the text = Every employee, from the C-level down to the lowest level Types of users in Managed Self-Service BI = Power users and casual users Goal of managed self-service BI = To make data and information widely available to any decision-maker Purpose of user marts in the data analytics platform = To allow power users to extend the solution

Data-driven organization = The goal of using Managed Self-Service BI User Space = An area where power users can create their own solutions Data Vault 2.0 = A concept used for designing data analytics platforms Power Users = Individuals who drive the data warehouse team and use the infrastructure and capabilities provided

Managed Self-Service BI = A concept used to transform organizations into a data-driven organization User Space = An area where power users can create their own solutions without any limitations Data Vault 2.0 = A concept for designing data analytics platforms Power Users = Individuals who drive the data warehouse team and use the infrastructure and capabilities provided

Data-driven organization = The goal of using Managed Self-Service BI User Space = An area where power users can create their own solutions Data Vault 2.0 = A concept used for designing data analytics platforms Power Users = Individuals who drive the data warehouse team and use the infrastructure and capabilities provided

User Space = An area where power users can build their own solutions without any limitations Data Vault 2.0 = An architecture that provides artifacts for extending the solution in the data analytics platform Power Users = Users who have the ability to process binary data that should not be loaded into a relational database User Marts = Downstream model for information delivery that often follows dimensional modeling with facts and dimensions

Data Security Guideline = A fence that ensures power users cannot share any data with anybody but must follow the guideline Privacy Guideline = A fence that prohibits storing personal data in the user space Auditability Guideline = A fence that ensures the ability to maintain auditability in the user space

Sharing Data = A scenario where power users can only share data they have access to with employees having the same security level clearance as themselves Stable Solution = A scenario where a solution in the user space is stable and maybe just done Lack of Resources = A scenario where an organization does not have enough experienced and skilled developers available on the market to build all the solutions

Managed Self-Service BI = A concept based on the Data Vault 2.0 architecture that extends it by user space User Space = An environment of the data analytics platform that is not limited to the relational database Power Users = Users who build their own solutions in the user space User Marts = Part of the user space that follows dimensional modeling with facts and dimensions

User Space = A green field where power users can do whatever they want Data Vault 2.0 = An architecture that provides additional benefit when combined with the user space Power Users = Users who can process binary data that should not be loaded into a relational database User Marts = Part of the user space that is used for information delivery

User Space = The area where power users can add additional data, extend the solutions provided by the data warehouse team, and create their user marts Data Vault 2.0 = An architecture that provides artifacts to augment data flows with additional raw data and increase the re-usability of business logic User Marts = Information marts created by power users in their own user space Power Users = Users who have the capability to login to the database and query the information marts by joining dimensions to facts and aggregating using SQL functionalities

Casual Users = Know how to login into the BI dashboarding software and open a static PDF report Advanced Users = Know how to drill down pre-configured dimensions on the report Sophisticated Users = Know how to customize the dashboard by adding additional dimensions, remove some others and configure different aggregations on measures Power Users = Considered those with SQL capabilities, who access the Data Vault model to build their own solutions

Re-usable Code Libraries = A potential solution to reduce the reinvention of the same business logic and other transformation logic by power users Regulatory Issues = Power users and data scientists have to deal with these, such as GDPR, when extracting data directly from the source system Self-Service BI = A common solution that allows power users and data scientists to access data sources directly and build their own solutions Managed Self-Service BI = An approach that works well with organizations driven by the business and involves a distinction between power users and casual users

Controlled Area = The area of the data analytics platform where power users are not supposed to create their solutions Information Marts = Artifacts used by power users, along with artifacts from the Raw Data Vault and Business Vault, to create their own solutions Business Vault = The area of the data analytics platform where power users can obtain business rules User Space = The area of the data analytics platform where power users can create their own solutions without limitations

Power Users = Can extend the solution by additional data, not yet integrated by the data warehouse team Data Scientists = Can leverage code that already exists in the business logic from the Business Vault Casual Users = Receive all BI reports in print and have limited interaction with the data analytics platform Advanced Users = Know how to login to the database and query the information marts by joining dimensions to facts and aggregating using SQL functionalities

User Space = A space on the data analytics platform where power users can create their own solutions without limitations Industrialization = An alternative to the time limitation of the traditional sandboxing approach, involving analysis, redesign, and re-implementation of a solution in the IT controlled area of the data analytics platform Data Governance = A set of processes and policies that ensure the availability, usability, integrity, and security of data in the organization Power User = An individual who has advanced knowledge and skills to create and manage solutions in the user space

GRANTS = Permissions that define who can access the solutions in the user space Fences = Guidelines or regulations that limit the potential applications for the user spaces User Marts = Part of the user space where power users can create custom dimensions using user-defined satellites Smart Business Keys = Business keys that have a specific prefix based on the type of entity, such as 'C-' for contacts

Infrastructure = Needs to be managed to ensure the availability and performance of the data analytics platform Data = Needs to be managed by the data analytics team to avoid the need for power users to reduce or delete personal data Standards = A book of standards should help power users to identify preferred tools that are supported by the data analytics team Support Processes = Should be in place to provide assistance to power users, such as a support hotline or documentation and training

A consumer has requested their right to be forgotten = Power users are informed and can either remove or reduce the record, or it is automatically deleted A solution exceeds defined thresholds = It deserves additional review and may undergo industrialization Many guidelines and regulations are put in place = The potential applications for the user spaces are limited and users may find alternative solutions 500+ users are using a power user solution = It has increased its impact over time through sharing of information

Power User Solution = Individual solutions that are built and managed by power users in the user space Data Vault 2.0 = An architecture that provides artifacts for data science and can be used as a basis for solutions in managed self-service BI User Space = A key component that allows power users to create and manage their own solutions Industrialization = An approach that helps manage solutions that exceed thresholds and need additional review

Power User = An advanced user who can create their own solutions in the user space User Space = A green field where power users can create their own solutions without any limitations Standard Report = A report built by the data analytics team and distinguished by a specific footnote Data Vault 2.0 = A reference architecture providing artifacts for power users to extend the solution

Managed Self-Service BI = A pattern that works well with organizations driven by the business User Mart = An information mart created by power users to build their own dashboards Fence = A way to monitor the user space and ensure compliance with guidelines Footnote = An addition to standard reports to help casual users distinguish them from power user reports

Power users can create their own information marts = True The user-defined satellites created by power users can be used to create custom dimensions in the information marts = True Power users might add any footnote they want, but certainly not 'built by the data analytics team' = True The user space in Managed Self-Service BI is limited to the relational database only = False

Power User = Creates solutions in the user space Data Analytics Team = Builds standard reports Security Team = Sets limits for making data widely available Casual User = Pulls reports and needs help distinguishing between types

Power User = Builds their own solutions in the user space Data Vault 2.0 = Provides artifacts for power users to extend the solution User Space = A green field where power users can create their own solutions Standard Report = Built by the data analytics team and distinguished by a specific footnote

User Space = A space where power users can upload and join data for analytics purposes Data Vault 2.0 = A reference architecture used to build the internal data warehouse Managed Self-Service BI = A pattern used for prototyping and eventually industrializing solutions Power User = A user who can extend existing standard solutions by creating new computed satellites

True or False: The user space on the data analytics platform allows power users to monitor the adherence of guidelines. = False True or False: Power users can extend existing standard solutions by creating new computed satellites in their user space. = True True or False: Industrialization monitoring helps identify solutions that exceed defined thresholds in terms of impact, stability, security violations, and resource consumption. = True True or False: The primary issue faced by the business user mentioned in the text is that the data from web servers does not fit into the spreadsheet application anymore. = True

Power User = They are responsible for developing the infrastructure and capabilities provided by the data warehouse team Managed Self-Service BI = It is used to transform organizations into a data-driven organization Data Vault 2.0 = It provides the business users with a user space where they can upload and join data User Space = It is used by power users to create their own solutions without any limitations

User Marts = Part of the user space in the data analytics platform Data Vault 2.0 = Built using it, the internal data warehouse provides a user space for power users Managed Self-Service BI = Used for prototyping and when one out of ten business prototypes generates revenues, the solution is industrialized Power User = They can extend existing standard solutions by creating new computed satellites in their user space

This pattern is used with a current client in the media industry which was facing decreasing revenues due to changing media consumption patterns by consumers. = Data Vault 2.0 This is a user who is not executing any more DDL statements on its user space, indicating that the solution is stable and maybe just done. = Power User This is a space where power users can upload the data, join it with existing data and information artifacts, and use their insights to modify the business prototype. = User Space This is a pattern used for prototyping and when one out of ten of these business prototypes eventually generates revenues, the solution is industrialized. = Managed Self-Service BI

User Space = An area where power users can build their own solutions and process binary data that should not be loaded into a relational database Data Vault 2.0 = A reference architecture that serves as the basis for Managed Self-Service BI and can be extended by the user space User Mart = Part of the user space that follows dimensional modeling with facts and dimensions for information delivery Fences = Guidelines and restrictions that can be implemented to ensure data and information security, privacy, and auditability in the user space

Data Vault notation using hubs, links, and satellites = An upstream model that power users in the user space are advised to follow Dimensional modeling with facts and dimensions = A downstream model for information delivery often used in the user space Sandboxing = A practice similar to the user space in other self-service approaches, but with a time limitation Re-usable code libraries = A solution to avoid power users reinventing the same business logic and transformation logic

Power Users = They can extend the solution by additional data not integrated by the data warehouse team Data Warehouse Team = Responsible for setting up and further developing the Data Vault 2.0 reference architecture User Space = Acts like a green field where power users can do whatever they want Managed Self-Service BI = Used to transform organizations into a data-driven organization

User space lacks Data Vault entities = The user space may have apparent issues and need management Spreadsheets used for data analytics = A challenge due to manual, error-prone activities and lack of management Power users create their own solutions = An advantage of the user space in Managed Self-Service BI Power users cannot share data with anyone = An outcome of implementing a fence for data and information security

Managed Self-Service BI = A concept based on the Data Vault 2.0 architecture that extends it by user space User Space = An environment of the data analytics platform that power users can manage and build their own solutions in User Mart = A part of the user space that follows dimensional modeling with facts and dimensions Fences = Guidelines and restrictions that can be implemented to ensure data and information security, privacy, and auditability in the user space

Managed Self-Service BI = A concept based on the Data Vault 2.0 architecture that extends it by user space Data Vault 2.0 = A concept for designing data analytics platforms Power Users = Individuals who drive the infrastructure and capabilities provided by the data warehouse team User Space = An extension to the Data Vault 2.0 reference architecture, where power users and data scientists can create custom solutions

Every employee needs to make decisions = A belief in the concept of managed self-service BI Managed self-service BI is used to transform organizations = The goal of managed self-service BI The integration of custom solutions for power users and data scientists = An extension to the Data Vault 2.0 reference architecture The data warehouse team provides the infrastructure and many capabilities = The role of the data warehouse team in managed self-service BI

Power users want to extend the data analytics platform = One of the major use cases supported by managed self-service BI An organization wants to make data and information widely available to any decision-maker = The goal of managed self-service BI A data-driven organization wants to turn decisions into rational decisions = The purpose of managed self-service BI The data warehouse team is responsible for setting up and further developing the architecture = The role of the data warehouse team in managed self-service BI

Impact = Should be relatively low for solutions in managed self-service BI Stability = Should be ensured for solutions in managed self-service BI Security = Should be considered for solutions in managed self-service BI Resource consumption = Should be monitored for solutions in managed self-service BI

User Marts = Part of the user space in the data analytics platform Industrialization Effort = The goal is to ensure that solutions are stable and done Scalefree International GmbH = The organization that introduced the concept of managed self-service BI Standard Development Techniques = Used for rebuilding stable solutions in the IT controlled area

User Space = A sandbox where power users can create their own solutions without any limitations Industrialization = An alternative to the time limitation of the traditional sandboxing approach Power User = An individual who can build their own solutions using binary data that should not be loaded into a relational database Data Vault 2.0 = A model that helps organizations make data widely available while maintaining security and privacy

User Space = A technical solution that allows power users to build their own solutions Data Governance = The process of managing the availability of data and API catalogs Managed Self-Service BI = A pattern that works well with organizations driven by the business Power User = An individual who can create their own information marts and dashboards

Infrastructure = Needs to be managed in the context of Managed Self-Service BI Data = Needs to be managed as it is maintained by the data analytics team Power Users = Should be supported through documentation, training, and monitoring User Spaces = Need to be monitored to check the adherence of the power user to the guidelines

Power User = An individual who can extend the data analytics platform with custom-built solutions Data Warehouse Team = Responsible for setting up and further developing the Data Vault 2.0 reference architecture Managed Self-Service BI = A pattern that works well with organizations driven by the business Scalefree International GmbH = A Big-Data consulting firm in Europe

Power User = Can create their own information marts and dashboards Data Warehouse Team = Responsible for setting up and further developing the Data Vault 2.0 reference architecture Scalefree International GmbH = A Big-Data consulting firm in Europe User Space = A sandbox where power users can build their own solutions

A power user stops executing DDL statements on their user space = Indicator that the solution is stable and maybe just done A power user wants to extend the information marts by additional dimensions = Can create a new computed satellite in the user space and attach it to an existing hub or link A power user tries to generate a user base for a business prototype = If successful, can try to generate revenue from the user base A power user receives data from the web servers for analytical purposes = Data does not fit into the spreadsheet application anymore

Creating many guidelines and regulations on how to use the user space limits the potential applications for the user spaces = False The industrialization of a solution becomes easier when a power user stops executing DDL statements on their user space = True Power users in the user space can build their own solutions using binary data that should not be loaded into a relational database = False Power users can extend existing standard solutions by creating new computed satellites in their user space = True

User space = A green field where power users can create their own solutions without any limitations Data Vault 2.0 = A model used to build the internal data warehouse, providing a foundation for managed self-service BI Power user = A user who can create their own solutions and modify existing ones in the user space Industrialization = The process of reimplementing solutions from the user space in the IT controlled area of the data analytics platform

Power user = Creates and modifies solutions in the user space Data analytics team = Takes over the solution from the power user when it is stable IT-driven part of the data architecture = Provides data artifacts, business rules, and information assets Data warehouse team = Provides the infrastructure and capabilities for power users and data scientists

Prototype = An initial version of a solution that is tested and modified to meet the desired requirements User space = A sandbox environment where power users can explore, experiment, and create their own solutions Business rules = Defines the operations, data transformations, and data quality requirements for a business process Industrialization = The process of transforming a solution from the user space into a production-ready system

Board members of a large enterprise = Receive all BI reports in print More advanced users = Know how to login into the BI dashboarding software and open a static PDF report Even more advanced users = Know how to drill down pre-configured dimensions on the report Sophisticated users = Know how to customize the dashboard by adding additional dimensions, remove some others and configure different aggregations on measures

Users who are not satisfied with the pre-defined dimensional models in the information mart = Access the Data Vault model to build their own solutions Users who login to the database and query the information marts by joining dimensions to facts and aggregating using SQL functionalities = Considered power users in the data analytics space Board members of a large enterprise = Receive all BI reports in print Users who know how to read their emails in their email application and how to open a static PDF report = More advanced users

Managed Self-Service BI = A pattern that works well with organizations driven by the business User space = An area where power users can add additional data, extend the solutions provided by the data warehouse team and create their user marts Data Vault 2.0 = An architecture that helps organizations make data widely available while maintaining security and privacy Power users = Can extend the solution by additional data, not yet integrated by the data warehouse team

User space = An area where power users can add additional data, extend the solutions provided by the data warehouse team and create their user marts Data Vault 2.0 = An architecture that can be used to augment data flows with additional raw data easily available from the data analytics platform or results from the business logic available Power users = Can create their own information marts, called user marts, and create their own dashboards Managed Self-Service BI = A concept based on the Data Vault 2.0 architecture and extends it by user space

User space = An area where power users can add additional data, extend the solutions provided by the data warehouse team and create their user marts Data Vault 2.0 = An architecture that can be used to augment data flows with additional raw data easily available from the data analytics platform or results from the business logic available Power users = Users who can extend the solution by additional data, not yet integrated by the data warehouse team Managed Self-Service BI = A concept based on the Data Vault 2.0 architecture and extends it by user space

Power user = Cannot create anything in the IT-driven area of the architecture Standard report = Built by the data analytics team, budgeted by xyz User space = Where power users can create their own solutions without any limitations Data Vault 2.0 = Helps organizations make data widely available in time within limits set forth by the security team

Managed Self-Service BI = A pattern that works well with organizations driven by the business Power user reports = Reports built by power users that may look like reports from the BI platform Standard reports = Reports built by the data analytics team, budgeted by xyz User space = A green field where power users can create their own solutions without any limitations

Data analytics team = Responsible for building standard reports Power users = Can create their own information marts and dashboards Casual users = Pull some report and need help to distinguish between different types of reports Security team = Sets the limits for making data widely available in time

Power user = Cannot create anything in the IT-driven area of the architecture Standard report = Built by the data analytics team, budgeted by xyz User space = Where power users can create their own solutions without any limitations Data Vault 2.0 = Helps organizations make data widely available in time within limits set forth by the security team

Managed Self-Service BI = A pattern that works well with organizations driven by the business Power user reports = Reports built by power users that may look like reports from the BI platform Standard reports = Reports built by the data analytics team, budgeted by xyz User space = A green field where power users can create their own solutions without any limitations