Chapter
Chapter
14Chapter
–14Comprehensive
–14Comprehensive
– Comprehensive
Data Data
Management
Data
Management
Management
and Reporting
and Reporting
and in
Reporting
Business
in Business
inIntelligence
Business
Intelligence
Intelligence
– Lecture
– Lecture
–
Summary
Lecture
Summary
and
Summary
Exam
and Exam
and
Revision
Exam
Revision
Material.pdf
Revision
Material.pdf
Material.pdf
Chapter 14 –
Comprehensive
Data Management
and Reporting in
Business
Intelligence –
Lecture Summary
and Exam Revision
Material
Chapter
Chapter
14Chapter
–14Comprehensive
–14Comprehensive
– Comprehensive
Data Data
Management
Data
Management
Management
and Reporting
and Reporting
and in
Reporting
Business
in Business
inIntelligence
Business
Intelligence
Intelligence
– Lecture
– Lecture
–
Summary
Lecture
Summary
and
Summary
Exam
and Exam
and
Revision
Exam
Revision
Material.pdf
Revision
Material.pdf
Material.pdf
, Chapter 14_ Comprehensive Data Management and Reporting in Business Intelligence.pdf Chapter 14_ Comprehensive Data Management and Reporting in Business Intelligence.pdf Chapter 14_ Comprehensive Data Management and Reporting in Business Intelligence.pdf
What are the three steps in the data extraction 1. Understand data needs and the data available. 2. Perform the data extraction.
process? 3. Verify the data extraction quality and document what you have done.
What is structured data? Data that is highly organized and fits into fixed fields, such as general ledger
data and data in relational databases.
What is unstructured data? Data that has no uniform structure, such as images, audio files, documents,
social media posts, and emails.
Define semi-structured data. Data that is organized in some ways but not fully organized to be inserted into
a relational database, like data stored in CSV or XML formats.
What is a data warehouse? A collection of information gathered from various external and operational
databases to facilitate reporting for decision making and business analysis.
What is the main purpose of a data warehouse? To serve as the main repository of a firm's historical data, acting as its
corporate memory and an archive of past performance.
How does a data mart differ from a data warehouse? A data mart is a smaller data repository that holds structured data for a subset
of an organization, making it faster to access and process.
Chapter 14_ Comprehensive Data Management and Reporting in Business Intelligence.pdf Chapter 14_ Comprehensive Data Management and Reporting in Business Intelligence.pdf Chapter 14_ Comprehensive Data Management and Reporting in Business Intelligence.pdf
Chapter
14Chapter
–14Comprehensive
–14Comprehensive
– Comprehensive
Data Data
Management
Data
Management
Management
and Reporting
and Reporting
and in
Reporting
Business
in Business
inIntelligence
Business
Intelligence
Intelligence
– Lecture
– Lecture
–
Summary
Lecture
Summary
and
Summary
Exam
and Exam
and
Revision
Exam
Revision
Material.pdf
Revision
Material.pdf
Material.pdf
Chapter 14 –
Comprehensive
Data Management
and Reporting in
Business
Intelligence –
Lecture Summary
and Exam Revision
Material
Chapter
Chapter
14Chapter
–14Comprehensive
–14Comprehensive
– Comprehensive
Data Data
Management
Data
Management
Management
and Reporting
and Reporting
and in
Reporting
Business
in Business
inIntelligence
Business
Intelligence
Intelligence
– Lecture
– Lecture
–
Summary
Lecture
Summary
and
Summary
Exam
and Exam
and
Revision
Exam
Revision
Material.pdf
Revision
Material.pdf
Material.pdf
, Chapter 14_ Comprehensive Data Management and Reporting in Business Intelligence.pdf Chapter 14_ Comprehensive Data Management and Reporting in Business Intelligence.pdf Chapter 14_ Comprehensive Data Management and Reporting in Business Intelligence.pdf
What are the three steps in the data extraction 1. Understand data needs and the data available. 2. Perform the data extraction.
process? 3. Verify the data extraction quality and document what you have done.
What is structured data? Data that is highly organized and fits into fixed fields, such as general ledger
data and data in relational databases.
What is unstructured data? Data that has no uniform structure, such as images, audio files, documents,
social media posts, and emails.
Define semi-structured data. Data that is organized in some ways but not fully organized to be inserted into
a relational database, like data stored in CSV or XML formats.
What is a data warehouse? A collection of information gathered from various external and operational
databases to facilitate reporting for decision making and business analysis.
What is the main purpose of a data warehouse? To serve as the main repository of a firm's historical data, acting as its
corporate memory and an archive of past performance.
How does a data mart differ from a data warehouse? A data mart is a smaller data repository that holds structured data for a subset
of an organization, making it faster to access and process.
Chapter 14_ Comprehensive Data Management and Reporting in Business Intelligence.pdf Chapter 14_ Comprehensive Data Management and Reporting in Business Intelligence.pdf Chapter 14_ Comprehensive Data Management and Reporting in Business Intelligence.pdf
