Hello and welcome to my YouTube channel!
Today we're going to learn how to get data in Power BI desktop, so let's get started!
So first let's take a tour of Power BI desktop. So on the top we have the Ribbons, so these are
just the ribbons they display common tasks that are associated with reports and visualization.
So there is the Report View,
the Report view is like a canvas where your visualizations are created and arranged.
Then we have the Data view, it allows you to view all your data available in the report.
And then the Model view, stores the relationship with you have a set of
relationship between tables and elements and common things relates those tables.
So now let's go to the .... before we go to the Visualization Pane
and then we have the Page, where you can add as many pages of visuals as you like
so here I'm just adding pages pages so you can see.
Then that's the visualization pane so you can choose any visual you want
and then you can choose as many visuals you want depending on what you're trying to communicate.
And then you can select data from the field in order to form your visual.
That's the Field, where you can select a column to visualize
and that's the Formats where you can actually format the table or chart or visual.
So this is the field you can pick up any column and just decide to visualize that
and relate that maybe number of products sold so you have to choose products and then
total or quantity for instance. So in this case I'm just showing you the fields are available.
Yeah and then we have the Filter you can actually put filter on the page to say make sure that
everything that is on this page is from the north west for instance, or everything on this page is
from the northeast so you can put a filter on the page, this particular page or you can put a filter
on the whole page. So that's entirely up to you depending on what you're trying to communicate.
So this is a Slicer visual I picked, I can actually put something in there to
say you should be able to filter the whole report based on a specific field or column.
We are not going to go really deep into the visualization itself, it's just to play around
it to just show you what we have in there.
Power BI can handle a variety of data types,
so I'm just going to go ahead and show you all the different types . Like the visual shows,
it can handle excel, it can handle Access, SQL, and others.
So like you can see here, we're just going to go to more so we can see more clearly
and you can see different data sources, data types you can pick from from any data source.
So you can either choose from the All,
just scroll down and pick what you want or you can actually go down to if you know it's already
a file you can pick a file or you can go to database or go to Power Platform or Azure.
So for example for the file you have excel, pdf and then for the database you have
different databases in there that you can pick from depending on what your data source is.
On power platform you can pick any of the Power Platform data sources,
even the Power BI dataset you already have that is existing in Power BI service.
Azure, online services, etc. Online services can include Google Analytics or GitHub.
And others as well.
So basically this is how you actually choose your data source or get your data into Power BI,
so depending on what your data is you have to first of all know what data type you have
and where it's coming from, the data source, before you can know what to connect to.
So once you have that sorted and selected, and then click connect.
And that's it!
In the next video we're going to go more deep into bringing actual data in.
Don't forget to like, subscribe
and leave a comment below and feel free to tell me what you want to see next.
And thank you for watching, bye!