{"id":2314,"date":"2019-09-15T11:09:13","date_gmt":"2019-09-15T11:09:13","guid":{"rendered":"https:\/\/customlytics.com\/how-to-avoid-pitfalls-working-with-your-data-warehouse\/"},"modified":"2021-11-26T14:17:36","modified_gmt":"2021-11-26T14:17:36","slug":"how-to-avoid-pitfalls-working-with-your-data-warehouse","status":"publish","type":"post","link":"https:\/\/customlytics.com\/de\/how-to-avoid-pitfalls-working-with-your-data-warehouse\/","title":{"rendered":"How to avoid pitfalls working with your data warehouse"},"content":{"rendered":"\n<div class=\"wp-block-media-text alignwide is-stacked-on-mobile\" style=\"grid-template-columns:23% auto\"><figure class=\"wp-block-media-text__media\"><img fetchpriority=\"high\" decoding=\"async\" width=\"250\" height=\"250\" src=\"https:\/\/customlytics.com\/wp-content\/uploads\/2019\/06\/martin-circle.png\" alt=\"\" class=\"wp-image-3448 size-full\" srcset=\"https:\/\/customlytics.com\/wp-content\/uploads\/2019\/06\/martin-circle.png 250w, https:\/\/customlytics.com\/wp-content\/uploads\/2019\/06\/martin-circle-150x150.png 150w\" sizes=\"(max-width: 250px) 100vw, 250px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<h3 class=\"wp-block-heading\">Martin Schneider&#13;\n\u2013 Big Data Engineer at Customlytics<\/h3>\n<\/div><\/div>\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n<p class=\"wp-block-paragraph\">In the third and last part of the Customlytics data warehouse series, I like to finally talk about the daily routines of managing a data warehouse. Previously to this article,\u00a0<a href=\"https:\/\/customlytics.com\/de\/the-why-when-how-and-whom-of-data-warehousing\/\">we encouraged you why to invest in a data warehouse<\/a>, and\u00a0<a href=\"https:\/\/customlytics.com\/de\/should-you-invest-in-a-data-warehouse\/\">we investigated the architecture of a data warehouse<\/a>. In case you haven\u2019t, we recommend to take the time and read the previous articles before continuing.<\/p>\n\n<h2 class=\"wp-block-heading\">General aspects to consider when managing a data warehouse<\/h2>\n\n<p class=\"wp-block-paragraph\">Once you have set up the data warehouse and the data is coming in steadily, what are the aspects you should take care of? Here is a list of essential details that I think are crucial, and which will be put into perspective in the following.<\/p>\n\n<ul class=\"wp-block-list\"><li>Monitoring \u2013 Enables you to inspect system performance and quickly spot if things are breaking down.<\/li><li>Business Intelligence (BI) tool \u2013 make the collected data accessible and visible for everyone.<\/li><li>Documentation \u2013 As part of good data governance, we suggest that you document your data warehousing.<\/li><li>Integration of new data sources \u2013 think about how to integrate new data sources with minimal effort.<\/li><li>Data discovery \u2013 with the increasing number of data sources and tables it becomes harder for everyone to find the right dataset for the right purpose so having the right tools in place is important.<\/li><\/ul>\n\n<p class=\"wp-block-paragraph\">Now, let\u2019s put these aspects in order and perspective by digging deeper into the means of maintaining your data warehouse.<\/p>\n\n<h2 class=\"wp-block-heading\">Daily routines of managing a BI tool<\/h2>\n\n<p class=\"wp-block-paragraph\">Often, the decision\u00a0<strong>which BI tool to use<\/strong>\u00a0in order to visualize data, dashboards, and reporting has already been taken alongside the decision to actually build a data warehouse. Most definitely someone on the team has gained experience with some of the BI software that is out there in the market and can recommend a tool according to features and price model.<\/p>\n\n<p class=\"wp-block-paragraph\">So what aspects do you have to take into consideration on a daily basis for a BI tool?<\/p>\n\n<p class=\"wp-block-paragraph\">First of all,\u00a0<strong>user and user rights management<\/strong>. This means granting users access to the BI tool and making sure they have the correct rights according to their role in the company. Stakeholders in your company want to get the data and insights according to their needs. For instance, finance needs to see different dashboards as opposed to the sales department.<\/p>\n\n<p class=\"wp-block-paragraph\">Secondly, depending on if you decided to go with an on-premise solution, regular updates have to be performed. Choosing a cloud solution for your Business Intelligence, however, saves you a lot of time and hassle because you don\u2019t have to take care of updates.<\/p>\n\n<h2 class=\"wp-block-heading\">Documentation is the foundation<\/h2>\n\n<p class=\"wp-block-paragraph\"><strong>The documentation<\/strong>\u00a0is something you should start along with the creation of your data warehouse and should encompass design decisions, a technical description, database schemas and a description of all data processing pipelines. The document should include description and imagery at varying levels of detail for different types of teams and stakeholders. The main goal of good documentation is to ensure that everyone is headed in the same direction. Detailed documentation is necessary for colleagues working on or with the data warehouse. Whereas a more abstract form of documentation can be provided for other stakeholders in the company and presentations. But documentation is worthless if it isn\u2019t kept up to date. So yes do it, it will save you a lot of trouble and time.<\/p>\n\n<p class=\"wp-block-paragraph\">The next point I like to mention is\u00a0<strong>monitoring<\/strong>. It needs to be done or otherwise, you realize at some point no data has been ingested. This can be very crucial for your business and money will be lost. That\u2019s why keeping a close eye is important. This brings me to the point of what should be monitored:<\/p>\n\n<ul class=\"wp-block-list\"><li>all data imports (batch or real-time ingest) (i.e. API or server errors)<\/li><li>data processing job(s) (i.e. failed scheduled queries)<\/li><li>velocity and volume of the data.<\/li><\/ul>\n\n<p class=\"wp-block-paragraph\">If you use\u00a0<a href=\"https:\/\/cloud.google.com\/\">Google Cloud Platform<\/a>\u00a0you can utilize\u00a0<a href=\"https:\/\/cloud.google.com\/stackdriver\/\">Stackdriver<\/a>\u00a0or check the email notification checkbox while setting up\u00a0<a href=\"https:\/\/cloud.google.com\/pubsub\/\">Pub\/Sub<\/a>\u00a0or a scheduled query in\u00a0<a href=\"https:\/\/cloud.google.com\/bigquery\/\">BigQuery<\/a>.<\/p>\n\n<p class=\"wp-block-paragraph\">But sometimes\u00a0<strong>not an error indicates that something is going wrong<\/strong>. Sometimes<strong>\u00a0a drastic change in the amount of data you receive is already indicating a problem<\/strong>\u00a0and requires you to take action. Consider the following example: a change was applied to an API you use and afterwards the amount of data drops, which might be a sign that you don\u2019t receive the full data. So make sure the amount of ingested data is also monitored.<\/p>\n\n<p class=\"wp-block-paragraph\">A situation you will encounter and should plan ahead is to i<strong>ntegrate an additional data source<\/strong>. So what could be done to make the process easier?<\/p>\n\n<p class=\"wp-block-paragraph\">Make a list of all the tables you plan to create or change. This list will serve you as a checklist for the Q&amp;A part and updating the documentation. So don\u2019t miss anything.<\/p>\n\n<p class=\"wp-block-paragraph\">Also, spend some time to think about how to orchestrate the new data import to the existing one. There could be some constraints (timewise) from the tables and their data sources you plan to change.<\/p>\n\n<p class=\"wp-block-paragraph\">I would recommend making a staged deployment. First, deploy the new data import and make sure it works. Afterwards, start to change the data pipeline. At last, don\u2019t forget to keep the documentation up to date.<\/p>\n\n<p class=\"wp-block-paragraph\">Last but not least I want to talk about\u00a0<strong>data discovery<\/strong>, which will become an issue the longer the data warehouse exists and the more first and third-party data sources are added.<\/p>\n\n<p class=\"wp-block-paragraph\">Examples for first-party data are Facebook or Google Adwords and a third party example is the\u00a0<a href=\"https:\/\/www.maxmind.com\/en\/geoip2-databases\">MaxMinds IP2Geo<\/a>\u00a0database, which maps IPs to geolocation.<\/p>\n\n<p class=\"wp-block-paragraph\">If you have a well-documented data warehouse you are halfway through it. The information provided in your data<em>b<\/em>ase just needs to be accessible to everyone in a way that they can find the right dataset for the question, they are looking to answer.<\/p>\n\n<h2 class=\"wp-block-heading\">Summary<\/h2>\n\n<p class=\"wp-block-paragraph\">Let\u2019s recap at the end and summaries it. With having built a data warehouse the work isn\u2019t done. The biggest part is about to come, maintaining the data warehouse. Documentation is important and shouldn\u2019t be neglected because it serves as a starting point for other tasks (like data discovery or integrating additional data sources).<\/p>\n\n<p class=\"wp-block-paragraph\">Making the move to a data warehouse strategy? We here at Customlytics cover all app marketing and analytics topics. We\u2019re here to help if you need actionable tips for your data warehousing strategy. Drop us a line via email\u00a0<a href=\"http:\/\/info@customlytics.com.\/\">info@customlytics.com.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the third and last part of the Customlytics data warehouse series, I like to finally talk about the daily routines of managing a data warehouse<\/p>\n","protected":false},"author":1,"featured_media":1010,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"0","ocean_second_sidebar":"0","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"0","ocean_custom_header_template":"0","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"0","ocean_menu_typo_font_family":"0","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"0","ocean_post_oembed":"","ocean_post_self_hosted_media":"","ocean_post_video_embed":"","ocean_link_format":"","ocean_link_format_target":"self","ocean_quote_format":"","ocean_quote_format_link":"post","ocean_gallery_link_images":"off","ocean_gallery_id":[],"footnotes":""},"categories":[74],"tags":[75,76],"class_list":["post-2314","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analytics-and-attribution-de","tag-bi-analytics-de","tag-data-warehousing-de","entry","has-media"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to avoid pitfalls working with your data warehouse &#8211; Customlytics<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/customlytics.com\/de\/how-to-avoid-pitfalls-working-with-your-data-warehouse\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to avoid pitfalls working with your data warehouse &#8211; Customlytics\" \/>\n<meta property=\"og:description\" content=\"In the third and last part of the Customlytics data warehouse series, I like to finally talk about the daily routines of managing a data warehouse\" \/>\n<meta property=\"og:url\" content=\"https:\/\/customlytics.com\/de\/how-to-avoid-pitfalls-working-with-your-data-warehouse\/\" \/>\n<meta property=\"og:site_name\" content=\"Customlytics\" \/>\n<meta property=\"article:published_time\" content=\"2019-09-15T11:09:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-26T14:17:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/customlytics.com\/wp-content\/uploads\/2020\/01\/data-warehousign-pitfaills.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2400\" \/>\n\t<meta property=\"og:image:height\" content=\"1254\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"5\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/customlytics.com\\\/de\\\/how-to-avoid-pitfalls-working-with-your-data-warehouse\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/customlytics.com\\\/de\\\/how-to-avoid-pitfalls-working-with-your-data-warehouse\\\/\"},\"author\":{\"name\":\"Admin\",\"@id\":\"https:\\\/\\\/customlytics.com\\\/de\\\/#\\\/schema\\\/person\\\/35c3b00d77171b55d0567e8c73671d99\"},\"headline\":\"How to avoid pitfalls working with your data warehouse\",\"datePublished\":\"2019-09-15T11:09:13+00:00\",\"dateModified\":\"2021-11-26T14:17:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/customlytics.com\\\/de\\\/how-to-avoid-pitfalls-working-with-your-data-warehouse\\\/\"},\"wordCount\":1101,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/customlytics.com\\\/de\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/customlytics.com\\\/de\\\/how-to-avoid-pitfalls-working-with-your-data-warehouse\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/customlytics.com\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/data-warehousign-pitfaills.jpg\",\"keywords\":[\"BI &amp; ANALYTICS\",\"DATA WAREHOUSING\"],\"articleSection\":[\"ANALYTICS &amp; ATTRIBUTION\"],\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/customlytics.com\\\/de\\\/how-to-avoid-pitfalls-working-with-your-data-warehouse\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/customlytics.com\\\/de\\\/how-to-avoid-pitfalls-working-with-your-data-warehouse\\\/\",\"url\":\"https:\\\/\\\/customlytics.com\\\/de\\\/how-to-avoid-pitfalls-working-with-your-data-warehouse\\\/\",\"name\":\"How to avoid pitfalls working with your data warehouse &#8211; Customlytics\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/customlytics.com\\\/de\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/customlytics.com\\\/de\\\/how-to-avoid-pitfalls-working-with-your-data-warehouse\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/customlytics.com\\\/de\\\/how-to-avoid-pitfalls-working-with-your-data-warehouse\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/customlytics.com\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/data-warehousign-pitfaills.jpg\",\"datePublished\":\"2019-09-15T11:09:13+00:00\",\"dateModified\":\"2021-11-26T14:17:36+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/customlytics.com\\\/de\\\/how-to-avoid-pitfalls-working-with-your-data-warehouse\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/customlytics.com\\\/de\\\/how-to-avoid-pitfalls-working-with-your-data-warehouse\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/customlytics.com\\\/de\\\/how-to-avoid-pitfalls-working-with-your-data-warehouse\\\/#primaryimage\",\"url\":\"https:\\\/\\\/customlytics.com\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/data-warehousign-pitfaills.jpg\",\"contentUrl\":\"https:\\\/\\\/customlytics.com\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/data-warehousign-pitfaills.jpg\",\"width\":2400,\"height\":1254,\"caption\":\"Data warehouse managing\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/customlytics.com\\\/de\\\/how-to-avoid-pitfalls-working-with-your-data-warehouse\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/customlytics.com\\\/de\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to avoid pitfalls working with your data warehouse\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/customlytics.com\\\/de\\\/#website\",\"url\":\"https:\\\/\\\/customlytics.com\\\/de\\\/\",\"name\":\"Customlytics\",\"description\":\"Full-Service App Marketing Agency &amp; Consultancy\",\"publisher\":{\"@id\":\"https:\\\/\\\/customlytics.com\\\/de\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/customlytics.com\\\/de\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/customlytics.com\\\/de\\\/#organization\",\"name\":\"Customlytics\",\"url\":\"https:\\\/\\\/customlytics.com\\\/de\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/customlytics.com\\\/de\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/customlytics.com\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/primary-logo-C.png\",\"contentUrl\":\"https:\\\/\\\/customlytics.com\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/primary-logo-C.png\",\"width\":3751,\"height\":918,\"caption\":\"Customlytics\"},\"image\":{\"@id\":\"https:\\\/\\\/customlytics.com\\\/de\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/customlytics.com\\\/de\\\/#\\\/schema\\\/person\\\/35c3b00d77171b55d0567e8c73671d99\",\"name\":\"Admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ffc3ba99a5ef59ac0a11d845d504dafe77a10a5c60c8996f106a47e28de102f2?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ffc3ba99a5ef59ac0a11d845d504dafe77a10a5c60c8996f106a47e28de102f2?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ffc3ba99a5ef59ac0a11d845d504dafe77a10a5c60c8996f106a47e28de102f2?s=96&d=mm&r=g\",\"caption\":\"Admin\"},\"url\":\"https:\\\/\\\/customlytics.com\\\/de\\\/author\\\/admin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to avoid pitfalls working with your data warehouse &#8211; Customlytics","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/customlytics.com\/de\/how-to-avoid-pitfalls-working-with-your-data-warehouse\/","og_locale":"de_DE","og_type":"article","og_title":"How to avoid pitfalls working with your data warehouse &#8211; Customlytics","og_description":"In the third and last part of the Customlytics data warehouse series, I like to finally talk about the daily routines of managing a data warehouse","og_url":"https:\/\/customlytics.com\/de\/how-to-avoid-pitfalls-working-with-your-data-warehouse\/","og_site_name":"Customlytics","article_published_time":"2019-09-15T11:09:13+00:00","article_modified_time":"2021-11-26T14:17:36+00:00","og_image":[{"width":2400,"height":1254,"url":"https:\/\/customlytics.com\/wp-content\/uploads\/2020\/01\/data-warehousign-pitfaills.jpg","type":"image\/jpeg"}],"author":"Admin","twitter_card":"summary_large_image","twitter_misc":{"Verfasst von":"Admin","Gesch\u00e4tzte Lesezeit":"5\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/customlytics.com\/de\/how-to-avoid-pitfalls-working-with-your-data-warehouse\/#article","isPartOf":{"@id":"https:\/\/customlytics.com\/de\/how-to-avoid-pitfalls-working-with-your-data-warehouse\/"},"author":{"name":"Admin","@id":"https:\/\/customlytics.com\/de\/#\/schema\/person\/35c3b00d77171b55d0567e8c73671d99"},"headline":"How to avoid pitfalls working with your data warehouse","datePublished":"2019-09-15T11:09:13+00:00","dateModified":"2021-11-26T14:17:36+00:00","mainEntityOfPage":{"@id":"https:\/\/customlytics.com\/de\/how-to-avoid-pitfalls-working-with-your-data-warehouse\/"},"wordCount":1101,"commentCount":0,"publisher":{"@id":"https:\/\/customlytics.com\/de\/#organization"},"image":{"@id":"https:\/\/customlytics.com\/de\/how-to-avoid-pitfalls-working-with-your-data-warehouse\/#primaryimage"},"thumbnailUrl":"https:\/\/customlytics.com\/wp-content\/uploads\/2020\/01\/data-warehousign-pitfaills.jpg","keywords":["BI &amp; ANALYTICS","DATA WAREHOUSING"],"articleSection":["ANALYTICS &amp; ATTRIBUTION"],"inLanguage":"de","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/customlytics.com\/de\/how-to-avoid-pitfalls-working-with-your-data-warehouse\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/customlytics.com\/de\/how-to-avoid-pitfalls-working-with-your-data-warehouse\/","url":"https:\/\/customlytics.com\/de\/how-to-avoid-pitfalls-working-with-your-data-warehouse\/","name":"How to avoid pitfalls working with your data warehouse &#8211; Customlytics","isPartOf":{"@id":"https:\/\/customlytics.com\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/customlytics.com\/de\/how-to-avoid-pitfalls-working-with-your-data-warehouse\/#primaryimage"},"image":{"@id":"https:\/\/customlytics.com\/de\/how-to-avoid-pitfalls-working-with-your-data-warehouse\/#primaryimage"},"thumbnailUrl":"https:\/\/customlytics.com\/wp-content\/uploads\/2020\/01\/data-warehousign-pitfaills.jpg","datePublished":"2019-09-15T11:09:13+00:00","dateModified":"2021-11-26T14:17:36+00:00","breadcrumb":{"@id":"https:\/\/customlytics.com\/de\/how-to-avoid-pitfalls-working-with-your-data-warehouse\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/customlytics.com\/de\/how-to-avoid-pitfalls-working-with-your-data-warehouse\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/customlytics.com\/de\/how-to-avoid-pitfalls-working-with-your-data-warehouse\/#primaryimage","url":"https:\/\/customlytics.com\/wp-content\/uploads\/2020\/01\/data-warehousign-pitfaills.jpg","contentUrl":"https:\/\/customlytics.com\/wp-content\/uploads\/2020\/01\/data-warehousign-pitfaills.jpg","width":2400,"height":1254,"caption":"Data warehouse managing"},{"@type":"BreadcrumbList","@id":"https:\/\/customlytics.com\/de\/how-to-avoid-pitfalls-working-with-your-data-warehouse\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/customlytics.com\/de\/"},{"@type":"ListItem","position":2,"name":"How to avoid pitfalls working with your data warehouse"}]},{"@type":"WebSite","@id":"https:\/\/customlytics.com\/de\/#website","url":"https:\/\/customlytics.com\/de\/","name":"Customlytics","description":"Full-Service App Marketing Agency &amp; Consultancy","publisher":{"@id":"https:\/\/customlytics.com\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/customlytics.com\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/customlytics.com\/de\/#organization","name":"Customlytics","url":"https:\/\/customlytics.com\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/customlytics.com\/de\/#\/schema\/logo\/image\/","url":"https:\/\/customlytics.com\/wp-content\/uploads\/2020\/01\/primary-logo-C.png","contentUrl":"https:\/\/customlytics.com\/wp-content\/uploads\/2020\/01\/primary-logo-C.png","width":3751,"height":918,"caption":"Customlytics"},"image":{"@id":"https:\/\/customlytics.com\/de\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/customlytics.com\/de\/#\/schema\/person\/35c3b00d77171b55d0567e8c73671d99","name":"Admin","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/secure.gravatar.com\/avatar\/ffc3ba99a5ef59ac0a11d845d504dafe77a10a5c60c8996f106a47e28de102f2?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ffc3ba99a5ef59ac0a11d845d504dafe77a10a5c60c8996f106a47e28de102f2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ffc3ba99a5ef59ac0a11d845d504dafe77a10a5c60c8996f106a47e28de102f2?s=96&d=mm&r=g","caption":"Admin"},"url":"https:\/\/customlytics.com\/de\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/customlytics.com\/de\/wp-json\/wp\/v2\/posts\/2314","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/customlytics.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/customlytics.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/customlytics.com\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/customlytics.com\/de\/wp-json\/wp\/v2\/comments?post=2314"}],"version-history":[{"count":5,"href":"https:\/\/customlytics.com\/de\/wp-json\/wp\/v2\/posts\/2314\/revisions"}],"predecessor-version":[{"id":10315,"href":"https:\/\/customlytics.com\/de\/wp-json\/wp\/v2\/posts\/2314\/revisions\/10315"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/customlytics.com\/de\/wp-json\/wp\/v2\/media\/1010"}],"wp:attachment":[{"href":"https:\/\/customlytics.com\/de\/wp-json\/wp\/v2\/media?parent=2314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/customlytics.com\/de\/wp-json\/wp\/v2\/categories?post=2314"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/customlytics.com\/de\/wp-json\/wp\/v2\/tags?post=2314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}