CERTIFIED SPECIALIST BUSINESS
INTELLIGENCE EXAM COMPLETE SOLUTION
STUDY GUIDE
◉ data analyst.
Answer: Collects, queries, and consumes organizational data to
uncover patterns and provide insights for strategic business
decision making.
◉ data scientist.
Answer: extracts knowledge from data by performing statistical
analysis, data mining, and advanced analytics on big data to identify
trends, market changes, and other relevant information
◉ three skills for a data analyst.
Answer: understanding of math and statistics + coding skills to work
with data + business area subject matter expertise
◉ Four categories of analytics.
Answer: descriptive, diagnostic, predictive, prescriptive
◉ Descriptive analytics.
,Answer: -describes past performance and history
-ex: creating a report that includes charts and grpahs that explains
the data or what happened in the past
◉ Diagnostic Analytics.
Answer: -examines data or content to asnwer the question "why did
it happen?"
-ex: helps you understand why something happened in the past such
as a decrease in online sales or an increase in online sales during a
particular season
◉ Predictive Analytics.
Answer: -techniques that extract information from data to predict
future trends and identify behavioral patters
-ex: using past sales data to predict what is most likely to happen for
future sales
◉ Prescriptive Analytics.
Answer: -creates models indicating the best decision to make or
course of action to take
-ex: airline using past purchasing data as inputs into a model that
recommends the best pricing strategy across all fights allowing the
company to maximize revenue
,◉ knowledge.
Answer: -skills,experience and expertise coupled with information
and intelligence that creates a person's intellectual resources
-knowledge assets
-knowledge facilitators
-knowledge worker
◉ data silo.
Answer: when one unit is unable to freely communicate with other
business units, making it difficult or impossible for organizations to
work cross-functionally
◉ data democratization.
Answer: the ability for data to be collected, analyzed, and accessible
to all users
◉ sales.
Answer: -potential customer data
-sales report data
-commission data
-customer support data
◉ accounting.
, Answer: -transactional data
-purchasing data
-payroll data
-tax data
◉ finance.
Answer: -investment data
-monetary data
-reporting data
◉ operations management.
Answer: -manufacturing data
-distribution data
-production data
◉ marketing.
Answer: -promotion data
-sales data
-advertising data
◉ finance.
Answer: -investment data
INTELLIGENCE EXAM COMPLETE SOLUTION
STUDY GUIDE
◉ data analyst.
Answer: Collects, queries, and consumes organizational data to
uncover patterns and provide insights for strategic business
decision making.
◉ data scientist.
Answer: extracts knowledge from data by performing statistical
analysis, data mining, and advanced analytics on big data to identify
trends, market changes, and other relevant information
◉ three skills for a data analyst.
Answer: understanding of math and statistics + coding skills to work
with data + business area subject matter expertise
◉ Four categories of analytics.
Answer: descriptive, diagnostic, predictive, prescriptive
◉ Descriptive analytics.
,Answer: -describes past performance and history
-ex: creating a report that includes charts and grpahs that explains
the data or what happened in the past
◉ Diagnostic Analytics.
Answer: -examines data or content to asnwer the question "why did
it happen?"
-ex: helps you understand why something happened in the past such
as a decrease in online sales or an increase in online sales during a
particular season
◉ Predictive Analytics.
Answer: -techniques that extract information from data to predict
future trends and identify behavioral patters
-ex: using past sales data to predict what is most likely to happen for
future sales
◉ Prescriptive Analytics.
Answer: -creates models indicating the best decision to make or
course of action to take
-ex: airline using past purchasing data as inputs into a model that
recommends the best pricing strategy across all fights allowing the
company to maximize revenue
,◉ knowledge.
Answer: -skills,experience and expertise coupled with information
and intelligence that creates a person's intellectual resources
-knowledge assets
-knowledge facilitators
-knowledge worker
◉ data silo.
Answer: when one unit is unable to freely communicate with other
business units, making it difficult or impossible for organizations to
work cross-functionally
◉ data democratization.
Answer: the ability for data to be collected, analyzed, and accessible
to all users
◉ sales.
Answer: -potential customer data
-sales report data
-commission data
-customer support data
◉ accounting.
, Answer: -transactional data
-purchasing data
-payroll data
-tax data
◉ finance.
Answer: -investment data
-monetary data
-reporting data
◉ operations management.
Answer: -manufacturing data
-distribution data
-production data
◉ marketing.
Answer: -promotion data
-sales data
-advertising data
◉ finance.
Answer: -investment data