# Business Intelligence and Analytics – From A to Z (Part 1) *Source: https://trginternational.com/blog/business-intelligence-and-analytics-from-a-to-z/* --- If you are new to [**Business Intelligence (BI)**,](../../../com/trginternational/blog/what-is-business-intelligence.html) navigating through its terminology is not an easy thing to do, which is why we are here to help. ## A and B – **A**nalytics and **B**usiness Intelligence The term ‘Business Intelligence’ [was invented in 1989](../../../com/trginternational/blog/revisiting-the-origins-and-definition-of-business-intelligence.html) by the consulting firm Gartner and has been popularised since then. Business Intelligence (BI) refers to technologies, processes, and skills needed to gather, analyse data, and turn **data** into actionable **insights**. In recent years, however, vendors and industry experts have been using the terms ‘**Business Analytics**’ or ‘**Analytics**’ more frequently. A quick research using Google Trends so how much popularity the term ‘Business Analytics’ (red) has gained during the last 5 years in comparison with ‘Business Intelligence’ (blue). **Read more:** [How Grab Uses Data Analytics to Refine New Products](../../../com/trginternational/blog/how-grab-uses-data-analytics-to-refine-new-products.html) ![Business Intelligence vs. Business Analytics](https://blog.trginternational.com/hs-fs/hubfs/images/Business-Intelligence-Business-Analytics-Google-Trends.jpg?width=711&name=Business-Intelligence-Business-Analytics-Google-Trends.jpg "Business Intelligence vs. Business Analytics") These terms often are used interchangeably and can cause quite a bit of confusion. The increasing popularity of the terms ‘Analytics’ and ‘Business Analytics’ can partly be explained by recent **advancements in data analytics** (in-memory, advanced algorithms, A.I., machine learning, etc.) which have given a massive boost to business intelligence software’s power. **Read more:** [How Data Analytics is changing hotel revenue management](../../../com/trginternational/blog/how-data-analytics-is-changing-hotel-revenue-management.html) Some vendors and experts may explain business analytics/analytics refers to more advanced technologies, those that are more proactive and forward-looking as opposed to traditional business intelligence software which is more reactive and backwards-looking. Still, such explanation is more of a marketing tool than an actual difference. **Modern BI** solutions also come with **advanced analytics** such as predictive and prescriptive modelling that can truly go beyond reflecting the past business performance. **Read more:** [3 best Business Intelligence & Analytics vendors 2017](../../../com/trginternational/blog/3-best-business-intelligence-analytics-vendors-2017.html) To add to the confusing, ‘analytics’ can be considered one of the three main [**components of a BI solution**.](../../../com/trginternational/blog/what-is-business-intelligence.html) The other two components are the data warehouse and dashboards/reporting. In most cases though, ‘Business Intelligence’, ‘Business Analytics’, and ‘Analytics’ can be used interchangeably. [![Subscribe to TRG Blog](https://no-cache.hubspot.com/cta/default/125873/446c9ad9-d721-4d95-a80c-96fbf226215c.png)](https://cta-redirect.hubspot.com/cta/redirect/125873/446c9ad9-d721-4d95-a80c-96fbf226215c) ## C – Data **C**ube A data cube is a multidimensional array of values and is used to represent data along some measure of interest, according to the definition on Wikipedia. The number of dimensions of a data ‘cube’ can be higher than three. For example, a sales data cube can have the following dimensions: Time, Location, and Item. A business intelligence solution may deal with multiple data cubes. Each cube can belong to certain departments or individuals. ![Data cube](https://blog.trginternational.com/hs-fs/hubfs/images/Business-Intelligence-Business-Analytics-Datacube.jpg?width=711&name=Business-Intelligence-Business-Analytics-Datacube.jpg "Data cube") ## D- **D**ashboard A BI dashboard is a collection of **visualisations** that monitors a business performance and facilitates decision making by displaying the status of metrics and KPIs, often **on a single screen.** A modern BI solution should allow for the ability to customise dashboards based on users’ **specific roles**. **Read more:** [How a Financial Shared Services Centre benefits from analytics software](../../../com/trginternational/blog/how-a-financial-shared-services-centre-benefits-from-analytics-software.html) ![Business Intelligence Dashboard](https://blog.trginternational.com/hs-fs/hubfs/images/Business-Intelligence-Business-Analytics-Dashboards-Example.jpg?width=711&name=Business-Intelligence-Business-Analytics-Dashboards-Example.jpg "Business Intelligence Dashboard") _An example of BI dashboard_ ## E- **ETL** **Business intelligence software** essentially collects and analyses data from other enterprise applications such as ERP, CRM and accounting software. The process in which data from different systems is pulled from the source systems and placed into the BI solution’s data warehouse is called **ETL (Extract – Transform – Load)**. The Extract step copies data from the source systems. By doing so, the performance of the source systems will not be affected by later analysis operations. Each system can have a different data format. This step also makes sure only the desired data sets are extracted. In the Transform step, the extracted **data is cleaned**, for e.g. mapping N/A to 0 or ‘M’ to ‘Male’. Other rules or functions can also be applied to prepare the data for data warehousing, such as selecting or deselecting certain columns, combining or splitting columns, transposing columns and rows, etc. The Load step moves the transformed data into the BI solution’s data warehouse where it can be further analysed. **This is the 1st part of our article. [Read the 2nd part](../../../com/trginternational/blog/business-intelligence-and-analytics-from-a-to-z-part-2.html) now or [subscribe to our blog](../../../com/trginternational/blog/subscribe-to-trg-blogs.html) for the latest content about Business Intelligence and Analytics.**  ** [![Subscribe to TRG Blog](https://no-cache.hubspot.com/cta/default/125873/fff8e68d-8465-4f5a-b7b4-ed9426ccc4ef.png)](https://cta-redirect.hubspot.com/cta/redirect/125873/fff8e68d-8465-4f5a-b7b4-ed9426ccc4ef) **