Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

BI & DM > Lecture 1 > Flashcards

Lecture 1 Flashcards

1
Q

Data management

A

Managing data as a valuable resource (mostly back-end)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Business Intelligence

A

Transforming data into meaningful information/knowledge to support business decision making (a.k.a. data-driven decision-making). Mostly front-end side.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Data

A

Items that are the most elementary descriptions of things, events, activities and transactions. Can be internal or external, structured or unstructured.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

(un)structured data

A

Most data is unstructured. During the data preparation, you make unstructured data structured. More and more unstructured data is becoming available over time.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Information

A

Organised data that has meaning and value.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Knowledge

A

Processed data or information that is applicable to a business decision problem. It is possible that some companies see certain data as information, where other companies see it as knowledge.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Taxonomy of Business Intelligence

A
  1. Descriptive analytics
  2. Predictive analytics
  3. Prescriptive analytics
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Descriptive analytics

A

Use data to understand past and present (SQL, OLAP)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Predictive analytics

A

Predict future behavior based on pas behavior. (Time series, clustering, decision trees, KNN)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Prescriptive analytics

A

Make decisions or recommendations to achieve the best performance. (Simulation, optimization, Ai)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Business Intelligence = Business Analytics

A

All decision support systems (DSS)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Business Intelligence (BI) (Process definition)

A

An umbrella term that combines processes, technologies, and tools needed to transform data into information, information into knowledge, and knowledge into plans that drive profitable business action.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Business Intelligence (BI) (Product definition)

A

Information and knowledge that enables business decision-making.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Objective of BI Product

A

Provide historical, current, and predictive views of business operations. Information/knowledge that could relate to:
- Understanding customer preferences.
- Coping with competition.
- Identifying with opportunities.
- Enhancing internal efficiency.
BI Solutions support the BI Process by utilizing BI Tools.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

BI Tools & Techniques

A
  • Data warehousing
  • Knowledge management
  • Query and reporting
  • Online analytical processing
  • Digital dashboards
  • Data, process, and text mining
  • Statistics
  • Visualisation
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Business Intelligence Architecture

A

Data flows through the veins of the organization.

17
Q

Business Intelligence Architecture

A
  1. Data is ‘produced’ (Business Database)
  2. Data is assembled, and stored (ETL Staging Area to Data warehouse)
  3. Data is processed, analyzed and consumed (Dashboards)
18
Q

OLAP Cubes (Online Analytical Processing)

A

Numeric (measures) data which can be put in different dimensions, product, time, and location.

19
Q

Databases

A

Backbone of business information systems (ERP). Supports decision making at all levels of the organization. Every time you are asked to input data, you’re accessing a database.

20
Q

Database

A

A collection of related tables, designed, maintained and utilized by multiple users, with software to update and query the data. Database system consists of:
- Data
- Software
- Hardware
- Users
Database is composed of objects and operations. Objects support operations.

21
Q

Database management systems (DBMS)

A

Software that controls the data.

22
Q

Database system possibilities

A

Allows users to:

  • Organize (CREATE)
  • Store (INSERT)
  • Update (UPDATE)
  • Delete (DELETE)
  • Retrieve their data (SELECT)
23
Q

Table

A

Structured list of data of a specific type. Each table has a name, and is divided into fields (columns) and records (rows).

24
Q

Relational database possibilities

A

Relational databases allow:

  • Data to be grouped into tables.
  • Sets relationships between tables.
25
Q

Join

A

Relationship between two tables using a common field. This is done with a primary key and a foreign key.

26
Q

Primary key

A

Fields that uniquely identifies each record in a table.
It consists of one or more attributes that determine other attributes. Key’s role is based on determinations: A -> B, C, D.
- If you know A you can look up B, C and D.
- B, C, D are functionally dependent on A

27
Q

Composite primary key

A

When a primary key contains multiple values.

28
Q

Superkey

A

Any key that uniquely identifies each row (potential primary key).

29
Q

Candidate key

A

Super key without unnecessary attributes.

30
Q

Foreign key

A

Attribute whose value matched the primary key values in the related table.

BI & DM (13 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions