POWER BI is a data analysis tool [ Software] which can help us to analyze the data in the lightening speed.
We already learnt the basic procedure of importing data into POWER BI through an example taken for the
Now we will learn to import the data from a csv file, which has become quite popular these days.
In this article , we would fetch the data from a csv file and create a visual.
CSV stands for COMMA SEPARATED VALUES.
It is a plain text file which has the content delimited by commas.
The records are presented in a line. Normally one line contains one record which is separated by a comma.
The fields are separated by commas.
The name is due to the use of the COMMA AS A SEPARATOR.
CSV can also contain semicolons, yet it would work as csv file. (European Countries use semicolon (;) in place of a comma (,)
The file has the extension as ” .csv “.
The structure of the table is shown in the picture below.
THE FIRST STEP IS TO CREATE CONNECTION IN POWER BI.
We have the following tasks in the data loaded into power query. [CLICK HERE FOR IN DEPTH DETAILS OF THE FOLLOWING OPERATIONS.]
1. Renaming the column names.:
Right click the column and click Rename. Choose the name as in the original table. Repeat the process for all the column names.
2. Removing the empty rows.
Click the arrow with the column names and deselect the blank , empty, column name [previous one as text] . It’ll remove them from the table. Do this process in the first column.
3. Changing the data types to number types.
Right click the column name, choose change type and choose WHOLE NUMBER. It’ll sort our purpose.
After all the steps are done, click CLOSE AND APPLY. The power query will close and the edited data will be loaded into power bi.
The data after cleaning looks like in the following picture.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE