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
Presenter: All right, get excited
2
00:00:01,000 --> 00:00:05,000
because it's time to finally introduce our course project.
3
00:00:05,000 --> 00:00:07,000
So here's the situation.
4
00:00:07,000 --> 00:00:08,000
You've just been hired
5
00:00:08,000 --> 00:00:11,000
as a business intelligence analyst by AdventureWorks,
6
00:00:11,000 --> 00:00:13,000
a fictional global manufacturing company
7
00:00:13,000 --> 00:00:17,000
that produces cycling equipment and accessories.
8
00:00:17,000 --> 00:00:19,000
And your role is to help the management team
9
00:00:19,000 --> 00:00:23,000
track their KPIs, things like sales, revenue,
10
00:00:23,000 --> 00:00:27,000
profit and returns, compare performance across regions,
11
00:00:27,000 --> 00:00:29,000
analyze product-level trends,
12
00:00:29,000 --> 00:00:31,000
and identify high-value customers.
13
00:00:31,000 --> 00:00:32,000
But all you've been given
14
00:00:32,000 --> 00:00:35,000
is a folder of raw CSV files,
15
00:00:35,000 --> 00:00:38,000
which contain information about transaction
16
00:00:38,000 --> 00:00:40,000
and return records, products,
17
00:00:40,000 --> 00:00:42,000
customers, and sales territories.
18
00:00:42,000 --> 00:00:43,000
So your objective here
19
00:00:43,000 --> 00:00:45,000
is to use Power BI desktop
20
00:00:45,000 --> 00:00:48,000
to connect and transform that raw data,
21
00:00:48,000 --> 00:00:50,000
build a relational data model,
22
00:00:50,000 --> 00:00:53,000
create calculated columns and measures with DAX,
23
00:00:53,000 --> 00:00:57,000
and finally, design an interactive dashboard
24
00:00:57,000 --> 00:01:00,000
to help visualize and analyze that data.
25
00:01:00,000 --> 00:01:01,000
So let's take a peek
26
00:01:01,000 --> 00:01:02,000
at what we're gonna be building
27
00:01:02,000 --> 00:01:05,000
and what the final product will look like.
28
00:01:05,000 --> 00:01:07,000
All right, so here's a quick preview
29
00:01:07,000 --> 00:01:09,000
of the AdventureWorks report
30
00:01:09,000 --> 00:01:10,000
that we're gonna build together.
31
00:01:10,000 --> 00:01:11,000
Right now we're looking at
32
00:01:11,000 --> 00:01:13,000
the executive summary view.
33
00:01:13,000 --> 00:01:15,000
You can see we've got those high level KPIs
34
00:01:15,000 --> 00:01:17,000
that the leadership team cares about,
35
00:01:17,000 --> 00:01:20,000
revenue, profit, orders, and return rate.
36
00:01:20,000 --> 00:01:21,000
We've got a nice
37
00:01:21,000 --> 00:01:24,000
weekly revenue trending chart here as well.
38
00:01:24,000 --> 00:01:26,000
And you'll see some really cool interactive elements
39
00:01:26,000 --> 00:01:28,000
that Power BI offers
40
00:01:28,000 --> 00:01:31,000
like sliders to zoom in on specific time periods,
41
00:01:31,000 --> 00:01:34,000
custom tool tips that we'll build together,
42
00:01:34,000 --> 00:01:38,000
and even a completely custom filter pane as well.
43
00:01:38,000 --> 00:01:39,000
Now, one thing you'll see here
44
00:01:39,000 --> 00:01:42,000
is that we can drill into any specific product
45
00:01:42,000 --> 00:01:44,000
to take us to our product detail view.
46
00:01:44,000 --> 00:01:45,000
That's gonna show us things like
47
00:01:45,000 --> 00:01:48,000
how a product is performing against
48
00:01:48,000 --> 00:01:51,000
its monthly order, revenue, or profit target.
49
00:01:51,000 --> 00:01:52,000
We're gonna practice using things
50
00:01:52,000 --> 00:01:55,000
like parameters for what if analysis.
51
00:01:55,000 --> 00:01:58,000
In this case, how does it change to the price,
52
00:01:58,000 --> 00:02:00,000
impact a metric like total profit.
53
00:02:00,000 --> 00:02:02,000
We'll explore field parameters
54
00:02:02,000 --> 00:02:04,000
to make these charts more interactive
55
00:02:04,000 --> 00:02:06,000
and dynamic for our end users.
56
00:02:06,000 --> 00:02:08,000
We'll drill into Power BI's mapping
57
00:02:08,000 --> 00:02:11,000
and geospatial tools like so,
58
00:02:11,000 --> 00:02:13,000
and we'll build a customer-level view
59
00:02:13,000 --> 00:02:15,000
to drill into performance
60
00:02:15,000 --> 00:02:17,000
at the individual customer level
61
00:02:17,000 --> 00:02:21,000
and break down different customer profiles and segments.
62
00:02:21,000 --> 00:02:22,000
So again, we're gonna build
63
00:02:22,000 --> 00:02:25,000
this entire report completely from scratch
64
00:02:25,000 --> 00:02:28,000
with nothing but a folder of raw CSV files.
65
00:02:28,000 --> 00:02:30,000
It's gonna be a lot of fun
66
00:02:30,000 --> 00:02:31,000
so I hope you're excited to dig in.
4953
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.
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
Faroese
Finnish
Galician
Georgian
German
Greek
Guarani
Haitian Creole
Hausa
Hawaiian
Hebrew
Hmong
Hungarian
Icelandic
Indonesian
Irish
Italian
Japanese
Kazakh
Kinyarwanda
Kirundi
Kongo
Korean
Krio (Sierra Leone)
Kurdish
Kyrgyz
Laothian
Latin
Latvian
Lithuanian
Luganda
Luo
Luxembourgish
Macedonian
Malagasy
Malay
Maltese
Maori
Mauritian Creole
Moldavian
Mongolian
Myanmar (Burmese)
Montenegrin
Nepali
Norwegian
Pashto
Persian
Polish
Portuguese (Brazil)
Portuguese (Portugal)
Quechua
Romanian
Romansh
Russian
Samoan
Scots Gaelic
Serbian
Sesotho
Setswana
Seychellois Creole
Shona
Sindhi
Sinhalese
Slovak
Slovenian
Somali
Spanish
Swedish
Tajik
Thai
Tigrinya
Tonga
Turkish
Turkmen
Ukrainian
Uzbek
Vietnamese
Welsh
Wolof