IntroductIon
durIng the economIc downturn that started in 2009, not many industries thrived in technology.
However, Business Intelligence did thrive, seeing double-digit growth at Microsoft as companies strived
to be more efficient with fewer resources. At Pragmatic Works, the Business Intelligence company
where this author team works, we started in 2009 with a small staff of four full-time consultants
and went into 2010 with nearly 30. You’ve picked the right technology to explore!
The best thing about Business Intelligence is it has a huge business impact on your users’ daily lives.
The reports and data that you bring to your users help those users make better decisions faster and
shine a light on how to save their company’s money. Business Intelligence can also use data mining
to upsell customers or find how much profit a user will make on a given date.
who thIs Book Is For
This is a beginner book and assumes that you only know SQL Server 2005 or 2008 to run queries
against the database engine. This book is structured with tutorials for a beginner; it focuses on only
the essential components and teaches you what need to complete your project at work or school. As
such, this is not a reference book filled with a description of every property in a given task.
what thIs Book covers
This book covers how to create Business Intelligence using SQL Server 2008 R2 and assumes no
previous knowledge of the Microsoft Business Intelligence set of products from SQL Server 2005
or 2008. Even t