Insight3 min read
Business intelligence, commonly known as BI, refers to decision-support computing.
Business intelligence, commonly known as BI, refers to decision-support computing. It enables better-informed decisions through a set of methods, resources and IT tools used to steer a company and support decision-making through:
- dashboards,
- analytical and forward-looking reports,
- prescriptive reports,
- and even predictive reports.
Companies have realised how important data is to their strategy. Analytics is now central for SMEs, which need to study summarised data and adapt indicators to their current needs.
BI relies on collecting, modelling and presenting the unstructured, heterogeneous data a company generates:
- paper archives,
- databases,
- Excel spreadsheets,
- customer data collected through an online service or a simple Google Form,
- and so on.
All of this is processed by extraction, transformation and loading tools (ETL) set up to standardise these sources and make them consistent with one another.
A very good example of an ETL tool — and one we recommend, since it is open source — is Talend.
Objectives of BI
BI programmes offer many benefits that make an organisation easier to manage:
- faster, better decision-making;
- optimised internal business processes;
- greater operational efficiency;
- new revenue streams;
- competitive advantage…
These programmes also help identify market trends and business problems that need solving.
BI data can include historical information as well as new data collected from source systems as it is generated. BI analysis can therefore support both strategic and tactical decision-making.
Originally, BI tools were mainly used by IT professionals, especially data analysts. They ran the analyses and produced reports containing query results for business users.
Today, executives and operational staff increasingly use BI software themselves, thanks to the development of data exploration and self-service BI tools.
Business intelligence and data management
Business intelligence gives decision-makers analysis tools and indicators they can rely on to set strategic direction without having to handle all the technical aspects.
Data is stored and processed in data warehouses. There are also more specific stores, called data marts, which focus on particular business activities: marketing, budget planning, logistics, human resources, sales relationships, student management…
There are of course many use cases for business intelligence, including:
- analytics,
- statistical analysis,
- Big Data analysis,
- reporting,
- forecasting…
Analytics, widely used in web marketing
Analytics means applying business intelligence (BI) and business analytics (BA) methods to digital content. Companies use analytics software to gain visibility over the volume, nature and use of the content they create.
A company produces two types of content: structured and unstructured. Structured content is stored in a database. Unstructured content can be anywhere in the company: text, such as emails, office documents and web pages, or non-text items such as videos, images and voice messages.
To identify patterns and trends across a company's unstructured content, analytics software uses natural language queries, trend analysis, contextual exploration and predictive analysis.
The aim of analysis is to gain new insights to improve decision-making. For example, a pattern in unstructured content may explain a trend in structured data, and vice versa.
Analytics also helps companies better manage information lifecycle management (ILM) by putting cost and consumption metrics in place.
With these indicators, companies can identify their most valuable digital content and adjust their future storage and analytics investments accordingly.
Reporting, the most widespread application
At the end of the chain, users rely on reporting tools to select data according to various criteria (period, customer or product type…), sort it using filters and build chart-based dashboards.
How does business intelligence work in real life?
Before being used in BI applications, raw data from different source systems must be integrated, consolidated and cleaned. Data integration and data quality tools ensure that analyses are based on accurate, consistent information.
Alongside BI managers, business intelligence teams usually include BI architects and developers, analysts and data administration professionals.
Business users are often involved too: they represent the business and make sure the BI development process meets their needs.
Companies can thus speed up the roll-out of BI capabilities and optimise or adjust development plans as business needs change or new requirements emerge and take priority.
Traditional BI versus advanced analytics
BI is sometimes used as a synonym for business analytics. In other cases, business analytics may refer either, in a narrow sense, to advanced data analytics or, more broadly, to both business intelligence and advanced analytics.
To learn more about careers in BI, follow this link (in French).
In a future article, we will focus on the Talend Data Integration ETL tool.
