My First Report in Power BI - Step By Step

Lets start Hello World! 

We will start with our First Simple report in Power BI which is easy to understand for the beginner too. 

Our Problem:- We have flat Text file Data (IndiaGDPPopulation.txt)

Our Target:-     Make quick Graphical report.

We will achieve our target with help of Power BI desktop.(this can be done in Power BI services too; without any installation, that we will see later)

Below is our flat text data 

State          GDP Population
Mahatashtra    8        11,12,00,000
MadhyaPradesh 5         8,12,00,000
Gujrat    6         6,18,00,000
Bihar    4         7,32,00,000
Rajstan    4.5 9,62,00,000
Delhi    9         3,12,00,000
Kerla    6.5 4,52,00,000

To start Power BI , Click on the below Icon.(Will see later installation)

Power Bi Icon

Below start up screen will open, Click on the Get data

Power BI Startup Screen

From the shown list, Select on Data source, Text/CSV option. (as our file is notepad file). Click on Connect to continue.

Data Source selection

Open file from your local path. (IndiaGDPPopulation.txt)

Select Data source File

You will see the file will open like below.

CSV File opened

Now by Default Comma is the Delimiter; we will Select Delimiter as Tab; and now our data will be pretty cool as below. Click on Load  to continue.

Data Delimited by Tab

Now you can see there are unwanted columns created like _1, _2, _3; to remove the same click on Edit and will open Query Editor (below screen shot)

Select the unwanted columns, and click on Remove Columns. 

Click on Close and Apply button to apply our changes.

Query Editor - Column Removal

Now it will back to Power BI desktop application, and you will see the Fields  from our Text/CSV file will appear here.

Fields

Now just select the State fields; will see the below magic. Will automatically detect the Map and locate states on India map. And that's the beauty of Power BI, No coding, No object declaration, no compilation, and no....

States on Map

Its not ending, its just beginning; now you just click any desired chart from Visualization (Pie chart, Bar chart and so on); chart Will appear accordingly without any extra efforts (Depend on filed selections).