Power BI Desktop is a free tool that used to create visualization, reports and dashboards for publishing it to Power BI service. Power BI desktop organizes, streamlines and centralizes all data to build meaningful visualizations.
Power BI desktop lets us connect to multiple data sources and shaping the data to create reports and visualizations. Power BI desktop has powerful query and data models for shaping the data. When reports are created they can be uploaded into power BI service and then shared with collaborators for viewing and editing.
Power BI Desktop saves file with .pbix extension. These file types can be shared like other file type, but the best way is to upload them into Power BI service portal.
Enthusiastic about exploring the skill set of Power BI? Then, have a look at the Power BI Training Course together additional knowledge.
Installing and Running Power BI Desktop
Power BI desktop runs in Windows version 7 and higher or Windows Server 2008R2 and higher. Minimum system requirements followed as
Internet Explorer 9 or later
Memory (RAM): At least 1 GB available, 1.5 GB or more recommended.
Display: At least 1440x900 or 1600x900 (16:9) recommended.
1GHz CPU x86 or x64 bit or faster
Power BI is available as a MSI package and runs as a windows application.
Power BI Views
There are three views in Power BI Desktop.
Report View: here we build visualizations using queries and drag and drop methods. These visualizations can be arranged with multiple pages and shared with ithers.
Data View: Here we can see the data in our report as a model format and add measures, create new columns and manage relationships.
Relationship View: Here we can get a graphical representation of the relationships between data model and manage or modify them.
Additionally Power BI Desktop has a powerful query editor for writing queries for transforming the data and the transformed data can be load into Power BI.
After installing power BI we can connect to data sources and establish a connection by selecting the Home ribbon, then Get Data > More.
After connecting and retrieving the data, we can reshape it to meet our requirements. This can include reaming the rows and column. Removing unnecessary rows and selecting headers. The query editor has powerful features to select from reshaping the data.
When we edit or shape the data the original data never changes. We only reshape the particular view or columns. Each time we perform changes in query editor it keeps a record and each time it performs the step to shape the data.
Combine the data
Power BI desktop has a feature to combine two or more data sources to build report.
There are two primary ways of combining queries – merging and appending.
When we have one or more columns that we would like to add to another query, we merge the queries. When we have, additional rows of data that we would like to add to an existing query, we append the query.
In power BI desktop report view we can create reports.
The Report view has five main areas:
The ribbon, which displays common tasks associated with reports and visualizations
The Report view, or canvas, where visualizations are created and arranged
The Pages tab area along the bottom, which lets you select or add a report page
The Visualizations pane, where you can change visualizations, customize colors or axes, apply filters, drag fields, and more.
The Fields pane, where query elements and filters can be dragged onto the Report view, or dragged to the Filters area of the Visualizations pane.
We can use the visualization panel to select visualizations and drag them to canvas to build reports.
After readying our reports we are ready to publish it and share it with others. we can share it with others on the Power BI service. There are a few ways to share your work in Power BI Desktop. You can publish to the Power BI service, you can upload the .pbix file directly from the Power BI service, or you can save the .pbix file and send it like any other file.