Chapter 1 Design and implement a data warehouse

Designing and implementing a data warehouse with SQL Server requires an understanding of both the business processes that users want to report, analyze, and derive insights from and the structures that make up the logical and physical design of a data warehouse. The combination of these skills results in the design of a practical data model that can be used by business users to quickly answer business questions that most transactional systems cannot address efficiently.

IMPORTANT Have you read page xvii?

It contains valuable information regarding the skills you need to pass the exam.

This chapter covers how to create a logical and physical model of common business processes in a data warehouse ...

Get Exam Ref 70-767 Implementing a SQL Data Warehouse 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.