Skip to main content
search
0
CartClose Cart
All Posts By

Building a scalable Data Platform?

Whether you're implementing Data Vault 2.1 or modernizing your analytics architecture, our experts help you turn complex data challenges into practical, future-proof solutions. From hands-on implementation to in-depth training, we support your team every step of the way.

In Data Vault Friday

Natural Key vs. Technical ID in Data Vault

Watch the Video

In our continuous exploration of Data Vault concepts during the Data Vault Friday series, our CEO, Michael Olschimke, takes on a thought-provoking question from a member of our audience regarding natural keys.

“Can a work order ID or recommendation ID be considered a natural business key even though there is no business ‘meaning’ to these ids? or should I use the text description of the recommendation as the business key? The work order would have to be a composite key made up of details and a date for the work order which at that point seems like just using the ID makes more sense.”

Michael addresses the nuanced concept of Natural Key and Technical ID in the context of work order and recommendation IDs. The discussion provides valuable insights into making informed decisions about choosing business keys in scenarios where the identifiers lack inherent business meaning.

Meet the Speaker

Profile picture of Michael Olschimke

Michael Olschimke

Michael has more than 15 years of experience in Information Technology. During the last eight years he has specialized in Business Intelligence topics such as OLAP, Dimensional Modelling, and Data Mining. Challenge him with your questions!

In Beginner, Salesforce

Snackable Data Insights: Analytics Meets Salesforce Data Cloud

Watch the Webinar

Snackable Data Insights: Analytics Meets Salesforce Data Cloud

What are we going to do with all that data? Something you might ask yourself when you are checking the current size of your data lake or data warehouse.

In our webinar, we will explore together how we can make use of our data residing in Snowflake using Salesforce Data Cloud or Tableau. Extract value from your data now!

Join us to learn more about the newest analytics tools inside the Salesforce ecosystem and how you can use them in your data architecture.

Watch Webinar Recording

Webinar Agenda

1. Recap DDL ’23
2. Ask the Right Questions
3. Issues
4. (New) Tools

Meet the Speaker

Picture of Markus Lewandowski

Markus Lewandowski

Markus Lewandowski is a Consultant at Scalefree, who has over 6 Years experience in Salesforce development and administration. While also being a Certified Data Vault 2.0 Practitioner (CDVP2™) he is taking a hybrid role as a Salesforce Specialist and DV 2.0 Practitioner. His main competences are Salesforce Process Automation, Application Integration and Data Management.

In Data Vault Friday

HL7 FHIR resources in Data Vault

Watch the Video

In our continuous exploration of Data Vault concepts during the Data Vault Friday series, our CEO, Michael Olschimke, takes on a compelling question posed by a member of our audience.

“How would you model data that is transmitted as HL7 FHIR resources in Data Vault?”

Michael delves into the intricacies of handling HL7 FHIR resources within the Data Vault framework. This session is a valuable resource for those seeking insights into the effective modeling of healthcare data encoded in HL7 FHIR resources.

Meet the Speaker

Profile picture of Michael Olschimke

Michael Olschimke

Michael has more than 15 years of experience in Information Technology. During the last eight years he has specialized in Business Intelligence topics such as OLAP, Dimensional Modelling, and Data Mining. Challenge him with your questions!

In Data Vault Friday

Business Satellites in Data Vault

Watch the Video

In the latest segment of our Data Vault Friday series, our esteemed CEO, Michael Olschimke, delves into a question brought forward by a member of our audience.

“What are business satellites?”

Michael passionately explores the concept of business satellites in a dedicated session, offering in-depth insights and valuable perspectives on their significance within the Data Vault methodology. This engaging discussion is geared towards enhancing your understanding of business satellites and their role in the broader context of Data Vault architecture.

Meet the Speaker

Profile picture of Michael Olschimke

Michael Olschimke

Michael has more than 15 years of experience in Information Technology. During the last eight years he has specialized in Business Intelligence topics such as OLAP, Dimensional Modelling, and Data Mining. Challenge him with your questions!

In Data Vault Friday

Data Vault Referential Integrity

Watch the Video

In the latest installment of our Data Vault Friday series, our accomplished Managing Consultant, Marc Finger, addresses a pertinent question posed by a member of our audience.

“How is referential integrity handled in DV 2.0?”

Marc provides comprehensive insights into the intricacies of maintaining referential integrity within the Data Vault 2.0 framework. He explores the nuances and best practices associated with ensuring a robust and reliable structure that upholds the integrity of relationships within the Data Vault architecture.

Meet the Speaker

Marc Winkelmann

Marc Finger

Marc is working in Business Intelligence and Enterprise Data Warehousing (EDW) with a focus on Data Vault 2.0 implementation and coaching. Since 2016 he is active in consulting and implementation of Data Vault 2.0 solutions with industry leaders in manufacturing, energy supply and facility management sector. In 2020 he became a Data Vault 2.0 Instructor for Scalefree.

In Data Vault Friday

Soft Deletes in Data Vault 2.0

Watch the Video

In the latest edition of our Data Vault Friday series, our knowledgeable BI Consultant, Lorenz Kindling, delves into a question posed by an audience member.

“Can you use soft deletes for GDPR or Security in Data Vault?”

Lorenz provides valuable insights into the application of soft deletes within the Data Vault framework, specifically addressing their potential role in achieving GDPR compliance and enhancing data security measures.

Meet the Speaker

Picture of Lorenz Kindling

Lorenz Kindling

Lorenz is working in Business Intelligence and Enterprise Data Warehousing (EDW) with a focus on data warehouse automation and Data Vault modeling. Since 2021, he has been advising renowned companies in various industries for Scalefree International. Prior to Scalefree, he also worked as a consultant in the field of data analytics. This allowed him to gain a comprehensive overview of data warehousing projects and common issues that arise.

In Data Vault Friday

Data Vault Modeling Styles

Watch the Video

As part of our engaging Data Vault Friday series, our CEO, Michael Olschimke, addresses a pertinent question raised by an audience member.

“What’s your view on other Data Vault philosophies? Some of my colleagues received training in such modeling styles, but the philosophy contains some substantial differences related to the CDVP2 certification.”

In this insightful video, Michael shares his perspectives on various Data Vault philosophies beyond the CDVP2 (Certified Data Vault Practitioner Level 2) certification. Drawing from his extensive experience and expertise, he navigates through the nuances of different modeling styles within the Data Vault framework.

Meet the Speaker

Profile picture of Michael Olschimke

Michael Olschimke

Michael has more than 15 years of experience in Information Technology. During the last eight years he has specialized in Business Intelligence topics such as OLAP, Dimensional Modelling, and Data Mining. Challenge him with your questions!

In Data Vault Friday

Point in Time vs. Record Source Tracking in Data Vault

Watch the Video

In the latest installment of our informative Data Vault Friday series, our CEO, Michael Olschimke, takes on a thought-provoking question posed by a member of our engaged audience.

“How are record source tracking satellites used in a Data Vault, and if it is not used in a project, then how can PIT tables come into play in tracking the customers or business keys? And if we are taking the PITs for tracking the keys, does this mean we should take the daily snapshots of the data?”

Michael intricately unpacks the nuances of utilizing record source tracking satellites within the context of Data Vault methodology. He provides valuable insights into the role of PIT (Point-in-Time) tables in effectively tracking customers or business keys, shedding light on their significance in scenarios where record source tracking satellites might not be employed.

Delving deeper into the intricacies, Michael elucidates whether the use of PIT tables necessitates the capture of daily snapshots of the data, offering a comprehensive perspective for data professionals seeking clarity on these vital aspects of data modeling.

Meet the Speaker

Profile picture of Michael Olschimke

Michael Olschimke

Michael has more than 15 years of experience in Information Technology. During the last eight years he has specialized in Business Intelligence topics such as OLAP, Dimensional Modelling, and Data Mining. Challenge him with your questions!

In Data Vault Friday

Timezone to Be Used for Timestamps in Data Vault

Watch the Video

As part of our engaging Data Vault Friday series, our distinguished CEO, Michael Olschimke, delves into a pertinent question posed by an inquisitive member of our audience.

“In DV2.0 it is advised to use the UTC zone. How to store income timestamps from incoming sources that are in other time zones (e.g. GMT)? E.g. in Azure SQL server.”

In addressing this query, Michael provides valuable insights into the best practices for handling timestamps, especially when dealing with diverse time zones within the Data Vault 2.0 methodology. Emphasizing the recommendation to utilize the UTC zone, he navigates through the considerations and strategies for storing incoming timestamps that originate from sources operating in different time zones, such as GMT.

This illuminating discussion serves as a testament to our commitment to fostering knowledge and expertise in the realm of data architecture, making our Data Vault Friday series a valuable resource for data professionals.

Meet the Speaker

Profile picture of Michael Olschimke

Michael Olschimke

Michael has more than 15 years of experience in Information Technology. During the last eight years he has specialized in Business Intelligence topics such as OLAP, Dimensional Modelling, and Data Mining. Challenge him with your questions!

In Data Vault Friday

Referencing Reference Tables in Data Vault

Watch the Video

In the ongoing journey of our Data Vault Friday series, our esteemed CEO, Michael Olschimke, delves into a thought-provoking question raised by a keen member of our audience.

“Is it possible to have an m:n link between two reference tables (country to currency)?”

In addressing this query, Michael navigates through the intricacies of data modeling, shedding light on the feasibility and implications of establishing an m:n (many-to-many) link between two reference tables, specifically in the context of countries and currencies.

By exploring the nuances of this scenario, Michael provides valuable insights into the challenges and considerations associated with creating such relationships in the Data Vault framework. This engagement exemplifies the essence of our Data Vault Friday series, where practical queries are met with informative discussions to enhance the understanding of data professionals.

Meet the Speaker

Profile picture of Michael Olschimke

Michael Olschimke

Michael has more than 15 years of experience in Information Technology. During the last eight years he has specialized in Business Intelligence topics such as OLAP, Dimensional Modelling, and Data Mining. Challenge him with your questions!

In Data Vault Friday

Hierarchical Link by Using an Example in Data Vault

Watch the Video

With this week’s episode of Data Vault Friday, our CEO, Michael Olschimke, turns his attention to an insightful question about the use of a Hierarchical Link:

“Can you please explain in detail the hierarchical link using an example (different from the Bill of Material one, please)?”

In response to this discerning inquiry, Michael embarks on a comprehensive exploration of the concept of hierarchical links within the Data Vault framework. Drawing upon his extensive expertise, he elucidates the intricacies of modeling hierarchical links by presenting a distinctive example, distinct from the conventional Bill of Material scenario.

Through this elucidation, Michael aims to demystify the complexities surrounding hierarchical links, providing the audience with a practical and nuanced understanding of their application in diverse contexts. His commitment to delivering insightful explanations reflects the ethos of our Data Vault Friday series, which strives to empower data professionals with valuable knowledge.

Meet the Speaker

Profile picture of Michael Olschimke

Michael Olschimke

Michael has more than 15 years of experience in Information Technology. During the last eight years he has specialized in Business Intelligence topics such as OLAP, Dimensional Modelling, and Data Mining. Challenge him with your questions!

In Data Vault Friday

Record Source for Links in Data Vault

Watch the Video

As part of our continuous Data Vault Friday series, our adept BI Consultant, Lorenz Kindling, delves into a thought-provoking question posed by a keen member of our audience.

“A Link refers to multiple Hubs, but we only have one Record_Source in the Link. Or the Link is loaded from more than one Source System. What do we use as a Record Source?”

In response to this intriguing query, Lorenz delves into the critical aspect of determining record sources for links within the Data Vault methodology. He shares insights into the best practices and considerations when dealing with scenarios where a Link is associated with multiple Hubs or loaded from various Source Systems.

Lorenz’s comprehensive analysis provides clarity on the nuanced decisions involved in selecting an appropriate Record Source, ensuring that the Data Vault model maintains accuracy and coherence. This discussion underscores Lorenz’s commitment to offering practical guidance to data professionals navigating the intricacies of link modeling.

Meet the Speaker

Picture of Lorenz Kindling

Lorenz Kindling

Lorenz is working in Business Intelligence and Enterprise Data Warehousing (EDW) with a focus on data warehouse automation and Data Vault modeling. Since 2021, he has been advising renowned companies in various industries for Scalefree International. Prior to Scalefree, he also worked as a consultant in the field of data analytics. This allowed him to gain a comprehensive overview of data warehousing projects and common issues that arise.

Close Menu