Posts

BUSINESS INTELLIGENCE

Image
  Business Intelligence: Business Intelligence is a process driven by technology. The procedural and technological framework that acquires, stores, and analyses the data obtained by a company’s activities are known as Business Intelligence (BI) ( Investopedia, 2022) . In the business intelligence process organization gets data from external sources and internal IT sources and systems, runs queries, prepares for analysis, and creates data visualizations by running queries against the data, BI reports, and dashboards to make the analytics results used by users for strategic planning and operational decision making. The primary purpose of BI initiatives is to produce better decisions for organizations to increase business revenue, Analyse customer behaviors, compare data with competitors, optimize operations, improve overall operational efficiency, can analyze market trends, and gain business advantages (techtarget, 2022). Working process: Organizations and Businesses have various goa...

DATA MINING

Image
  Data mining is a critical step in data analeptics. In layman's language, we can look at data mining as a person digging through a cave in search of gold. The method of analyzing data from various viewpoints using various methods and summarizing it into valuable information is known as data mining  (Roiger, 2017.) . Data mining with proper tools may result in discovering previously undiscovered fascinating patterns, unexpected records, and relationships ( Witten, et al.,2005).   figure: 1 TYPES OF DATA  Types of data:  In the above figure: 1 we can see that data is classified into qualitative and quantitative, which further is classified into nominal & ordinal data and discrete & continuous data. Qualitative data:  This category of data is the kind of classification that is used to group data—for example, age, gender, and one's job title. Within the quantitative data, there are nominal data and ordinal data. ·        ...

DATA WAREHOUSING

Image
  Data Warehousing A Data warehouse is a repository where information is gathered from multiple data sources and stored electronically .  Data engineers and Business analysts for business intelligence purposes in an organization can access data warehouses that store data in larger amounts. The data is accessible and easy to evaluate for business insights. The data gathered from multiple sources is in multiple formats, such as Structured, Semi-structured, or Unstructured. The collected data is processed, modified, and converted into information so that the users can access the data through multiple tools such as Spreadsheets, SQL Clients, etc.  A data warehouse is a centralized location where all the enterprise data gets stored for further analysis. Business Intelligence tools help organizations to explore the data to make better business decisions.   The data is stored in the data warehouse through ETL (Extract, Transform and Load). The data is extracted from the sou...