Power BI - Entering data

Hello friends and welcome to Tuttle's Point

In this segment of the video we are going to see how to enter data in Power BI desktop

So far we already know that we can import data with various data sources, sources like

Excel, SQL, SQL Server, Access Database, a text file, a CSV file or a web-based file as well

There are many other sources from where we can import the data that we have seen in our previous

video as well. Now let's take for an example that I have a very small data set and I want to generate a report for that

So why will I do an additional effort of going to the Excel file or an excess database and

create the table and imported from them? Instead of doing this such a rigorous work, what we can do out here is we can manually create

the data in Power BI desktop itself. So how to create this table and how to enter the data manually will be having a better understanding

of this in our practical approach hello friends and welcome in this video we are going to see

how to enter data in power bi so let's go ahead and let's see how it is done so in order to do that

we have to go under the home tab and under the home tab do you see something called us enter data

now how it is different from get data the only difference between this is when i click on

enter data it helps me to feed the data manually to power bi whereas when i

do get data i am importing data from different various sources all right so we will be seeing how to enter data manually in Power BI So I will simply click on Enter data

The moment I click on Enter Data, it gets me a new window which says create table

I will simply go to this particular column and I'll simply type a name. Let's say John, I hit Enter

I will again go ahead add some new more names. Let's say Smith, we have Diana and we have Rose

all right so we I have this call number one if I want to insert a new column you see

there's an asterisk mark out here I will simply click on this asterisk mark and

will rein this as the age let's say for an example and this will be our

name so name and age let's say John is 30 just a sec John is 30 then we have

25 then let's say 24 and rows around 28 okay so this is how you enter the

data manually if I want to add new columns I will simply click on this button and if I

want to add new rows I will simply click on the asterisk mask in the row section

all right so this is how you can enter the data manually all right so out here

if you can see that below it is also asking me if you want to name this table

yes let's say that this is employee database employee database in which I have

the name and I have that is that's it and the moment i simply click on load it will load the data right on my power bai screen or if you want to make any kind of changes i don think so that will be requiring any kind of changes as it a very simple data with the name and age to it so I simply click on load the moment I click on load this particular table will get added to my power BI screen as you can see I have age I have name as well so let say create a graph if I want to add names and let see their age so I be getting simple simple column chart which says the name of all the employees and

there's respective ages along with it okay i'll simply delete this now this what we have

learned how to enter data manually by typing it we can also enter data using a clipboard function

that is the control c that is copy and paste function where i'll simply copy the data from specifically

let's say excel sheet and get it pasted in our module out here so i will simply click on enter data

all right again i have this uh trade table right in front of you let me

quickly go to the Excel sheet that will be fetching the data from so I will

simply go to my Excel sheet now all right so out here you can see my Excel sheet

in which I have some more columns I have some product units unit price and the total

cost along with it so what we will be doing we will be copying and pasting this

data in our power BI screen okay so let's go and copy this so the shortcut keys control see I have copy this data let me quickly move to the power BI screen all right so we are back to our power

B I'll simply click here and I'll just press control V the moment you keep on

control V it is getting me all the data that which which was being seen in our

Excel sheet right now this time we will say our product database we are

near naming this particular table as product database and in which as you can see the very first row it has automatically taken as the column header

it is also giving you an indication which says the first row of data that you pasted has been

promoted to column headers if you don't want to you can simply undo the headers but as we wanted

i will simply close this and similarly you can add here manually as well but as of now i won't

be needing this so i'll simply click on load all right so

So I have the product database out here. You can see on this drop-down menu, I have the product

So I'll simply drag this product and their cost along with it

So it's in a tabular format. A simple tabular format. Let's make it into a graphical format

Let's say a pie or let's say a column chart. We also have some donut chart along with here

which will give you a better understanding that how this report is being shown

Alright, so guys, this is how you enter data manually using the enter data feature in power BI

All right. Hopefully you guys like this video, see you until next time