{"id":26993,"date":"2021-02-08T15:34:11","date_gmt":"2021-02-08T14:34:11","guid":{"rendered":"https:\/\/www.beer-management.de\/data-analysis-for-logistics-system-planning\/"},"modified":"2023-04-29T11:47:46","modified_gmt":"2023-04-29T09:47:46","slug":"data-analysis-for-logistics-system-planning","status":"publish","type":"page","link":"https:\/\/www.beer-management.de\/en\/seminars-training-establishing-knowledge-and-skills\/data-analysis-for-logistics-system-planning\/","title":{"rendered":"Data analysis for warehouse planning"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Turn raw data into planning data<\/h2>\n\n<p>Any planning of an intralogistics system requires detailed data analysis to understand and define the requirements of the new system. For this purpose, extensive amounts of data are linked together and relevant information is derived as a basis for planning. The results of the data analysis are essential for communication with system providers, consultants, and own logistics staff and warehouse managers. Only with reliable results of a data analysis can a logistics system be planned. A good understanding of planning data and the ability to interpret it for deriving design criteria of the system to be planned are prerequisites for successful planning projects.<\/p>\n\n<p><strong>Abstract:<\/strong> This workshop teaches the essential techniques of data analysis and interpretation for planning automated and semi-automated intralogistics systems. Using raw data as a starting point, participants learn how to apply relevant analysis techniques to create a database that serves as a basis for planning, based on practical examples. The database is then used to draw initial conclusions for planning the intralogistics system.<\/p>\n\n<p><strong>Contents:<\/strong> Data sources for planning projects \u2022 Evaluation of data quality \u2022 Dealing with erroneous or inconsistent data \u2022 The role of client and consultant in data analysis \u2022 Tools and systems for analyzing and visualizing data \u2022 Types of data analysis \u2022 Performing data analysis with Python or MS Excel and PowerQuery or MS Access or SQL (depending on the IT landscape in your company and the client&#8217;s requirements) \u2022 Example of automated data analysis with Python \u2022 Interpreting the results and deriving the basis for planning<\/p>\n\n<p><strong>Target group: <\/strong>Sales engineers for logistics systems, sales managers for logistics systems, logistics consultants, project managers for logistics automation projects in industry and retail, junior data analysts. This workshop is perfect for onboarding planning engineers and data analysts, as well as for logistics automation companies that want to establish data analysis expertise in-house. <\/p>\n\n<p><strong>Technical Requirements:<\/strong> Participants should have a basic knowledge of Microsoft Excel and be familiar with essential warehouse operations processes and elements of warehouse automation. Basic knowledge of PowerQuery, MS Access and\/or SQL will be learned during the course.<\/p>\n\n<p><strong>Language:<\/strong> German or English<\/p>\n\n<p><strong>Duration: <\/strong>1 or 2 days<\/p>\n\n<p><strong>Methodology<\/strong>: Presentation and practical exercise (if possible based on current planning data from your projects)<\/p>\n\n<p><strong>Location:<\/strong> In-house workshop on your premises or in suitable conference hotels, alternatively online via video conferencing.<\/p>\n\n<p>The PDF flyer for the seminar can be <a href=\"https:\/\/www.beer-management.de\/download\/25120\/?tmstv=1676113420\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>downloaded here<\/strong><\/a>.<\/p>\n\n<p>Are you interested in this seminar? Get in touch with us by<a href=\"mailto:info@beer-management.de?subject=Interesse%20an%20Seminar%20%22Datenanalyse%20f%C3%BCr%20die%20Logistiksystemplanung%22\" target=\"_blank\" rel=\"noreferrer noopener\"><strong> e-mail!<\/strong><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Turn raw data into planning data Any planning of an intralogistics system requires detailed data analysis to understand and define the requirements of the new system. For this purpose, extensive amounts of data are linked together and relevant information is derived as a basis for planning. The results of the data analysis are essential for [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":27036,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-26993","page","type-page","status-publish","hentry","entry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Data analysis for warehouse planning - Dr. Beer Management &amp; Logistik<\/title>\n<meta name=\"description\" content=\"This workshop teaches the essential techniques of data analysis for planning automated intralogistics systems.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.beer-management.de\/en\/seminars-training-establishing-knowledge-and-skills\/data-analysis-for-logistics-system-planning\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data analysis for warehouse planning - Dr. Beer Management &amp; Logistik\" \/>\n<meta property=\"og:description\" content=\"This workshop teaches the essential techniques of data analysis for planning automated intralogistics systems.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.beer-management.de\/en\/seminars-training-establishing-knowledge-and-skills\/data-analysis-for-logistics-system-planning\/\" \/>\n<meta property=\"og:site_name\" content=\"Dr. Beer Management &amp; Logistik\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-29T09:47:46+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.beer-management.de\\\/en\\\/seminars-training-establishing-knowledge-and-skills\\\/data-analysis-for-logistics-system-planning\\\/\",\"url\":\"https:\\\/\\\/www.beer-management.de\\\/en\\\/seminars-training-establishing-knowledge-and-skills\\\/data-analysis-for-logistics-system-planning\\\/\",\"name\":\"Data analysis for warehouse planning - Dr. Beer Management &amp; Logistik\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.beer-management.de\\\/en\\\/#website\"},\"datePublished\":\"2021-02-08T14:34:11+00:00\",\"dateModified\":\"2023-04-29T09:47:46+00:00\",\"description\":\"This workshop teaches the essential techniques of data analysis for planning automated intralogistics systems.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.beer-management.de\\\/en\\\/seminars-training-establishing-knowledge-and-skills\\\/data-analysis-for-logistics-system-planning\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.beer-management.de\\\/en\\\/seminars-training-establishing-knowledge-and-skills\\\/data-analysis-for-logistics-system-planning\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.beer-management.de\\\/en\\\/seminars-training-establishing-knowledge-and-skills\\\/data-analysis-for-logistics-system-planning\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/www.beer-management.de\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data analysis for warehouse planning\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.beer-management.de\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.beer-management.de\\\/en\\\/\",\"name\":\"Dr. Beer Management &amp; Logistik\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.beer-management.de\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.beer-management.de\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.beer-management.de\\\/en\\\/#organization\",\"name\":\"Dr. Beer Management & Logistik\",\"url\":\"https:\\\/\\\/www.beer-management.de\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.beer-management.de\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.beer-management.de\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/favicon.ico\",\"contentUrl\":\"https:\\\/\\\/www.beer-management.de\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/favicon.ico\",\"width\":42,\"height\":42,\"caption\":\"Dr. Beer Management & Logistik\"},\"image\":{\"@id\":\"https:\\\/\\\/www.beer-management.de\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data analysis for warehouse planning - Dr. Beer Management &amp; Logistik","description":"This workshop teaches the essential techniques of data analysis for planning automated intralogistics systems.","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:\/\/www.beer-management.de\/en\/seminars-training-establishing-knowledge-and-skills\/data-analysis-for-logistics-system-planning\/","og_locale":"en_US","og_type":"article","og_title":"Data analysis for warehouse planning - Dr. Beer Management &amp; Logistik","og_description":"This workshop teaches the essential techniques of data analysis for planning automated intralogistics systems.","og_url":"https:\/\/www.beer-management.de\/en\/seminars-training-establishing-knowledge-and-skills\/data-analysis-for-logistics-system-planning\/","og_site_name":"Dr. Beer Management &amp; Logistik","article_modified_time":"2023-04-29T09:47:46+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.beer-management.de\/en\/seminars-training-establishing-knowledge-and-skills\/data-analysis-for-logistics-system-planning\/","url":"https:\/\/www.beer-management.de\/en\/seminars-training-establishing-knowledge-and-skills\/data-analysis-for-logistics-system-planning\/","name":"Data analysis for warehouse planning - Dr. Beer Management &amp; Logistik","isPartOf":{"@id":"https:\/\/www.beer-management.de\/en\/#website"},"datePublished":"2021-02-08T14:34:11+00:00","dateModified":"2023-04-29T09:47:46+00:00","description":"This workshop teaches the essential techniques of data analysis for planning automated intralogistics systems.","breadcrumb":{"@id":"https:\/\/www.beer-management.de\/en\/seminars-training-establishing-knowledge-and-skills\/data-analysis-for-logistics-system-planning\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.beer-management.de\/en\/seminars-training-establishing-knowledge-and-skills\/data-analysis-for-logistics-system-planning\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.beer-management.de\/en\/seminars-training-establishing-knowledge-and-skills\/data-analysis-for-logistics-system-planning\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/www.beer-management.de\/en\/"},{"@type":"ListItem","position":2,"name":"Data analysis for warehouse planning"}]},{"@type":"WebSite","@id":"https:\/\/www.beer-management.de\/en\/#website","url":"https:\/\/www.beer-management.de\/en\/","name":"Dr. Beer Management &amp; Logistik","description":"","publisher":{"@id":"https:\/\/www.beer-management.de\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.beer-management.de\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.beer-management.de\/en\/#organization","name":"Dr. Beer Management & Logistik","url":"https:\/\/www.beer-management.de\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.beer-management.de\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.beer-management.de\/wp-content\/uploads\/2019\/07\/favicon.ico","contentUrl":"https:\/\/www.beer-management.de\/wp-content\/uploads\/2019\/07\/favicon.ico","width":42,"height":42,"caption":"Dr. Beer Management & Logistik"},"image":{"@id":"https:\/\/www.beer-management.de\/en\/#\/schema\/logo\/image\/"}}]}},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.beer-management.de\/en\/wp-json\/wp\/v2\/pages\/26993","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.beer-management.de\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.beer-management.de\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.beer-management.de\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.beer-management.de\/en\/wp-json\/wp\/v2\/comments?post=26993"}],"version-history":[{"count":4,"href":"https:\/\/www.beer-management.de\/en\/wp-json\/wp\/v2\/pages\/26993\/revisions"}],"predecessor-version":[{"id":26997,"href":"https:\/\/www.beer-management.de\/en\/wp-json\/wp\/v2\/pages\/26993\/revisions\/26997"}],"up":[{"embeddable":true,"href":"https:\/\/www.beer-management.de\/en\/wp-json\/wp\/v2\/pages\/27036"}],"wp:attachment":[{"href":"https:\/\/www.beer-management.de\/en\/wp-json\/wp\/v2\/media?parent=26993"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}