Purpose of PowerBI Desktop application is to create reports on a local machine and publish them in the cloud for users who can see them anytime, at any moment, by Internet browser on a PC or a mobile device. Managers need to get clear, simple and visually nice reports. It seems that PowerBI meets all given criteria. In a text that follows I will describe various ways to create reports in PowerBI Desktop.
PowerBI Desktop application allows you to import data from many sources: file, database, BI solution, “Big“ (unstructured) data, Microsoft “cloud” (Azure), the web page … Given the fact that there is no good report without quality data I think it is appropriate to devote one recipe especially to this problem. Below, I’ll show you how, with the help PowerBI Desktop you can import, purge and combine various data.
In one of the earlier posts I wrote about that PowerBI comes in many “flavors”: as a Cloud Service (PowerBI.com) as a development environment (PowerBI Desktop), as application for mobile devices available on Windows, Android and iOS platforms (PowerBI Mobile). Since the majority of you who are reading these lines deal with reports development I decided to demonstrate you, in a practical example, how to use PowerBI Desktop.
Companies sometimes have the need to publish reports that are of importance for the various concerned parties (customers, suppliers, shareholders, banks) such as balance sheet, income statement, inventory… If you connect with ERP or BI solution, and further import data to PowerBI and create reports and dashboards, there is an option to generate a link for sharing PowerBI reports on external web site.
In a previous “recipe” you’ve met PowerBI work environment and ways to create reports and dashboards. In the following post I will introduce you to the featured dashboards, favorites, groups and workspaces, display and filtering the content that appears in the menu. Also, there will be words and the additional options to edit, add content and share dashboards. Most of these options can be used in the free variant PowerBI service.