Power BI Crash Course for Beginners 2020 – Analyze & Visualize Data with Power BI Desktop

00:00:00 hi welcome to this course greater of you
00:00:02 on board in this course you will learn
00:00:03 all about power bi desktop power bi pro
00:00:06 power bi mobile and more because power
00:00:09 bi is not a single tool it's a set of
00:00:11 combined tools and in this course you
00:00:14 will learn all to go from zero to
00:00:16 creating your own power bi projects we
00:00:19 will learn all this step-by-step in an
00:00:21 interactive course project the project
00:00:23 starts with power bi desktop a local
00:00:26 application which you can download to
00:00:28 your Windows computer power bi desktop
00:00:30 is all about data preparation beta
00:00:32 analysis and data visualization and we
00:00:35 will cover all these three parts in a
00:00:37 lot of detail after power bi desktop
00:00:39 we'll have a look at Power bi Pro which
00:00:42 allows us to bring our data from the
00:00:43 local computer to the cloud in power
00:00:46 appear Pro you can collaborate in your
00:00:48 projects with your colleagues and you
00:00:50 can share projects within and outside
00:00:52 your organization will then continue
00:00:55 with power bi mobile it's esta name
00:00:57 indicates a mobile application which
00:00:59 allows you to access your data from
00:01:02 anywhere from your mobile device after
00:01:05 that we'll dive into more advanced
00:01:07 features of power bi
00:01:08 for example we will learn how to create
00:01:10 own custom visuals power bi ships with a
00:01:13 lot of beautiful visuals but if that's
00:01:15 not enough
00:01:16 hey then you can dive deeper and create
00:01:18 visuals exactly according to your needs
00:01:20 on your own this and a lot more is
00:01:23 what's inside the course so what are we
00:01:25 waiting for let's get started
00:01:35 let's dive right into the course and to
00:01:38 do that we should have a look at the
00:01:40 most important question first what is
00:01:42 power bi actually on the official
00:01:45 website you can find this statement here
00:01:47 telling you that power bi is a business
00:01:50 analytic solution it allows you to
00:01:52 visualize data and to share information
00:01:54 and that it can be connected to hundreds
00:01:57 of data sources and you can use it to
00:02:00 create dashboards and reports
00:02:01 that's a nice statement indicating that
00:02:04 power bi is a quite powerful tool but I
00:02:07 guess it's a bit too complex at this
00:02:09 stage because in simpler words power bi
00:02:12 is a bi a business intelligence tool
00:02:15 allowing you to analyze visualize and
00:02:18 share data that's it in the end and
00:02:20 there are some thing is that power bi is
00:02:22 a bi tool for everyone so you don't need
00:02:25 any prior experience to work with power
00:02:28 bi now we will dive into all its core
00:02:32 features throughout the course but at
00:02:33 this point we should understand how
00:02:35 power bi is organized and structured to
00:02:38 allow everyone to become a bi expert for
00:02:42 that we should have a look at the three
00:02:43 core areas of power bi the first core
00:02:46 area is the data preparation and
00:02:48 analysis so anything related to data or
00:02:52 tables you could say data preparation
00:02:54 means connecting power bi to different
00:02:56 source files and to work on that raw
00:02:59 information this can mean that you want
00:03:02 to work on columns delete columns for
00:03:04 example or you might want to change the
00:03:06 data format from a text to a number the
00:03:09 goal of data preparation is to have
00:03:11 shaped or prepared data which you can
00:03:13 then use to perform your analysis
00:03:15 analyzing data in power bi could mean
00:03:18 simple tasks like calculating averages
00:03:21 or more complex calculations we'll have
00:03:24 a look at throughout the course with the
00:03:25 data related part finished we can
00:03:28 continue with the next core area
00:03:30 visualizations because you can of course
00:03:32 present data as simple tables this is
00:03:35 also possible and power bi but you can
00:03:37 also create lots of different visuals
00:03:40 this can be line charts column charts
00:03:42 bar charts or more advanced visuals like
00:03:44 maps for example so that's the second
00:03:47 core area we now saw that we can work
00:03:49 data and that we can present our results
00:03:50 and this brings us to the third and last
00:03:53 core area of power bi collaboration and
00:03:56 sharing because you can work on your own
00:03:58 in power bi this is possible but you can
00:04:01 also work together in teams and you can

00:04:04 also share your results then within your
00:04:05 organization or even outside your
00:04:07 organization this is collaboration and
00:04:10 sharing so these are the three core
00:04:13 areas making power bi such a powerful bi
00:04:16 tool the last question now is how does
00:04:20 power bi do this though which tools do I
00:04:22 have to achieve all these goals well
00:04:25 this brings us to the core power bi
00:04:27 tools it because power bi isn't a single
00:04:31 tool it's a set of multiple combined
00:04:34 tools interacting with each other and
00:04:36 these core tools are power bi desktop
00:04:39 power bi service or pro and power bi
00:04:43 mobile let's get started with power bi
00:04:46 desktop power bi desktop is a local
00:04:49 application this means it's a program
00:04:51 you can download for free to your
00:04:53 computer with one single restriction
00:04:56 though it's only available for Windows
00:04:58 machines with power bi desktop you have
00:05:01 a very strong tool covering many of the
00:05:04 core areas we just talked about already
00:05:06 because in power bi desktop you can work
00:05:08 on data sets this means the initial data
00:05:11 preparation we just talked about so the
00:05:13 connection to the source files empty
00:05:14 work on that information and also the
00:05:17 data analysis part meaning that you
00:05:19 apply your own calculations to the
00:05:20 information to get the insights you need
00:05:22 into your data you can also create
00:05:25 visuals in power up your desktop as I
00:05:27 said we have line charts bar charts
00:05:29 column charts Maps even combined charts
00:05:31 so many many different ways to visualize
00:05:34 information in power bi desktop to bring
00:05:36 more structure into your visuals power
00:05:39 bi has the so called report feature a
00:05:41 report simply allows you to organize
00:05:43 your visuals on different pages so you
00:05:46 have one page for example with revenue
00:05:49 data a second page with cost data just
00:05:51 to give you a simple example here and in
00:05:54 the end all these different pages are
00:05:56 summarized in one report this is what
00:05:59 power bi desktop is about in a nutshell
00:06:01 as you can see
00:06:03 a very very powerful tool already it has
00:06:05 one core restriction though it can be
00:06:08 downloaded to your machine and therefore
00:06:10 you are kind of alone when you work in
00:06:12 power up your desktop now this can be
00:06:14 okay for certain projects but typically
00:06:17 if you work in an organization you are
00:06:20 not alone and you're working in teams
00:06:22 and this brings us to the second core
00:06:25 power bi tool power bi service or pro
00:06:28 power bi service is a cloud application
00:06:31 this means you just need a account
00:06:34 a power bi account and then you can use
00:06:36 it to log in to power bi service this
00:06:39 means it's not limited to Windows only
00:06:40 you only need a browser to well access
00:06:43 this website what can we do in power bi
00:06:46 service now well power bi service is not
00:06:49 the tool to work on datasets that's part
00:06:52 of power bi desktop therefore we don't
00:06:54 have these strong data preparation and
00:06:56 analysis capabilities which has talked
00:06:58 about in power bi desktop power bi
00:07:01 service can be used to create visuals
00:07:03 and reports though this is possible but
00:07:06 it works basically the same way as it
00:07:09 does in power bi desktop therefore in
00:07:11 this course we will focus on 2 power bi
00:07:13 desktop when it comes to visuals and
00:07:15 reports and not dive too deep into this
00:07:18 area in power bi service because there
00:07:20 is actually another part where power bi
00:07:23 service really shines and this is
00:07:25 creating dashboards dashboards our
00:07:28 summary pages you could say so one
00:07:31 single page with the core visuals of the
00:07:34 report this could be a page you present
00:07:36 your executive to give them an overview
00:07:38 of the most important numbers from the
00:07:41 dashboard you can then dive into the
00:07:44 report and into single visuals if you
00:07:46 want you but the dashboard is the first
00:07:48 thing you see now as I talk about
00:07:51 presenting dashboards to your executive
00:07:53 this brings us to the other really
00:07:56 strong part of power bi service this is
00:07:58 collaboration and results sharing
00:08:01 because power bi service is the tool you
00:08:04 need when it comes to any kind of
00:08:06 interaction with other people be it
00:08:08 inside your team beat inside your
00:08:10 organization or even outside your

00:08:12 organization you can use power bi
00:08:14 service to collaborate on your
00:08:16 object and to share the final results
00:08:18 with other people and this sharing part
00:08:21 also brings us to the last core power bi
00:08:24 toolset
00:08:24 power bi mobile as the name indicates
00:08:27 power bi Mobile is a mobile app which
00:08:30 you can download from the Google Play
00:08:32 Store or the App Store if you have an
00:08:34 Apple device and it simply allows us to
00:08:37 access our information our dashboards
00:08:39 our reports from anywhere and this is
00:08:43 not core power bi toolset that was the
00:08:47 fury part and throughout this course
00:08:49 we'll dive into all these tools we'll
00:08:51 see how these tools interact in a real
00:08:53 interactive project but now we should
00:08:56 get started first and we will get
00:08:58 started with power bi desktop
00:09:04 so let's dive into the world of power bi
00:09:07 desktop for that we have to download it
00:09:09 first to do so we should go to the
00:09:12 official Microsoft website here power bi
00:09:15 dot Microsoft comm and there if you go
00:09:17 to products click onto it you can select
00:09:20 power bi desktop if you do so you have
00:09:24 two options to download it now download
00:09:27 free and see download or language
00:09:29 options this one is fine you can do this
00:09:32 but I recommend the advanced download
00:09:34 option here as it allows you to well
00:09:37 select the language and as it also
00:09:39 provides some additional information
00:09:41 we'll have a look at in a few seconds so
00:09:43 let's click on to see download or
00:09:45 language options now this new window
00:09:48 opens and if we scroll down a bit here
00:09:51 we can first see that we can select the
00:09:54 language power bi desktop should be
00:09:56 installed and download it in I'll go
00:09:59 with English here I recommend you to do
00:10:01 the same at this point and if we scroll
00:10:03 down a bit further you can also open
00:10:06 this system requirements menu here you
00:10:08 see which requirements power bi desktop
00:10:11 as you see the required operating system
00:10:13 and down here you see that you need a
00:10:16 32-bit or 64-bit Windows platform if you
00:10:20 are not sure here if you have a 2 bit or
00:10:22 64 bit platform you can simply press the
00:10:24 Windows key on your keyboard and then
00:10:27 enter system information then can open
00:10:32 this app right here and then under the
00:10:34 system type you see that I have a 64 bit
00:10:36 based PC if you have for the 2 bit here
00:10:40 then you should go with the 32 bit
00:10:41 version and you can select the
00:10:43 corresponding version now if you go to
00:10:45 download there you have t2 options so 64
00:10:49 bit for me this would be the first 2 bit
00:10:50 version and now by clicking next the
00:10:55 download should start as you can see
00:10:57 down here can take a few seconds and
00:10:58 once this download is finished we'll
00:11:01 continue with the installation of power
00:11:03 bi desktop the download finished so you
00:11:06 should have this executable file here if
00:11:09 you double click it the installation
00:11:11 wizard starts so you can again select
00:11:13 the language we selected English already
00:11:15 so we'll stick to this one pressing next
00:11:17 we'll bring us to the next menu here we
00:11:21 can simply click on to next we can
00:11:24 accept the License Agreement
00:11:26 press next once again they you can now
00:11:28 change the path your power bi desktop
00:11:30 should be installed you for me the
00:11:32 default one works totally fine so I'll
00:11:34 click Next once again and then we can
00:11:37 start the installation I'll also create
00:11:38 a desktop shortcut here maybe you do the
00:11:40 same so let's press install now this
00:11:43 again takes a few seconds now the
00:11:45 installation is done and now we could
00:11:47 launch power bi desktop immediately I
00:11:49 will uncheck this dough and start it
00:11:51 manually as I want to give you one
00:11:53 additional information at this point
00:11:55 so let's uncheck this box and press
00:11:57 finish and now you have the power bi
00:11:59 desktop application here on the desktop
00:12:02 if we not double click it we open power
00:12:06 bi desktop and with that we open a new
00:12:08 project that's important at this point
00:12:11 because if we open a new project we also
00:12:13 have to save a new one we'll do this
00:12:15 later throughout this introduction video
00:12:17 just keep in mind if you open power bi
00:12:19 desktop like this a new project will be

00:12:22 opened what you can see here now is the
00:12:24 starting screen restarting menu don't
00:12:27 get distracted by this sign in part here
00:12:29 this is required for power bi service or
00:12:32 power bi pro so we'll cover this later
00:12:34 throughout the course for power bi
00:12:36 desktop no
00:12:37 sign-in is required now we could
00:12:41 directly connect power bi desktop to a
00:12:43 source file if we go to get data right
00:12:45 here but I would like to go to the
00:12:47 options menu first to show you one very
00:12:50 important option for power bi desktop in
00:12:53 general but also to follow along this
00:12:55 course conveniently so let's close this
00:12:58 pop-up here and now we see the power bi
00:13:01 desktop interface something we'll
00:13:03 explore in a lot of detail in the next
00:13:06 module for now just go to file now to
00:13:09 options and settings right here and now
00:13:13 we go to options up there in this menu
00:13:17 please go down to current file down here
00:13:20 and select regional settings this menu
00:13:24 allows you to set the so-called locale
00:13:26 as you can see here the locale is
00:13:28 important to interpret numbers dates and
00:13:31 cetera so it's basically important to
00:13:34 make sure that if I apply a change to
00:13:36 data to data formats that this change is
00:13:39 also applied accordingly in your project
00:13:41 for your individual projects you can use
00:13:43 different locales for the purpose of
00:13:45 this course I highly recommend to use
00:13:47 English United States right here also
00:13:50 the locale I use so just make sure that
00:13:52 this is set correctly and press ok and
00:13:54 now we are back in power bi desktop the
00:13:57 problem we have of course is that we
00:13:59 don't have any kind of data in our
00:14:01 project let's change this quickly for
00:14:03 that we stay in this home ribbon here
00:14:06 and go to get data if you click it in a
00:14:08 lower part you get a quick summary of
00:14:10 some common data sources if you click it
00:14:13 in the upper part right here you get an
00:14:15 overview of all data sources as you can
00:14:18 see part of a desktop ships with a lot
00:14:20 of data sources many of these covered
00:14:22 throughout this course you can also
00:14:24 select different data sources by
00:14:26 category for example file data sources
00:14:28 like Excel CSV and so on or databases
00:14:32 like sequel or you cannot use this
00:14:35 search option here and if I now enter
00:14:37 web then you see we have this Web source
00:14:42 type and that's the source type I want
00:14:44 to use for this introduction project if
00:14:47 you select it and press connect then
00:14:49 well you can connect power bi desktop to
00:14:51 a specific website what is missing here
00:14:54 though is our URL let's quickly get one
00:14:58 and here will not search for the IMF
00:15:00 World Economic Outlook database this one
00:15:09 now in my case the April 2020 version is
00:15:12 the latest one if you have a more recent
00:15:14 version at the point in time where you
00:15:16 are watching this course you can of
00:15:17 course use this one because the
00:15:19 structure will remain the same you will
00:15:21 just have more updated data talking
00:15:23 about data quickly the IMF World
00:15:25 Economic Outlook database simply
00:15:27 provides GDP data so gross domestic
00:15:30 product data for different countries for
00:15:32 different years therefore it's a really
00:15:35 nice data set to quickly get started
00:15:36 with power bi desktop enough of the
00:15:39 words let's select this April 2020
00:15:41 version here in my case here we can now
00:15:45 download or access to information I will
00:15:47 use by countries here in this menu on
00:15:50 the next page will select all countries
00:15:52 this option we can continue here so we
00:15:56 can select all our countries here we can
00:15:58 now select the type of GDP data we want
00:16:01 to download I'll go with the gross
00:16:03 domestic product in current prices so
00:16:05 the second option right here so let's
00:16:07 not press continue here we can now
00:16:10 select a date range we'll keep the
00:16:12 default one and with that we cannot
00:16:14 press prepare report and now we have our
00:16:17 information already as you can see if
00:16:19 you scroll to the right you have now GDP
00:16:21 data for different years for different
00:16:24 countries now we could download the
00:16:26 information with this download button or
00:16:29 alternatively we can directly access the
00:16:31 information now from the browser from
00:16:34 the website so to say to do so please

00:16:37 select the URL up here right-click it
00:16:39 and now press copy now go back to power
00:16:43 bi desktop and now right click and paste
00:16:46 this URL and click OK now this pop-up
00:16:51 opens as power bi desktop wants to know
00:16:54 how it should access this information on
00:16:57 this website as we don't have any
00:16:59 critical data here we can simply go with
00:17:02 anonymous here and access this
00:17:04 information on the website without any
00:17:06 specific credentials so we can press
00:17:08 connect here and here we are now in this
00:17:12 so-called navigator the navigator now
00:17:15 allows us to select the data or specific
00:17:18 data that we want to receive from the
00:17:20 website we have two views available here
00:17:23 the so-called table view and the web
00:17:25 view the default view is this table view
00:17:28 and in this left part you can see the
00:17:30 content of the website divided into
00:17:32 different tables into different parts of
00:17:35 the page you could say and if you click
00:17:37 on to one of these tables you can see
00:17:38 that this is well this part of the page
00:17:40 this right here is another one and here
00:17:43 Table five this is the actual content
00:17:46 that we need so our data with two
00:17:48 different columns and the GDP data we
00:17:50 also have this web view as I said this
00:17:52 one right here this presents us the
00:17:54 entire web page however as you can see
00:17:56 right here the web view is a bit
00:17:59 bagi from time to time unfortunately
00:18:00 because normally you should be able to
00:18:03 see the different tables here
00:18:04 highlighted so that you could directly
00:18:06 select the tables here also in the web
00:18:08 view this is not working here at the
00:18:10 moment probably it's the same for you
00:18:12 therefore I recommend to go back to the
00:18:14 table view and to quickly check the
00:18:15 content of the page right here and as I
00:18:18 said table 5 is the one that we have to
00:18:20 select and to finally select it we have
00:18:22 to tick this box right here next to
00:18:24 table 5 now with this table being
00:18:27 selected we also have two options down
00:18:29 here load and trends from data now short
00:18:33 note at this point this is just the
00:18:35 introduction project here so the goal is
00:18:38 to guide you through the first steps in
00:18:40 power bi desktop to show you how easy it
00:18:42 is to connect power bi desktop to data
00:18:44 and to create your first visuals
00:18:47 throughout the course we'll dive a lot
00:18:49 deeper into everything and a lot more
00:18:51 you'll see in this introduction project
00:18:54 so for the moment just follow along and
00:18:56 enjoy the easiness of using power bi
00:18:59 desktop a quick preview on load versus
00:19:03 transform data at this point though load
00:19:05 would mean that you immediately load the
00:19:08 information into your so called data
00:19:10 model so this would mean that you want
00:19:12 to immediately start visualizing your
00:19:15 data you could say transform data is the
00:19:17 data preparation part I was talking
00:19:20 about in the last lecture this is this
00:19:22 connecting power bi desktop to source
00:19:24 files but then working on columns data
00:19:26 formats and so on therefore will now
00:19:29 select transform data here to see if we
00:19:31 have to prepare our information and if
00:19:34 we do so you see something interesting
00:19:36 you see a new menu and you interface and
00:19:40 a new window which is opening I can
00:19:43 prove this to you if I click on to this
00:19:45 button to make the window a bit smaller
00:19:47 you see we still have our initial menu
00:19:50 in the background with some pending
00:19:52 changes we'll cover that later
00:19:53 throughout the course and now we have a
00:19:55 separate window and this is the
00:19:57 so-called query editor or power query
00:20:00 editor as its named since a recent
00:20:03 update now this power query editor or
00:20:07 query editor as I will refer to
00:20:08 throughout the course now allows you to
00:20:11 work on the connection to resource file
00:20:13 and also on the structure of the
00:20:16 information displayed right here this
00:20:18 means now it's time to explore this
00:20:20 curry editor and to do our first data
00:20:23 preparation steps
00:20:28 as mentioned before this is just the
00:20:31 introduction project therefore I just
00:20:33 guide you through the core steps
00:20:35 required for this project we'll dive
00:20:37 into everything you see right here and a
00:20:39 lot more in a lot of detail throughout

00:20:42 the course therefore a very quick intro
00:20:44 on what you can see right here in the
00:20:46 center part you have the information
00:20:47 that we saw on the website now import it
00:20:51 into power bi desktop and the left part
00:20:53 you see our so-called queries our
00:20:55 connections to the source files here we
00:20:57 have one connection to the website in
00:21:00 the right part you have these all called
00:21:02 applied steps this will present and
00:21:04 store all changes applied to our data
00:21:07 here these three steps for automatically
00:21:09 applied by power bi desktop by the way
00:21:10 and up here you see we have different
00:21:13 ribbons we can click through and each
00:21:15 ribbon comes with different options
00:21:17 mainly related to the information here
00:21:20 in the center of our screen so what
00:21:23 should we do with this information now
00:21:25 well the goal is to have a clean and
00:21:28 prepared data set we can use to then
00:21:30 create our visual and for that we first
00:21:34 should work on the column names because
00:21:36 here you can select the individual
00:21:38 columns and you see we have column one
00:21:40 column two and so on not the best column
00:21:43 names at this stage especially as row
00:21:45 number two this one here has country
00:21:48 subject descriptor units and so on so it
00:21:51 already contains our correct column
00:21:53 names now we could manually rename these
00:21:56 columns here this would be possible but
00:21:57 the better way would be to delete this
00:22:00 first column here and with that our row
00:22:03 two would become our new Row one and
00:22:05 then we could turn this first row into
00:22:08 our column names into our so called
00:22:10 header this means we have two steps we
00:22:13 should do right here
00:22:14 we should delete this existing first row
00:22:16 and then we should turn our new first
00:22:18 row this one here into the column names
00:22:21 to do so we go to the home ribbon up
00:22:24 here and then you have this reduce rows
00:22:27 area if you click on to remove rows you
00:22:30 see we have plenty of options in our
00:22:33 case the first one is the required
00:22:35 option remove top rows let's select this
00:22:38 and now we have to specify how many rows
00:22:41 starting from the
00:22:43 we want to remove well in our case you
00:22:45 want to remove row 1 therefore we should
00:22:48 simply enter 1 right here press ok and
00:22:51 the first row is immediately gun also
00:22:55 indicated by the removed top row step
00:22:57 here in the right part in our applied
00:22:59 steps column so whenever you
00:23:01 accidentally do a wrong step here you
00:23:03 can simply undo this by clicking onto
00:23:05 this X symbol left to that applied step
00:23:07 just as a side note with the first step
00:23:10 done we now need to turn this row into
00:23:12 our column names to do so we can again
00:23:15 go to the home ribbon now go to the
00:23:18 right part of the screen here and click
00:23:20 on to use first row as headers like this
00:23:23 and now we have the correct column names
00:23:25 country subject descriptor units and so
00:23:28 on this was quite easy wasn't it now as
00:23:32 we are talking about columns here at the
00:23:34 moment we should check if we need all
00:23:36 these different columns that we have in
00:23:39 our data you can select the columns with
00:23:41 the mouse as I did it right here or
00:23:42 navigate through different columns with
00:23:45 the left and right arrow key on your
00:23:47 keyboard so we could say that the
00:23:49 country yeah this is a column we need
00:23:50 the subject descriptor showing you that
00:23:53 we have to GDP here this is also fine
00:23:55 but the units for example I don't think
00:23:57 we need that column therefore we can now
00:24:00 either go again to our home ribbon this
00:24:03 one and go to remove columns right and
00:24:06 therefore remove this existing column or
00:24:09 alternatively we can right click on to
00:24:11 that column and press remove up here
00:24:13 let's go with this approach now to
00:24:16 remove the column the scale can be kept
00:24:18 this is fine here we have an empty
00:24:21 column so again the same approach right
00:24:23 click and remove and the remaining
00:24:25 columns showing our GDP data I think
00:24:27 these are all right let's see if we have
00:24:30 any additional and required column yes
00:24:32 the last one here so one less time right
00:24:35 click and remove and with that we
00:24:38 already improved our columns a lot
00:24:41 however I'm still not happy with the
00:24:44 result because now we should work on the

00:24:46 structure of our data because if you
00:24:49 have a look at the first columns we have
00:24:50 the country we have the scale and then
00:24:53 we have all these different years now
00:24:55 what
00:24:56 it'd be more in line with our current
00:24:57 structure if it would have country then
00:25:01 back here maybe a column named here and
00:25:04 then one column named GDP because with
00:25:07 that each individual topic would be
00:25:09 covered in a separate column and the
00:25:11 corresponding values would be stored
00:25:13 inside that column I think this would be
00:25:16 a good idea
00:25:17 and to do that we simply can select the
00:25:20 2014 column now scroll to the right
00:25:23 press and hold the shift button on our
00:25:26 keyboard and select the 2021 column now
00:25:30 all columns should be selected and what
00:25:33 I want to do now is I want to turn these
00:25:35 individual columns into two new columns
00:25:38 with one column being the year and the
00:25:40 corresponding Year values we can see
00:25:42 here as the column names and with the
00:25:45 second column containing all the
00:25:46 corresponding GDP data so all this
00:25:49 information that is now stored in
00:25:50 separate columns should be stored in
00:25:53 this individual column that sounds a bit
00:25:55 complex at this stage but it's a really
00:25:57 helpful feature so let's do it and then
00:25:59 take a closer look at it again to apply
00:26:02 this transformation we should now not go
00:26:04 to the home ribbon but to the transform
00:26:07 ribbon here and here we can now go to
00:26:09 unfavored columns and this unfavored
00:26:11 option will exactly do what i was just
00:26:14 explaining if we select this you see
00:26:17 that we now have two columns only all
00:26:19 the other columns are gone or are not
00:26:21 gone actually are structured or
00:26:24 organized differently now this attribute
00:26:27 column here contains all the annual data
00:26:29 so all the data for the different years
00:26:31 and the value column contains the GDP
00:26:34 data this means we reduced the amount of
00:26:36 columns but of course increased the row
00:26:39 count because now all the different
00:26:41 years are stored in a different row
00:26:43 before these were stored in different
00:26:44 columns with that we achieved a big step
00:26:48 already what we should do now is we
00:26:50 should maybe rename this column so we
00:26:52 can do this with a simple double click
00:26:53 and naming it here pressing enter
00:26:56 alternatively we can also right click
00:26:58 here and go down to rename and name it
00:27:02 GDP auditing enter so this looks already
00:27:07 very good we are almost done with
00:27:09 our data preparation here there are just
00:27:11 two important steps missing one step is
00:27:14 to change the data format because at the
00:27:16 moment all our information is stored as
00:27:18 text you can see this indicated by this
00:27:21 ABC symbol here and if you click onto
00:27:23 that you see that we can change the data
00:27:25 format like this but before we do that
00:27:28 that's very important also for the rest
00:27:30 of the course
00:27:31 we should make sure that if we want to
00:27:32 change the data format from a text that
00:27:34 we have right here to a number we should
00:27:37 make sure that the information stored
00:27:39 here can be converted to a different
00:27:41 format because here the GP should not be
00:27:44 stored as text it should be stored as a
00:27:46 number actually
00:27:47 therefore we should ensure that it
00:27:49 contains only data which can be
00:27:51 formatted as a number to do that we can
00:27:54 simply click on to this arrow next to
00:27:57 the column name and here we have the
00:28:00 filter menu the filter menu allows you
00:28:03 to change the order the information is
00:28:05 displayed and it allows you to scroll
00:28:07 through the data to see if you have any
00:28:10 unwanted values if you scroll down right
00:28:12 here for example you can see that we
00:28:14 have and then a value down there and
00:28:16 this and a value can't be formatted as a
00:28:18 number therefore this would cause errors
00:28:20 so this means if we now unselect an 8 it
00:28:24 will be excluded from our data and this
00:28:27 will then allow us to format the data
00:28:28 correctly so let's press ok here and now
00:28:32 we can change the data format and to do
00:28:36 that I showed you that already we can
00:28:38 simply click on to the symbol and now
00:28:40 change the GDP to a decimal number like
00:28:42 this and the same thing can be done for

00:28:45 a year so let's click right here we
00:28:47 could actually format it as a date but
00:28:49 for the purpose of the introduction
00:28:52 project we can simply format it as whole
00:28:54 number totally sufficient at this point
00:28:56 and with that we did our first data
00:29:00 preparation as you can see this were
00:29:02 lots of steps actually for an
00:29:03 introduction project but it shows you
00:29:05 how powerful power bi desktop is what we
00:29:09 have to do now is we have to leave our
00:29:10 query editor and load this information
00:29:14 into our so called data model this means
00:29:16 you should make sure that we get the
00:29:18 information from that editor into this
00:29:21 part of power bi desktop you could say
00:29:23 to do that we go to file and now press
00:29:27 close and apply right here like this
00:29:30 producer you see the creditors closing
00:29:33 and decree changes are now applied and
00:29:36 the data is loaded into our data model
00:29:39 in this data model we will now finally
00:29:42 create our visuals
00:29:48 we prepared the data and we now have the
00:29:50 information stored in our data model but
00:29:52 we cannot see any data at this point why
00:29:55 is this the case well because we are in
00:29:57 the so-called report for you right here
00:29:59 at the moment this is the part where we
00:30:02 will create our visualizations but you
00:30:05 can already see this fields column in
00:30:07 the right part here so this indicates
00:30:09 that we have some information available
00:30:12 in power bi desktop in our data model
00:30:14 before we use this information though we
00:30:16 should switch to another view the so
00:30:18 called data view which is right here in
00:30:21 the state of view you cannot see again
00:30:23 our prepared information this is our
00:30:26 final data set now loaded into the data
00:30:29 model we could apply calculations in
00:30:31 here now this will be covered later
00:30:32 throughout the course but I actually
00:30:34 only want to apply one change here at
00:30:37 this point this change is related to the
00:30:39 country column here because at the
00:30:41 moment this country information is
00:30:43 stored as text which is fine but you can
00:30:47 also tell power bi that you have
00:30:48 specific data here specific data types
00:30:51 in here you could say because we have
00:30:53 text but actually this column contains
00:30:55 countries so geographic information and
00:30:59 the information that we have countries
00:31:01 here so that geographic information will
00:31:03 become important in a few minutes now to
00:31:05 tell power bi desktop that we have
00:31:07 countries here we select the country
00:31:09 column as I did it already and now we
00:31:11 have these column tools here in these
00:31:14 column tools we see the data type right
00:31:17 here so text these are the same options
00:31:19 we saw in the career editor but here in
00:31:21 this properties area we have the data
00:31:24 category at the moment we have uncatted
00:31:26 eyes data but if you open this menu you
00:31:30 have plenty of options on how to provide
00:31:32 additional information on the data
00:31:35 category for power bi desktop in our
00:31:37 case the right category is country
00:31:39 important not County but country down
00:31:42 here look that change applied nothing
00:31:45 changed at first sight here but if you
00:31:48 look into the right part into these
00:31:49 fields which are by the way equal to the
00:31:52 ones we saw in our report view here you
00:31:54 see we have this globe symbol in front
00:31:56 of the country indicating that power bi
00:31:58 desktop is not aware of the fact that
00:32:00 this
00:32:01 geographic information with that change
00:32:04 being applied we can get back to our
00:32:06 report view and now finally create our
00:32:09 first visual to create visuals and power
00:32:13 bi desktop you have this visualizations
00:32:15 column here and you can select the
00:32:17 visualization type directly in here
00:32:19 let's say we want to go with this from
00:32:21 right here the stacked column chart just
00:32:23 select it and now you have this
00:32:25 blueprint you could say for your visual
00:32:27 we don't have anything in it but you can
00:32:29 drag it around Center it as you want or
00:32:31 even make it bigger I think that's the
00:32:33 right option our case and now you can
00:32:35 Center it like this and like that so we
00:32:40 now have to blueprint for the visual but
00:32:41 we need some information in here and for
00:32:43 that we need our fields so again this
00:32:45 column to the right because now we have

00:32:48 to interact between our visualizations
00:32:49 here and these fields containing the
00:32:52 actual data and with the visualization
00:32:54 being selected right here we now can
00:32:57 interact between these two columns this
00:33:00 means if I want to get started with
00:33:01 presenting the GDP I can simply select
00:33:05 it here and now drag and drop it into a
00:33:07 specific data field of the visual in our
00:33:10 case the GDP would be a value that we
00:33:12 want to display so we can drag and drop
00:33:13 it right here
00:33:15 now the GDP data is applied right here
00:33:18 but not very spectacular we need some
00:33:22 additional information to make this
00:33:23 chart a bit more fancy for that we can
00:33:26 now select here and drag and drop it as
00:33:29 the axis maybe now we quickly created
00:33:33 our chart presenting GDP for different
00:33:36 years what's missing though is the
00:33:39 country specific information right
00:33:41 because like this we just have it on a
00:33:42 global level we can also do this let's
00:33:45 go back to our fields and now take our
00:33:47 country and drag it to the legend now we
00:33:51 have more details in our chart now we
00:33:53 have the GDP for different years for
00:33:56 different countries the problem is that
00:33:58 we have a bit too much information in
00:34:01 here now because nobody can see a thing
00:34:03 right here you could click to the right
00:34:04 to see all the countries but I don't
00:34:06 think this adds any value what you need
00:34:08 right here at this stage maybe is a
00:34:10 so-called filter to maybe only display
00:34:13 the top
00:34:14 ten countries other countries with the
00:34:16 most contribution to the GDP for that we
00:34:19 have this filter column here in this
00:34:21 filter column we can now say that we
00:34:23 want to apply specific filters on this
00:34:26 visual right here in our case I want to
00:34:29 filter for the top ten countries by GDP
00:34:33 therefore the country is the important
00:34:35 filter that we have to use right here
00:34:37 for that we can hover to the country now
00:34:40 expand this menu there we can now select
00:34:42 the filter type a basic filtering would
00:34:45 allow us to individually select the
00:34:47 countries but I just want to select a
00:34:49 top ten filter therefore we select this
00:34:51 menu and now go to top end this one now
00:34:55 we have to specify which top n should be
00:34:58 presented so n in our case should be the
00:35:01 top ten countries but the top ten
00:35:04 countries by what well by the GDP
00:35:07 therefore we can again go to our fields
00:35:09 column and add this data field right
00:35:12 there pressing apply filter now will
00:35:16 well apply the filter and now we only
00:35:19 have to top ten countries here in our
00:35:21 visualization again we did a big change
00:35:24 to our visual with just this simple step
00:35:28 we are almost done with our introduction
00:35:30 project at this point but we actually
00:35:33 change the data category of our
00:35:35 countries you remember this globe symbol
00:35:37 which added a few minutes ago
00:35:39 so for country specific data wouldn't a
00:35:42 world map be the better visual I think
00:35:45 so and we can immediately change this by
00:35:47 simply selecting our visual that's
00:35:49 important and now selecting the globe
00:35:51 symbol right there
00:35:53 if we do so you see we immediately get a
00:35:56 world map in power bi desktop with our
00:36:00 top 10 countries the problem here is
00:36:02 that we have the information for each
00:36:04 single year and here I just want to have
00:36:06 the cumulative GDP data for each country
00:36:09 for all the years therefore what we can
00:36:11 do now is we can simply unselect the
00:36:14 legend so we go to the legend area and
00:36:16 click on to this X with that we now have
00:36:19 the GDP data in a cumulative way and the
00:36:23 bigger the GDP the bigger this bubble
00:36:26 right here
00:36:27 what's missing here maybe is the country
00:36:29 name this will be our last addition to
00:36:32 this visual and to change specific
00:36:35 visual effects of our visual we can go
00:36:38 to this menu here the format menu if you
00:36:41 click onto this you have plenty of
00:36:43 options on how to interact with your
00:36:45 visual also cover throughout the course
00:36:46 of course but at this point I only want
00:36:49 to add the so called data category so if
00:36:51 we switch this to on you see we now have
00:36:54 the information regarding a country
00:36:57 where the specific GDP belongs to also

00:36:59 added to our visual and with that we
00:37:02 finished our first power bi project and
00:37:04 you also saw lots of core features
00:37:07 already in this little example one less
00:37:10 thing is missing though and this is
00:37:12 saving a project of course because as I
00:37:14 said in the beginning if you open a new
00:37:15 instance of power bi desktop a new
00:37:17 project will be opened therefore let's
00:37:20 save this current project by clicking
00:37:21 onto the Save button in the left upper
00:37:23 part of the screen now you can select a
00:37:26 location in my case I will just save it
00:37:28 on the desktop and I will call it
00:37:31 initial project maybe and it will be
00:37:35 stored as PB IX file these are power bi
00:37:38 desktop project files you save this now
00:37:40 your project is stored you can now
00:37:42 access it whenever you need it and we
00:37:44 can continue with the next important
00:37:46 part of this course the course outline
00:37:48 because this course is packed with
00:37:50 content and I want to make sure that you
00:37:52 know what you can expect from this
00:37:54 course
00:37:59 what's inside this course what does it
00:38:02 offer to make you a power bi expert we
00:38:05 are almost done with getting started and
00:38:07 in the next module we will have a look
00:38:09 at the prerequisites not at the course
00:38:11 prerequisites but at the power bi
00:38:14 desktop prerequisites meaning we'll have
00:38:16 a look at the interface or at
00:38:18 recommended options so basically
00:38:20 anything you need to make sure you
00:38:22 already feel familiar with the tool and
00:38:24 the look and feel of power bi desktop
00:38:26 because in the third module we'll dive
00:38:29 into the course project and there we'll
00:38:31 have a closer look at the query editor
00:38:33 will again see how we can work with
00:38:36 columns and rows as you saw it in the
00:38:38 introduction project already but we'll
00:38:40 dive a lot deeper here so we'll have a
00:38:42 look at how we can connect power bi
00:38:44 desktop to different data sources how we
00:38:46 can use features like append or merge
00:38:48 and how we can even create our own data
00:38:51 schema our own data model schema here
00:38:54 with power bi desktop in the query
00:38:55 editor because the final goal of this
00:38:57 module will be to have our own data set
00:39:00 which is based on multiple different
00:39:03 sources with this data set being
00:39:06 finished we will of course load this
00:39:07 data set into our data model and there
00:39:10 we'll start analyzing our data this
00:39:13 analysis part is a really crucial part
00:39:15 of power bi desktop as it allows you to
00:39:18 finally gain insights into your data for
00:39:20 example by applying calculations to the
00:39:22 information you have but it also allows
00:39:25 you to enhance your current data schema
00:39:28 for example by establishing
00:39:30 relationships or by using Dax back
00:39:33 stands for data analysis expression this
00:39:35 is a special language allowing you to
00:39:38 write different formulas which then
00:39:40 allow your wealth to gain these insights
00:39:42 into your data with the analyzing data
00:39:44 part being finished we will conclude
00:39:46 this first core part of the course with
00:39:49 the visualization part here we'll work
00:39:51 in the report view will create different
00:39:54 visuals starting from simple line charts
00:39:57 bar charts or column charts up to more
00:39:59 complex data types like combined charts
00:40:02 slicers and a lot more this will be the
00:40:06 first core part of this course it's the
00:40:09 local work in power bi desktop but as
00:40:12 you learn already power
00:40:13 I has more to offer than this local burg
00:40:16 in power bi desktop and this more will
00:40:18 be tackled in the next part of this
00:40:21 course he will dive into power bi
00:40:23 service or pro that's the cloud
00:40:25 application this means he will create a
00:40:27 new account and login to this cloud
00:40:29 service and we will then learn how we
00:40:32 can use our finished power up your
00:40:34 desktop project and publish it to power
00:40:36 bi service in power bi service will then
00:40:39 learn how we can create dashboards how
00:40:41 we can collaborate inside our team with
00:40:44 so called workspaces and apps and we'll
00:40:47 also learn how we can share our work
00:40:49 with other people inside and outside of
00:40:52 our organization will then conclude this
00:40:55 sharing and collaborating part of the
00:40:56 course with power bi mobile this means

00:40:59 we will install the mobile app and have
00:41:01 a look at how we can access it and at
00:41:03 the options this app offers so to
00:41:06 summarize that this will be the
00:41:07 collaboration and sharing part of the
00:41:10 course we could stop here but we are not
00:41:12 done yet because we will then continue
00:41:14 with having a look at additional data
00:41:17 sources because up to this point we
00:41:19 mainly work with text files CSV files or
00:41:22 Excel files but power bi has lots of
00:41:25 different so-called connectors so the
00:41:27 connectors allow you to connect power bi
00:41:29 desktop to the source files and in this
00:41:31 module we'll have a look at many of
00:41:33 these just to give you one example here
00:41:35 we'll have a look at how we can connect
00:41:37 power bi desktop to sequel or no sequel
00:41:39 databases once we also learned how we
00:41:42 can use this more advanced data sources
00:41:44 we'll also make sure that you always
00:41:46 stay up to date because the power bi
00:41:49 toolset is constantly evolving it gets
00:41:52 an amazing support by Microsoft the tool
00:41:54 constantly evolves and therefore we want
00:41:57 to make sure that you stay up to date
00:41:59 therefore we'll have a look at specific
00:42:01 resources you can check and also
00:42:04 specific parts of the tool you can dive
00:42:06 into to make sure you can stay update
00:42:09 and which also allow you to track
00:42:11 specific changes or updates that might
00:42:13 be coming in the near future these two
00:42:15 modules are the dive deeper part of the
00:42:18 course
00:42:19 so with that you already have a really
00:42:20 solid understanding of the power bi
00:42:23 tools it but we are still not done yet
00:42:25 because then we'll
00:42:26 to look at advanced features this
00:42:29 advanced features part dives into
00:42:31 specific features of power bi desktop
00:42:33 which were not covered yet but which
00:42:36 become interesting once you have do you
00:42:38 required basic knowledge and this also
00:42:41 covers the developers part because power
00:42:43 bi also allows people with at least
00:42:46 basic programming language to create own
00:42:49 visuals for example now these advanced
00:42:52 features will be covered in this part of
00:42:54 the course and this is really the part
00:42:57 where you will master power bi and
00:42:58 really become an expert in it and after
00:43:02 that we are finally done then we will
00:43:04 round up that course and show you some
00:43:05 next steps how to continue after
00:43:07 finishing this journey with that we are
00:43:10 almost ready to get started and to dive
00:43:12 into the prerequisites but before we do
00:43:14 so let's make sure that you really get
00:43:17 the most out of this course
00:43:23 how do you get the most out of this
00:43:25 corpse because you are part of this
00:43:27 course and we want to make sure that you
00:43:29 really get as much out of it as possible
00:43:32 and for that we have some things that
00:43:34 you should keep in mind the first thing
00:43:36 is quite obvious watch the videos
00:43:38 it's an on-demand video course so well
00:43:40 you kind of should watch the videos to
00:43:42 learn something here
00:43:43 however watch the videos at your speed
00:43:46 and pause and rewind if necessary we do
00:43:49 our best you find a good balance between
00:43:51 too slow and too fast but this doesn't
00:43:54 work for every student therefore use the
00:43:57 tools you have in the video player you
00:43:59 can slow us down or even increase the
00:44:01 playback speed in case we are too slow
00:44:03 if you didn't understand something when
00:44:06 watching the video the first time pause
00:44:08 that part and rewind it that's not bad
00:44:10 at all it's a really good thing to
00:44:12 rethink about certain concepts and to
00:44:14 really only continue with the video once
00:44:16 these concepts are clear in addition to
00:44:19 that work along and do the exercises
00:44:21 this entire course is built in an
00:44:24 interactive way you saw it in the
00:44:26 introductory project already this course
00:44:28 is built to work along throughout the
00:44:31 course you'll not only have the course
00:44:32 project but also different assignments
00:44:35 and quizzes and make sure to do these
00:44:37 because these will help you to remember
00:44:39 the knowledge and to practice the things
00:44:41 we learn throughout the course with that
00:44:43 you can really make sure that you
00:44:45 understood what we learned so far in the
00:44:47 course and as for the videos itself make

00:44:50 sure to do these exercises and work
00:44:53 along at your speed I want to emphasize
00:44:55 this once again here additionally make
00:44:58 sure to use the course resources
00:45:00 attached to different lectures and
00:45:02 attach to the last lecture of each
00:45:05 module you can find our project so in
00:45:08 case you're stuck in case something is
00:45:09 not working you can use these resources
00:45:12 and see what you did differently when
00:45:15 compared to us and with that it's easy
00:45:17 to track down any kind of differences
00:45:18 and therefore you can easily make sure
00:45:20 your project is working again
00:45:22 besides that you cannot only find
00:45:24 project files but also links these links
00:45:27 allow you to dive a bit deeper into
00:45:29 specific topics which might not be the
00:45:31 core focus of the course but which might
00:45:33 be interesting to you it yours
00:45:35 project so make sure to use these
00:45:37 project files and also dive into the
00:45:40 links provided even though you have the
00:45:42 project files and the links you might
00:45:44 get stuck throughout the course that's
00:45:46 not a problem because you can ask in the
00:45:48 course Q&A section in this Q&A section
00:45:51 we and also other students do our best
00:45:54 to make sure we can help you here and to
00:45:57 solve your problem but that's just one
00:46:00 side of the medal you could say because
00:46:01 well to be honest asking and waiting for
00:46:04 a response that's easy but this should
00:46:07 be an interactive thing as the entire
00:46:09 course actually is therefore besides
00:46:11 asking also make sure to help others in
00:46:14 the Q&A section and I'm not saying this
00:46:17 because we're lazy and we don't want to
00:46:18 answer your questions we will answer
00:46:20 your questions but the best way to learn
00:46:22 and to practice what you learned is to
00:46:24 help others because a student has a
00:46:26 question and then you can try your best
00:46:28 to answer this question and there is
00:46:31 nothing you have to lose right here
00:46:32 because if your answer is wrong well
00:46:34 then you will get corrected and then you
00:46:36 learn something interest you wouldn't
00:46:37 ask the question we'll learn something
00:46:39 but if you were right but then that's a
00:46:41 great proof for you because you saw that
00:46:43 you learn something in the course that
00:46:45 you understood the concepts well and for
00:46:47 a student to ask it's also good because
00:46:49 he or she received an answer
00:46:51 so to summarize our helping part here
00:46:53 great learnings are guaranteed if you do
00:46:56 so that's the whole introduction module
00:46:58 with that you already know what power bi
00:47:01 is all about what you will learn
00:47:02 throughout the course and how you get
00:47:04 the most out of this course therefore
00:47:06 let's dive into the course now and
00:47:07 continue with the next module or we dive
00:47:10 into the power bi
00:47:11 prerequisites
00:47:16 welcome to this module in this module we
00:47:19 will explore the desktop application so
00:47:22 power bi desktop because we want to make
00:47:24 sure that you are familiar with the
00:47:26 interface and also with some other
00:47:28 prerequisites required to follow along
00:47:31 this course conveniently what's inside
00:47:33 this module now well first we'll have a
00:47:35 look at how you can use the attached
00:47:37 project files throughout the course you
00:47:39 will find several attachments and here
00:47:42 you will learn how you can use these
00:47:44 after that we'll have a look at the
00:47:46 power bi desktop workflow because power
00:47:48 bi desktop comes with lots of different
00:47:51 tools you sort of create it already you
00:47:53 saw this data model and the report tree
00:47:55 for example and I want to make sure that
00:47:57 you know how these different tools
00:47:59 connect and how this workflow inside
00:48:01 power bi desktop works additionally
00:48:04 we'll have a look at the data model this
00:48:06 is the part of power bi desktop you can
00:48:09 see when you open it initially so this
00:48:11 part with the final data model you could
00:48:13 say where you can also create your
00:48:15 visualizations and here we will dive a
00:48:17 bit deeper into the interface to make
00:48:19 sure you know where you can find which
00:48:21 tools which features after data model
00:48:24 we'll also go back to the query editor
00:48:26 and also explore the interface here to
00:48:28 make sure you know how you can prepare
00:48:30 your data efficiently finally we'll dive

00:48:33 into the recommended settings we'll have
00:48:35 a look at some core options of power bi
00:48:37 desktop and we'll also prepare our power
00:48:40 bi desktop course file which I highly
00:48:42 recommend to use throughout this course
00:48:44 this is what's inside this module so
00:48:47 what are we waiting for let's get
00:48:48 started
00:48:52 throughout the course you will find my
00:48:55 current state of the project attached to
00:48:58 different lectures in case you're stuck
00:49:00 or something went wrong with your
00:49:01 project you can then download my project
00:49:04 and compare it to yours to make sure
00:49:06 this works successfully you have to know
00:49:09 some steps which you have to apply to be
00:49:11 able to use this project let's have a
00:49:14 look at these steps now and for that you
00:49:16 can find my project attached to this
00:49:18 lecture it's a zip file make sure to
00:49:21 download this zip file it's this zip
00:49:23 file right here once you downloaded it
00:49:25 make sure to unzip it with a tool of
00:49:27 your choice I'm using WinRAR here for
00:49:29 example so just double click it then and
00:49:32 in this zip file you cannot find the PPI
00:49:34 x-files or the current power bi project
00:49:36 file and a source folder in this folder
00:49:39 you can find all the relevant source
00:49:41 files for this specific project state in
00:49:44 this case we have a GDP data CSV file
00:49:46 because this is actually our initial
00:49:49 project from the last module but now
00:49:51 linked to a local a CSV file no longer
00:49:54 linked to the web therefore make sure to
00:49:56 select this folder and the corresponding
00:49:58 power bi project file and well drag and
00:50:00 drop it to a folder of your choice now
00:50:03 you can open this pbi x file and at
00:50:07 first sight everything looks alright you
00:50:09 can see the map that we created no
00:50:11 errors right here but if you now click
00:50:14 onto this refresh button up here which
00:50:16 will reload the entire data model you
00:50:20 see we have a problem because we could
00:50:22 not find the file because this path
00:50:24 right here is no longer valid in this
00:50:26 case it points to a wrong folder in your
00:50:29 case it would point to a folder on my
00:50:32 machine which obviously is not available
00:50:34 on your computer what you have to do
00:50:35 with each of the downloadable project
00:50:37 files therefore is first have to close
00:50:39 this window now you go to transform data
00:50:42 and click it in the lower part and now
00:50:44 you go to data source settings this
00:50:46 option here in these data source
00:50:49 settings you can find the current data
00:50:51 sources in this power bi file and as you
00:50:54 can see we are currently are using this
00:50:56 path right here pointing towards this
00:50:58 GDP data dot CSV file but apparently
00:51:00 this path is wrong
00:51:02 now click on to change source then we
00:51:06 can again find half and also some
00:51:08 settings related to the where you open
00:51:10 this file but you can leave the defaults
00:51:11 here now go to browse and now go to the
00:51:15 source folder you just unzipped
00:51:16 double-click it and in this folder you
00:51:19 can find this GB data dot CSV file press
00:51:22 open and ok and then close this pop-up
00:51:26 now you see that we have some pending
00:51:28 changes in our queries this means we'd
00:51:30 connected power of your desktop to the
00:51:32 source file and now we have to load this
00:51:33 data from the curia editor into our data
00:51:36 model and by clicking apply changes here
00:51:38 this will well apply these changes and
00:51:41 reload and as you can see now we don't
00:51:44 have anymore problems even if you press
00:51:46 refresh once again the refresh works
00:51:48 successfully and the file is correctly
00:51:51 connected to our source file now make
00:51:53 sure to save this updated path by
00:51:55 clicking on to well save right here and
00:51:58 with that you're ready to go this is how
00:52:01 you can use the attached project files
00:52:03 with that we successfully connected
00:52:05 power bi desktop to our source file one
00:52:08 important note at this point you if you
00:52:10 switch through date of you this is
00:52:12 typically empty you can simply change
00:52:14 that by selecting one of the columns
00:52:16 here in the right part of this fields so
00:52:18 in case this is hidden you can click on
00:52:20 to this arrow and then for example
00:52:22 select the country column with that the
00:52:25 data will be reloaded and you can see
00:52:26 the content of our file talking about

00:52:29 the report view and the state of view
00:52:31 right here we already saw that we have
00:52:34 this Korea datura we have the data model
00:52:36 with the report view and the date of U
00:52:38 and this third option down here so
00:52:40 before we dive deeper into this whole
00:52:43 interface here I think it's important
00:52:45 how power bi desktop actually works what
00:52:48 does the power bi desktop workflow look
00:52:50 like
00:52:54 fury Editora data model dataview report
00:52:58 few lots of different terms at this
00:53:00 point and now the question is how do all
00:53:04 these terms work together where can we
00:53:06 do what in power bi desktop and
00:53:07 especially why let's have a look at the
00:53:10 power bi desktop workflow because
00:53:12 generally you can divide this workflow
00:53:15 into three different core areas the data
00:53:18 preparation the data modelling and the
00:53:20 data visualization the data preparation
00:53:23 is the part we saw in the query editor
00:53:26 this is the part that is all about
00:53:28 connecting power of your desktop to our
00:53:29 source files to this raw data in the end
00:53:32 and working on this raw data to get our
00:53:34 actual data set the data set is the data
00:53:37 we want to work with finally the data we
00:53:40 want to analyse this means once we
00:53:43 finish this preparation we use disclose
00:53:45 and apply method to load the data from
00:53:47 the curia detour into our so-called data
00:53:50 model and this data model consists of
00:53:53 two parts then the data modelling and
00:53:56 the data visualization data modeling is
00:53:58 performed in the data view and the
00:54:00 relationship view we haven't seen the
00:54:02 relationship view so far this allows us
00:54:04 to establish connections between
00:54:07 different tables we'll dive into this in
00:54:09 a lot of detail throughout the course
00:54:10 the data uh view is the view we saw
00:54:12 already this was the part where we could
00:54:14 decide that our country column contains
00:54:17 geographic information for example so
00:54:19 data modelling is this part where the
00:54:22 data analysis takes place where we
00:54:24 further work on our prepared data set
00:54:27 you could say the difference to data
00:54:29 preparation here by the way is that the
00:54:30 data preparation is more focused on to
00:54:32 cleaning the data the data modelling has
00:54:34 the state analysis emphases so as I
00:54:37 mentioned it already we apply
00:54:38 calculations for example to get insights
00:54:41 into our data the data visualization
00:54:43 well this takes place in the report view
00:54:45 then we saw this already this was the
00:54:48 view where we create our different
00:54:49 visuals so this is an important workflow
00:54:53 we'll come back to this workflow several
00:54:55 times throughout the course to make sure
00:54:56 you remember this and you keep this in
00:54:58 mind
00:54:58 but in the end data preparation data
00:55:01 modeling and data visualization data
00:55:03 preparation takes place in the curia
00:55:05 editor data modeling and
00:55:07 is done in the data model and this is
00:55:10 also the way I will use these terms
00:55:12 throughout the course so that's the
00:55:14 theory but what do these parts of power
00:55:17 bi desktop look like in practice
00:55:19 let's explore the interfaces now and
00:55:21 let's get started with the interface of
00:55:23 the data model
00:55:28 I'm back in the project in the default
00:55:31 view whenever you start power up your
00:55:32 desktop the report view in the data
00:55:35 model in the data model we have four
00:55:38 different core areas we have these
00:55:40 ribbons on top here we have these free
00:55:43 buttons to the left we have this center
00:55:45 part you could say with the content of
00:55:47 the corresponding view and we have these
00:55:49 columns to the right let's get started
00:55:52 with these free buttons maybe because if
00:55:54 you think back about the slide regarding
00:55:56 the workflow you see that the data model
00:55:58 consists of the report view the data
00:56:01 view and the relationship view and we
00:56:03 can switch between these free views with
00:56:05 these buttons the default one is the
00:56:07 report view weather report the current
00:56:10 visual is displayed then we have the
00:56:12 data of you with the underlying data in
00:56:14 our data model and we have the
00:56:16 relationship view this doesn't help us
00:56:18 too much at this stage as relationships
00:56:21 are all about establishing connections

00:56:23 between different tables in our data
00:56:26 model at the moment we only have one
00:56:28 table therefore this is not too helpful
00:56:30 at this stage but the important thing is
00:56:32 depending on the view you select
00:56:34 different types of content are displayed
00:56:37 here now we see here in our relationship
00:56:40 view that we have the table name up here
00:56:42 and our column names or our fields and
00:56:45 these fields can also be seen in the
00:56:48 right part here because if you expand
00:56:51 the menu here you see we have these
00:56:53 fields once again and this fields column
00:56:55 is also available in the data view right
00:56:58 here and in the report view because the
00:57:01 fields indicated here as the
00:57:03 corresponding column names contain the
00:57:05 underlying information in our data and
00:57:07 with these fields we can then interact
00:57:10 with the content in the corresponding
00:57:12 view for example in the report view if I
00:57:15 select current visual I can interact
00:57:18 with it for example I can unselect the
00:57:19 GDP or edit or I can drag-and-drop new
00:57:22 values into specific areas of our visual
00:57:25 same thing can be done in the date of
00:57:27 view if they go there too I can select a
00:57:29 specific column for example right here
00:57:31 right there or right there so fields are
00:57:34 the interaction part between our content
00:57:36 and define what should be displayed here
00:57:38 now when we are look at this view
00:57:41 we see that in the data view we only
00:57:43 have one single column so Chesterfields
00:57:46 in the relationship view we have two
00:57:48 columns fields and properties properties
00:57:51 will become important later
00:57:52 when we work on relationships and in the
00:57:55 report view we have three columns fields
00:57:57 visualizations and filters we use the
00:58:00 filter already here to filter for our
00:58:02 top 10 countries by GDP so these filters
00:58:04 allow us to specifically tailor the
00:58:07 information that should be displayed in
00:58:09 our visual and here in the
00:58:11 visualizations column we have the option
00:58:13 to interact with our current visual for
00:58:15 example here when it comes to the type
00:58:18 of data that is displayed individual or
00:58:20 right here to change the style the
00:58:23 format of our visual by disabling or
00:58:26 enabling the category labels or by
00:58:28 changing the visual type by simply
00:58:30 selecting a different one like this or
00:58:32 like that so these are the three core
00:58:35 areas down here we can switch between
00:58:37 different views which has an impact on
00:58:40 to our content that is displayed and
00:58:42 also on to the columns here displayed to
00:58:45 the right but it's all about fields and
00:58:47 the corresponding content in the end
00:58:49 what about these ribbons appear now well
00:58:52 these ribbons also change depending on
00:58:54 the view and depending on our selection
00:58:56 of the content in the corresponding view
00:58:59 I selected the visual here in the report
00:59:02 view therefore I have two additional
00:59:04 ribbons format right here and theta
00:59:07 drill if I unselected visual these
00:59:10 ribbons are gone because I can't
00:59:12 interact with a specific visual as I
00:59:14 didn't select one if I go to the date of
00:59:16 you you see we have these column tools
00:59:19 here we have these column tools because
00:59:21 we previously selected a column scale
00:59:24 right here if I select country well
00:59:26 column tools are still available but now
00:59:28 for the country field or a country
00:59:30 column and if I go right here to the
00:59:33 left and click on to GDP data or a table
00:59:35 then the column tools are gone now we
00:59:38 refer to our enter a table because
00:59:41 relationship view for example you see we
00:59:43 don't have these ribbons we only have
00:59:44 home and held for a moment talking about
00:59:47 the home ribbon the home ribbon is
00:59:49 available in all the different views and
00:59:51 it summarizes some core features you
00:59:55 could say
00:59:55 options available in all different views
00:59:58 our data and queries these are all about
01:00:00 the connection to our source files and
01:00:02 about access to the query editor if you
01:00:05 go to the relationship view tree home
01:00:06 ribbon
01:00:07 you see we also have data and queries
01:00:09 same thing is the case here in you
01:00:11 report view we also got data and queries
01:00:13 we still got some unique options also
01:00:16 depending on the view we are using for

01:00:18 example in the report view we have this
01:00:20 insert option related to creating new
01:00:23 visuals which can also be accessed in
01:00:26 more detail here in this insert ribbon
01:00:28 this would not be available here in our
01:00:31 data of you estivate of you is not about
01:00:34 creating visuals what we have in both
01:00:36 though the data view and the report view
01:00:39 are these calculations calculations will
01:00:42 create new columns or new fields
01:00:44 therefore if I create a new field I want
01:00:47 to see this field maybe here in the date
01:00:49 of you or I want to use this field here
01:00:52 in the report view therefore if you go
01:00:54 to modeling right here you also have
01:00:56 these calculation options so this is a
01:00:58 first glance at the interface and at the
01:01:00 different ribbons it's just important to
01:01:02 keep in mind that we have different
01:01:04 views with different purposes and
01:01:06 different options available to last
01:01:09 things here maybe when it comes to the
01:01:11 interface here we can save our project
01:01:13 or undo or redo our last action also
01:01:16 quite helpful feature and here in the
01:01:19 file ribbon we have options related to
01:01:21 the power bi file itself like saving
01:01:23 data or like accessing the options and
01:01:25 settings so that's the data model but
01:01:28 what about decree editor now
01:01:34 the Curie editor is the data preparation
01:01:37 part so actually this is a step ahead of
01:01:40 the actual data model as I said whenever
01:01:43 you start power bi desktop you are in
01:01:45 the report view in the data model to
01:01:47 access the free editor you can simply
01:01:50 click on to this button right here this
01:01:51 one with that we learned that already a
01:01:54 new window will open so a tool inside
01:01:57 the tool so to say the query editor and
01:01:59 this part is all about the data
01:02:01 preparation the connection to resource
01:02:03 files and about shaping our data the
01:02:06 interface in the query editor looks a
01:02:08 bit different though the general
01:02:10 structure when it comes to four
01:02:12 different core areas is kind of the same
01:02:14 you again have some ribbons up here you
01:02:17 have the actual content in the center of
01:02:20 the screen and then you have information
01:02:22 to the left and the right here let's
01:02:25 second get started with the information
01:02:27 to the left
01:02:27 this furies column the queerest column
01:02:30 simply shows you all connections you
01:02:32 have to source files in our case we have
01:02:35 a single connection to the GDP data file
01:02:38 and the corresponding data it contains
01:02:40 therefore we have one query here in the
01:02:42 right part of the screen you can access
01:02:44 settings related to this query first we
01:02:47 can change the name right here if you
01:02:49 want to so you can simply type something
01:02:51 right here press Enter and the name gets
01:02:52 updated I won't change the name at this
01:02:55 stage though and you have the applied
01:02:57 steps the applied steps are a very
01:02:59 important feature because undoing steps
01:03:02 as we just saw it in a data model is not
01:03:04 possible but this applied steps is
01:03:06 actually a way more powerful tool
01:03:08 because you can undo steps by clicking
01:03:11 onto this X symbol right here or you can
01:03:14 even jump back to previous steps by
01:03:16 clicking onto the step here in this
01:03:19 column like this now we are one step
01:03:21 ahead of renaming our columns as you can
01:03:23 see it right here if you want to jump
01:03:25 back just click right there
01:03:26 so the columns here to the left and to
01:03:29 the right are all about managing our
01:03:31 queries our connections to the source
01:03:33 files in the center of the screen we
01:03:35 have the data loaded into power bi
01:03:38 desktop we talked about this already and
01:03:40 above the table you have this formula
01:03:42 bar this formula bar is the code behind
01:03:45 our applied steps because
01:03:48 all these steps are applied by a
01:03:50 specific programming language you could
01:03:52 say the M language also covered later
01:03:54 throughout the course and s power bi is
01:03:57 a user oriented tool we don't have to
01:03:59 write code on our own we can though but
01:04:01 we don't have to and if you want to see
01:04:04 what's behind these steps you can see
01:04:06 this here in this formula bar by the way
01:04:09 if you can't see this formula bar you
01:04:11 can't go to this view ribbon up here and
01:04:13 simply activate it right there now it's

01:04:15 disabled now it's enabled same thing
01:04:18 applies for the query settings in case
01:04:20 you cannot see this column just disable
01:04:22 or enable it right there and this brings
01:04:25 us already to the ribbons once again as
01:04:27 you can see the ribbons look different
01:04:30 when comparing it to the ones we saw on
01:04:31 the data model and here in a query
01:04:34 editor the ribbons are very important as
01:04:36 these ribbons contain all the actions we
01:04:39 can apply to our actual data here in a
01:04:42 query editor you just saw this here with
01:04:44 the view ribbon where you can specify
01:04:46 which type of information should be
01:04:48 displayed you again have an home ribbon
01:04:50 with some core tools like connecting
01:04:53 power bi desktop to data sources or
01:04:55 working on columns or rows but you also
01:04:57 have some detailed options here as we
01:04:59 saw it in a data model so for example
01:05:02 the transform part here but you can use
01:05:04 the first row as headers as we did it
01:05:06 already in the introduction project if
01:05:07 you want to dive deeper into
01:05:09 transforming then simply go to the
01:05:11 transfer ribbon here you have lots of
01:05:13 options are related to transforming or
01:05:15 shaping data of course we'll have a look
01:05:19 at all these options throughout the
01:05:20 course it's just important to keep in
01:05:22 mind that interactions with the actual
01:05:24 data are applied either via the ribbons
01:05:27 up here or by a right clicking on to a
01:05:31 specific part in the actual data so
01:05:34 these are the two ways how you can
01:05:35 interact with your data finally we have
01:05:37 some options not directly related to the
01:05:39 data at first it's the save option right
01:05:42 here you notice already if you do so you
01:05:44 can save your current status of the
01:05:46 report and we again in file options to
01:05:48 save the file or to access the options
01:05:51 in general and you have close and apply
01:05:53 apply or close these are options to
01:05:56 leave the creator for the moment we
01:05:58 can't just click close and apply it to
01:05:59 do so
01:06:01 with that we are back in the data model
01:06:04 and as we now saw the interface of the
01:06:06 Korea deter and this data model it's now
01:06:09 time to dive into the recommended
01:06:11 settings and also to create a blueprint
01:06:14 project file which we can use to follow
01:06:17 along this course conveniently
01:06:22 in the next course module we'll get
01:06:24 started with the course project for this
01:06:27 we need an empty power bi desktop
01:06:28 project file and I want to make sure
01:06:31 that we are all starting with the same
01:06:33 file settings otherwise this can cause
01:06:36 some inconveniences throughout the
01:06:38 course to avoid this let's create this
01:06:40 file now and let's set the options
01:06:42 correctly there for this we'll close our
01:06:45 current initial projects use V file and
01:06:48 we can of course save the changes that's
01:06:51 fine and now we will open a new power bi
01:06:54 desktop file by simply opening power bi
01:06:56 desktop again we can close this pop-up
01:07:02 and now I want to access the options we
01:07:05 know how this works already we go to
01:07:07 file options and settings and here we go
01:07:12 to options in here we have two different
01:07:17 types of options we have global options
01:07:20 and current file options global options
01:07:23 are applied to power bi desktop in
01:07:25 general this means this applies to all
01:07:27 our power bi desktop projects we have on
01:07:30 our computer current file options as the
01:07:33 name indicates only apply for the
01:07:36 currently open project file and that's
01:07:39 very important because if you start a
01:07:41 new project you have to make sure that
01:07:43 the current file options are set
01:07:45 according to your needs and that's also
01:07:47 the reason why I want to create this
01:07:49 blueprint project file together now
01:07:51 because with this we can make sure that
01:07:54 we are all starting with the same
01:07:55 settings let's get started with the
01:07:58 global options though here we only have
01:08:00 one important thing actually when it
01:08:02 comes to this course project the
01:08:04 regional settings right here this model
01:08:07 language should be set to English United
01:08:09 States make sure to do so as this will
01:08:12 have an impact on to the way power bi
01:08:14 interacts with strings for example so
01:08:17 that's the first setting you should
01:08:18 change this could be set to use

01:08:20 application language in your case
01:08:21 therefore make sure to change it to
01:08:23 English United States now we continue
01:08:27 with the current file options first we
01:08:29 go to data load and here it's important
01:08:31 to unselect all boxes when it comes to
01:08:34 type detection and relationships
01:08:36 these are not bad options at all these
01:08:38 can be very helpful options in your own
01:08:40 project but in this course I want to
01:08:43 make sure that each step we perform is
01:08:45 performed manually by us as we want to
01:08:48 understand how power bi works
01:08:49 therefore we should unselect first the
01:08:52 type detection which should
01:08:53 automatically detect data formats for
01:08:55 example or column names and
01:08:57 relationships which would automatically
01:08:59 establish relationships in our project
01:09:02 file also something we want to do on our
01:09:04 own so this looks all right here the
01:09:07 next option are the regional settings
01:09:09 now here this is the locale we talked
01:09:12 about this in the introduction project
01:09:13 already and the locale is a crucial
01:09:16 setting when it comes to formatting and
01:09:18 interpreting numbers dates and more
01:09:20 make sure to set this to English United
01:09:23 States here because this will allow you
01:09:25 to conveniently follow along this course
01:09:27 let's press ok now and in case you get
01:09:31 the warning that you should restart
01:09:32 power bi desktop to make sure the
01:09:35 changes are applied you can do so but
01:09:37 before you do this make sure to save
01:09:39 this blueprint file that's very
01:09:41 important because we will use this
01:09:43 project in the next module for this we
01:09:45 simply click onto this save symbol here
01:09:47 now you navigate to a folder of your
01:09:49 choice and let's maybe call this project
01:09:53 blueprint here and let's save this now
01:09:59 make sure to close this file
01:10:00 because you might have to restart it to
01:10:02 apply our changes and now let's reopen
01:10:05 this file this project blueprint pbi X
01:10:08 file and here we go
01:10:14 now we prepared our project and now
01:10:17 you're ready to get started with power
01:10:18 bi desktop and how do we get started
01:10:20 well with our course project and with
01:10:23 the data preparation so it's time to
01:10:25 dive deeper in through query editor now
01:10:27 in the next module
01:10:38 you

You may also like