Please enable JavaScript.
Coggle requires JavaScript to display documents.
GFK Data, SQL, download, SQL monthly - Coggle Diagram
GFK Data
SQL
views
ce.vw_GfK_data_weekly
ce.vw_GfK_data_monthly
neue Daten
SP --> check, ob vorhanden
mapping tables
Y:\Employees\Tamara\Gfk DB\Key Files
Display Tech.xlsx
DisplayTechnology2
Gfk models.xlsx
SamsungModelCode
[BI_Database].[dim].[tbl_gfkCE_Models]
Update
IMPORTANT BRANDS.xlsx
ImportantBrands
add columns
Inch Categories.xlsx
InchCategory
new column naming
new upload
PIN_TO_PIN_master.xlsx
PinToPin
new column naming!
new upload
historische Daten
download
weekly
6 channels
random tag - verfügbarkeit der daten
trigger
teams channel
weekly
monthly
random tag - verfügbarkeit der daten
trigger
teams channel
7 channels
SQL monthly
Import Raw to [BI_Staging_DB].[ce].[tbl_GfK_data_monthly_import]
MAPPING
Import mapped to [BI_Staging_DB].[ce].[tbl_GfK_data_monthly_mapped]
import to live [BI_Database].[ce].[tbl_GfK_data_monthly]
final report view (TBC) --> YTD COLUMN!
view