Archive for the ‘Business Intelligence’ Category

SQL Server Data Warehousing concepts Video

An introduction to SQL Server data warehousing concepts

Data warehousing Concepts
Relational warehouse Concepts
Multi-Dimensional Concepts

Data Warehouse Components

Data Sources

ETL

Relational Data warehouse (SQL Server)

Dimensional Data warehouse (Analysis Services)

Graphical User Interface Tools

  • Use SQL to query relational warehouse
  • Use MDX (Multi dimensional expressionsĀ  to query cubes)
Reblog this post [with Zemanta]
Advertisements