Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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,

...

  • enterprise reporting
  • Data transformations: Extract-Transform-Load (ETL), Extract-Transform-Load (ELT)
  • Dashboards,
  • Analysis: slice-and-dice, pivot tables, on-line analytical processing (OLAP), cubes, dimensions and hierarchies, drill-downs
    *Storage Models: data marts, data warehouses

...

  • , star schemas, snowflake schemas, fact tables, de-normalization,
  • Predictive Analytics: data mining, predictivea analytics, machine learning
  • Analytical applications: balanced scorecards

...

  • Flavors: 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

...