Chapter VI.2. Creating Business Intelligence Solutions with BIDS

Business intelligence translates raw data into usable information — exactly what business managers need to make intelligent decisions. Whether a manager is overseeing 100 different projects, or 100 different retail stores, she must be able to view the key information. By creating cubes from databases, you can convert raw data into usable information.

The Business Intelligence Development Studio (BIDS) is the central tool used to create SQL Server Analysis Services (SSAS) projects. You can use it to create, modify, and manage cubes. In this chapter, you create a cube and gain a better understanding of the details that can be added to a cube from within BIDS.

Get Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies® now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.