Building a Data Warehouse With Examples in SQL Server by Vincent Rainardi
  • InstantOn purchase
  • Full bookAll chapters
  • Any devicePC, tablet, phone
  • SecureSSL checkout
Authorised digital seller
On saleDigital download

Building a Data Warehouse With Examples in SQL Server by Vincent Rainardi

by Apress

Rated 4.9 by 12,400+ readers
$31.49 $99.99 Save 68%

Lowest price online, guaranteed. One-time payment, no subscription.

Publisher store $99.99
BooksGen $31.49

Download link emailed instantly after payment, 24/7

AMERICAN EXPRESSAPPLE PAYDINERS CLUBDISCOVERGOOGLE PAYKLARNA
30-day money-back guarantee

File issue? We replace it or refund you, no questions asked.

Digital product, nothing is shipped

You'll receive a download link by email immediately after checkout.

Can't find the ebook you need?

Send us the book cover via live chat and we'll request it for you. Typical response time: 10 minutes.

About this book

What's inside

Building a Data Warehouse: With Examples in SQL Server describes how to build a data warehouse completely from scratch and shows practical examples on how to do it. Author Vincent Rainardi also describes some practical issues he has experienced that developers are likely to encounter in their first data warehousing project, along with solutions and advice. The relational database management system (RDBMS) used in the examples is SQL Server; the version will not be an issue as long as the user has SQL Server 2005 or later.

The book is organized as follows. In the beginning of this book (chapters 1 through 6), you learn how to build a data warehouse, for example, defining the architecture, understanding the methodology, gathering the requirements, designing the data models, and creating the databases. Then in chapters 7 through 10, you learn how to populate the data warehouse, for example, extracting from source systems, loading the data stores, maintaining data quality, and utilizing the metadata. After you populate the data warehouse, in chapters 11 through 15, you explore how to present data to users using reports and multidimensional databases and how to use the data in the data warehouse for business intelligence, customer relationship management, and other purposes. Chapters 16 and 17 wrap up the book: After you have built your data warehouse, before it can be released to production, you need to test it thoroughly. After your application is in production, you need to understand how to administer data warehouse operation.

What you’ll learn A detailed understanding of what it takes to build a data warehouse The implementation code in SQL Server to build the data warehouse Dimensional modeling, data extraction methods, data warehouse loading, populating dimension and fact tables, data quality, data warehouse architecture, and database design Practical data warehousing applications such as business intelligence reports, analytics applications, and customer relationship management Who this book is for

There are three audiences for the book. The first are the people who implement the data warehouse. This could be considered a field guide for them. The second is database users/admins who want to get a good understanding of what it would take to build a data warehouse. Finally, the third audience is managers who must make decisions about aspects of the data warehousing task before them and use the book to learn about these issues.

How it works

From checkout to chapter one in seconds

0110 sec

Check out securely

Pay by card or wallet. Use an email address you can access right now.

02Instant

Get your link

Your download link arrives by email the moment your payment clears, 24/7.

03Forever

Read anywhere

Open it on your laptop, tablet or phone. Save it and keep it.

Why buy from us

Smarter than paying full price

100%

Authorised by publisher: licensed copy, never pirated.

–84%

Less than Amazon Kindle, with our lowest-price guarantee.

Instant

Delivered the moment your payment clears, day or night.

Full

Complete edition: every chapter, no missing pages.

Questions

Good to know

How do I receive my ebook?

Right after checkout we email you a download link. Check your spam folder if it doesn't arrive within a few minutes.

Which devices can I read it on?

Any computer, tablet or phone. PDF opens in any browser or free reader app.

I entered the wrong email. What now?

Contact us via live chat with your order number and we'll resend the link to the right address.

What if there's a problem with the file?

We'll replace it or refund you within 30 days, no questions asked.