Data EngineeringModeling and ETL

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=8suqrdPxD34

Data Analytics and BI, Topic 2: • Activities: • -Download sample OLTP adventure works Database • -Restore Database • -Business Requirement: Sales by territory • -Data Modeling based on Bus requirements • -Create Data Vault or Staging, Schema • -Create SSIS Packages to load from Source to Destination • -Run ETL • -Run Truncate SQL Task • Source Code: • https://github.com/AgbonAgb/Data-Analytics...","styleRuns":[{"startIndex":0,"length":334,"styleRunExtensions":{"styleRunColorMapExtension":{"colorMap":[{"key":"USER_INTERFACE_THEME_DARK","value":4294967295},{"key":"USER_INTERFACE_THEME_LIGHT","value":4279440147}]}},"fontFamilyName":"Roboto"},{"startIndex":334,"length":45,"styleRunExtensions":{"styleRunColorMapExtension":{"colorMap":[{"key":"USER_INTERFACE_THEME_DARK","value":4294967295},{"key":"USER_INTERFACE_THEME_LIGHT","value":4279440147}]}},"fontFamilyName":"Roboto"}]},"headerRuns":[{"startIndex":0,"length":334,"headerMapping":"ATTRIBUTED_STRING_HEADER_MAPPING_UNSPECIFIED"},{"startIndex":334,"length":45,"headerMapping":"ATTRIBUTED_STRING_HEADER_MAPPING_UNSPECIFIED"}]}},{"itemSectionRenderer":{"contents":[{"continuationItemRenderer":{"trigger":"CONTINUATION_TRIGGER_ON_ITEM_SHOWN","continuationEndpoint":{"clickTrackingParams":"CLsBELsvGAIiEwjGpeHAwMiLAxXR40IFHQYOGug=","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/next"}},"continuationCommand":{"token":"Eg0SCzhzdXFyZFB4RDM0GAYyJSIRIgs4c3VxcmRQeEQzNDAAeAJCEGNvbW1lbnRzLXNlY3Rpb24%3D","request":"CONTINUATION_REQUEST_TYPE_WATCH_NEXT"}}}}],"trackingParams":"CLsBELsvGAIiEwjGpeHAwMiLAxXR40IFHQYOGug=","sectionIdentifier":"comment-item-section","targetId":"comments-section"}}],"trackingParams":"CLoBELovIhMIxqXhwMDIiwMV0eNCBR0GDhro"}},"secondaryResults":{"secondaryResults":{"results":[{"compactVideoRenderer":{"videoId":"RYFEyE1zwzw","thumbnail":{"thumbnails":[{"url":"https://i.ytimg.com/vi/RYFEyE1zwzw/hqdefault.jpg?sqp=-oaymwE1CKgBEF5IVfKriqkDKAgBFQAAiEIYAXABwAEG8AEB-AH6CYAC0AWKAgwIABABGBMgQSh_MA8= rs=AOn4CLB0WSFJXN4ACxTgttIGaJ-R1dLMjw","width":168,"height":94},{"url":"https://i.ytimg.com/vi/RYFEyE1zwzw/hqdefault.jpg?sqp=-oaymwE2CNACELwBSFXyq4qpAygIARUAAIhCGAFwAcABBvABAfgB-gmAAtAFigIMCAAQARgTIEEofzAP rs=AOn4CLAd7XlwQV7Ak3XnEagoGpsqJvN1jA","width":336,"height":188}]},"title":{"accessibility":{"accessibilityData":{"label":"Data Analytics and BI for Beginners, Topic 1 by Godwin Agbon 43 views 8 months ago 18 minutes"}},"simpleText":"Data Analytics and BI for Beginners, Topic 1"},"longBylineText":{"runs":[{"text":"Godwin Agbon","navigationEndpoint":{"clickTrackingParams":"CLMBEKQwGAAiEwjGpeHAwMiLAxXR40IFHQYOGugyB3JlbGF0ZWQ=","commandMetadata":{"webCommandMetadata":{"url":"/@godwinagbon1117","webPageType":"WEB_PAGE_TYPE_CHANNEL","rootVe":3611,"apiUrl":"/youtubei/v1/browse"}},"browseEndpoint":{"browseId":"UCOzaQi2v5dlGIxrLqrfGfAw","canonicalBaseUrl":"/@godwinagbon1117"}}}]},"publishedTimeText":{"simpleText":"8 months ago"},"viewCountText":{"simpleText":"43 views"},"lengthText":{"accessibility":{"accessibilityData":{"label":"18 minutes, 57 seconds"}},"simpleText":"18:57"},"navigationEndpoint":{"clickTrackingParams":"CLMBEKQwGAAiEwjGpeHAwMiLAxXR40IFHQYOGugyB3JlbGF0ZWRI_p7En93V6uXyAZoBBQgBEPgd","commandMetadata":{"webCommandMetadata":{"url":"/watch?v=RYFEyE1zwzw","webPageType":"WEB_PAGE_TYPE_WATCH","rootVe":3832}},"watchEndpoint":{"videoId":"RYFEyE1zwzw","nofollow":true,"watchEndpointSupportedOnesieConfig":{"html5PlaybackOnesieConfig":{"commonConfig":{"url":"https://rr5---sn-nv47zn7y.googlevideo.com/initplayback?source=youtube oeis=1 c=WEB oad=3200 ovd=3200 oaad=11000 oavd=11000 ocs=700 oewis=1 oputc=1 ofpcc=1 msp=1 odepv=1 id=458144c84d73c33c ip=2a02%3A27aa%3A0%3A0%3A0%3A0%3A0%3Ad49 initcwndbps=1871250 mt=1739719256 oweuc= pxtags=Cg4KAnR4Egg1MTM5MzE2MA rxtags=Cg4KAnR4Egg1MTM5MzE2MA%2CCg4KAnR4Egg1MTM5MzE2MQ%2CCg4KAnR4Egg1MTM5MzE2Mg%2CCg4KAnR4Egg1MTM5MzE2Mw%2CCg4KAnR4Egg1MTM5MzE2NA"}}}}},"shortBylineText":{"runs":[{"text":"Godwin Agbon","navigationEndpoint":{"clickTrackingParams":"CLMBEKQwGAAiEwjGpeHAwMiLAxXR40IFHQYOGugyB3JlbGF0ZWQ=","commandMetadata":{"webCommandMetadata":{"url":"/@godwinagbon1117","webPageType":"WEB_PAGE_TYPE_CHANNEL","rootVe":3611,"apiUrl":"/youtubei/v1/browse"}},"browseEndpoint":{"browseId":"UCOzaQi2v5dlGIxrLqrfGfAw","canonicalBaseUrl":"/@godwinagbon1117"}}}]},"channelThumbnail":{"thumbnails":[{"url":"https://yt3.ggpht.com/e7kT0nwyxd_-ESKvuN0m-jPCn25QLq9jLQyVf8a1i0rviFOhepRyFvqUWOSbhlyPQALNENa0=s68-c-k-c0x00ffffff-no-rj","width":68,"height":68}]},"trackingParams":"CLMBEKQwGAAiEwjGpeHAwMiLAxXR40IFHQYOGuhAvIbP64SZ0cBF","shortViewCountText":{"accessibility":{"accessibilityData":{"label":"43 views"}},"simpleText":"43 views"},"menu":{"menuRenderer":{"items":[{"menuServiceItemRenderer":{"text":{"runs":[{"text":"Add to queue"}]},"icon":{"iconType":"ADD_TO_QUEUE_TAIL"},"serviceEndpoint":{"clickTrackingParams":"CLgBEP6YBBgGIhMIxqXhwMDIiwMV0eNCBR0GDhro","commandMetadata":{"webCommandMetadata":{"sendPost":true}},"signalServiceEndpoint":{"signal":"CLIENT_SIGNAL","actions":[{"clickTrackingParams":"CLgBEP6YBBgGIhMIxqXhwMDIiwMV0eNCBR0GDhro","addToPlaylistCommand":{"openMiniplayer":false,"openListPanel":true,"videoId":"RYFEyE1zwzw","listType":"PLAYLIST_EDIT_LIST_TYPE_QUEUE","onCreateListCommand":{"clickTrackingParams":"CLgBEP6YBBgGIhMIxqXhwMDIiwMV0eNCBR0GDhro","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/playlist/create"}},"createPlaylistServiceEndpoint":{"videoIds":["RYFEyE1zwzw"],"params":"CAQ%3D"}},"videoIds":["RYFEyE1zwzw"]}},{"clickTrackingParams":"CLgBEP6YBBgGIhMIxqXhwMDIiwMV0eNCBR0GDhro","openPopupAction":{"popup":{"notificationActionRenderer":{"responseText":{"simpleText":"Added to queue"},"trackingParams":"CLkBELlqIhMIxqXhwMDIiwMV0eNCBR0GDhro"}},"popupType":"TOAST"}}]}},"trackingParams":"CLgBEP6YBBgGIhMIxqXhwMDIiwMV0eNCBR0GDhro"}},{"menuServiceItemDownloadRenderer":{"serviceEndpoint":{"clickTrackingParams":"CLcBENGqBRgHIhMIxqXhwMDIiwMV0eNCBR0GDhro","offlineVideoEndpoint":{"videoId":"RYFEyE1zwzw","onAddCommand":{"clickTrackingParams":"CLcBENGqBRgHIhMIxqXhwMDIiwMV0eNCBR0GDhro","getDownloadActionCommand":{"videoId":"RYFEyE1zwzw","params":"CAIQAA%3D%3D"}}}},"trackingParams":"CLcBENGqBRgHIhMIxqXhwMDIiwMV0eNCBR0GDhro"}},{"menuServiceItemRenderer":{"text":{"runs":[{"text":"Share"}]},"icon":{"iconType":"SHARE"},"serviceEndpoint":{"clickTrackingParams":"CLMBEKQwGAAiEwjGpeHAwMiLAxXR40IFHQYOGug=","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/share/get_share_panel"}},"shareEntityServiceEndpoint":{"serializedShareEntity":"CgtSWUZFeUUxend6dw%3D%3D","commands":[{"clickTrackingParams":"CLMBEKQwGAAiEwjGpeHAwMiLAxXR40IFHQYOGug=","openPopupAction":{"popup":{"unifiedSharePanelRenderer":{"trackingParams":"CLYBEI5iIhMIxqXhwMDIiwMV0eNCBR0GDhro","showLoadingSpinner":true}},"popupType":"DIALOG","beReused":true}}]}},"trackingParams":"CLMBEKQwGAAiEwjGpeHAwMiLAxXR40IFHQYOGug=","hasSeparator":true}}],"trackingParams":"CLMBEKQwGAAiEwjGpeHAwMiLAxXR40IFHQYOGug=","accessibility":{"accessibilityData":{"label":"Action menu"}},"targetId":"watch-related-menu-button"}},"thumbnailOverlays":[{"thumbnailOverlayTimeStatusRenderer":{"text":{"accessibility":{"accessibilityData":{"label":"18 minutes, 57 seconds"}},"simpleText":"18:57"},"style":"DEFAULT"}},{"thumbnailOverlayToggleButtonRenderer":{"isToggled":false,"untoggledIcon":{"iconType":"WATCH_LATER"},"toggledIcon":{"iconType":"CHECK"},"untoggledTooltip":"Watch later","toggledTooltip":"Added","untoggledServiceEndpoint":{"clickTrackingParams":"CLUBEPnnAxgBIhMIxqXhwMDIiwMV0eNCBR0GDhro","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/browse/edit_playlist"}},"playlistEditEndpoint":{"playlistId":"WL","actions":[{"addedVideoId":"RYFEyE1zwzw","action":"ACTION_ADD_VIDEO"}]}},"toggledServiceEndpoint":{"clickTrackingParams":"CLUBEPnnAxgBIhMIxqXhwMDIiwMV0eNCBR0GDhro","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/browse/edit_playlist"}},"playlistEditEndpoint":{"playlistId":"WL","actions":[{"action":"ACTION_REMOVE_VIDEO_BY_VIDEO_ID","removedVideoId":"RYFEyE1zwzw"}]}},"untoggledAccessibility":{"accessibilityData":{"label":"Watch later"}},"toggledAccessibility":{"accessibilityData":{"label":"Added"}},"trackingParams":"CLUBEPnnAxgBIhMIxqXhwMDIiwMV0eNCBR0GDhro"}},{"thumbnailOverlayToggleButtonRenderer":{"untoggledIcon":{"iconType":"ADD_TO_QUEUE_TAIL"},"toggledIcon":{"iconType":"PLAYLIST_ADD_CHECK"},"untoggledTooltip":"Add to queue","toggledTooltip":"Added","untoggledServiceEndpoint":{"clickTrackingParams":"CLQBEMfsBBgCIhMIxqXhwMDIiwMV0eNCBR0GDhro","commandMetadata":{"webCommandMetadata":{"sendPost":true}},"signalServiceEndpoint":{"signal":"CLIENT_SIGNAL","actions":[{"clickTrackingParams":"CLQBEMfsBBgCIhMIxqXhwMDIiwMV0eNCBR0GDhro","addToPlaylistCommand":{"openMiniplayer":false,"openListPanel":true,"videoId":"RYFEyE1zwzw","listType":"PLAYLIST_EDIT_LIST_TYPE_QUEUE","onCreateListCommand":{"clickTrackingParams":"CLQBEMfsBBgCIhMIxqXhwMDIiwMV0eNCBR0GDhro","commandMetadata":{"webCommandMetadata":{"sendPost":true,"apiUrl":"/youtubei/v1/playlist/create"}},"createPlaylistServiceEndpoint":{"videoIds":["RYFEyE1zwzw"],"params":"CAQ%3D"}},"videoIds":["RYFEyE1zwzw"]}}]}},"untoggledAccessibility":{"accessibilityData":{"label":"Add to queue"}},"toggledAccessibility":{"accessibilityData":{"label":"Added"}},"trackingParams":"CLQBEMfsBBgCIhMIxqXhwMDIiwMV0eNCBR0GDhro"}},{"thumbnailOverlayNowPlayingRenderer":{"text":{"runs":[{"text":"Now playing"}]}}}],"accessibility":{"accessibilityData":{"label":"Data Analytics and BI for Beginners, Topic 1 - 18 minutes - Go to channel - Godwin Agbon - 43 views - 8 months ago - play video"}},"richThumbnail":{"movingThumbnailRenderer":{"movingThumbnailDetails":{"thumbnails":[{"url":"https://i.ytimg.com/an_webp/RYFEyE1zwzw/mqdefault_6s.webp?du=3000 sqp=CLz8x70G rs=AOn4CLA-17nw_BdUfSGw4UloNTTcXyEzDw","width":320,"height":180}],"logAsMovingThumbnail":true},"enableHoveredLogging":true,"enableOverlay":true}}}},{"lockupViewModel":{"contentImage":{"collectionThumbnailViewModel":{"primaryThumbnail":{"thumbnailViewModel":{"image":{"sources":[{"url":"https://i.ytimg.com/vi/pv3IbdlojEw/hqdefault.jpg?sqp=-oaymwEwCKgBEF5IWvKriqkDIwgBFQAAiEIYAfABAfgB-gmAAtAFigIMCAAQARhdIF0oXTAP rs=AOn4CLD-ZT99QPgsQwAemIcgL3klanEJLA","width":168,"height":94},{"url":"https://i.ytimg.com/vi/pv3IbdlojEw/hqdefault.jpg?sqp=-oaymwExCNACELwBSFryq4qpAyMIARUAAIhCGAHwAQH4AfoJgALQBYoCDAgAEAEYXSBdKF0wDw== rs=AOn4CLAa3V-gQPDMFTdpAN7bq0FbHLucfw","width":336,"height":188}]},"overlays":[{"thumbnailOverlayBadgeViewModel":{"thumbnailBadges":[{"thumbnailBadgeViewModel":{"icon":{"sources":[{"clientResource":{"imageName":"PLAYLISTS"}}]},"text":"5 videos","badgeStyle":"THUMBNAIL_OVERLAY_BADGE_STYLE_DEFAULT","backgroundColor":{"lightTheme":2500134,"darkTheme":2500134}}}],"position":"THUMBNAIL_OVERLAY_BADGE_POSITION_BOTTOM_END"}},{"thumbnailHoverOverlayViewModel":{"icon":{"sources":[{"clientResource":{"imageName":"PLAY_ALL"}}]},"text":{"content":"Play all","styleRuns":[{"startIndex":0,"length":8}]},"style":"THUMBNAIL_HOVER_OVERLAY_STYLE_COVER"}}],"backgroundColor":{"lightTheme":3618615,"darkTheme":3618615}}},"stackColor":{"lightTheme":10066329,"darkTheme":9211020}}},"metadata":{"lockupMetadataViewModel":{"title":{"content":"Data Analytics and Business intelligence"},"metadata":{"contentMetadataViewModel":{"metadataRows":[{"metadataParts":[{"text":{"content":"Godwin Agbon

#############################

New on site