DIM_Customers

[Marina-ai-hub]

DIM_Caustomers.csv

SQL Code:
-- Cleaned DIM_Customers Table --
SELECT
c.customerkey AS [CustomerKey]
-- ,[GeographyKey]
-- ,[CustomerAlternateKey]
-- ,[Title]
, c.firstname AS [FirstName]
-- ,[MiddleName]
, c.lastname AS [LastName]
, CONCAT( c.firstname, ' ', c.lastname) AS [Full Name],
-- ,[NameStyle]
-- ,[BirthDate]
-- ,[MaritalStatus]
-- ,[Suffix]
CASE c.gender WHEN 'M' THEN 'Male'
WHEN 'F' THEN 'Female' END AS Gender
-- ,[EmailAddress]
-- ,[YearlyIncome]
-- ,[TotalChildren]
-- ,[NumberChildrenAtHome]
-- ,[EnglishEducation]
-- ,[SpanishEducation]
-- ,[FrenchEducation]
-- ,[EnglishOccupation]
-- ,[SpanishOccupation]
-- ,[FrenchOccupation]
-- ,[HouseOwnerFlag]
-- ,[NumberCarsOwned]
-- ,[AddressLine1]
-- ,[AddressLine2]
-- ,[Phone]
, c.datefirstpurchase AS DateFirstPurchase
-- ,[CommuteDistance]
-- g.city AS [Customer City]
FROM dbo.dimcustomer AS c
-- LEFT JOIN dbo.dimgeography AS g
-- ON g.geographykey = c.geographykey
ORDER BY CustomerKey ASC