BI EXAM QUESTIONS AND ANSWERS
1. Why is a Business Strategy important in order to successfully apply Business
Intelligence in an organisation?- answer - 1. The business strategy is a long term plan of the
organisation and includes investment strategies which must be aligned with the investment in IT required by BI
2. Investment in BI must have upper management support due to substantial investment costs and ROI
3. BI can transform the organisation through transformative business processes and due to this must be aligned with
strategy so changes are anticipated and can be planned.
4. BI is linked to performance management which is critical to business strategy for its ability to monitor and support
long term goals.
5. BI can support developing and shaping business strategy. BI can support the lifecycle of a plan
- strategise
- Plan
- Monitor
- Analyse
- Act
- Adjust
2. What is "Quantity of Users"?- answer - It represents the
hierarchical pyramid- answer - TOP - Few decision makers
BOTTOM - Statt responsible for operations within the organisation
BI supports all levels, but on all levels there is a ditterent number of end users.
3. What does 'Clear Visualisation of Data Low vs. High' mean?- answer - On the
,top HIGH - Decisions makers need a clear overall picture of the whole organisation and strategic decisions made
on this level have a high impact on the organisation.
On the Bottom LOW - The operations also benefit from visual data but do not require the overall picture. They focus on daily
operations, quick simple decisions that have low impact on the overall organisation.
4. Explain the different Bi Focus on the left hand side?- answer - On the TOP - Decision
makers are responsble for long term plans and actions that shape the organisation in the long term. BI can support
the business strategy of the entity through monitoring, analysing, acting and adjusting.
, On the BOTTOM - Statt deal with transaction-realted info (sales, customer requests). BI's focus on the daily operations looks
at planning how many request will come in or staflng to handle the operation.
5. Mention four typical questions that should be addressed in the beginning of
a BI
project lifecycle?- answer - 1. Where do
we want to be (Corporate plans, KPI, Metrics)
2. How are we
performing? (Past
trends & Future
Forecasts)
3. Why are we on/ott/ahead of track?
- What is contributing to success or failure
- How do they interrelate and impact eachother
- What are the costs/ demand / risk driver
4. What can we do about it?
(What changes could be made and where?)
6. Self-service BI tools are regarded as a better solution compared to a large
scale BI platform solution. What are the drawbacks of self service BI solutions?-
- answer - - Data must be managed by end user manuall which is expensive.
- No support to ensure high quality data
- Performance with large set of data is a problem
- There is no security
- Lack of Data Governance
- No Standards in Place
1. Why is a Business Strategy important in order to successfully apply Business
Intelligence in an organisation?- answer - 1. The business strategy is a long term plan of the
organisation and includes investment strategies which must be aligned with the investment in IT required by BI
2. Investment in BI must have upper management support due to substantial investment costs and ROI
3. BI can transform the organisation through transformative business processes and due to this must be aligned with
strategy so changes are anticipated and can be planned.
4. BI is linked to performance management which is critical to business strategy for its ability to monitor and support
long term goals.
5. BI can support developing and shaping business strategy. BI can support the lifecycle of a plan
- strategise
- Plan
- Monitor
- Analyse
- Act
- Adjust
2. What is "Quantity of Users"?- answer - It represents the
hierarchical pyramid- answer - TOP - Few decision makers
BOTTOM - Statt responsible for operations within the organisation
BI supports all levels, but on all levels there is a ditterent number of end users.
3. What does 'Clear Visualisation of Data Low vs. High' mean?- answer - On the
,top HIGH - Decisions makers need a clear overall picture of the whole organisation and strategic decisions made
on this level have a high impact on the organisation.
On the Bottom LOW - The operations also benefit from visual data but do not require the overall picture. They focus on daily
operations, quick simple decisions that have low impact on the overall organisation.
4. Explain the different Bi Focus on the left hand side?- answer - On the TOP - Decision
makers are responsble for long term plans and actions that shape the organisation in the long term. BI can support
the business strategy of the entity through monitoring, analysing, acting and adjusting.
, On the BOTTOM - Statt deal with transaction-realted info (sales, customer requests). BI's focus on the daily operations looks
at planning how many request will come in or staflng to handle the operation.
5. Mention four typical questions that should be addressed in the beginning of
a BI
project lifecycle?- answer - 1. Where do
we want to be (Corporate plans, KPI, Metrics)
2. How are we
performing? (Past
trends & Future
Forecasts)
3. Why are we on/ott/ahead of track?
- What is contributing to success or failure
- How do they interrelate and impact eachother
- What are the costs/ demand / risk driver
4. What can we do about it?
(What changes could be made and where?)
6. Self-service BI tools are regarded as a better solution compared to a large
scale BI platform solution. What are the drawbacks of self service BI solutions?-
- answer - - Data must be managed by end user manuall which is expensive.
- No support to ensure high quality data
- Performance with large set of data is a problem
- There is no security
- Lack of Data Governance
- No Standards in Place
