So let's start with one of the most important features of pi will be a that is Square-D editor.
So first of all let's import our data from our Excel data source so we select that find and then we'll
just quickly load it into our RBA file.
And once the file is loaded we can see it here in this field panel.
Now to go to the query letter we just simply have to click this and will be taken back to the glory
of indu.
So this is our window.
And first of all I'll show you some of the basic but important features of the editor.
So when working included editor one of the most important things is to always keep these things clear.
We have the right data type in the right column.
So suppose this is a numerical value so the data type should always be number format.
This all of these which are a number form should be numeric almost like this is OUR did call them.
So it is in the day I did that.
So suppose if you are having a wrong date or time in our column then then we are working with the charts
and graphs this will really cause us some trouble.
If we are using wrong types always make sure that the data types are up here.
So if you want to change any data type we have to just click on these numbers and we see all the data
types which are available here.
So right now just in the right format this is it is the whole number.
We can convert these into any of our defriended or dice.
But as of now this looks quite good.
The x is in text format the number is in number format.
And so this looks good so always make sure that your data type is in the correct format.
Next up is.
Suppose we want to start these columns.
So right now they are in just any random order if you want to these.
We have this two numbers up here sort ascending and start descending.
If you click on this we will get numbers are telling us any order from the smallest to the largest number.
And if we want to sorted in descending order we can just simply click it and we just get the numbers
in the descending order.
We can do this for any column.
And when we click apply any step or romantically this will be shown up in the steps up here and it is
done here.
It is sort of gross.
This was the previous step.
So if we have done anything wrong we can simply go back by clicking on the previous step.
This is one of the important and a pretty good feature of power that we can do.
And ISTEP suppose you don't want Bossard you have done it by any kind of mistake or any applied MS You
have done anything wrong so this is a number format and you have applied it are tax deductible.
So this must not work correctly.
And so one of the good thing is it is mentioned up here we can really just click on the cross cycle
and we will be taken back to the previous step if we don't want to the sort of rules we can again play
across one and we'll take them back to the next step.
So this is a pretty handy step to jump to our previous steps.
Now another thing is all the tables which you'll be loaded will be shown up here so we can pretty easily
rename our it was an image I suppose I want to give this as only sales data.
So our name will be easier pretty easily.
And all of these studies which I've followed here are written in the advance igitur as well.
When you click on this this new window will pop up and this Gore-Bush up here is in language.
So the source is the actual voice.
This is my you model and all of the steps which I've followed are written here in the language so you
can always keep an eye on your and good.
Now suppose that you have genes anything in your base that must be the source.
Suppose the data is from where you have these have any kind of changes.
So if you want to skip that means you are as well.
You can always click on the refresh preview if you click on the refresh preview you will always get
updated data.
If you made any changes in the Exel table so automatically it will not affect you or you have to click
on the refresh preview and once you click click here there will be updated here as well.
So always make sure that you have all that you have the latest data in your file will be fine.
So there are some bunch of other features which I'll explain in the next reviews like boom transform
columns view and you can always go to this window and click on any of these.
These are provided by Microsoft only and they have given a very deep guided learning documentation and
good reviews as well to get any in-depth knowledge.
So that's all for this we do not see you in the next one.
Thank you.