{"id":933,"date":"2019-09-10T08:57:21","date_gmt":"2019-09-10T06:57:21","guid":{"rendered":"https:\/\/kindsonthegenius.com\/blog\/?p=933"},"modified":"2020-08-22T14:23:35","modified_gmt":"2020-08-22T12:23:35","slug":"6-top-business-intelligence-tools-2019-2020","status":"publish","type":"post","link":"https:\/\/kindsonthegenius.com\/blog\/6-top-business-intelligence-tools-2019-2020\/","title":{"rendered":"6 Top Business Intelligence Tools (2019\/2020)"},"content":{"rendered":"<p>I would tell you about the 6 top Business Intelligence Applications you should know. Business Intelligence is simply an industry term and it refers the the processes involved in transforming data (normally from different sources, both structured and unstructured) into useful information.This information can then be visualized and used for making business decisions.<\/p>\n<p>I have decided to explain some details in separate articles.<\/p>\n<ol>\n<li><a href=\"#t1\">SAP BusinessObjects Business Intelligence Suite<\/a><\/li>\n<li><a href=\"#t2\">Power BI<\/a><\/li>\n<li><a href=\"#t3\">Tableau<\/a><\/li>\n<li><a href=\"#t4\">Microsoft BI<\/a><\/li>\n<li><a href=\"#t5\">Informatica<\/a><\/li>\n<li><a href=\"#t6\">IBM Cognos<\/a><\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><strong id=\"t1\">1. SAP BusinessObjects Business Intelligence Suite<\/strong><\/p>\n<p>This is a suite of a number of tools that SAP says will &#8220;support your growth with a centralized platform for visualization and reporting&#8221;.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-934 aligncenter\" src=\"https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/SAP-Business-Objects-Business-Intelligence-Suite-300x270.jpg\" alt=\"SAP BusinessObjects Business Intelligence Suite\" width=\"300\" height=\"270\" srcset=\"https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/SAP-Business-Objects-Business-Intelligence-Suite-300x270.jpg 300w, https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/SAP-Business-Objects-Business-Intelligence-Suite.jpg 626w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>This is a tool-suite developed and maintained by SAP as an Enterprise BI suite. Features of SAP BO BI Suite includes<\/p>\n<ul>\n<li>Reporting and Analysis<\/li>\n<li>Analytics Application<\/li>\n<li>Data Visualization<\/li>\n<li>Integration with Office Applications<\/li>\n<li>Integration with SAP Ecosystem<\/li>\n<\/ul>\n<p>Other features of SAP BO BI Suite according to SAP includes on-premise deployment, real-time business intelligence, improved user autonomy and simplified\/personalized information consumption.<\/p>\n<p><strong>Pros:<\/strong> Very robust and feature-rich<\/p>\n<p><strong>Cons:<\/strong> As with other SAP products, it is highly proprietary. Beside, in terms of cost is mainly for enterprises of considerable size<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong id=\"t2\">2. Power BI<\/strong><\/p>\n<p>Just like the Microsoft BI, Power BI\u00a0 is also provided by Microsoft as a business analytics tool. It provides easy to use and interactive visualization. This makes it one of the most easy-to-learn BI tool. Can be used to create custom reports and dashboards.<\/p>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_936\" aria-describedby=\"caption-attachment-936\" style=\"width: 640px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-936 size-large\" src=\"https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/Power-BI-1024x409.jpg\" alt=\"\" width=\"640\" height=\"256\" srcset=\"https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/Power-BI-1024x409.jpg 1024w, https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/Power-BI-300x120.jpg 300w, https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/Power-BI-768x307.jpg 768w, https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/Power-BI.jpg 1042w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><figcaption id=\"caption-attachment-936\" class=\"wp-caption-text\">Power BI<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p>I would recommed Power BI for beginner data analysts.<\/p>\n<p>Some components of PowerBI includes:<\/p>\n<ul>\n<li><strong>Power BI Desktop<\/strong> &#8211; a -desktop application for Windows PCs<\/li>\n<li><strong>Power BI Service<\/strong> &#8211; a cloud Software as a Service tool<\/li>\n<li><strong>Power BI Mobile Apps<\/strong> &#8211; for mobile devices: Aandroi, Windows and iOS<\/li>\n<li><strong>Power BI Gateway<\/strong> &#8211; used to integrate external data channels and fetch data. Allows for exporting of data as well<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong id=\"t3\">3. Tableau<\/strong><\/p>\n<p>The Tableau BI tool is developed and <a href=\"https:\/\/en.wikipedia.org\/wiki\/Tableau_Software\">Tableau Software Inc<\/a>. which is a subsidiary of <a href=\"https:\/\/en.wikipedia.org\/wiki\/Salesforce.com\">Salesforce<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_935\" aria-describedby=\"caption-attachment-935\" style=\"width: 300px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-935 size-medium\" src=\"https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/Tableau-Business-Intelligence-300x241.jpg\" alt=\"Tableau Business Intelligence\" width=\"300\" height=\"241\" srcset=\"https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/Tableau-Business-Intelligence-300x241.jpg 300w, https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/Tableau-Business-Intelligence-768x616.jpg 768w, https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/Tableau-Business-Intelligence.jpg 909w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><figcaption id=\"caption-attachment-935\" class=\"wp-caption-text\">Tableau<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p>Tableau allows you to query a variaty of data stores including cloud databases, relational database, online analytical processing cubes and spreadsheets. It allows generation of graph-type data visualization. It can also be used for extraction, storage and retrieval from in-memory data storage engines.<\/p>\n<ul>\n<li>Tableau products included the following:<\/li>\n<li>Tableau Server<\/li>\n<li>Tables Desktop<\/li>\n<li>Tableau Prep Builder<\/li>\n<li>Tableau Vizable<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong id=\"t4\">4. Microsoft Business Intelligence<\/strong><\/p>\n<figure id=\"attachment_937\" aria-describedby=\"caption-attachment-937\" style=\"width: 465px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-937 \" src=\"https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/SQL-Server-Reporting-Services.jpg\" alt=\"SQL Server Reporting Services\" width=\"465\" height=\"350\" srcset=\"https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/SQL-Server-Reporting-Services.jpg 895w, https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/SQL-Server-Reporting-Services-300x225.jpg 300w, https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/SQL-Server-Reporting-Services-768x577.jpg 768w\" sizes=\"(max-width: 465px) 100vw, 465px\" \/><figcaption id=\"caption-attachment-937\" class=\"wp-caption-text\">SQL Server Reporting Services<\/figcaption><\/figure>\n<p>&nbsp;<\/p>\n<p>This is also a tool-suite provided by Microsoft. It consists of three components:<\/p>\n<ul>\n<li>Microsoft SQL Server Reporting Services(SSRS)<\/li>\n<li>Microsoft SQL Server Integration Services(SSIS)<\/li>\n<li>Microsoft SQL Server Analytics Services(SSAS)<\/li>\n<\/ul>\n<p>This tools supports ETL (Extract, Transform and Load). This means that data is taken from a variety of sources, then analysis is performed on the data, and then finally stored in the target database.<\/p>\n<p>From the database, reports can then be generated from the data.<\/p>\n<p><strong>Pros<\/strong>: Very feature rich. Integration with Microsoft products. Easy to learn for developers.<\/p>\n<p><strong>Cons<\/strong>: Steep learning curve. May be a bit complicated for new analysts.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong id=\"t5\">5. Informatica<\/strong><\/p>\n<p>This is the name of the software company that provides a set of Business Intelligence Tools.<\/p>\n<figure id=\"attachment_938\" aria-describedby=\"caption-attachment-938\" style=\"width: 492px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-938 \" src=\"https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/Informatica.jpg\" alt=\"Informatica\" width=\"492\" height=\"464\" srcset=\"https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/Informatica.jpg 837w, https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/Informatica-300x283.jpg 300w, https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/Informatica-768x724.jpg 768w\" sizes=\"(max-width: 492px) 100vw, 492px\" \/><figcaption id=\"caption-attachment-938\" class=\"wp-caption-text\">Informatica<\/figcaption><\/figure>\n<p>Some of its products and services includes:<\/p>\n<ul>\n<li>Enterprise Data Management<\/li>\n<li>Data Integration<\/li>\n<li>Information Life Cycle Management<\/li>\n<\/ul>\n<p>Other products includes cloud computing integration, b2b data exchanges, data replication, data visualization and master data management.<\/p>\n<p>From a white paper I just read, Informatica works integrates with Tableau to provide a more tailored data analytics and insight.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><strong id=\"t6\">6. IBM Cognos BI<\/strong><\/p>\n<p>IBM Cognos BI is a web-based integrated business intelligence tool-suite developed by IBM. Toolset includes analytics, reporting, scorecarding and event-monitoring.<\/p>\n<p>&nbsp;<\/p>\n<figure id=\"attachment_939\" aria-describedby=\"caption-attachment-939\" style=\"width: 688px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-939 \" src=\"https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/IBM-Cognos.jpg\" alt=\"IBM Cognos\" width=\"688\" height=\"393\" srcset=\"https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/IBM-Cognos.jpg 887w, https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/IBM-Cognos-300x171.jpg 300w, https:\/\/kindsonthegenius.com\/blog\/wp-content\/uploads\/2019\/09\/IBM-Cognos-768x439.jpg 768w\" sizes=\"(max-width: 688px) 100vw, 688px\" \/><figcaption id=\"caption-attachment-939\" class=\"wp-caption-text\">IBM Cognos<\/figcaption><\/figure>\n<p>Components of IBM Cognos BI includes the following:<\/p>\n<ul>\n<li>Query Studio &#8211; used for creating simple and customizable queries and reports.<\/li>\n<li>Report Studio &#8211; specifically for creating management reports.<\/li>\n<li>Cognos Connection &#8211; serves as a web portal for IBM Cognos BI<\/li>\n<li>Analysis Studio &#8211; allows users to analyze large and multidimensional data sources<\/li>\n<li>Event Studio &#8211; used for creating notification about events within an enterprise<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Conclusion<\/strong><\/p>\n<p>I would be writing separate articles on each of this applications. For now, I would like to thank you for reading.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I would tell you about the 6 top Business Intelligence Applications you should know. Business Intelligence is simply an industry term and it refers the &hellip; <\/p>\n","protected":false},"author":1,"featured_media":940,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[584],"tags":[],"_links":{"self":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/933"}],"collection":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/comments?post=933"}],"version-history":[{"count":1,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/933\/revisions"}],"predecessor-version":[{"id":941,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/posts\/933\/revisions\/941"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/media\/940"}],"wp:attachment":[{"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/media?parent=933"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/categories?post=933"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kindsonthegenius.com\/blog\/wp-json\/wp\/v2\/tags?post=933"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}