subtitlecat.com

All language subtitles for 017 SOLUTION Numerical Tools_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:00,000 Narrator: Welcome to the 2 00:00:00,000 --> 00:00:02,000 Numerical Tools Solution walkthrough. 3 00:00:02,000 --> 00:00:04,000 As a quick reminder, 4 00:00:04,000 --> 00:00:06,000 Ethan reached out because he needs you to help validate 5 00:00:06,000 --> 00:00:10,000 some high level stats about our products and customers. 6 00:00:10,000 --> 00:00:13,000 So in the Solution Preview, 7 00:00:13,000 --> 00:00:15,000 I've added in all of the answers in bold, 8 00:00:15,000 --> 00:00:17,000 but let's head over to Power BI 9 00:00:17,000 --> 00:00:19,000 and check these out for ourselves. 10 00:00:19,000 --> 00:00:21,000 All right, so our first question is, 11 00:00:21,000 --> 00:00:24,000 what is our average product cost, right? 12 00:00:24,000 --> 00:00:26,000 And so from the Product Lookup Table, 13 00:00:26,000 --> 00:00:30,000 we want to head over to our Product Cost column 14 00:00:32,000 --> 00:00:36,000 and Transform, Statistics, Average, 15 00:00:38,000 --> 00:00:43,000 and we get 413.66 if we round to two digits there. 16 00:00:44,000 --> 00:00:45,000 So that checks out. 17 00:00:46,000 --> 00:00:51,000 Up next, how many colors do we sell our products in? 18 00:00:51,000 --> 00:00:56,000 So we're gonna head over to our Product Color column, 19 00:00:56,000 --> 00:00:59,000 Transform, Statistics. 20 00:00:59,000 --> 00:01:00,000 And then again, here, 21 00:01:00,000 --> 00:01:03,000 we want to count the distinct values within this column, 22 00:01:03,000 --> 00:01:04,000 right? 23 00:01:04,000 --> 00:01:06,000 And we get 10, which again, 24 00:01:06,000 --> 00:01:08,000 that aligns with what we saw in the solution preview. 25 00:01:09,000 --> 00:01:13,000 Next, how many distinct customers do we have? 26 00:01:13,000 --> 00:01:15,000 So for this we're gonna head to the Customer Table. 27 00:01:16,000 --> 00:01:19,000 And our Customer Key column 28 00:01:19,000 --> 00:01:23,000 is going to give us the unique number of customers. 29 00:01:23,000 --> 00:01:28,000 So from here, Transform, Statistics. 30 00:01:28,000 --> 00:01:30,000 And then again, we're gonna count distinct. 31 00:01:31,000 --> 00:01:36,000 And we get 18,148, which looks good. 32 00:01:38,000 --> 00:01:40,000 And then our last question here 33 00:01:40,000 --> 00:01:43,000 is what is the maximum annual customer income? 34 00:01:43,000 --> 00:01:46,000 So we'll scroll over to our Customer Income field, 35 00:01:49,000 --> 00:01:53,000 and then we will use our maximum function here 36 00:01:53,000 --> 00:01:57,000 to get that value, and that is 170,000. 37 00:01:57,000 --> 00:01:57,000 Perfect. 38 00:01:57,000 --> 00:02:00,000 The last piece here was to return all of the tables 39 00:02:00,000 --> 00:02:02,000 to their original state. 40 00:02:02,000 --> 00:02:03,000 And with that, 41 00:02:03,000 --> 00:02:06,000 that's gonna wrap up this solution walkthrough 42 00:02:06,000 --> 00:02:07,000 on the numerical tools. 3174