BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+
GRADED
Comma-separated values (CSV)
Uses commas to separate data into columns and a newline character to separate data
in to rows
Data model
collection of related tables that contain structured data used to create a database;
enables you to integrate data from multiple sources within a workbook
data shaping
the process of editing information from one or more data sources to desired parameters
before importing into an application
data visualization
method of summarizing data visually to better understand the significance of the
information
delimiter
special characters (tab or space) that separate data
dimension
attributes that contribute to the visualization of data
embed
act of importing external data into excel but not maintaining a link to the original data
source
external data properties
settings that control how imported data connects to the external data source
fixed-width text file
a file in which each column contains a specific number of characters
importing
process of inserting external data- data created or stored in another format- into the
current application
newline character
special character that designates the end of a line and separates data for the next line
or row
power BI
online application suite designed to help users manage, supplement, visualize, and
analyze data
power pivot
A built in add in program that enables users to create a pivot table from multiple related
tables
offers key functionality included in excel's stock pivot table
power query editor
business intelligence tool that can connect and shape data from multiple sources
refresh
updates the linked data in an excel workbook with the most up to date information
relationship
GRADED
Comma-separated values (CSV)
Uses commas to separate data into columns and a newline character to separate data
in to rows
Data model
collection of related tables that contain structured data used to create a database;
enables you to integrate data from multiple sources within a workbook
data shaping
the process of editing information from one or more data sources to desired parameters
before importing into an application
data visualization
method of summarizing data visually to better understand the significance of the
information
delimiter
special characters (tab or space) that separate data
dimension
attributes that contribute to the visualization of data
embed
act of importing external data into excel but not maintaining a link to the original data
source
external data properties
settings that control how imported data connects to the external data source
fixed-width text file
a file in which each column contains a specific number of characters
importing
process of inserting external data- data created or stored in another format- into the
current application
newline character
special character that designates the end of a line and separates data for the next line
or row
power BI
online application suite designed to help users manage, supplement, visualize, and
analyze data
power pivot
A built in add in program that enables users to create a pivot table from multiple related
tables
offers key functionality included in excel's stock pivot table
power query editor
business intelligence tool that can connect and shape data from multiple sources
refresh
updates the linked data in an excel workbook with the most up to date information
relationship
