Power BI Desktop – Powerful Report Tool Introduction

Last modified date:

Power BI Desktop is a desktop app for report preparation. It is free and offers a user-friendly interface for data visualization and management. Reports and dashboards do look good in the Power BI.

Data Visualization using Power BI Desktop

Report making used to be a job mainly for IT developers. Regular business users were not able to put hand on the data and edit it. Users like that did not even had a comfortable and easy-to-use tool to make their own report (that was only possible using paid professional platforms). But that is in the past. You can now do all of it on your own using cloud service Power BI (deployment environment) and a Power BI Desktop tool which enables you to create reports and upload them to the cloud.

This is how Power BI Desktop interface looks like:

And this is the final report. You can take a look at it in the picture below. Clicking on the picture will take you directly to the Power bi report.

The image and report is localized for Czech traffic and contains Czech captions … sorry for that, I’ll fix it soon

Power BI Desktop Tool Helps Prepare Data for Reporting

One can stand on their head but this is not doable without well-prepared data. Power BI consists of already mentioned platform for data handlink (data transformations) apart from visualization tools. You are able to create connection to bunch of data sources using simple interface (incl. web tables, your company’s database, excels, text files etc.), you can also edit the data afterwards. List of connectors is basically identical to connectors used by power query (more in article Power Query)

1) You can connect to Excel sheet and import table from there using connector

power bi desktop jak importovat excel

2) You can see the imported tables in the app so you can immediately create reports or…

3)..edit tables before reporting like in excel. App “remembers” list of the steps you have made with the table therefore it can repeat those steps after data update. You can see a demonstration of column name change in the picture. There is also a link to the list of steps (Applied steps) where the name change is visible.

4) Tables can be easily linked between each other in the data model

Comfy data editing into reportable form is a great benefit of Power bi desktop in my opinion.

My name is Jan Zedníček and I work as a BI Developer at Kentico Software in Brno. Mostly you can see me there working in the office, but I also work partly as a freelancer. I have been working as a freelancer for many companies for more than 5 years, but Kentico is the matter of my heart. I used to work as a financial controller at companies like Aero Vodochody or Sberbank and I also used to be a bond program manager in Unicapital Investment group. When I am not at work, I like playing volleyball, chess, doing a workout in the gym and I enjoy tasting of best quality rums. I am trying to summarize all my knowledge on this website not to forget them (because of the rum effect, you know =) and to put them forward to anyone. Don´t worry about asking for help or writing some comments.

Category: Power BI desktop

About Ing. Jan Zedníček - BI Developer, Finance controller

My name is Jan Zedníček and I work as a BI Developer at Kentico Software in Brno. Mostly you can see me there working in the office, but I also work partly as a freelancer. I have been working as a freelancer for many companies for more than 5 years, but Kentico is the matter of my heart. I used to work as a financial controller at companies like Aero Vodochody or Sberbank and I also used to be a bond program manager in Unicapital Investment group. When I am not at work, I like playing volleyball, chess, doing a workout in the gym and I enjoy tasting of best quality rums. I am trying to summarize all my knowledge on this website not to forget them (because of the rum effect, you know =) and to put them forward to anyone. Don´t worry about asking for help or writing some comments.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.