subtitlecat.com

All language subtitles for 006 ASSIGNMENT Table Transformations_en

Afrikaans

Akan

Albanian

Amharic

Arabic

Armenian

Azerbaijani

Basque

Belarusian

Bemba

Bengali

Bihari

Bosnian

Breton

Bulgarian

Cambodian

Catalan

Cebuano

Cherokee

Chichewa

Chinese (Simplified)

Chinese (Traditional)

Corsican

Croatian

Czech

Danish

Dutch

English

Esperanto

Estonian

Ewe

Faroese

Filipino

Finnish

French Download

Frisian

Galician

Georgian

German

Greek

Guarani

Gujarati

Haitian Creole

Hausa

Hawaiian

Hebrew

Hindi

Hmong

Hungarian

Icelandic

Igbo

Indonesian

Interlingua

Irish

Italian

Japanese

Javanese

Kannada

Kazakh

Kinyarwanda

Kirundi

Kongo

Korean

Krio (Sierra Leone)

Kurdish

Kurdish (Soranî)

Kyrgyz

Laothian

Latin

Latvian

Lingala

Lithuanian

Lozi

Luganda

Luo

Luxembourgish

Macedonian

Malagasy

Malay

Malayalam

Maltese

Maori

Marathi

Mauritian Creole

Moldavian

Mongolian

Myanmar (Burmese)

Montenegrin

Nepali

Nigerian Pidgin

Northern Sotho

Norwegian

Norwegian (Nynorsk)

Occitan

Oriya

Oromo

Pashto

Persian

Polish

Portuguese (Brazil)

Portuguese (Portugal)

Punjabi

Quechua

Romanian

Romansh

Runyakitara

Russian

Samoan

Scots Gaelic

Serbian

Serbo-Croatian

Sesotho

Setswana

Seychellois Creole

Shona

Sindhi

Sinhalese

Slovak

Slovenian

Somali

Spanish

Spanish (Latin American)

Sundanese

Swahili

Swedish

Tajik

Tamil

Tatar

Telugu

Thai

Tigrinya

Tonga

Tshiluba

Tumbuka

Turkish

Turkmen

Twi

Uighur

Ukrainian

Urdu

Uzbek

Vietnamese

Welsh

Wolof

Xhosa

Yiddish

Yoruba

Zulu

Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated: 1 00:00:00,000 --> 00:00:01,000 Instructor: All right, so you've come 2 00:00:01,000 --> 00:00:03,000 to the first assignment of the course, 3 00:00:03,000 --> 00:00:06,000 and it's an email from your manager, Ethan T. Langer. 4 00:00:06,000 --> 00:00:10,000 And Ethan says, "Hello, and welcome to the team. 5 00:00:10,000 --> 00:00:12,000 We're excited that you'll be helping us develop 6 00:00:12,000 --> 00:00:14,000 our new internal reports in Power BI. 7 00:00:14,000 --> 00:00:16,000 Looks like you've already gotten started, 8 00:00:16,000 --> 00:00:19,000 but we have some new data to add to the model. 9 00:00:19,000 --> 00:00:22,000 Could you please create two new queries to connect 10 00:00:22,000 --> 00:00:23,000 to the Product Category Lookup 11 00:00:23,000 --> 00:00:26,000 and Product Subcategory Lookup files attached 12 00:00:26,000 --> 00:00:29,000 and help with a few modifications to the product table? 13 00:00:29,000 --> 00:00:31,000 Thanks. ETL." 14 00:00:31,000 --> 00:00:33,000 All right, so for this assignment 15 00:00:33,000 --> 00:00:36,000 we've got seven key objectives to work through. 16 00:00:36,000 --> 00:00:37,000 We need to create queries to connect 17 00:00:37,000 --> 00:00:40,000 to the two new CSV files. 18 00:00:40,000 --> 00:00:43,000 We're gonna rename the queries Product Category Lookup 19 00:00:43,000 --> 00:00:45,000 and Product Subcategory Lookup. 20 00:00:45,000 --> 00:00:48,000 We'll confirm that the column headers have been promoted 21 00:00:50,000 --> 00:00:53,000 We're gonna add a new column to extract all characters 22 00:00:53,000 --> 00:00:58,000 before the dash in product SKU and name it SKU Type. 23 00:00:58,000 --> 00:01:01,000 We're gonna update the SKU type calculation above 24 00:01:01,000 --> 00:01:04,000 to return all characters before the second dash. 25 00:01:04,000 --> 00:01:05,000 instead of the first,. 26 00:01:05,000 --> 00:01:07,000 We're gonna replace zeros 27 00:01:07,000 --> 00:01:10,000 in the Product Style column with NA, 28 00:01:10,000 --> 00:01:13,000 and then we're gonna close and load our data model. 29 00:01:13,000 --> 00:01:15,000 All right, so I'll catch up with you in the next lesson, 30 00:01:15,000 --> 00:01:17,000 where we'll walk through the solution. 2414