Jump to ratings and reviews
Rate this book

Pro SQL Server 2012 BI Solutions

Rate this book
Business Intelligence Solutions


A Big Picture Overview


Planning Solutions


Designing a Data Warehouse


Creating a Data Warehouse


ETL Processing with SQL


Beginning the ETL Process with SSIS


Concluding the ETL Process with SSIS


Beginning the SSAS Project


Configuring Dimensions with SSAS


Creating and Configuring SSAS Cubes


Additional Cube and Dimension Configurations


Creating Reports with SQL Queries


Reporting with MDX Queries


Reporting with Microsoft Excel

Creating Reports with SSRS

Configuring Reports with SSRS


Testing and Tuning BI Solutions


Approve, Release, and Prepare

836 pages, Paperback

First published August 29, 2012

Loading...
Loading...

About the author

Randal Root

2 books

Ratings & Reviews

What do you think?
Rate this book

Friends & Following

Create a free account to discover what your friends think of this book!

Community Reviews

5 stars
8 (28%)
4 stars
10 (35%)
3 stars
6 (21%)
2 stars
3 (10%)
1 star
1 (3%)
Displaying 1 - 3 of 3 reviews
661 reviews15 followers
March 19, 2019
Easy-to-follow textbook that explains the process of designing and implementing a BI solution using SQL Server and Visual Studio. Lots of screenshots, and chapter exercises with clear instructions.
Profile Image for Andreas.
36 reviews3 followers
September 5, 2014
This book of Randal will get you started with SSIS, SSAS and SSRS in no time! Depending on your level of experience, you will be running a simple, yet full ETL, OLAP and reporting service within a day to week. More concretely, you will learn how to tackle a BI project, which steps you have to follow, how to identify data sources, bring them together (SSIS) and make them available for analysis (SSAS and SSRS).

Mind that this book is mostly technology-focused. This means you will learn to use Microsoft ETL and OLAP tools. It will not provide you with the necessary insights and skills to successfully deliver a BI project. For that purpose, there are other books out there (e.g. Kimballs book on datawarehousing).
Displaying 1 - 3 of 3 reviews