Microsoft Power Bi

By Author: pranay
Total Articles: 5
Comment this article

Dear Friends from quite a long time I was wishing to write a few blogs on this topic, but due to some limitation, I was unable to do so. I will be posting a few blogs in this series using which any beginners can practice and have hands-on to understand this concept and start using this powerful tool for visuals and reporting. power bi training online it guru

Microsoft Power BI brings your data to life, transforming your company's data into rich visuals for you to collect and organize so you can focus on what matters to you.

An Overview:

PowerBI-1

What all you need to get started with creating reports.

To get started first of all we will be required to register our account to PowerBI.com

Go to this Link Power BI

Scroll down on the page to find below

PowerBI-2

Here you require your company registered e-mail id, any private e-mail id, for example, Yahoo, Google, Hotmail etc. will not be acceptable.

Follow the onscreen guide to complete your signup.

Please use this link to access available downloads.

PowerBI-3

As of now we will use highlighted ...
... two components. Download and Install them. We will use and explore them in our upcoming posts.

At this step you are ready to start with using Power BI, you can design the Reports & Datasets on your in premise database and publish to Power BI.

We will use these components in our future posts, today we will have a quick report creation using data from Excel as our first Report. Here we go…….

Step 1- Collecting the Data.

Open your Navision and Export some data which we can use to create our first Report.

In my example, I am going to Export my Customer List and save the Excel file, make sure your data is saved in Table Format else Power BI will fail to import data.

Step 2- Getting Data in Power BI from Excel using Get Data.

Login to Power BI using your credentials used above to register the Power BI.

From Lading Page perform below step:

PowerBI-4

When you click to Get Data you will get options to connect with available data source options.

PowerBI-5

Click Get button as highlighted in the above screenshot, as we are connecting the data from Excel file created in the above Step.

On Clicking Get Button option available to get file will be displayed, depending upon where you placed your file select the desired option. In my case, I have saved the File on My Desktop, so I will be using the Local File option.

PowerBI-6

PowerBI-7

Select the desired file having data. In my case Customer List as created in the above step.

PowerBI-8

Once done you will see a new Dataset and a Blank Report in Dashboard is added, in my case CustomerList.

Step 3- Analysing Data in Power BI or creating a Visual Report.

Click on the customer list dataset

PowerBI-9

This will show you the available Fields as per Excel columns, available Visualization options.

PowerBI-10

Select the No. Field from the Field List, a list table will be added on the canvas as shown in the above screen.

Here say we want to count the no of Unique Customers in the data.

PowerBI-11

From the Values of the Field, we will choose Count Option.

At the same time to make data more representable, we will choose Card Visualization.

The data will be formatted and displayed as:

PowerBI-12

Next, we will add some summary analysis Data.

PowerBI-13

Here we added two Fields Location (Value = Don’t Summarize) and Name (Value = Count). Visualization = Table.

A new table gets added on the Report Canvas as shown above.

Let’s change the Visualization of above Table to Treemap, the Table will get formatted as:

PowerBI-14

That’s all for today, we will see more features and other available options in our next blog. online it guru
Contact Information:
USA: +1 469 522 91 62
INDIA: +91 9550102466