Monday, February 09, 2015

Spin out a cutting edge report with Power BI under 10 minutes

PowerBI presetnly in preview is available free for users in USA. You only have to agree to licese terms and you are on your way to creating a great looking report under 10 minutes. Any programming requirements? None.

What do you need to get this great report going?

You need to get the PowerBI and download it to your machine from here:


Launch it and connect to your data. Here is a screen shot of PowerBi designer right after launching it. It is the starting page. It looks like a Office page with ribbon and a main menu.

To author a report, you will have to provide information about your datasource. In the present post PowerBI was used to connect to SQL Server 2012. The Sales.SalesPerson table in AdventureWorks2012 database was used to generate the report.

You also have to provide connection information and more importantly information about what you want to report upon. This involves choosing the preferred table or view.There was no programming involved. If you have worked with Power View reports in SQL Server 2012 you sail through very easily, even otherwise it is intuitive.

If you want a thorough grinding in Power View, I have a whole chapter on Power View in my illustrated book, Learn SQL Server 2012 Reporting Services shown below:

As I emphasized earlier you have to know what you are reporting about and server authentication.

Here SalesLastYear and SalesYTD for some of the store personnel is reported. The fields are the ones you choose and voila you a report ready.

PowerBI is still in preview and by the time it gets released it will have gotten input from so many you will be getting a very superior product.

You can find a more descriptive post on my other site in a day or two:


No comments: Protection Status