{"id":998,"date":"2015-11-08T13:15:41","date_gmt":"2015-11-08T12:15:41","guid":{"rendered":"http:\/\/melyakub.com\/?p=998"},"modified":"2018-06-21T01:39:21","modified_gmt":"2018-06-21T00:39:21","slug":"business-intelligence","status":"publish","type":"post","link":"https:\/\/melyakub.com\/?p=998","title":{"rendered":"Business Intelligence"},"content":{"rendered":"<p><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\"><a href=\"http:\/\/melyakub.com\/wp-content\/uploads\/2015\/11\/images-16.jpeg\"><img loading=\"lazy\" decoding=\"async\" class=\" size-full wp-image-1053 alignleft\" src=\"http:\/\/melyakub.com\/wp-content\/uploads\/2015\/11\/images-16.jpeg\" alt=\"images-16\" width=\"275\" height=\"183\" srcset=\"https:\/\/melyakub.com\/wp-content\/uploads\/2015\/11\/images-16.jpeg 275w, https:\/\/melyakub.com\/wp-content\/uploads\/2015\/11\/images-16-200x133.jpeg 200w\" sizes=\"auto, (max-width: 275px) 100vw, 275px\" \/><\/a><\/span><\/p>\n<p><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\">The quality of our decisions, and the results we get therefrom, are dependent on a few factors as follows:<\/span><\/p>\n<ol>\n<li><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\">The quality and quantity of information that we have at our disposal,<\/span><\/li>\n<li><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\">Our abilities to intelligently process the information available and make decisions based on that,<\/span><\/li>\n<li><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\">The environmental response to our the decisions.<\/span><\/li>\n<\/ol>\n<p><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\">The third factor is not entirely within our control. However, the first and second factors are to a large extent within our control. How, therefore, does the small and medium business entrepreneur obtain and process the information they need to enable them make effective decisions that will deliver the required business results?<\/span><\/p>\n<p><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\"><strong>1) What is Business Intelligence?<\/strong> Business Intelligence (\u2018BI\u2019) refers to broad scope of software verticals that enables your business establish trends from disparate sets of data, thereby providing you with key information (read \u2018intelligence\u2019) that you can use to make informed decisions. BI tools enables organisations to collate, monitor and process data, thereby generating business insights necessary for making smarter and better decisions that drive results positively. Large corporations collate and analyse massive amount of business data to enable them understand their operating business environment sufficiently enough to make informed decisions. They also make use of the results to try to understand and make predictions about future trends. Business intelligence is therefore simply the capacity to turn (massive) data into neat and sensible information for business decision making.<\/span><\/p>\n<p><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\">Until recently, BI capability was very expensive and even difficult for most small and medium enterprises to consider. In addition to the cost of procurement and implementation of BI systems, small and medium enterprises (&#8216;SMEs&#8217;) will also need the expertise to interprete and apply the results. Yet, this capability is, to some extent at least, even more required by the SMEs. This is for the simple reason that a larger corporation can more easily bear the consequences of bad decisions and make corrections to wrong decisions, that can just wipe out an SME.<\/span><\/p>\n<p><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\">The emergence of, and developments in \u2018cloud computing\u2019, open source, visualization technologies etc., now make it easier and cheaper for the SME to access BI capability and enjoy their attendant benefits. Over the last few years, the BI market has actually\u00a0pivoted to accommodate the needs of SMEs by lowering the financial investment requirements as well as eliminating the need for in-house data experts.<\/span><\/p>\n<p><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\"><a href=\"http:\/\/melyakub.com\/wp-content\/uploads\/2015\/11\/BI-Tool-with-Responsive-UI.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-1055\" src=\"http:\/\/melyakub.com\/wp-content\/uploads\/2015\/11\/BI-Tool-with-Responsive-UI-300x160.png\" alt=\"BI-Tool-with-Responsive-UI\" width=\"300\" height=\"160\" \/><\/a><\/span><\/p>\n<p><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\"><strong>2) Benefits of BI Systems: <\/strong>As mentioned earlier, the primary benefit of an effective BI system is to enable you make informed decisions on various key aspects of your business. A typical BI system will, without any manual computations, enable you:<\/span><\/p>\n<ul>\n<li><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\">Make sense of your massive business data and process it into easily interpretable results,<\/span><\/li>\n<li><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\">Intelligently forecast upcoming key business indicators like sales revenue,<\/span><\/li>\n<li><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\">Analyse your operational efficiency,<\/span><\/li>\n<li><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\">Identify highest yielding customers, highest revenue generating regions, etc.,<\/span><\/li>\n<li><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\">Focus on business objectives instead of getting unwittingly overwhelmed by the \u2018noise\u2019,<\/span><\/li>\n<li><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\">Ability to recongise and respond quickly to emerging opportunities,<\/span><\/li>\n<li><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\">Enhance your competitive capacity.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\"><strong>3) How to Selecting a BI System for your business:<\/strong>\u00a0In selecting an appropriate BI system for your organisation, the challenge is for you and your team to decide on the following:<\/span><\/p>\n<ul>\n<li><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\">Ensure the availability of relevant and reliable or at least quite reasonable (acceptable) data,<\/span><\/li>\n<li><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\">Understand exactly what your requirements and objectives are, i.e. what questions do you wish to have answered?<\/span><\/li>\n<li><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\">Identify what success factors derive your corporate decision making process,<\/span><\/li>\n<li><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\">Review the various options (of \u00a0BI systems) available,<\/span><\/li>\n<li><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\">Match the options available with your requirements, resurces and constraints.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\"><strong>Seek expert advise:<\/strong> Given the, literally unlimited options available, it is important to work with an expert and go through your requirements to ensure you get the best system possible.<\/span><\/p>\n<p><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\">There are many types of BI tools, from analytics and big data statistics to reporting tools and dashboards that offer you &#8216;at-a-glance&#8217; information across indicators.\u00a0When selecting a BI system:<\/span><\/p>\n<ul>\n<li><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\"><strong>Involve your team:<\/strong> Adopting and implementing a BI system is a major issue even with large corporations. You should therefore involve your staff from across functions and from various levels. Empower all those involved to make the most professional and sincere input. The right attitude must be encouraged in the process. This is necessary if you are to succeed in deriving the benefits of the system.<\/span><\/li>\n<\/ul>\n<ul>\n<li><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\"><strong>Connect the data<\/strong>: As mentioned above, it is necessary to first identify the various sources of all you data, from tools to databases, that your company has or has legal access to. Everything must be pulled together to help you get a meaningful picture of how your business is currently performing. Next, you should establish what additional data you need to also pull in so that you can have more reliable results.<\/span><\/li>\n<\/ul>\n<ul>\n<li><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\"><strong><a href=\"http:\/\/melyakub.com\/wp-content\/uploads\/2015\/11\/business-intelligence-dashboard.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-1054 size-full alignleft\" src=\"http:\/\/melyakub.com\/wp-content\/uploads\/2015\/11\/business-intelligence-dashboard.jpg\" alt=\"business-intelligence-dashboard\" width=\"688\" height=\"460\" srcset=\"https:\/\/melyakub.com\/wp-content\/uploads\/2015\/11\/business-intelligence-dashboard.jpg 688w, https:\/\/melyakub.com\/wp-content\/uploads\/2015\/11\/business-intelligence-dashboard-200x134.jpg 200w, https:\/\/melyakub.com\/wp-content\/uploads\/2015\/11\/business-intelligence-dashboard-400x267.jpg 400w\" sizes=\"auto, (max-width: 688px) 100vw, 688px\" \/><\/a>Right capability:<\/strong>\u00a0Consider selecting tools that allow you to visualize and analyze relevant data. Above, from Business Cubic, shows a dashboard indicating a number of variables. It should also be able to combine, eliminate and customize data to generate the information you require that will help you better understand what drives your business. The ultimate objective is to be able to make fact-based and insightful decisions that will improve your corporate performance.<\/span><\/li>\n<\/ul>\n<ul>\n<li><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\"><strong>Start small:<\/strong> A common problem when implementing BI system for the first time is to consider a relatively expensive system notwithstanding exactly what the benefits to you are. Another problem is also becoming bogged down by trying to track everything under the sun. Instead, you should identify and stick to variables that are relevant to your business and are measurable. Approach and implelement the system gradually and in simple steps over a reasonable time. Do not take steps in leaps and bounds that will overwhelm you.<\/span><\/li>\n<\/ul>\n<ul>\n<li><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\"><strong>Keep evolving:<\/strong> The implementation of a BI system should not be seen as a one time event. Start small but keep improving as you introduce more data into the analytical process. Surely and steadily, you will develop your confidence and improve on your analyses and decision making process.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\"><strong>4) What BI System?<\/strong>\u00a0Even without understanding it, Excel is often the first &#8216;BI&#8217; solution most SMEs utilise. It is affordable and available. However, it obviously is highly limited. More robust BI solutions have much more analytical capability and offer visualizations, thereby making it easier to bring out the required information necessary for decision making.\u00a0To go a notch higher therefore, you team could review options such as Microsoft\u2019s PowerPivot which does much more than Excel. Others systems include JDEdwards, Hitachi&#8217;s Pentaho, BIME, DBxtra, Sisense, NetSuite, Microsoft Dynamics, Intuit QuickBooks etc. Whatever system you consider deploying, you should ensure that the it does you settle for does not lock you into a &#8216;strait-jacketed&#8217; way of looking at your data only. It should also make it easy to export the data into a data warehouse for further processing and utilisation elsewhere. This is again important so that you can integrate all your data down the road when you want to further enhance your capability. In addition, whatever system you decide to adopt, ensure that a mobile platform is offered by your vendor if your workforce are mobile and make require information on the go.<\/span><\/p>\n<p><span style=\"font-family: 'book antiqua', palatino, serif; font-size: 14pt;\">It is very important for an entrepreneur to appreciate the good use to which a BI system could be put to. Assess your requirements and buy what meets them at good value. At the end of the day, business is all about making many decisions on a daily basis. Obviously, a number of decisions will be made intuitively. However, a vast majority of decisions must be made intelligently and backed by hard and raw data. This is where a good BI system will help you by significantly improving your chances of success.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The quality of our decisions, and the results we get therefrom, are dependent on a few factors as follows: The quality and quantity of information that we have at our disposal, Our abilities to intelligently process the information available and make decisions based on that, The environmental response to our <a href=\"https:\/\/melyakub.com\/?p=998\" class=\"btn btn-link continue-link\">Continue Reading<\/a><\/p>\n","protected":false},"author":2,"featured_media":1053,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[65],"tags":[],"class_list":["post-998","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-archives"],"_links":{"self":[{"href":"https:\/\/melyakub.com\/index.php?rest_route=\/wp\/v2\/posts\/998","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/melyakub.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/melyakub.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/melyakub.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/melyakub.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=998"}],"version-history":[{"count":1,"href":"https:\/\/melyakub.com\/index.php?rest_route=\/wp\/v2\/posts\/998\/revisions"}],"predecessor-version":[{"id":3171,"href":"https:\/\/melyakub.com\/index.php?rest_route=\/wp\/v2\/posts\/998\/revisions\/3171"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/melyakub.com\/index.php?rest_route=\/wp\/v2\/media\/1053"}],"wp:attachment":[{"href":"https:\/\/melyakub.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=998"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/melyakub.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=998"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/melyakub.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=998"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}