{"id":1227,"date":"2016-10-27T12:22:37","date_gmt":"2016-10-27T12:22:37","guid":{"rendered":"https:\/\/pl.server2.purelogics.net\/blog\/?p=307"},"modified":"2023-10-24T12:17:22","modified_gmt":"2023-10-24T12:17:22","slug":"how-to-create-a-suitable-business-intelligence-system","status":"publish","type":"post","link":"https:\/\/pl.server2.purelogics.net\/?p=1227","title":{"rendered":"How To Create A Suitable Business Intelligence System"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_65 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/pl.server2.purelogics.net\/?p=1227\/#Design\" title=\"Design\">Design<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/pl.server2.purelogics.net\/?p=1227\/#Analyze_the_%E2%80%9Craw%E2%80%9D_data_not_ready_slices\" title=\"Analyze the &#8220;raw&#8221; data, not ready slices\">Analyze the &#8220;raw&#8221; data, not ready slices<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/pl.server2.purelogics.net\/?p=1227\/#Look_for_the_right_solutions_that_complement_your_custom_BI_system\" title=\"Look for the right solutions that complement your custom BI system. \">Look for the right solutions that complement your custom BI system. <\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/pl.server2.purelogics.net\/?p=1227\/#Collect_data_asynchronously\" title=\"Collect data asynchronously\">Collect data asynchronously<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/pl.server2.purelogics.net\/?p=1227\/#Check_the_data_collected\" title=\"Check the data collected\">Check the data collected<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/pl.server2.purelogics.net\/?p=1227\/#Superfluous_Data_do_not_exist_there_are_repetition\" title=\"Superfluous Data do not exist, there are repetition\">Superfluous Data do not exist, there are repetition<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/pl.server2.purelogics.net\/?p=1227\/#Do_not_strive_for_100_compliance\" title=\"Do not strive for 100% compliance\">Do not strive for 100% compliance<\/a><\/li><\/ul><\/nav><\/div>\n<span class=\"rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Reading Time: <\/span> <span class=\"rt-time\">3<\/span> <span class=\"rt-label rt-postfix\">minutes<\/span><\/span><p>For correct business decision-making it\u2019s important to have detailed information and insights on the state of affairs in the company. But often such information is limited to the annual or quarterly reports.<\/p>\n<p>To effectively analyze the organizational processes and progress, enterprises often implement business intelligence systems (BI-system) that enable them to make more informed decisions. Here I\u2019m sharing a few tips that may help when you create a BI-system for your company.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Design\"><\/span><strong>Design<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Store the raw data, rather than sections. Do not hope that the fixed schedules and reports will be sufficient. Instead, managers will ask you to build more and more detailed graphics. There will be lot of updates required.<\/p>\n<p>For example, we received a request for how much money singles in California under the age of 25 years spent for each month of the previous year. To be prepared to answer this question, we need to have not only their complete profile but also their financial reports.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Analyze_the_%E2%80%9Craw%E2%80%9D_data_not_ready_slices\"><\/span><strong>Analyze the &#8220;raw&#8221; data, not ready slices<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Try to analyze the &#8220;raw&#8221; data. Do not pre-aggregate. Remember: once you do the aggregation of data, you lose information.<br \/>\nFor example, you need to obtain statistics on the number of new contacts per day for New Yorkers. If you do an analysis of the data itself directly, you can confirm these results with concrete examples: who, when and with whom.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Look_for_the_right_solutions_that_complement_your_custom_BI_system\"><\/span><strong>Look for the right solutions that complement your custom BI system. <\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Remember that you are not the first one to create a BI-system. And for many problems ready-made solutions already exist. Because of this factor, most of the development can be reduced simply to a data collection and analysis software configuration.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Collect_data_asynchronously\"><\/span><strong>Collect data asynchronously<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to start collecting data about user behavior, do so asynchronously. You can write in the logs, you can write to the Scribe.<\/p>\n<p>In the development of infrastructure for the collection of information about the behavior of our customers, we know about the large volume of data to be processed. All this data was to be collected in a single data repository.<\/p>\n<p>Of course, any problems in the work of the store should be invisible to users of the site. Therefore, it was decided to record the raw data in log files, and only then move them to a separate storage back-end script.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Check_the_data_collected\"><\/span><strong>Check the data collected<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>With the implementation of BI-systems incoming data should be checked, and you need to do this very carefully. For example, if you get the parameters of the system users, be sure to check the distribution of registration dates, birthdays, etc. Ideally you should check the distribution of values in each column or columns in pairs.<\/p>\n<p>Often, when new data is added there is a situation when the column value in all rows is the same. Almost always the cause is the human error &#8211; the developers simply forget about this column.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Superfluous_Data_do_not_exist_there_are_repetition\"><\/span><strong>Superfluous Data do not exist, there are repetition<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When you look at what data is to be imported into the system, remember that extra data is not there. There are these repetitions. And now to the repetitions should be treated with suspicion. It is better to take the additional data and make sure that you have the same values than previously refused repetitions.<\/p>\n<p>This helps to identify errors in the system. Our <a href=\"https:\/\/pl.server2.purelogics.net\/level-up-my-team\/\"><strong>Team at PureLogics<\/strong><\/a> has fixed a lot of errors like this in BI-system implementation. These were mistakes in user profiles, and errors in the data on the cities, and even a few errors in the financial data.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Do_not_strive_for_100_compliance\"><\/span><strong>Do not strive for 100% compliance<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>By comparing and contrasting data from different sources, do not chase for 100% satisfaction. If you reach the 95% match, it is good enough.<\/p>\n<p>Very often the discrepancy of data is caused by objective reasons, for example, out of sync time. For example, the registration time of payment in their own &#8220;billing&#8221; and in the payment system. The difference in time of 1 second on December 31 may lead to the fact that one and the same payment will be dated in different years.<\/p>\n<p>These tips are not universal, each of them can find an exception. They should not be taken as absolute truth. On the contrary, the more counter-examples you can give, the better you will understand the essence of these rules. And if you have specific questions, we will try to answer them.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><span class=\"rt-reading-time\" style=\"display: block;\"><span class=\"rt-label rt-prefix\">Reading Time: <\/span> <span class=\"rt-time\">3<\/span> <span class=\"rt-label rt-postfix\">minutes<\/span><\/span> For correct business decision-making it\u2019s important to have detailed information and insights on the state of affairs in the company. But often such information is limited to the annual or quarterly reports. To effectively analyze the organizational processes and progress, enterprises often implement business intelligence systems (BI-system) that enable them to make more informed decisions. <a href=\"https:\/\/pl.server2.purelogics.net\/?p=1227\" class=\"more-link\">&#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":16025,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[8,16],"tags":[69,77,104,133,214],"class_list":["post-1227","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-artificial-intelligence","category-enterprise-software","tag-bi","tag-business-intelligence","tag-custom-enterprise-software","tag-erp","tag-reporting-and-intelligence-software"],"_links":{"self":[{"href":"https:\/\/pl.server2.purelogics.net\/index.php?rest_route=\/wp\/v2\/posts\/1227","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pl.server2.purelogics.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pl.server2.purelogics.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pl.server2.purelogics.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pl.server2.purelogics.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1227"}],"version-history":[{"count":3,"href":"https:\/\/pl.server2.purelogics.net\/index.php?rest_route=\/wp\/v2\/posts\/1227\/revisions"}],"predecessor-version":[{"id":17164,"href":"https:\/\/pl.server2.purelogics.net\/index.php?rest_route=\/wp\/v2\/posts\/1227\/revisions\/17164"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pl.server2.purelogics.net\/index.php?rest_route=\/wp\/v2\/media\/16025"}],"wp:attachment":[{"href":"https:\/\/pl.server2.purelogics.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pl.server2.purelogics.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1227"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pl.server2.purelogics.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}