Wednesday, May 11, 2022

What is business intelligence

Here is its definition:

Raw information - initial information, primary information.

Based on these definitions, it is not obvious why to buy BI products, if in almost any enterprise the process of comprehending primary information already exists. It uses:

  1. Automation of the collection of primary information: In the modern world, such automation has been introduced almost everywhere. Starting from payment terminals and ending with employees who manually enter this information into a computer every day.
  2. Data Warehouse: They try to somehow analyze the received information, for which they most often create a database that stores information for the current day (OLTP), and a separate database where information is stored for all previous days (Data Warehouse); at night, data is usually moved from one database to another.
  3. Data analysis in the warehouse: They try to analyze the accumulated information by organizing downloads from it, which are reduced to an Excel file, using the capabilities of Excel to comprehend the information received.
  4. Microsoft Excel as an analytics tool: To help analysts, Microsoft offers Power BI, which turns Excel into a very serious and modern BI tool. Working with it, business analysts get a complete picture of the current financial processes of the organization.

Essential tools for business analysis

Notion

Allows you to conveniently and flexibly write notes and share them with others.

The main advantages of Notion:

  • the speed of opening and processing a document (compared to Google Docs),
  • a wide range of features that are easy to use: spreadsheets, kanban boards, gallery, calendar, todo lists, CRM.

What can be done in Notion:

  • vacancy description,
  • offer,
  • notes on the results of a meeting or call,
  • collect a draft of the article,
  • make an MVP landing, sales funnel or task board.


There are many tools for business analysis. However, the more you try, the easier it is to learn new ones. For example, if you are good at Excel, you will find it easier to dive into SQL and BI.

What is business intelligence

Here is its definition: Raw information - initial information, primary information. Based on these definitions, it is not obvious why to buy...