Skip Navigation Links
Info
Courses
Certifications
Technologies
Resources
Community
U2U Brussels +32 2 466 00 16 www.u2u.net

SQL Server 2005 Business Intelligence: Resource Center

Articles

  • Reporting Services can cache data, which improves both scalability (less load on the database) and response time. But the risk is that you are served outdated data... unless you automatically trigger your cache to be dropped and regenerated when the underlying data changes. This article tells you how to do this. It will show you how to 'manage' your Report Server using web services, and you'll learn about the .Net SqlDependencies as well.
  • If you are not familiar with the concept of OLAP databases, or you want to find out what is new in Analysis Services 2005, you can read this introductory article (only available in Dutch).
  • If you are not familiar with ETL (Extract, Transform and Load) concepts, or you want to know more about Integration Services, the replacement of old DTS (Data Transformation Services), you can check out this introductory article (only available in Dutch).

Courses

The big picture

For those people who want to get an overview of the three BI tools that ship with Sql Server 2005, we have a five day course which introduces you to Integration Services (the tool to transform data and load data from nearly any source to nearly any source), Analysis Services (the smart cache on top of your data warehouse which provides not only performant querying, but also data mining capabilities) and Reporting Services (to build those great looking reports on top of your valuable data).

A detailed look

  • You want to find out how you can combine that Excel file and an Access database into a single Oracle table? You want to build an RSS feed reader, filter and archiver in 5 minutes time? You need to find out how to refresh the data in the data warehouse? Welcome to our course on Integration Services.
  • Cubes are improving the query response time, and are more intuitive for your end users to use. And this software is part of your SQL Server license allready! What more do you want? Analytical data mining capabilities maybe? The course USQ5AS brings you the knowledge to use all this. Since there is some overlap with the overview course, you can also take a three day course which shows you the advanced features for those of you who already took the USQ5BI course.
  • Building and maintaining reports is the topic of the three day course USQ5RS.

Tools

  • Analysis Services Documenter is a tool developed by U2U, which generates documentation for an Analysis Services 2005 Database. It renders an HTML page which describes data sources, data source views, dimensions and cubes.
  • Analysis Services Best Practise Analyser checks your live OLAP databases against some key Best practises. Currently, it checks for aggregations, attribute relationships and non-empty behavior on calculations.