• 26. 11. 2019
  • Ing. Jan Zedníček - Data Engineer & Controlling
  • 0

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.

Rate this post

Ing. Jan Zedníček - Data Engineer & Controlling

My name is Jan Zedníček and I have been working as a freelancer for many companies for more than 10 years. I used to work as a financial controller, analyst and manager at many different companies in field of banking and manufacturing. When I am not at work, I like playing volleyball, chess, doing a workout in the gym.

🔥 If you found this article helpful, please share it or mention me on your website

Leave a Reply

Your email address will not be published. Required fields are marked *