SQL Server 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 and 2008, 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. If you want to find out what is new in SQL Server 2008 Reporting
services, attend the extra day on
Reporting Services 2008.
- 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.