visualizations


Excel is the most commonly used tool for data manipulation and analysis.You will find that most companies are unwilling to incorporate Business Intelligence because they already have Office Suite. Excel comes as “free” and most office managers wouldn’t want to invest in a service which they seem to already have. However, relying solely on Excel presents the following set of problems: • Strategic decision making isn’t supported. • Excel proficiency is needed and the average business owner may be lacking in it. • Spreadsheets are latent and may lack in accuracy. Thankfully......

Continue Reading


The most important asset to ensure survival and success in today’s marketplace is data. Business Intelligence converts this raw data into actionable information. The internet, deregulation, increased competition, consolidation and convergence of insurance services with other financial services have changed the structure of the insurance industry. This has greatly increased the need to implement business intelligence tools within insurance companies. BI refers to collecting, analyzing, presenting and disseminating business data. In an insurance company, this would be data sourced from Sales, Claims, Marketing and Premiums etc. BI tools ensure that data from......

Continue Reading


Sample CEO Dashboard. Source: https://www.informationbuilders.com/ Dashboards and Scorecards are common tools used in business intelligence for supporting performance management. They are usually used for similar purposes and can be used at the same time but their functionalities differ. When choosing a dashboard or scorecard, one should consider the purpose of use, types of data to be monitored, and the focus on long term goals and strategy versus immediate goals. Use of visualization and key metrics in both tools are common thus confusing some people on their similarities. A data dashboard is an information management tool......

Continue Reading


    The terms Business Intelligence are often heard rarely understood. There is the general understanding that it is to do with management of data and so most business owners often believe that with a functioning IT system there is no need for Business Intelligence tools. However, BI, is a lot more than just management of data. It is a set of tools, products used to support the collection, analysis, presentation and dissemination of business information. With BI, the words business analytics often follow too. This is the continuous exploration of past......

Continue Reading


    The Pathways International Maturity model.       The Pathways business intelligence maturity model is a tool that we use to establish the technical, business processes and reporting level of an organization for us to be able to determine the best business intelligence processes and tools that fit.     The 7-step model uses a bottom up approach in identification of the levels and maturity of the business intelligence process for an organization.   1. Level 0:   Everything at this stage is manual. The business processes are manual, information......

Continue Reading


  As the amount of data companies are collecting continues to grow at a rapid rate, the talent pool of individuals needed to analyze this information is having trouble keeping up. It comes as no surprise that jobs for business intelligence (BI) analysts—employees tasked with analyzing large amounts of data— are opening up faster than they can be filled. While employers seek candidates with a wide variety of technical experience, proficiency in SQL (the programming language used for data definition and manipulation) tops the list. To learn what types of roles prospective......

Continue Reading