Font size
WorksheetsBusiness intelligence 2
Total questions: 25
Worksheet time: 20mins
Business intelligence (BI) is a broad category of applications programs which can include
Decision support
Report writing
Sales pitches
All of the above
What is an endpoint and why does it matter in Business Intelligence
The place where the data ends in the BI application
The place where data can be extracted from
The place where data enters the system
The place where data ends in a system
What is an API and why does it matter in BI
Academic Performance Index, a way to measure KPI's
application programming interface, a way to talk to databases
American Pacific Industry, the place where BI was first created
Air Pollution Index, a common measurement in BI systems
Business intelligence systems usually talk directly to databases
Yes, that is the fastest way to get new information
No, that will slow down the operation of the business
No, the totals need to be compounded for faster searching
Yes, that is the most reliable way to get information into the system
Yes, multipule in fact, then they use that information to make graphs! duhh
Please select all that apply: Business intelligence matters because
I can write easy reports
I can find information easy
I know If my company is making progress
I can do market research
I can make pretty graphs to impress my manager
What would be KPI"s that help with this We have the ambition to sell 10.000 cars of 100.000 euro plus this year in Germany
Number of cars sold over 100.000 euro
Number of cars sold in germany
Number of cars sold
Types of cars sold in germany
Ratio of female to male drivers in the germany
The way to build a good story with Data with 3 "easy steps" is
Introduction information conclusion
setup conflict resolution
problem conflict resolution
problem solution call-to-action
In business intelligence it is more important to:
Have more data so you can do more detailed analysis
Connect all it systems together
Have one central place where I collect data
Ask the right questions
Build very big dashboards
This is a broad category of applications and technologies for gathering, storing, analysing, and providing access to data to help enterprise users make better business decisions.
Data mining
Data mart
Business intelligence
Business intelligence warehousing
Artificial intelligence
The following sources can be used for Business intelligence (Multiple are correct)
Excel
SQL
ERP
CRM
None of the above
Business intelligence is often considered to be something very difficult, but honestly it's easy.
True
False
What is "data mining"
when you use a pickaxe to mine the data
when find the data and shout "MINE!"
process of uncovering patterns and other valuable information from large data sets
Using the internet to collect more data, sometimes unwillingly
What is an "Ad Hoc Query"
A query that is made out of the blue without any prior knowledge
creating a one-off, "on demand" report from BI or analytics software that answers a specific business question.
A latin phrase that helps to confuse people that you are talking to.
A performance management tool that holistically captures an organization's performance from several vantage points (e.g., sales results vs. inventory levels) on a single page.
What is a "data broker"
A company that selects data to be broken up into specific pieces to be analysed by other companies
A business that collects personal information about consumers and sells that information to other organizations.
A business intelligence computer component that will help the translation of different types of data into one format
A small data repository that is focused on information for a specific subject area of the company, such as Sales, Finance, or Marketing.
What is a data warehouse
Data that gives information about what the primary data is about (e.g., if a photo is the primary data, its metadata might consist of what its resolution is, when the photo was taken, etc.).
Data manipulation tools in reporting or spreadsheet software that allow users to view data from any angle.
A view of data at a particular moment in time.
A data repository that deals with multiple subject areas (or data marts).
In simple terms why we use business intelligence is to..
A) Report B) make Decisions C) Do Conversation
A) Bill B) Make Graphs C) Find information
A) Find information B) Make Graphs C) Do Calculations
A) Do predictions B) Make Graphs C) Make Reports
What does KPI stand for in BI?
Key Pad Interface
Critical Performance Indicator
Key Persons Index
Key Performance Indicator
What is a "data steward" ?
Someone that makes sure that data is correctly imputed into the system correctly
Someone that "takes care" of the data, so that it does not get lost
A technical component that ships data from one system to another
In Business intelligence, this is another word for Data Custodian, a person who is responsible for the information in the system and will hand it over once true king of data arrives
Business intelligence is only possible with big applications like powerBI
Yes, Expensive software is nessecairy
Yes, if it doesn't have a database, it's not really BI
No, anything can be used as business intelligence.
No, Business intelligence means using data to support your case and displaying it in an understandable way.
What is business intelligence
A automated system managing our business
A system to sort data and help us be more efficient
A program giving business models
All of the above
{look at pic} This area of application of data mining is referred to as:
Market analysis
Expert system
Customer segmentation
Vertical integration
One of the following is wrong ! Which one ?!
BI tries to improve efficiency
BI improves visibility
BI controls consumer's behaviour
BI turns data into actionable data
Do you agree with manager's statement? Assume the data is true and representative
There is a correlation so it must be true.
Even though it shows a correlation the underlying assumption is wrong
This doesn't make any sense
What are the 4 components of a KPI
Metric, Purpose, Status and Trend
Metric, Purpose, Structure and trend
Metric, Pupose, status, Target
Metric, Purpose, Stucture, target
What does OLAP stand for
Online transformational processing
Online transaction processing
Online transitional processing
Online Logical Analyse Protocol
