{"id":1281,"date":"2018-07-21T12:43:44","date_gmt":"2018-07-21T12:43:44","guid":{"rendered":"https:\/\/craftbreweryfinance.com\/oldversion\/?p=1281"},"modified":"2018-07-21T12:43:44","modified_gmt":"2018-07-21T12:43:44","slug":"how-to-manage-brewery-data","status":"publish","type":"post","link":"https:\/\/craftbreweryfinance.com\/oldversion\/how-to-manage-brewery-data\/","title":{"rendered":"How to Manage Brewery Data"},"content":{"rendered":"<h4><img decoding=\"async\" class=\"alignleft wp-image-1282 size-thumbnail\" src=\"https:\/\/craftbreweryfinance.com\/oldversion\/wp-content\/uploads\/2018\/07\/list-2389219_1280-150x150.png\" alt=\"\" width=\"150\" height=\"150\" srcset=\"https:\/\/craftbreweryfinance.com\/oldversion\/wp-content\/uploads\/2018\/07\/list-2389219_1280-150x150.png 150w, https:\/\/craftbreweryfinance.com\/oldversion\/wp-content\/uploads\/2018\/07\/list-2389219_1280-300x300.png 300w, https:\/\/craftbreweryfinance.com\/oldversion\/wp-content\/uploads\/2018\/07\/list-2389219_1280-1024x1024.png 1024w, https:\/\/craftbreweryfinance.com\/oldversion\/wp-content\/uploads\/2018\/07\/list-2389219_1280-768x768.png 768w, https:\/\/craftbreweryfinance.com\/oldversion\/wp-content\/uploads\/2018\/07\/list-2389219_1280-75x75.png 75w, https:\/\/craftbreweryfinance.com\/oldversion\/wp-content\/uploads\/2018\/07\/list-2389219_1280.png 1280w\" sizes=\"(max-width: 150px) 100vw, 150px\" \/>It\u2019s painful to have expensive brewery software and then fill it up with dirty data.\u00a0Your data is\u00a0your business intelligence, and you rely on it to provide an accurate picture of what&#8217;s going on in the business.<\/h4>\n<p>Dirty data jeopardizes the accuracy of your reporting and possibly the fate of the free world. Or at least your sales reports.\u00a0Your data is an asset \u2013 maintain, manage and verify it.<\/p>\n<p>This short checklist provides tips you can follow to implement a data management plan in your brewery to keep your intel fresh and clean.<\/p>\n<p><strong>The Data Management Checklist for Breweries<\/strong><\/p>\n<ul>\n<li><strong>Begin at the beginning: <\/strong>\n<ul>\n<li>Start with this simple approach: Ask those who use the data \u2013 the sales team, the inventory person, the GM &#8211; what problems do they see with reports? What info are they concerned about? What do they think needs to be \u2018fixed\u2019?<\/li>\n<li>Make a list of their issues (data issues only, leave the other issues for HR). This list will help you prioritize where to start the clean-up process.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Conduct a data audit <\/strong>\n<ul>\n<li>It sounds impressive, and it is. Make an assessment of your data and determine how much work needs to be done.<\/li>\n<li>Most common issues: missing, incomplete or inconsistent data.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Create a clean-up plan<\/strong>\n<ul>\n<li>Start with the most important areas: Products (Bill of Materials) and Costing are the two pillars of the brewery database. Tidy these up first. Run reports to check completeness of data.<\/li>\n<li>Next, plan to clean up the issues noted by your team in step one.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Get support from the top <\/strong>\n<ul>\n<li>\u201cHey boss, here are some problems I found\u2026\u201d Buy-in from the top is a big piece of the data management plan. People need to take the data seriously or you\u2019ll just be spinning your wheels. Get the boss on board, and tell them it was their idea.<\/li>\n<\/ul>\n<\/li>\n<li><strong>One person must be in charge of your database<\/strong>\n<ul>\n<li>If everyone is responsible, no one is responsible. Have one person in charge of your data management plan, and data integrity. The buck stops with this person (and it\u2019s probably you!)<\/li>\n<\/ul>\n<\/li>\n<li><strong>Limit the number of people allowed to enter data <\/strong>\n<ul>\n<li>Give some people access to view the database, but not to enter data (you know who these people are \u2013 they\u2019re not fit to dress themselves, let alone enter data in the system. View only permission for these folks).<\/li>\n<\/ul>\n<\/li>\n<li><strong>Train people to enter data the <em>right way<\/em><\/strong>\n<ul>\n<li>Train each person who does data entry carefully on the correct procedures. The fewer number of people you have making entries, the easier this will be.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Document procedures and clearly define the process for data entry<\/strong>\n<ul>\n<li>It\u2019s not enough to tell them what to do, you need to write it down and put it on paper. In some cases you may need to tattoo it on their forearm. Do what must be done; data entry standards are essential to data integrity.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Only you can prevent dirty data. Implement a data management plan today.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>It\u2019s painful to have expensive brewery software and then fill it up with dirty data.\u00a0Your data is\u00a0your business intelligence, and you rely on it to provide an accurate picture of what&#8217;s going on in the business. Dirty data jeopardizes the accuracy of your reporting and possibly the fate of the free world. Or at least [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1282,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"pgc_meta":"","_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[94,97,98],"tags":[],"class_list":["post-1281","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-it-and-software","category-it-and-software-newsletters","category-it-and-software-resources"],"_links":{"self":[{"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/posts\/1281"}],"collection":[{"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/comments?post=1281"}],"version-history":[{"count":0,"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/posts\/1281\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/media\/1282"}],"wp:attachment":[{"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/media?parent=1281"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/categories?post=1281"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/tags?post=1281"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}