| Wiki Markup |
|---|
{scrollbar}
|
Wikipedia
...
describes
...
'Business
...
Intelligence'
...
:
...
Business |
...
Intelligence |
...
(BI) |
...
refers |
...
to |
...
technologies, |
...
applications |
...
and |
...
practices |
...
for |
...
the |
...
collection, |
...
integration, |
...
analysis, |
...
and |
...
presentation |
...
of |
...
business |
...
information |
...
and |
...
sometimes |
...
to |
...
the |
...
information |
...
itself. |
...
The |
...
purpose |
...
of |
...
business |
...
intelligence-a |
...
term |
...
that |
...
dates |
...
at |
...
least |
...
to |
...
1958-is |
...
to |
...
support |
...
better |
...
business |
...
decision |
...
making. |
...
Thus, |
...
BI |
...
is |
...
also |
...
described |
...
as |
...
a |
...
decision |
...
support |
...
system |
...
(DSS) |
...
|
Reference: http://en.wikipedia.org/wiki/Business_intelligence
...
As
...
we
...
can
...
see
...
the
...
Business
...
Intelligence
...
market,
...
if
...
described
...
in
...
the
...
loosest
...
terms,
...
is
...
a
...
set
...
of
...
commonly
...
used
...
terminology,
...
tools,
...
and
...
technologies
...
that
...
are
...
used
...
to
...
solve
...
a
...
set
...
of
...
commonly
...
related
...
problems.
...
The
...
terminology,
...
tools,
...
and
...
technologies
...
include
...
(with
...
links
...
to
...
the
...
relevant
...
Wikipedia
...
entries):
...
- Reporting:
...
- standard
...
- reports,
...
- parameterized
...
- reports,
...
- ad-hoc
...
- reports,
...
- desktop
...
- reporting,
...
- report
...
- bursting,
...
...
...
- ,
...
- report
...
- server,
...
- self-service
...
- reporting
...
- Analysis:
...
- slice-and-dice,
...
- pivot
...
- tables,
...
- on-line
...
- analytical
...
- processing
...
- (OLAP),
...
- cubes,
...
- dimensions
...
- and
...
- hierarchies,
...
...
- down
- Storage Models: data marts, data warehouses, star schemas, snowflake schemas, fact tables, de-normalization,
- Data: data integration, Extract-Transform-Load
...
...
- ,
...
...
...
- ,
...
...
...
- ,
...
...
...
- ,
...
- metadata
- Predictive Analytics: data mining, predictive analytics and machine learning
- Analytical applications: balanced scorecard, Decision Support System (DSS), Executive Information System (EIS), dashboard
- Flavors: operational BI, real-time BI
[TODO
Describe (briefly):
- Reporting, analysis, dashboards, ad-hoc, OLAP
- Historical / trending vs live / operational reporting
- Transactional vs operation data store vs data-mart / data-warehouses.
- ETL
- Dimensions, attributes, measures, and keys
- Typical architectures
Include references to external sources.]]
Business Intelligence projects are often complex and expensive undertakings that have several problems.