****************************************************************************************************
Location : Tableau Server
Host     : http://bnbrepository9/#/
Path     : Tableau Samples/SalesForce 1
****************************************************************************************************

-------------------------------------------------- Datasource Opportunities (Salesforce) --------------------------------------------------

-- Query(s)

SELECT 
	[Opportunities].[Id] AS [Opportunity ID],
	[Opportunities].[IsDeleted] AS [IsDeleted (Opportunities)],
	[Opportunities].[AccountId] AS [AccountId (Opportunities)],
	[Opportunities].[IsPrivate] AS [Private],
	[Opportunities].[Name] AS [Name (Opportunities)],
	[Opportunities].[StageName] AS [Stage],
	[Opportunities].[Amount],
	[Opportunities].[Probability] AS [Probability (%)],
	[Opportunities].[ExpectedRevenue] AS [Expected Amount],
	[Opportunities].[TotalOpportunityQuantity] AS [Quantity],
	[Opportunities].[CloseDate] AS [Close Date],
	[Opportunities].[Type] AS [Opportunity Type],
	[Opportunities].[NextStep] AS [Next Step],
	[Opportunities].[LeadSource] AS [Lead Source],
	[Opportunities].[IsClosed] AS [Closed],
	[Opportunities].[IsWon] AS [Won],
	[Opportunities].[ForecastCategory] AS [Forecast Category],
	[Opportunities].[ForecastCategoryName] AS [Forecast Category1],
	[Opportunities].[CampaignId] AS [Campaign ID],
	[Opportunities].[HasOpportunityLineItem] AS [Has Line Item],
	[Opportunities].[Pricebook2Id] AS [Price Book ID],
	[Opportunities].[OwnerId] AS [OwnerId (Opportunities)],
	[Opportunities].[CreatedDate] AS [CreatedDate (Opportunities)],
	[Opportunities].[CreatedById] AS [CreatedById (Opportunities)],
	[Opportunities].[LastModifiedDate] AS [LastModifiedDate (Opportunities)],
	[Opportunities].[LastModifiedById] AS [LastModifiedById (Opportunities)],
	[Opportunities].[SystemModstamp] AS [SystemModstamp (Opportunities)],
	[Opportunities].[LastActivityDate] AS [LastActivityDate (Opportunities)],
	[Opportunities].[FiscalQuarter] AS [Fiscal Quarter],
	[Opportunities].[FiscalYear] AS [Fiscal Year],
	[Opportunities].[Fiscal] AS [Fiscal Period],
	[Opportunities].[LastViewedDate] AS [Last Viewed Date],
	[Opportunities].[LastReferencedDate] AS [Last Referenced Date],
	[Opportunities].[DeliveryInstallationStatus__c] AS [Delivery/Installation Status],
	[Opportunities].[TrackingNumber__c] AS [Tracking Number],
	[Opportunities].[OrderNumber__c] AS [Order Number],
	[Opportunities].[CurrentGenerators__c] AS [Current Generator(s)],
	[Opportunities].[MainCompetitors__c] AS [Main Competitor(s)]
FROM
	[Opportunity] AS [Opportunities]

SELECT 
	[Account].[Id] AS [Id (Account)],
	[Account].[IsDeleted] AS [Deleted],
	[Account].[MasterRecordId] AS [Master Record ID],
	[Account].[Name] AS [Account Name],
	[Account].[Type] AS [Account Type],
	[Account].[ParentId] AS [Parent Account ID],
	[Account].[BillingStreet] AS [Billing Street],
	[Account].[BillingCity] AS [Billing City],
	[Account].[BillingState] AS [Billing State/Province],
	[Account].[BillingPostalCode] AS [Billing Zip/Postal Code],
	[Account].[BillingCountry] AS [Billing Country],
	[Account].[BillingLatitude] AS [Billing Latitude],
	[Account].[BillingLongitude] AS [Billing Longitude],
	[Account].[ShippingStreet] AS [Shipping Street],
	[Account].[ShippingCity] AS [Shipping City],
	[Account].[ShippingState] AS [Shipping State/Province],
	[Account].[ShippingPostalCode] AS [Shipping Zip/Postal Code],
	[Account].[ShippingCountry] AS [Shipping Country],
	[Account].[ShippingLatitude] AS [Shipping Latitude],
	[Account].[ShippingLongitude] AS [Shipping Longitude],
	[Account].[Phone] AS [Account Phone],
	[Account].[Fax] AS [Account Fax],
	[Account].[AccountNumber] AS [Account Number],
	[Account].[Website],
	[Account].[PhotoUrl] AS [Photo URL],
	[Account].[Sic] AS [SIC Code],
	[Account].[Industry],
	[Account].[AnnualRevenue] AS [Annual Revenue],
	[Account].[NumberOfEmployees] AS [Employees],
	[Account].[Ownership],
	[Account].[TickerSymbol] AS [Ticker Symbol],
	[Account].[Rating] AS [Account Rating],
	[Account].[Site] AS [Account Site],
	[Account].[OwnerId] AS [Owner ID],
	[Account].[CreatedDate] AS [CreatedDate (Account)],
	[Account].[CreatedById] AS [CreatedById (Account)],
	[Account].[LastModifiedDate] AS [LastModifiedDate (Account)],
	[Account].[LastModifiedById] AS [LastModifiedById (Account)],
	[Account].[SystemModstamp] AS [SystemModstamp (Account)],
	[Account].[LastActivityDate] AS [Last Activity],
	[Account].[LastViewedDate] AS [LastViewedDate (Account)],
	[Account].[LastReferencedDate] AS [LastReferencedDate (Account)],
	[Account].[Jigsaw] AS [Data.com Key],
	[Account].[JigsawCompanyId] AS [Jigsaw Company ID],
	[Account].[CleanStatus] AS [Clean Status],
	[Account].[AccountSource] AS [Account Source],
	[Account].[DunsNumber] AS [D-U-N-S Number],
	[Account].[Tradestyle],
	[Account].[NaicsCode] AS [NAICS Code],
	[Account].[NaicsDesc] AS [NAICS Description],
	[Account].[YearStarted] AS [Year Started],
	[Account].[SicDesc] AS [SIC Description],
	[Account].[DandbCompanyId] AS [D&B Company ID],
	[Account].[CustomerPriority__c] AS [Customer Priority],
	[Account].[SLA__c] AS [SLA],
	[Account].[Active__c] AS [Active__c (Account)],
	[Account].[NumberofLocations__c] AS [Number of Locations],
	[Account].[UpsellOpportunity__c] AS [Upsell Opportunity],
	[Account].[SLASerialNumber__c] AS [SLA Serial Number],
	[Account].[SLAExpirationDate__c] AS [SLA Expiration Date]
FROM
	[Account]

SELECT 
	[Owned By].[Id] AS [User ID],
	[Owned By].[Username],
	[Owned By].[LastName] AS [Last Name],
	[Owned By].[FirstName] AS [First Name],
	[Owned By].[Name] AS [Full Name],
	[Owned By].[CompanyName] AS [Company Name],
	[Owned By].[Division],
	[Owned By].[Department],
	[Owned By].[Title],
	[Owned By].[Street],
	[Owned By].[City],
	[Owned By].[State] AS [State/Province],
	[Owned By].[PostalCode] AS [Zip/Postal Code],
	[Owned By].[Country],
	[Owned By].[Latitude],
	[Owned By].[Longitude],
	[Owned By].[Email] AS [E-mail],
	[Owned By].[EmailPreferencesAutoBcc] AS [AutoBcc],
	[Owned By].[EmailPreferencesAutoBccStayInTouch] AS [AutoBccStayInTouch],
	[Owned By].[EmailPreferencesStayInTouchReminder] AS [StayInTouchReminder],
	[Owned By].[SenderEmail] AS [Email Sender Address],
	[Owned By].[SenderName] AS [Email Sender Name],
	[Owned By].[Signature] AS [Email Signature],
	[Owned By].[StayInTouchSubject] AS [Stay-in-Touch Email Subject],
	[Owned By].[StayInTouchSignature] AS [Stay-in-Touch Email Signature],
	[Owned By].[StayInTouchNote] AS [Stay-in-Touch Email Note],
	[Owned By].[Phone],
	[Owned By].[Fax],
	[Owned By].[MobilePhone] AS [Cell],
	[Owned By].[Alias],
	[Owned By].[CommunityNickname] AS [Nickname],
	[Owned By].[IsBadged] AS [User Photo has a badge overlay],
	[Owned By].[IsActive] AS [Active],
	[Owned By].[TimeZoneSidKey] AS [Time Zone],
	[Owned By].[UserRoleId] AS [Role ID],
	[Owned By].[LocaleSidKey] AS [Locale],
	[Owned By].[ReceivesInfoEmails] AS [Info Emails],
	[Owned By].[ReceivesAdminInfoEmails] AS [Admin Info Emails],
	[Owned By].[EmailEncodingKey] AS [Email Encoding],
	[Owned By].[ProfileId] AS [Profile ID],
	[Owned By].[UserType] AS [User Type],
	[Owned By].[LanguageLocaleKey] AS [Language],
	[Owned By].[EmployeeNumber] AS [Employee Number],
	[Owned By].[DelegatedApproverId] AS [Delegated Approver ID],
	[Owned By].[ManagerId] AS [Manager ID],
	[Owned By].[LastLoginDate] AS [Last Login],
	[Owned By].[LastPasswordChangeDate] AS [Last Password Change or Reset],
	[Owned By].[CreatedDate] AS [Created Date],
	[Owned By].[CreatedById] AS [Created By ID],
	[Owned By].[LastModifiedDate] AS [Last Modified Date],
	[Owned By].[LastModifiedById] AS [Last Modified By ID],
	[Owned By].[SystemModstamp] AS [System Modstamp],
	[Owned By].[OfflineTrialExpirationDate] AS [Offline Edition Trial Expiration Date],
	[Owned By].[OfflinePdaTrialExpirationDate] AS [Sales Anywhere Trial Expiration Date],
	[Owned By].[UserPermissionsMarketingUser] AS [Marketing User],
	[Owned By].[UserPermissionsOfflineUser] AS [Offline User],
	[Owned By].[UserPermissionsCallCenterAutoLogin] AS [Auto-login To Call Center],
	[Owned By].[UserPermissionsMobileUser] AS [Apex Mobile User],
	[Owned By].[UserPermissionsSFContentUser] AS [Salesforce CRM Content User],
	[Owned By].[UserPermissionsKnowledgeUser] AS [Knowledge User],
	[Owned By].[UserPermissionsInteractionUser] AS [Force.com Flow User],
	[Owned By].[UserPermissionsSupportUser] AS [Service Cloud User],
	[Owned By].[UserPermissionsJigsawProspectingUser] AS [Data.com User],
	[Owned By].[UserPermissionsSiteforceContributorUser] AS [Site.com Contributor User],
	[Owned By].[UserPermissionsSiteforcePublisherUser] AS [Site.com Publisher User],
	[Owned By].[UserPermissionsWorkDotComUserFeature] AS [Work.com User],
	[Owned By].[ForecastEnabled] AS [Allow Forecasting],
	[Owned By].[UserPreferencesActivityRemindersPopup] AS [ActivityRemindersPopup],
	[Owned By].[UserPreferencesEventRemindersCheckboxDefault] AS [EventRemindersCheckboxDefault],
	[Owned By].[UserPreferencesTaskRemindersCheckboxDefault] AS [TaskRemindersCheckboxDefault],
	[Owned By].[UserPreferencesReminderSoundOff] AS [ReminderSoundOff],
	[Owned By].[UserPreferencesDisableAllFeedsEmail] AS [DisableAllFeedsEmail],
	[Owned By].[UserPreferencesDisableFollowersEmail] AS [DisableFollowersEmail],
	[Owned By].[UserPreferencesDisableProfilePostEmail] AS [DisableProfilePostEmail],
	[Owned By].[UserPreferencesDisableChangeCommentEmail] AS [DisableChangeCommentEmail],
	[Owned By].[UserPreferencesDisableLaterCommentEmail] AS [DisableLaterCommentEmail],
	[Owned By].[UserPreferencesDisProfPostCommentEmail] AS [DisProfPostCommentEmail],
	[Owned By].[UserPreferencesContentNoEmail] AS [ContentNoEmail],
	[Owned By].[UserPreferencesContentEmailAsAndWhen] AS [ContentEmailAsAndWhen],
	[Owned By].[UserPreferencesApexPagesDeveloperMode] AS [ApexPagesDeveloperMode],
	[Owned By].[UserPreferencesHideCSNGetChatterMobileTask] AS [HideCSNGetChatterMobileTask],
	[Owned By].[UserPreferencesDisableMentionsPostEmail] AS [DisableMentionsPostEmail],
	[Owned By].[UserPreferencesDisMentionsCommentEmail] AS [DisMentionsCommentEmail],
	[Owned By].[UserPreferencesHideCSNDesktopTask] AS [HideCSNDesktopTask],
	[Owned By].[UserPreferencesHideChatterOnboardingSplash] AS [HideChatterOnboardingSplash],
	[Owned By].[UserPreferencesHideSecondChatterOnboardingSplash] AS [HideSecondChatterOnboardingSplash],
	[Owned By].[UserPreferencesDisCommentAfterLikeEmail] AS [DisCommentAfterLikeEmail],
	[Owned By].[UserPreferencesDisableLikeEmail] AS [DisableLikeEmail],
	[Owned By].[UserPreferencesSortFeedByComment] AS [SortFeedByComment],
	[Owned By].[UserPreferencesDisableMessageEmail] AS [DisableMessageEmail],
	[Owned By].[UserPreferencesJigsawListUser] AS [JigsawListUser],
	[Owned By].[UserPreferencesDisableBookmarkEmail] AS [DisableBookmarkEmail],
	[Owned By].[UserPreferencesDisableSharePostEmail] AS [DisableSharePostEmail],
	[Owned By].[UserPreferencesEnableAutoSubForFeeds] AS [EnableAutoSubForFeeds],
	[Owned By].[UserPreferencesDisableFileShareNotificationsForApi] AS [DisableFileShareNotificationsForApi],
	[Owned By].[UserPreferencesShowTitleToExternalUsers] AS [ShowTitleToExternalUsers],
	[Owned By].[UserPreferencesShowManagerToExternalUsers] AS [ShowManagerToExternalUsers],
	[Owned By].[UserPreferencesShowEmailToExternalUsers] AS [ShowEmailToExternalUsers],
	[Owned By].[UserPreferencesShowWorkPhoneToExternalUsers] AS [ShowWorkPhoneToExternalUsers],
	[Owned By].[UserPreferencesShowMobilePhoneToExternalUsers] AS [ShowMobilePhoneToExternalUsers],
	[Owned By].[UserPreferencesShowFaxToExternalUsers] AS [ShowFaxToExternalUsers],
	[Owned By].[UserPreferencesShowStreetAddressToExternalUsers] AS [ShowStreetAddressToExternalUsers],
	[Owned By].[UserPreferencesShowCityToExternalUsers] AS [ShowCityToExternalUsers],
	[Owned By].[UserPreferencesShowStateToExternalUsers] AS [ShowStateToExternalUsers],
	[Owned By].[UserPreferencesShowPostalCodeToExternalUsers] AS [ShowPostalCodeToExternalUsers],
	[Owned By].[UserPreferencesShowCountryToExternalUsers] AS [ShowCountryToExternalUsers],
	[Owned By].[UserPreferencesShowProfilePicToGuestUsers] AS [ShowProfilePicToGuestUsers],
	[Owned By].[UserPreferencesShowTitleToGuestUsers] AS [ShowTitleToGuestUsers],
	[Owned By].[UserPreferencesShowCityToGuestUsers] AS [ShowCityToGuestUsers],
	[Owned By].[UserPreferencesShowStateToGuestUsers] AS [ShowStateToGuestUsers],
	[Owned By].[UserPreferencesShowPostalCodeToGuestUsers] AS [ShowPostalCodeToGuestUsers],
	[Owned By].[UserPreferencesShowCountryToGuestUsers] AS [ShowCountryToGuestUsers],
	[Owned By].[UserPreferencesDisableFeedbackEmail] AS [DisableFeedbackEmail],
	[Owned By].[UserPreferencesDisableWorkEmail] AS [DisableWorkEmail],
	[Owned By].[UserPreferencesHideS1BrowserUI] AS [HideS1BrowserUI],
	[Owned By].[UserPreferencesDisableEndorsementEmail] AS [DisableEndorsementEmail],
	[Owned By].[UserPreferencesLightningExperiencePreferred] AS [LightningExperiencePreferred],
	[Owned By].[ContactId] AS [Contact ID],
	[Owned By].[AccountId] AS [Account ID],
	[Owned By].[CallCenterId] AS [Call Center ID],
	[Owned By].[Extension],
	[Owned By].[FederationIdentifier] AS [SAML Federation ID],
	[Owned By].[AboutMe] AS [About Me],
	[Owned By].[FullPhotoUrl] AS [Url for full-sized Photo],
	[Owned By].[SmallPhotoUrl] AS [Url for Thumbnail sized Photo],
	[Owned By].[DigestFrequency] AS [Chatter Email Highlights Frequency],
	[Owned By].[DefaultGroupNotificationFrequency] AS [Default Notification Frequency when Joining Groups],
	[Owned By].[JigsawImportLimitOverride] AS [Data.com Monthly Addition Limit],
	[Owned By].[LastViewedDate] AS [LastViewedDate (Owned By)],
	[Owned By].[LastReferencedDate] AS [LastReferencedDate (Owned By)]
FROM
	[User] AS [Owned By]

SELECT 
	[OpportunityLineItem].[Id] AS [Line Item ID],
	[OpportunityLineItem].[OpportunityId] AS [OpportunityId (Opportunity Product)],
	[OpportunityLineItem].[SortOrder] AS [Sort Order],
	[OpportunityLineItem].[PricebookEntryId] AS [Price Book Entry ID],
	[OpportunityLineItem].[Product2Id] AS [Product ID],
	[OpportunityLineItem].[ProductCode] AS [Product Code],
	[OpportunityLineItem].[Name] AS [Opportunity Product Name],
	[OpportunityLineItem].[Quantity] AS [Quantity (Opportunity Product)],
	[OpportunityLineItem].[TotalPrice] AS [Total Price],
	[OpportunityLineItem].[UnitPrice] AS [Sales Price],
	[OpportunityLineItem].[ListPrice] AS [List Price],
	[OpportunityLineItem].[ServiceDate] AS [Date],
	[OpportunityLineItem].[Description] AS [Line Description],
	[OpportunityLineItem].[CreatedDate] AS [CreatedDate (Opportunity Product)],
	[OpportunityLineItem].[CreatedById] AS [CreatedById (Opportunity Product)],
	[OpportunityLineItem].[LastModifiedDate] AS [LastModifiedDate (Opportunity Product)],
	[OpportunityLineItem].[LastModifiedById] AS [LastModifiedById (Opportunity Product)],
	[OpportunityLineItem].[SystemModstamp] AS [SystemModstamp (Opportunity Product)],
	[OpportunityLineItem].[IsDeleted] AS [IsDeleted (Opportunity Product)]
FROM
	[OpportunityLineItem]

SELECT 
	[PricebookEntry].[Id] AS [Id (Price Book Entry)],
	[PricebookEntry].[Name] AS [Product Name],
	[PricebookEntry].[Pricebook2Id] AS [Pricebook2Id (Price Book Entry)],
	[PricebookEntry].[Product2Id] AS [Product2Id (Price Book Entry)],
	[PricebookEntry].[UnitPrice] AS [UnitPrice (Price Book Entry)],
	[PricebookEntry].[IsActive] AS [IsActive (Price Book Entry)],
	[PricebookEntry].[UseStandardPrice] AS [Use Standard Price],
	[PricebookEntry].[CreatedDate] AS [CreatedDate (Price Book Entry)],
	[PricebookEntry].[CreatedById] AS [CreatedById (Price Book Entry)],
	[PricebookEntry].[LastModifiedDate] AS [LastModifiedDate (Price Book Entry)],
	[PricebookEntry].[LastModifiedById] AS [LastModifiedById (Price Book Entry)],
	[PricebookEntry].[SystemModstamp] AS [SystemModstamp (Price Book Entry)],
	[PricebookEntry].[ProductCode] AS [ProductCode (Price Book Entry)],
	[PricebookEntry].[IsDeleted] AS [IsDeleted (Price Book Entry)]
FROM
	[PricebookEntry]

SELECT 
	[Product2].[Id] AS [Id (Product)],
	[Product2].[Name] AS [Name (Product)],
	[Product2].[ProductCode] AS [ProductCode (Product)],
	[Product2].[Description] AS [Product Description],
	[Product2].[IsActive] AS [IsActive (Product)],
	[Product2].[CreatedDate] AS [CreatedDate (Product)],
	[Product2].[CreatedById] AS [CreatedById (Product)],
	[Product2].[LastModifiedDate] AS [LastModifiedDate (Product)],
	[Product2].[LastModifiedById] AS [LastModifiedById (Product)],
	[Product2].[SystemModstamp] AS [SystemModstamp (Product)],
	[Product2].[Family] AS [Product Family],
	[Product2].[IsDeleted] AS [IsDeleted (Product)],
	[Product2].[LastViewedDate] AS [LastViewedDate (Product)],
	[Product2].[LastReferencedDate] AS [LastReferencedDate (Product)]
FROM
	[Product2]