Apress - Building A Data Warehouse, With Examples In Sql Server (2015).pdf

cyan yeLLOW
  MAGENTA   BLACK
  PANTONE 123 C
Books for professionals by professionals® The EXPERT’s VOIce® in SQL Server
Companion
eBook Available
Building a Data Warehouse:
Building a Data Warehouse
With Examples in SQL Server With Examples in SQL Server
Dear Reader,
This book contains essential topics of data warehousing that everyone embarking
on a data warehousing journey will need to understand in order to build a data
warehouse. It covers dimensional modeling, data extraction from source systems,
dimension and fact table population, data quality, and database design. It also
explains practical data warehousing applications such as business intelligence,
analytic applications, and customer relationship management. All in all, the
book covers the whole spectrum of data warehousing from start to finish. Building a
I wrote this book to help people with a basic knowledge of database systems
who want to take their first step into data warehousing. People who are familiar
with databases such as DBAs and developers who have never built a data ware-
house will benefit the most from this book. IT students and self-learners will
also benefit. In addition, BI and data warehousing professionals will be interested
in checking out the practical examples, code, techniques, and architectures Data Warehouse
described in the book.
Throughout this book, we will be building a data warehouse using the
Amadeus Entertainment case study, an entertainment retailer specializing in
music, films, and audio books. We will use Microsoft SQL Server 2005 and 2008
to build the data warehouse and BI applications. You will gain experience designing With Examples in SQL Server
and building ponents of a data warehouse, including the architecture,
data model, physical databases (using SQL Server), ETL (using SSIS), BI reports
(using SSRS), OLAP cubes (using SSAS), and data mining (using SSAS).
I wish you great ess in y