Unlock the power of data with our Data Aggregation and Google BigQuery Knowledge Base!
Are you tired of spending countless hours sifting through endless amounts of data? Do you struggle to get accurate and timely results? Look no further because our comprehensive dataset has the solution you′ve been searching for.
Containing 1510 prioritized requirements, solutions, benefits, results, and example case studies/use cases, our Data Aggregation and Google BigQuery Knowledge Base has everything you need to make informed decisions and achieve your desired outcomes.
And the best part? It′s user-friendly and designed to provide results based on both urgency and scope - saving you valuable time and effort.
Why choose our dataset over competitors and alternatives? Our expertly curated content is specifically tailored for professionals in need of efficient data analysis.
Whether you′re a small business or a large corporation, our product is suitable for all.
It′s designed to be used by anyone, so you don′t have to break the bank hiring expensive analysts.
With our DIY/affordable product alternative, you can access reliable information at your fingertips.
But that′s not all.
Our dataset provides a detailed and comprehensive overview of Data Aggregation and Google BigQuery, ensuring that you have a complete understanding of the product and its specifications.
You can compare it with semi-related products and see for yourself the benefits of choosing ours.
Don′t just take our word for it - our dataset has been carefully researched and compiled, utilizing the latest industry trends and best practices.
This means you can trust in the accuracy and reliability of our information, giving you peace of mind and confidence in your decision-making process.
Our Data Aggregation and Google BigQuery Knowledge Base is not just for businesses - it′s for anyone who wants to harness the full potential of their data.
And with its affordable cost, the return on investment is unmatched.
Our dataset simplifies the process and eliminates any guesswork, saving you time, effort, and money.
So, what does our dataset do exactly? It streamlines the data aggregation and analysis process, providing you with quick and accurate results.
It enables you to make data-driven decisions and unlock insights that can improve your business strategy.
In short, it revolutionizes the way you handle data.
Don′t miss out on this opportunity to enhance your data capabilities and stay ahead of the competition.
Invest in our Data Aggregation and Google BigQuery Knowledge Base today and see the difference it can make for your business.
With its numerous benefits and comprehensive features, it′s a must-have tool for any data-driven professional.
What is the purpose of the ROLLUP and CUBE aggregations in BigQuery, and how do they enable more complex data summarization? How do these aggregations differ from traditional GROUP BY clauses, and what are some common use cases for using them? How does BigQuery′s data freshness model impact real-time data analysis, and what are the implications of using incremental aggregation and snapshotting for aggregating and analyzing high-volume, high-velocity data streams? What is the difference between a grouped aggregation and an aggregate function in BigQuery, and how do they serve different purposes in data summarization? How do grouped aggregations allow for more complex data summarization, and what are some common use cases for using them?
Data Aggregation
ROLLUP and CUBE aggregations in BigQuery enable complex data summarization by generating multiple groupings and aggregations in a single query.
Here are the solutions and their benefits in the context of Google BigQuery:
**ROLLUP Aggregation:**
* Purpose: Generates a result set that contains aggregated values for each grouping set specified.
* Benefit: Enables hierarchical aggregation and calculation of subtotals and grand totals.
**CUBE Aggregation:**
* Purpose: Computes the aggregate values for all possible combinations of columns in the GROUP BY clause.
* Benefit: Allows for fast and efficient computation of cross-tabulations and data cubes.
**Key differences from traditional GROUP BY clauses:**
* ROLLUP and CUBE generate more result rows than traditional GROUP BY.
* They enable hierarchical and cross-tabulation aggregations not possible with traditional GROUP BY.
**Common use cases:**
* Reporting and analytics: Use ROLLUP for hierarchical summaries and CUBE for cross-tabulations.
* Data warehousing: Use CUBE for fast and efficient computation of data cubes.
* Business intelligence: Use ROLLUP and CUBE to generate complex reports and summaries.
CONTROL QUESTION: What is the purpose of the ROLLUP and CUBE aggregations in BigQuery, and how do they enable more complex data summarization? How do these aggregations differ from traditional GROUP BY clauses, and what are some common use cases for using them?
Big Hairy Audacious Goal (BHAG) for 10 years from now: Here′s a Big Hairy Audacious Goal (BHAG) for Data Aggregation in 10 years:
**BHAG:** By 2033, data aggregation will be fully democratized, and anyone will be able to access, combine, and analyze complex data from diverse sources seamlessly, enabling unprecedented insights and decision-making capabilities.
**Purpose of ROLLUP and CUBE aggregations in BigQuery:**
In BigQuery, ROLLUP and CUBE aggregations are two advanced data summarization techniques that enable users to generate multiple groupings and aggregations of data in a single query. These aggregations are particularly useful when working with large datasets and complex data models.
**ROLLUP:**
The ROLLUP aggregation creates a result set that contains aggregated values for each group of rows, as well as aggregated values for each combination of grouping columns, creating a hierarchical structure. For example, if you have a table with columns `region`, `city`, and `sales`, a ROLLUP aggregation would generate the following result set:
* Total sales for each region
* Total sales for each city within each region
* Grand total sales across all regions and cities
**CUBE:**
The CUBE aggregation generates a result set that contains aggregated values for all possible combinations of grouping columns. Unlike ROLLUP, CUBE does not create a hierarchical structure; instead, it produces a flat result set with all possible combinations of grouping columns. Using the same example as above, a CUBE aggregation would generate the following result set:
* Total sales for each region
* Total sales for each city
* Total sales for each region and city combination
* Grand total sales across all regions and cities
**Key differences from traditional GROUP BY clauses:**
1. **Multiple grouping sets:** ROLLUP and CUBE allow for multiple grouping sets in a single query, whereas traditional GROUP BY clauses require separate queries for each grouping set.
2. **Hierarchical structure:** ROLLUP creates a hierarchical structure, while CUBE produces a flat result set.
3. **Aggregated values:** ROLLUP and CUBE provide aggregated values for each grouping set, whereas traditional GROUP BY clauses require explicit aggregation functions (e. g. , SUM, AVG) for each column.
**Common use cases for ROLLUP and CUBE:**
1. **Data analysis:** Use ROLLUP and CUBE to analyze data across multiple dimensions, such as sales by region, city, and product.
2. **Reporting:** Generate reports with aggregated values for multiple groupings, such as customer demographics, sales, and product categories.
3. **Data visualization:** Use ROLLUP and CUBE to create interactive dashboards with drill-down capabilities for complex data analysis.
4. **Machine learning:** Prepare data for machine learning models by generating aggregated features from large datasets.
By 2033, data aggregation will have evolved to seamlessly integrate these advanced techniques, enabling users to effortlessly combine and analyze complex data from diverse sources, driving unprecedented insights and decision-making capabilities.
"The customer support is top-notch. They were very helpful in answering my questions and setting me up for success."
**Synopsis:**
Our client, a leading e-commerce company, had a large dataset of customer transactions and wanted to analyze the sales trends across different regions, product categories, and time periods. They needed a scalable and efficient way to aggregate their data, generating reports that would provide insights into customer behavior and sales performance. Our team was engaged to implement data aggregation using ROLLUP and CUBE in BigQuery, enabling more complex data summarization and addressing the client′s requirements.
**Consulting Methodology:**
Our consulting methodology involved the following steps:
1. **Data Analysis**: We analyzed the client′s dataset, identifying the key variables and relationships between them.
2. **Aggregation Requirements**: We determined the aggregation requirements, including the types of reports and metrics needed to support the client′s business decisions.
3. **Data Modeling**: We designed a data model that optimized data aggregation using ROLLUP and CUBE in BigQuery.
4. **Implementation**: We implemented the data aggregation using BigQuery′s ROLLUP and CUBE functions.
5. **Testing and Validation**: We tested and validated the results to ensure accuracy and completeness.
6. **Deployment and Maintenance**: We deployed the solution and provided ongoing maintenance and support.
**Deliverables:**
* A scalable data aggregation framework using ROLLUP and CUBE in BigQuery
* A set of reports and metrics that provide insights into customer behavior and sales performance
* A data model optimized for data aggregation and analysis
**Implementation Challenges:**
* Handling large datasets and optimizing query performance
* Managing data complexity and ensuring data quality
* Integrating with existing data pipelines and systems
**KPIs:**
* **Query Performance**: Average query time reduced by 30% due to optimized data aggregation
* **Data Coverage**: 95% of required reports and metrics generated using ROLLUP and CUBE
* **User Adoption**: 80% of business users reported increased satisfaction with reporting and analytics capabilities
**Purpose of ROLLUP and CUBE Aggregations:**
ROLLUP and CUBE are advanced aggregation functions in BigQuery that enable more complex data summarization by generating multiple groupings and aggregations in a single query. ROLLUP generates a hierarchical aggregation, whereas CUBE generates a cross-tabulation of all possible combinations of groupings (Kimball, 2013).
**Differences from Traditional GROUP BY Clauses:**
ROLLUP and CUBE aggregations differ from traditional GROUP BY clauses in the following ways:
* **Multiple Groupings**: ROLLUP and CUBE can generate multiple groupings and aggregations in a single query, whereas GROUP BY requires a separate query for each grouping.
* **Hierarchical Aggregation**: ROLLUP generates a hierarchical aggregation, whereas GROUP BY requires a flat aggregation.
* **Cross-Tabulation**: CUBE generates a cross-tabulation of all possible combinations of groupings, whereas GROUP BY requires a separate query for each combination.
**Common Use Cases:**
1. **Sales Analysis**: Analyze sales trends across different regions, product categories, and time periods.
2. **Customer Segmentation**: Segment customers based on demographics, behavior, and preferences.
3. **Product Performance**: Analyze product performance across different channels, regions, and time periods.
**Citations:**
* Kimball, R. (2013). Data Warehousing Toolkit: The Definitive Guide to Dimensional Modeling. John Wiley u0026 Sons.
* Inmon, W. H., u0026 Kelley, K. (2011). ROLLUP and CUBE: A Guide to Data Aggregation. Information Management Magazine.
* BigQuery Documentation. (n.d.). ROLLUP and CUBE Aggregations. Retrieved from u003chttps://cloud.google.com/bigquery/docs/reference/stdsql/aggregate-functions#rollup_and_cube_aggregationsu003e
**Market Research Reports:**
* Gartner (2020). Magic Quadrant for Cloud Database Management Systems.
* Forrester (2020). The Future of Database Management Systems.
This case study demonstrates the effectiveness of using ROLLUP and CUBE aggregations in BigQuery to enable more complex data summarization and address the client′s business requirements. By optimizing data aggregation, we improved query performance, data coverage, and user adoption, ultimately driving business value and insights.
Are you tired of spending countless hours sifting through endless amounts of data? Do you struggle to get accurate and timely results? Look no further because our comprehensive dataset has the solution you′ve been searching for.
Containing 1510 prioritized requirements, solutions, benefits, results, and example case studies/use cases, our Data Aggregation and Google BigQuery Knowledge Base has everything you need to make informed decisions and achieve your desired outcomes.
And the best part? It′s user-friendly and designed to provide results based on both urgency and scope - saving you valuable time and effort.
Why choose our dataset over competitors and alternatives? Our expertly curated content is specifically tailored for professionals in need of efficient data analysis.
Whether you′re a small business or a large corporation, our product is suitable for all.
It′s designed to be used by anyone, so you don′t have to break the bank hiring expensive analysts.
With our DIY/affordable product alternative, you can access reliable information at your fingertips.
But that′s not all.
Our dataset provides a detailed and comprehensive overview of Data Aggregation and Google BigQuery, ensuring that you have a complete understanding of the product and its specifications.
You can compare it with semi-related products and see for yourself the benefits of choosing ours.
Don′t just take our word for it - our dataset has been carefully researched and compiled, utilizing the latest industry trends and best practices.
This means you can trust in the accuracy and reliability of our information, giving you peace of mind and confidence in your decision-making process.
Our Data Aggregation and Google BigQuery Knowledge Base is not just for businesses - it′s for anyone who wants to harness the full potential of their data.
And with its affordable cost, the return on investment is unmatched.
Our dataset simplifies the process and eliminates any guesswork, saving you time, effort, and money.
So, what does our dataset do exactly? It streamlines the data aggregation and analysis process, providing you with quick and accurate results.
It enables you to make data-driven decisions and unlock insights that can improve your business strategy.
In short, it revolutionizes the way you handle data.
Don′t miss out on this opportunity to enhance your data capabilities and stay ahead of the competition.
Invest in our Data Aggregation and Google BigQuery Knowledge Base today and see the difference it can make for your business.
With its numerous benefits and comprehensive features, it′s a must-have tool for any data-driven professional.
Discover Insights, Make Informed Decisions, and Stay Ahead of the Curve:
Key Features:
Comprehensive set of 1510 prioritized Data Aggregation requirements. - Extensive coverage of 86 Data Aggregation topic scopes.
- In-depth analysis of 86 Data Aggregation step-by-step solutions, benefits, BHAGs.
- Detailed examination of 86 Data Aggregation case studies and use cases.
- Digital download upon purchase.
- Enjoy lifetime document updates included with your purchase.
- Benefit from a fully editable and customizable Excel format.
- Trusted and utilized by over 10,000 organizations.
- Covering: Data Pipelines, Data Governance, Data Warehousing, Cloud Based, Cost Estimation, Data Masking, Data API, Data Refining, BigQuery Insights, BigQuery Projects, BigQuery Services, Data Federation, Data Quality, Real Time Data, Disaster Recovery, Data Science, Cloud Storage, Big Data Analytics, BigQuery View, BigQuery Dataset, Machine Learning, Data Mining, BigQuery API, BigQuery Dashboard, BigQuery Cost, Data Processing, Data Grouping, Data Preprocessing, BigQuery Visualization, Scalable Solutions, Fast Data, High Availability, Data Aggregation, On Demand Pricing, Data Retention, BigQuery Design, Predictive Modeling, Data Visualization, Data Querying, Google BigQuery, Security Config, Data Backup, BigQuery Limitations, Performance Tuning, Data Transformation, Data Import, Data Validation, Data CLI, Data Lake, Usage Report, Data Compression, Business Intelligence, Access Control, Data Analytics, Query Optimization, Row Level Security, BigQuery Notification, Data Restore, BigQuery Analytics, Data Cleansing, BigQuery Functions, BigQuery Best Practice, Data Retrieval, BigQuery Solutions, Data Integration, BigQuery Table, BigQuery Explorer, Data Export, BigQuery SQL, Data Storytelling, BigQuery CLI, Data Storage, Real Time Analytics, Backup Recovery, Data Filtering, BigQuery Integration, Data Encryption, BigQuery Pattern, Data Sorting, Advanced Analytics, Data Ingest, BigQuery Reporting, BigQuery Architecture, Data Standardization, BigQuery Challenges, BigQuery UDF
Data Aggregation Assessment Dataset - Utilization, Solutions, Advantages, BHAG (Big Hairy Audacious Goal):
Data Aggregation
ROLLUP and CUBE aggregations in BigQuery enable complex data summarization by generating multiple groupings and aggregations in a single query.
Here are the solutions and their benefits in the context of Google BigQuery:
**ROLLUP Aggregation:**
* Purpose: Generates a result set that contains aggregated values for each grouping set specified.
* Benefit: Enables hierarchical aggregation and calculation of subtotals and grand totals.
**CUBE Aggregation:**
* Purpose: Computes the aggregate values for all possible combinations of columns in the GROUP BY clause.
* Benefit: Allows for fast and efficient computation of cross-tabulations and data cubes.
**Key differences from traditional GROUP BY clauses:**
* ROLLUP and CUBE generate more result rows than traditional GROUP BY.
* They enable hierarchical and cross-tabulation aggregations not possible with traditional GROUP BY.
**Common use cases:**
* Reporting and analytics: Use ROLLUP for hierarchical summaries and CUBE for cross-tabulations.
* Data warehousing: Use CUBE for fast and efficient computation of data cubes.
* Business intelligence: Use ROLLUP and CUBE to generate complex reports and summaries.
CONTROL QUESTION: What is the purpose of the ROLLUP and CUBE aggregations in BigQuery, and how do they enable more complex data summarization? How do these aggregations differ from traditional GROUP BY clauses, and what are some common use cases for using them?
Big Hairy Audacious Goal (BHAG) for 10 years from now: Here′s a Big Hairy Audacious Goal (BHAG) for Data Aggregation in 10 years:
**BHAG:** By 2033, data aggregation will be fully democratized, and anyone will be able to access, combine, and analyze complex data from diverse sources seamlessly, enabling unprecedented insights and decision-making capabilities.
**Purpose of ROLLUP and CUBE aggregations in BigQuery:**
In BigQuery, ROLLUP and CUBE aggregations are two advanced data summarization techniques that enable users to generate multiple groupings and aggregations of data in a single query. These aggregations are particularly useful when working with large datasets and complex data models.
**ROLLUP:**
The ROLLUP aggregation creates a result set that contains aggregated values for each group of rows, as well as aggregated values for each combination of grouping columns, creating a hierarchical structure. For example, if you have a table with columns `region`, `city`, and `sales`, a ROLLUP aggregation would generate the following result set:
* Total sales for each region
* Total sales for each city within each region
* Grand total sales across all regions and cities
**CUBE:**
The CUBE aggregation generates a result set that contains aggregated values for all possible combinations of grouping columns. Unlike ROLLUP, CUBE does not create a hierarchical structure; instead, it produces a flat result set with all possible combinations of grouping columns. Using the same example as above, a CUBE aggregation would generate the following result set:
* Total sales for each region
* Total sales for each city
* Total sales for each region and city combination
* Grand total sales across all regions and cities
**Key differences from traditional GROUP BY clauses:**
1. **Multiple grouping sets:** ROLLUP and CUBE allow for multiple grouping sets in a single query, whereas traditional GROUP BY clauses require separate queries for each grouping set.
2. **Hierarchical structure:** ROLLUP creates a hierarchical structure, while CUBE produces a flat result set.
3. **Aggregated values:** ROLLUP and CUBE provide aggregated values for each grouping set, whereas traditional GROUP BY clauses require explicit aggregation functions (e. g. , SUM, AVG) for each column.
**Common use cases for ROLLUP and CUBE:**
1. **Data analysis:** Use ROLLUP and CUBE to analyze data across multiple dimensions, such as sales by region, city, and product.
2. **Reporting:** Generate reports with aggregated values for multiple groupings, such as customer demographics, sales, and product categories.
3. **Data visualization:** Use ROLLUP and CUBE to create interactive dashboards with drill-down capabilities for complex data analysis.
4. **Machine learning:** Prepare data for machine learning models by generating aggregated features from large datasets.
By 2033, data aggregation will have evolved to seamlessly integrate these advanced techniques, enabling users to effortlessly combine and analyze complex data from diverse sources, driving unprecedented insights and decision-making capabilities.
Customer Testimonials:
"The customer support is top-notch. They were very helpful in answering my questions and setting me up for success."
"As a researcher, having access to this dataset has been a game-changer. The prioritized recommendations have streamlined my analysis, allowing me to focus on the most impactful strategies."
"This dataset has been a lifesaver for my research. The prioritized recommendations are clear and concise, making it easy to identify the most impactful actions. A must-have for anyone in the field!"
Data Aggregation Case Study/Use Case example - How to use:
**Case Study:** Data Aggregation with ROLLUP and CUBE in BigQuery**Synopsis:**
Our client, a leading e-commerce company, had a large dataset of customer transactions and wanted to analyze the sales trends across different regions, product categories, and time periods. They needed a scalable and efficient way to aggregate their data, generating reports that would provide insights into customer behavior and sales performance. Our team was engaged to implement data aggregation using ROLLUP and CUBE in BigQuery, enabling more complex data summarization and addressing the client′s requirements.
**Consulting Methodology:**
Our consulting methodology involved the following steps:
1. **Data Analysis**: We analyzed the client′s dataset, identifying the key variables and relationships between them.
2. **Aggregation Requirements**: We determined the aggregation requirements, including the types of reports and metrics needed to support the client′s business decisions.
3. **Data Modeling**: We designed a data model that optimized data aggregation using ROLLUP and CUBE in BigQuery.
4. **Implementation**: We implemented the data aggregation using BigQuery′s ROLLUP and CUBE functions.
5. **Testing and Validation**: We tested and validated the results to ensure accuracy and completeness.
6. **Deployment and Maintenance**: We deployed the solution and provided ongoing maintenance and support.
**Deliverables:**
* A scalable data aggregation framework using ROLLUP and CUBE in BigQuery
* A set of reports and metrics that provide insights into customer behavior and sales performance
* A data model optimized for data aggregation and analysis
**Implementation Challenges:**
* Handling large datasets and optimizing query performance
* Managing data complexity and ensuring data quality
* Integrating with existing data pipelines and systems
**KPIs:**
* **Query Performance**: Average query time reduced by 30% due to optimized data aggregation
* **Data Coverage**: 95% of required reports and metrics generated using ROLLUP and CUBE
* **User Adoption**: 80% of business users reported increased satisfaction with reporting and analytics capabilities
**Purpose of ROLLUP and CUBE Aggregations:**
ROLLUP and CUBE are advanced aggregation functions in BigQuery that enable more complex data summarization by generating multiple groupings and aggregations in a single query. ROLLUP generates a hierarchical aggregation, whereas CUBE generates a cross-tabulation of all possible combinations of groupings (Kimball, 2013).
**Differences from Traditional GROUP BY Clauses:**
ROLLUP and CUBE aggregations differ from traditional GROUP BY clauses in the following ways:
* **Multiple Groupings**: ROLLUP and CUBE can generate multiple groupings and aggregations in a single query, whereas GROUP BY requires a separate query for each grouping.
* **Hierarchical Aggregation**: ROLLUP generates a hierarchical aggregation, whereas GROUP BY requires a flat aggregation.
* **Cross-Tabulation**: CUBE generates a cross-tabulation of all possible combinations of groupings, whereas GROUP BY requires a separate query for each combination.
**Common Use Cases:**
1. **Sales Analysis**: Analyze sales trends across different regions, product categories, and time periods.
2. **Customer Segmentation**: Segment customers based on demographics, behavior, and preferences.
3. **Product Performance**: Analyze product performance across different channels, regions, and time periods.
**Citations:**
* Kimball, R. (2013). Data Warehousing Toolkit: The Definitive Guide to Dimensional Modeling. John Wiley u0026 Sons.
* Inmon, W. H., u0026 Kelley, K. (2011). ROLLUP and CUBE: A Guide to Data Aggregation. Information Management Magazine.
* BigQuery Documentation. (n.d.). ROLLUP and CUBE Aggregations. Retrieved from u003chttps://cloud.google.com/bigquery/docs/reference/stdsql/aggregate-functions#rollup_and_cube_aggregationsu003e
**Market Research Reports:**
* Gartner (2020). Magic Quadrant for Cloud Database Management Systems.
* Forrester (2020). The Future of Database Management Systems.
This case study demonstrates the effectiveness of using ROLLUP and CUBE aggregations in BigQuery to enable more complex data summarization and address the client′s business requirements. By optimizing data aggregation, we improved query performance, data coverage, and user adoption, ultimately driving business value and insights.
Security and Trust:
- Secure checkout with SSL encryption Visa, Mastercard, Apple Pay, Google Pay, Stripe, Paypal
- Money-back guarantee for 30 days
- Our team is available 24/7 to assist you - support@theartofservice.com
About the Authors: Unleashing Excellence: The Mastery of Service Accredited by the Scientific Community
Immerse yourself in the pinnacle of operational wisdom through The Art of Service`s Excellence, now distinguished with esteemed accreditation from the scientific community. With an impressive 1000+ citations, The Art of Service stands as a beacon of reliability and authority in the field.Our dedication to excellence is highlighted by meticulous scrutiny and validation from the scientific community, evidenced by the 1000+ citations spanning various disciplines. Each citation attests to the profound impact and scholarly recognition of The Art of Service`s contributions.
Embark on a journey of unparalleled expertise, fortified by a wealth of research and acknowledgment from scholars globally. Join the community that not only recognizes but endorses the brilliance encapsulated in The Art of Service`s Excellence. Enhance your understanding, strategy, and implementation with a resource acknowledged and embraced by the scientific community.
Embrace excellence. Embrace The Art of Service.
Your trust in us aligns you with prestigious company; boasting over 1000 academic citations, our work ranks in the top 1% of the most cited globally. Explore our scholarly contributions at: https://scholar.google.com/scholar?hl=en&as_sdt=0%2C5&q=blokdyk
About The Art of Service:
Our clients seek confidence in making risk management and compliance decisions based on accurate data. However, navigating compliance can be complex, and sometimes, the unknowns are even more challenging.
We empathize with the frustrations of senior executives and business owners after decades in the industry. That`s why The Art of Service has developed Self-Assessment and implementation tools, trusted by over 100,000 professionals worldwide, empowering you to take control of your compliance assessments. With over 1000 academic citations, our work stands in the top 1% of the most cited globally, reflecting our commitment to helping businesses thrive.
Founders:
Gerard Blokdyk
LinkedIn: https://www.linkedin.com/in/gerardblokdijk/
Ivanka Menken
LinkedIn: https://www.linkedin.com/in/ivankamenken/
