Power BI - Tools and Functionalities Last Updated : 17 Jan, 2023 Comments Improve Suggest changes Like Article Like Report Power BI is a Data Visualization and Business Intelligence tool by Microsoft that converts data from different data sources to create various business intelligence reports. It provides interactive visualizations using which end users can create reports and interactive dashboards by themselves. It is highly recommended to download Power-BI tool before proceeding further. Navigating Power BI: Power BI provides a plethora of various tool and services to make creative, interactive and intelligent Business Reports. Import/Export .csv files 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? Query Editor in Power BI is used to edit or format the data files before they are loaded into the Power BI Model. The Query Editor plays the role of an intermediate data container where you can modify data type or the way the data is stored by selecting the particular rows and columns. Views in Power BI There are 3 different types of views in Power BI. You can switch between the 3 views using Navigation Pane. The 3 Views in Power BI Report 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. Various tools and panels in Power-BI The Power-BI provides various tools and services: Modelling Ribbon: You can perform various functionalities using this panel. Upload datasets.Make calculations.Edit data types.Format data category for a column.Insert visualizations. Fields list: This list contains elements of your uploaded dataset. You can select a table or column to view in the data grid. Navigation Pane: This panel controls the different views of Power BI (Report/Data/Model). Visualization Pane: There are many different types of visualizations in Power-BI that help depict your report in various ways. This panel provides over 30 visualizations. More custom visualizations could be found online as well.Few important visualizations are listed below. 1Stacked Bar/Column Charts6Tree Maps2Clustered Bar/Column Charts7Tables and Matrix3Line/Area Charts8Pie Charts4Ribbon Charts9Python-Scripts5Waterfall Charts10R-Scripts Building Blocks of Power-BI There are 4 major building blocks that make Power-BI a very powerful tool. Fact: There is a 5th Building Block known as Tiles that is available in the Power-BI pro version. Visualization 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.Power BI : Visualizations Datasets:A Dataset is a collection of data or a container of data that is used by PowerBI to create visualizations.A Dataset is something which you import or connect to.Datasets can be renamed, refreshed, removes, and explored.Power BI : Types of DatasetsS.noData SourceDescription1.Comma Separated Value (.csv)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. 2.Excel (.xlsx)A workbook can have data entered manually or data, which is queried and loaded from external data sources. 3.Databases via SQL ServerYou can connect directly to SQL Server Analysis Services Relational model databases.4.Databases on CloudYou can connect live to Azure SQL Database, Azure SQL Data Warehouse, etc to get databases.5.Power BI (.pbi)You can use Power BI Desktop to query and load data from external data sources. Reports:A report is one or more pages of interactive visuals, text, and graphics that makes up a single report.All of the visualizations in a report come from a single dataset.Power BI : Reports Dashboards:A dashboard represents a customized view of some subset of the underlying dataset(s).A dashboard is a single canvas that has tiles, graphics, and text.Purpose of Dashboards is toget all the info at one place, needed to make decisions.to monitor the most-important info about your business.to ensure all colleagues are on the same page.to monitor the growth of a business or product. Power BI : Dashboards This was a brief introduction covering the fundamentals of Power BI and the tools are services provided by Power BI. It is a very powerful tool by Microsoft that helps make large business decisions and stimulate the growth of the company. You can now import your own dataset and create your own innovative and interactive reports using the building blocks of Power BI. For any doubts/queries, leave a comment below. Comment More infoAdvertise with us Next Article Power BI - Tools and Functionalities P prakharr0y Follow Improve Article Tags : Power BI Similar Reads Power BI - Data Sources and its type In Power BI a data source is simply where your data originally comes from. It could be a file stored on your computer, a database, an online service or any other place that Power BI can connect to. These data sources are important because they provide the basic information that Power BI uses to crea 4 min read Power BI - Administration Role The Administration role allows users to manage and administer the Power BI service. Users with this role have access to administrative features such as managing users, workspaces, and data sources, setting up security policies, and monitoring usage and performance. To administrate Power BI for you, 9 min read Power BI - Introduction Power BI is a software developed by Microsoft that helps you to turn raw data into clear and useful information. It helps to create interactive charts, reports and dashboards so you can easily understand your data. Whether you work in business, research or any field that uses data Power BI makes it 5 min read Power BI - How to edit in Power BI App? Power BI is a data visualization application that lets you connect, transform and find insights into the most pressing matters of your business. It helps in sourcing your data and creating visual dashboards, KPIs, and reports by editing the data as per your concerns. You can collaborate, share and i 8 min read Power BI - Business Applications Business Intelligence (BI) reveals information that can be used to inform strategic choices. Tools for business intelligence evaluate both recent and historical data and display insights in simple visual representations. Any application that is crucial to managing your firm is referred to as a busin 10 min read Power BI - Practical Applications A feature of Microsoft Office 365 called Power BI gives business users access to insights from their data. Users of the software can visualize information using a range of tools, such as graphs and diagrams. In other words, Power BI serves as a link between your data and the individual who will ulti 7 min read Power BI Tutorial | Learn Power BI Power BI is a Microsoft-powered business intelligence tool that helps transform raw data into interactive dashboards and actionable insights. It allow users to connect to various data sources, clean and shape data and visualize it using charts, graphs and reports all with minimal coding.It’s widely 5 min read Differences Between Microsoft Power BI and SSRS SSRS and Power BI are both Business Intelligence (BI) tools that are made to show data to users in a easy to understand way. Even though Microsoft made both but they are designed for different types of users and used for different purposes. In this article, we will see the differences between Power 3 min read Editing Power BI Report Interactions Power BI is a platform that is used to connect, visualize, and share data with other users. It is a business analytics and data visualization tool that converts data from sources extracts information from that data and represents it in interactive visualizations and reports. In this article, we will 10 min read Power BI - Excel Integration Power BI and Excel integration combine the data visualization and reporting capabilities of Power BI with the spreadsheet functionality of Excel. By linking the two users can analyze and manipulate Power BI data directly within Excel. This is vey useful tool for those who prefer working in Excel but 3 min read Like