{"id":922,"date":"2023-08-04T13:38:22","date_gmt":"2023-08-04T13:38:22","guid":{"rendered":"https:\/\/bi-wooning.com\/data-modelling\/"},"modified":"2023-09-01T07:21:03","modified_gmt":"2023-09-01T07:21:03","slug":"data-modelling","status":"publish","type":"page","link":"https:\/\/bi-wooning.com\/en\/data-modelling\/","title":{"rendered":"Data modelling"},"content":{"rendered":"<p data-sourcepos=\"14:3-14:282\">Data models are essential for analytical purposes. A data warehouse (DWH) is used for storing historical data. This provides insights into trends over time from previous events and can be used to make predictions for the future.<\/p>\n<p data-sourcepos=\"16:3-16:200\">9 out of 10 times, a new data model results from reverse engineering. Data vault is often used for the backend because of its scalability, flexibility, and auditability and traceability.<\/p>\n<p data-sourcepos=\"18:3-18:231\">For the front-end, a Kimball model (dimensional or star schema) is the one of best solutions. A Kimball model is easy to understand and use, and it allows for efficient and accurate reporting.<\/p>\n<p data-sourcepos=\"20:3-20:236\">Initially, the backend data model is built, taking as much data as possible into account. In the front-end model, a selection is made of relevant data in a star schema, on which the reports are based.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data models are essential for analytical purposes. A data warehouse (DWH) is used for storing historical data. This provides insights into trends over time from previous events and can be used to make predictions for the future. 9 out of 10 times, a new data model results from reverse engineering. Data vault is often used [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":851,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"off","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"class_list":["post-922","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/bi-wooning.com\/en\/wp-json\/wp\/v2\/pages\/922","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bi-wooning.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bi-wooning.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bi-wooning.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bi-wooning.com\/en\/wp-json\/wp\/v2\/comments?post=922"}],"version-history":[{"count":1,"href":"https:\/\/bi-wooning.com\/en\/wp-json\/wp\/v2\/pages\/922\/revisions"}],"predecessor-version":[{"id":923,"href":"https:\/\/bi-wooning.com\/en\/wp-json\/wp\/v2\/pages\/922\/revisions\/923"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bi-wooning.com\/en\/wp-json\/wp\/v2\/media\/851"}],"wp:attachment":[{"href":"https:\/\/bi-wooning.com\/en\/wp-json\/wp\/v2\/media?parent=922"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}