...
The terminology, tools, and technologies include: standard reports, parameterized reports, ad-hoc reports, desktop reporting, report bursting, data transformations, dashboards, slice-and-dice, pivot tables, on-line analytical processing (OLAP), cubes, dimensions and hierarchies, data marts, data warehouses, drill-downs, star schemas, snowflake schemas, fact tables, de-normalization, balanced scorecards, operational BI, real-time BI.
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.
BI projects are often complex and expensive undertakings that have several problems.