How to use and prepare Data in Power BI Desktop
About Power Bi : Microsoft Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence. It is part of the Microsoft Power Platform.
In this blog We will see how to install and use power bi .
1. We will download Power bi desktop : for it go to Microsoft store and search Power Bi then click on get
2. Then after downloading power bi desktop open it and a window will appear as shown below.
4. After clicking on get data you will see the option like excel,sql,text etc. choose one according to you
5. Now after chhosing the type you will see 3 options : Load , transform and cancel .
6. Click on load data and automatically it will save . After loading press
transform data option and a new window will appear containing the dataset.
7. Now after loading the data set we will see different options like to clean data , row or column transformation ,changing datatype ,removing missing values etc.
Operations that I did in my data set
In my data there is a column name as discount so i had changed the datatype of that column by clicking on the left of that column name as shown below:
Now to check the error or null value i had done one thing by choosing column distribution option in view and got this:
Here Error and Empty is 0 that means there is no null value or wrong value it also give us the distribution graph that can help us to check balance in data .
This type of heatmaps can also be made in visualization option
Comments
Post a Comment