WorksheetsISEL 303_M2 Quiz
Total questions: 65
Worksheet time: 33mins
Who handle raw data?
Data Analyst
Data Engineer
Data Scientist
All answers are correct
What are the Soft Skills needed by a Data Analyst?
Critical thinking and problem solving
Writing and communication
Domain knowledge
All answers are correct
What are the Business Intelligence tools?
C#
.Net
HTML
Power BI
Which of the following statement is true about Business Intelligence?
BI converts raw data into Meaningful Information
BI tools perform data analysis & create reports, dashboards, maps, graphs
BI has a direct impact on an organization's strategic, business decision
All of the Above
What does KPI stand for?
Key Performance Indicators
Key Processes Indicators
Key Performance Identifier
Key Processes Identifier
Data Visualization uses Business Intelligence because .........
It is a quick and accurate way to convey concepts in a universal manner.
Large amounts of complex data can be shown in an easy way
The human brain processes information fastly using charts or graphs
All of the Above
Data Visualization uses Business Intelligence because .........
It is a quick and accurate way to convey concepts in a universal manner.
Large amounts of complex data can be shown in an easy way
The human brain processes information fastly using charts or graphs
All of the Above
_____ is a system where operations like data extraction, transformation, and loading operations are executed
ETL
Data Mining
Data Integration
All of the Above
What is the Full form of SQL?
Structured Query Letter
Structured Quality Language
Structured Query Language
Simple Query Language
What are the Skill set required to become a BI developer ?
SQL
Excel
Power BI
All of the Above
What is Tableau Public?
Paid service
Open-source tool equivalent to Tableau Desktop
DataBase
IDE
What is the role of SQL?
Perform data related task
Data Visualization
Its ETL tool
its DataBase
Business Intelligence (BI) is a broad category of application programs which includes _________
Decision Support
Data Mining
Business Insights
All the Above
This is a traditional business serving customers in a building as
contrasted to an online business
click and mortar
revenue
audit
These are the moral principles that govern a person's behavior or the conducting of an activity.
business IQ
SEO
behavior
This is a broad term to describe a system of storing data on a different server and
accessing it via a network. The server could be offsite or onsite.
cookie
algorithm
ethics
This is an umbrella term that includes the applications, infrastructure, tools, and best
practices that enable access to and analysis of information to help organizations improve and
optimize decisions and performance
capital
single sign-on
bio
This is an official inspection of a company’s, or individual’s, accounts.
revenue
capital
SEO
This is income, especially when of a company or organization and of a substantial nature.
audit
geotargeting
ethics
A labeled element of a tuple, e.g. "Address" or "Date of birth" that describes a particular database entity is called
row
tuple
attribute
record
1) Which of the following best illustrates the relationship between entities and attributes?
The entity STUDENT with the attribute NAME
The entity NAME with the attribute COURSE
The entity NAME with the attribute STUDENT
The entity COURSE with the attribute NAME
Identify all issues faced by traditional file environment.
data inconsistency.
poor security.
lack of flexibility in creating ad-hoc reports.
inability to develop specialized applications for functional areas.
It occurs when the same data is duplicated in multiple files of a database.
Data independence
Data discrepancy
Data redundancy
Data repetition
Data ________ occurs when the same attribute in related data files has different values?
duplication
redundancy
inconsistency
discrepancy
_________ is the fact that a traditional file system cannot respond to unanticipated information requirements in a timely fashion is an example of issues with traditional file systems.
Poor security
Program-data dependence
Lack of data sharing
Lack of flexibility
____________ is a feature of DBMS to avoid data redundancy and inconsistency.
Ability to enforce referential integrity
Ability to minimize isolated files with repeated data
Ability to create two-dimensional tables
Use of a data dictionary
_____________ is an identified field that holds the unique identifier of records in a table.
Key field
Unique ID
Primary key
Primary field
DBMS has report-generating tools feature to help users to _________.
analyze the database's performance
display data in graphs
retrieve and display data
display data in an easier-to-read format
__________ streamlines data to minimize redundancy and awkward many-to-many relationships.
optimization
normalization
data cleansing
data scrubbing
Select all description that describe the term big data:
machine-generated data (i.e. from sensors)
datasets with unstructured data
data created by social media (i.e. tweets, Facebook
data from Web traffic.
Multiple data marts are combined and streamlined to create a data warehouse.
TRUE
FALSE
In-memory computing relies primarily on a computer (RAM) for data storage.
TRUE
FALSE
The term data governance refers to the policies and processes for managing the integrity and security of data in a firm.
TRUE
FALSE
Select all statements that is/are true about the importance of knowledge to a firm.
Knowledge experiences network effects as more people share it.
Knowledge should be seen as an intangible key asset.
Much of the firm's value relies on being able to create knowledge.
Knowledge enables firms to become more efficient in their use of scarce resources.
For a firm, organizational resources are unnecessary to transform data into knowledge.
TRUE
FALSE
_________ _________ combine operational data with analytical tools to present complex and competitive information to planners and decision makers.
(a)
Technologies, applications & practices for the collection, integration, analysis & presentation of business information
Business Concept
Business Intelligence
Business Information
Business Technology
BI stands for _____.
Business Intelligence
Business Informatics
Business Integration
Business Illustrative
BI major objective is to _____.
exploit data security
enable easy access to data and models
allow anyone to have access to data
create business intelligence system
Which is FALSE about BI?
Exploit data security
Transforms data to information and knowledge
Enables easy access to data and models
Helps to make decision and to take action
The environment in which organizations operate today is becoming _____ each day
simpler
more complex
impossible
a norm
What are some of the business environmental factors that make the business becoming more complex?
Supplier demand, advertisement companies, and technology
Supplier demand, markets, societal, and advertisement companies
Markets, consumer demands, technology, and societal
Advertisement companies, consumer demands, and societal
Strong competition, expanding global market, blooming e-market on the internet, and innovative marketing methods
Markets
Customer Demand
Technology
Societal
Desire for customization, quality, diversity of products and speed of delivery; since customers are becoming less loyal
Markets
Customer Demand
Technology
Societal
An organized collection of data
Source data
Data set
Database
Server
Which of the following cannot be answered using business intelligence
Where has the business been?
Where is the business now?
Where should the business go to improve the past
Where is the business going?
The tools that allow transformation of data into information and knowledge
Data warehouse
Business analytics
Business performance management
User interface
Allows monitoring, measuring, and comparing key performance indicators
Data warehouse
Business analytics
Business performance management
User interface
A large repository of well-organized historical data
Data warehouse
Business analytics
Business performance management
User interface
Allows access and easy manipulation of other BI components
Data warehouse
Business analytics
Business performance management
User interface
An analysis type that describe "what happened"
Historical
Operational
Analytical
Predictive
An analysis type that describe "why did it happen"
Historical
Operational
Analytical
Predictive
An analysis type that describe "what will happen happen"
Historical
Operational
Analytical
Predictive
An analysis type that describe "what's out there that I don't know about"
Prescriptive
Exploratory
Analytical
Predictive
An analysis type that describe "what should I do about it"
Prescriptive
Exploratory
Analytical
Predictive
What are the different types of data visualization techniques used in business intelligence?
Bar charts, line charts, scatter plots, pie charts, heat maps, histograms, etc.
Text charts, image charts, video charts, audio charts
Bar graphs, line graphs, word clouds, 3D charts
Alphabetical charts, numerical charts, color charts
Explain the concept of predictive analytics and its importance in business intelligence.
Predictive analytics is the use of astrology and tarot card readings to predict future business outcomes.
Predictive analytics is the process of randomly guessing future outcomes without any data or statistical analysis.
Predictive analytics is the use of historical data to analyze past events and has no importance in business intelligence.
Predictive analytics is the use of data, statistical algorithms, and machine learning techniques to identify the likelihood of future outcomes based on historical data. It is important in business intelligence as it helps in making informed decisions, identifying trends, and forecasting future events.
How can businesses ensure data quality for effective data analytics?
Relying solely on automated data collection without any validation
Ignoring data quality issues and using the data as is
Implementing data validation processes, using data cleaning tools, establishing data governance policies, and regularly monitoring and updating data
Hiring more employees to manually check the data
What are the benefits of using data analytics and business intelligence in decision-making?
It is too time-consuming and costly to implement
It only provides historical data with no predictive value
It has no impact on decision-making
It helps in making informed decisions by providing insights from data, identifying trends, and predicting future outcomes.
What is the difference between data analytics and business intelligence?
Data analytics focuses on analyzing and interpreting data to make informed decisions, while business intelligence involves the use of technology to gather, store, and analyze data to support business decision-making.
Data analytics is only used in small businesses, while business intelligence is only used in large corporations
Data analytics only involves qualitative data, while business intelligence only involves quantitative data
Data analytics and business intelligence are the same thing
What are the key components of a data analytics process?
Data storage, data encryption, data transmission
The key components of a data analytics process include data collection, data cleaning, data analysis, and data visualization.
Data analysis, data reporting, data encryption
Data visualization, data interpretation, data storage
