Power BI is a powerful Data Visualization and Business Intelligence (BI) tool developed by Microsoft. It transforms raw data from various sources into insightful and interactive business intelligence reports. With its intuitive drag-and-drop features and interactive dashboards, Power BI empowers even non-technical users to build reports and analyze data on their own.
Navigating Power BI
Power BI offers a rich suite of tools and services to help users create creative, interactive, and intelligent business reports. Let’s explore them in detail.
Importing and Exporting Data:
Power BI allows you to import data from a wide range of sources, including CSV, Excel, SQL databases, and cloud services. Once you import your dataset, a window called the Query Editor usually pops up automatically.
On following the above steps, the dataset will be uploaded and a window will pop up. This window is called the Query Editor.
Note: If the Query Editor window does not pop up automatically. Just click on Transform Data in the above Navigation panel.
What is Query Editor?
The Query Editor in Power BI is a data preparation tool. It acts as an intermediate data container where you can clean, transform, and format data before loading it into the Power BI data model. Using the Query Editor, you can:
This ensures your data is accurate and optimized before visualization.
Views in Power BI
Power BI provides three distinct views, accessible via the Navigation Pane:
Three Views in Power BIReport View:
Report view is a section of Power-BI where you can create any number of report pages with visualizations.
This view provides a designing environment where you can move visualizations around, copy and paste, merge, and so on.
You can add one/multiple pages here for various visualization of BI-Reports.
Data View:
Data view is a section of Power-BI that helps you inspect, explore, and understand data.
It's different from how you view tables, columns, and data in Power Query Editor.
With Data view, you're looking at your data after it has been loaded into the model.
Relationship View (Model View):
Model view shows all of the tables, columns, and relationships in your model.
This view can be especially helpful when your model has complex relationships between many tables.
Power BI Tools and Panels
Power BI provides a variety of tools and panels to build and manage reports efficiently:
Modelling Ribbon
Perform calculations
Change data types
Format columns
Add relationships
Fields List
View and manage tables, columns, and fields from your data sources.
Navigation Pane
Switch between Report, Data, and Model views.
Visualization Pane
Access over 30 built-in visualizations, including:
Stacked and Clustered Bar/Column Charts
Line/Area Charts
Ribbon and Waterfall Charts
Pie Charts
Tree Maps
Tables and Matrices
Python and R script visuals
You can also import custom visuals from the online Power BI marketplace.
Some of the important built-in visualizations include:
Stacked Bar/Column Charts
Clustered Bar/Column Charts
Line/Area Charts
Ribbon Charts
Waterfall Charts
Tree Maps
Tables and Matrices
Pie Charts
Python-Scripts
R-Scripts
Building Blocks of Power-BI
Power BI is built on four core building blocks, with a fifth available in the Pro version.
Fact: There is a 5th Building Block known as Tiles that is available in the Power-BI pro version.
Visualization Power BI : Visualizations
A visualization is a visual representation of data, like a bar graph, pie chart, a color-coded map, or other through which you can visualize the data.
The following image shows a collection of different visualizations that are there in the Power BI.
A Comma Separated Values (.csv) file is a plain text file that contains a list of data. Every row can contain one or more values, which is separated by a comma.
On following the above steps, the dataset will be uploaded and a window will pop up. This window is called the Query Editor. 
Power BI Tools and Panels
