The major components of PowerBI are as follows :
Let’s discuss each component in brief:
Power Query: It is one of the most important components of PowerBI to transform data. Power Query helps to extract data from different data sources like Oracle, SQL, Text/CSV files, Excel, etc. and even delete data from different sources.
Power Pivot : It is used for data modeling that uses DAX ( Data Analysis Expression) functions for the calculations. Relationships between different tables can also be created here and we can get values that can be shown in Pivot Tables.
Power View: The Power View is used for providing an intuitive display of the data and retrieving the metadata for data analysis. The views are interactive in nature and slicers and filters can be used for slicing and dicing the data.
Power BI Desktop: Power Desktop is an integration tool for Power Query, Power View, and Power Pivot. It helps to create advanced queries, data models, reports and dashboards and helps in developing your BI skills for data analysis.
Power BI Mobile Application: It is available for the Operating systems Android, iOS and even Windows. The App has an interactive display of the dashboards which can be shared as well.
Power Map: It presents geo-spatial visualization of the data in 3 Dimensional Mode. The data can be highlighted based on the geographical location which can be continent, state, city or even street address.
Power Q&A : It is used to provide answers to the questions asked by users. It works with Power View and can be answered with representations by Power Q&A.
