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: "In the Filename field, select the persons.csv file you downloaded."

A block of code is set as follows:

-- Lead Source Standardization
case 
when `LeadSource` = 'Patnes' then 'Partners'
when `LeadSource` = 'Diect' then 'Direct'
when `LeadSource` = 'Sales Ceated' then 'Sales Created'
when `LeadSource` = 'efeal' then 'Referral'
when `LeadSource` = 'Self-Souced' then 'Self-Sourced'
when `LeadSource` = 'Maketing Outbound' then 'Marketing Outbound'
when `LeadSource` = 'Stategic Accounts Maketing' then 'Strategic Accounts Marketing'
when `LeadSource` = 'Patneing' then 'Partners'
else `LeadSource` -- If not mapped then keep as is
end

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 
DATE(`LastModifiedDate`) as 'Date', 
SUM(case when `IsWon`= 'true' then 1 else 0 end) as 'Won',
-- Lost = Closed - Won
SUM(case when `IsClosed` = 'true' then 1 else 0 end) -
SUM(case when `IsWon`= 'true' then 1 else 0 end) as 'Lost',
SUM(case when `IsClosed` = 'true' then 1 else 0 end) as 'Closed'
FROM `opportunity_cleansed`
GROUP BY DATE(`LastModifiedDate`)
ORDER BY 1 DESC

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: "Python Script is the design tile to drag and drop for use in a dataflow."

Tips or important notes

Appear like this.