markerMaatwerkoplossingen

markerBetrokken & direct

markerResultaatgericht

markerSamen voor de beste oplossing

BLOG
OceanBI

Afbeelding belemmeringen Business Intelligence overwinnen

De 4 grootste belemmeringen voor succes met Business Intelligence

Succes met Business Intelligence – We hebben Business Intelligence (BI) nodig om stuurinformatie voor onze organisaties te halen uit een groeiende hoeveelheid en continu veranderend aanbod van data (data integratie). Toch wordt BI en data integratie waarschijnlijk door uw organisatie ook nog niet effectief benut. Waar ligt dat aan? Hieronder beschrijf ik de vier grootste […]

Afbeelding medewerkers OceanBI

Wat is Data Management?

Data management wordt onmisbaar voor de bedrijfsvoering van organisaties. Het besef dat het op slimme wijze gebruiken van data organisaties een grotere omzet en klanttevredenheid brengt, efficiënter en succesvoller maakt neemt snel toe. Men wil data gedreven werken en slim Data Management is dan onmisbaar. Maar ‘wat is Data Management nou eigenlijk?’ Data en informatie […]

Afbeelding belemmeringen Business Intelligence overwinnen

DDM Studio voor SQL Server compatibel met SQL Server 2016

DDM Studio voor SQL Server, versie  4.0.2, is SQL Server 2016 compatibel en gecertificeerd (geldt ook voor SQL Server 2014). Zowel op de on-site versie als in de Azure omgeving zijn de tests succesvol uitgevoerd, de bestaande informatie modellen worden razendsnel geladen. Hierdoor kunnen alle DDM Studio klanten met minimale inspanningen de upgrade naar SQL […]

afbeelding Data Management Consultancy OceanBI

The Data Vault adventure – Business Vault

Author: Mesa Jajan What is a Business Vault? Introduction Previously several posts have been published about the Data Vault. But while having a closer look at the Data Vault and reading online discussions, the term ‘Business Vault’ catches the attention. A long journey has been conducted to have a clear definition of the Business Vault. […]

Afbeelding medewerkers OceanBI

The Datavault Adventure – Myths Busted and more

Author: René van Kooten The Datavault Adventure – Myths Busted and more Dan Linstedt published the principles of the Data Vault methodology in 5 articles in July 2002. In 2005, the Data Vault Data Warehouse Methodology arrived in The Netherlands: the first articles about Data Vault written by Dutch adaptors were published. The interest in […]

DVSK_Picture10_LinkProcessQueue.jpg|DVSK_Picture09_TRV.jpg|DVSK_Picture08_SAD.jpg|DVSK_Picture07_LoadedDVSK.jpg|DVSK_Picture06_Satellites.jpg|DVSK_Picture05_LinkFK.jpg|DVSK_Picture04_AfterInsertHub.jpg|DVSK_Picture03_InsertHub.jpg|DVSK_Picture02_OverviewODSobjects.jpg|DVSK_Picture01_ImportODS.jpg

The Data Vault Adventure – Building a Data Vault with DDM Studio (Surrogate Keys)

Author: René van Kooten Building a Data Vault with DDM Studio (Surrogate Keys) After a Data Vault has been modeled it is time to build the Data Vault with DDM Studio as also shown in this previous article. DDM Studio has been based on the principles of the Data Vault methodology described in the five […]

AdventureWorksDatavault.jpg

The Data Vault Adventure – Modeling the Adventureworks Data Vault

Author: René van Kooten Modeling the Adventureworks Data Vault Modeling the Data Vault Building a Data Vault starts with modeling the Data Vault based on an existing datamodel of a transactional source system. The result is an Entity Relationship Diagram (ERD), which consists of HUBs, LINKs and Satellites. But how to model the Data Vault? The […]

Data-Vault-model-1.jpg

The Data Vault Adventure – An introduction

Author: Mesa Jajan An introduction to Data Vault modeling What is Data Vault modeling? Data Vault is a method to model a database which is designed to provide long-term historical storage of data extracted from multiple operational systems. Apart from the modeling aspect, this method deals with issues such as auditing and tracing data from a […]

Huib Oudemast

DDM Studio 3 for Microsoft SQL Server

Reduce Costs and Deliver Faster Results Authors:                  Huib Oudemast, René van Kooten Published:              September 2012 7 Features of DDM Studio 3 for SQL Server that will Reduce Costs and Deliver Faster Results Summary: The difficult economic climate has created new priorities in the challenges that most organizations have to […]