Download the color images

We also provide a PDF file that has color images of the screenshots and diagrams used in this book. You can download it here: https://packt.link/Xxotr.

Conventions used

There are a number of text conventions used throughout this book.

Code in text: Indicates code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles. Here is an example: “All window functions can utilize the PARTITION BY expression of the OVER clause, which is always optional.”

A block of code is set as follows:

SELECT TOP (3) [Order Key]
      ,[Description]
  FROM [Fact].[Order]

When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:

SELECT TOP(3) FORMAT( [Date], 'D', 'en-US' ) 'US English'
      ,FORMAT( [Date], 'D', 'en-gb' ) 'British English'
      ,FORMAT( [Date], 'D', 'de-de' ) 'German'
      ,FORMAT( [Date], 'D', 'zh-cn' ) 'Chinese Simplified (PRC)'
 FROM [Dimension].[Date]

Bold: Indicates a new term, an important word, or words that you see onscreen. For instance, words in menus or dialog boxes appear in bold. Here is an example: “Next you will expand the Security and Users folders and find your login ID.”

Tips or important notes

Appear like this.