VA Session 1 !

Question 1

Business Intelligence (BI)

Answer 1

• Technology-driven process
• for gathering, storing, accessing & analyzing data
• for decision making (in businesses)

Question 2

common enterprise systems that provide data for BI

Answer 2

HRMS, CRM, ERP

Question 3

Visual Analytics (VA)

Answer 3

• BI method
• process of combining interactive visualizations
• with analytical reasoning

Question 4

Dashboard

Answer 4

• Collection of visualizations & KPIs
• usually interactive with changes in aggregation & filtering (central part of BI)

Question 5

ETL

Answer 5

• Extract, transform & load
• Process of organizing, cleaning & combining data from multiple sources (e.g. data warehouse or data lake):
  a) continuous (streaming) or
  b) batch process (e.g. daily)
• e.g. pipeline where data from multiple databases retrieved, cleaned & combined & then put in data warehouse
• SQL, Python, Alteryx

Question 6

ETL software

Answer 6

• Software designed for ETL operations on data
• without programming
• connecting data from one system to other e.g. from database to data visualization software

Question 7

Data visualization software

Answer 7

Software designed for: a) creating visualizations & dashboards, b) exploratory data analysis and c) reporting

Question 8

Data

Answer 8

• Facts that are recorded & can be accessed
• formats: text, numbers, images etc.

Question 9

Information

Answer 9

• Data that is accessed by a user for purpose
• often needs activity on data such as searching or manipulating

Question 10

Data Pipeline (BI architecture)

Answer 10

• Database or external software to retrieve data from (CRM, ERP, Cloud Service AWS)
• ETL (with SQL/Python, Alteryx)
• Data Warehouse to store data before analyzed by end-user
• Reporting / Analytics / Data Mining (Power BI / Tableau)

Question 11

Database

Answer 11

• structured collection of related data stored on computer
• organizes data so that efficient access to information captured in data

Question 12

Database system

Answer 12

• computer-based systems
• efficient interaction btw users & information captured in database

Question 13

Database Management System

Answer 13

• Software used for
• a) creation of databases
• b) insertion, storage, retrieval, update & deletion of data in database or
• c) maintenance of databases
• e,g Oracle, MySQL, SQlite