ADM 1370 Lecture Notes - Lecture 14: Business Intelligence, Context Menu, Clip Art
Class 14
Excel as a Front-End Tool for Business Intelligence
• Business intelligence
o A broad category of applications and technologies for gathering, storing,
analyzing, sharing and providing access to data to help enterprise users make
better business decisions
o BI applications are decision support tools that enable real-time, interactive access,
analysis and manipulation of mission-critical corporate information
o Components (R-A-D)
▪ Reporting
▪ Regular mass information dissemination in a standard format
▪ Analytics
▪ Slicing and Dicing with visual feedback and interactivity
▪ Mainly for the middle management - for the tactical decisions and
to guide strategic decisions
▪ Dashboards
▪ Quick distilled snapshots, highlighting the key indices, for instant
decision making
• Dashboards
o (I.e) car content
▪ A panel extending across interior of a vehicle, usualing containing
instruments and controls
o BI context
▪ A visual display of the most important information needed to achieve
business objectives - consolidated and arranged in a single screen so the
information can be monitored at a glance
• Key ideas
o More than just data (data -> information)
o Visual tool with graphical displays of key performance indicators (KPIs)
o Information is organized and presented in a way that is easy to read and interpret
(at a glance)
• Types of BI dashboards
o Strategic dashboards
▪ Provides quick overview that decision makers need for monitoring the
health and opportunities of the business
▪ Typically derived form static snapshots of data, and focus on high-level
measures of performance
▪ Comparisons with rage or levels
▪ Performance indicated categorically or on scales (good/bad;
high/medium/low)
o Analytical dashboards
▪ Support more sophisticated data analysis by facilitating by facilitating rich
companions, and fine grained performance evaluation (drill-down;slice-
and-dice)
find more resources at oneclass.com
find more resources at oneclass.com