1
Q
Business Intelligence (BI)
A
- Technology-driven process
- for gathering, storing, accessing & analyzing data
- for decision making (in businesses)
2
Q
common enterprise systems that provide data for BI
A
HRMS, CRM, ERP
3
Q
Visual Analytics (VA)
A
- BI method
- process of combining interactive visualizations
- with analytical reasoning
4
Q
Dashboard
A
- Collection of visualizations & KPIs
- usually interactive with changes in aggregation & filtering (central part of BI)
5
Q
ETL
A
- 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
6
Q
ETL software
A
- Software designed for ETL operations on data
- without programming
- connecting data from one system to other e.g. from database to data visualization software
7
Q
Data visualization software
A
Software designed for: a) creating visualizations & dashboards, b) exploratory data analysis and c) reporting
8
Q
Data
A
- Facts that are recorded & can be accessed
- formats: text, numbers, images etc.
9
Q
Information
A
- Data that is accessed by a user for purpose
- often needs activity on data such as searching or manipulating
10
Q
Data Pipeline (BI architecture)
A
- 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)
11
Q
Database
A
- structured collection of related data stored on computer
- organizes data so that efficient access to information captured in data
12
Q
Database system
A
- computer-based systems
- efficient interaction btw users & information captured in database
13
Q
Database Management System
A
- 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
