Power BI is a cloud-based data analysis, which can be used for reporting and data analysis from wide range of data source. #PowerBI is simple and user friendly enough that #businessanalysts and power users can work with it and get benefits of it. On the other hand, Power BI is powerful and mature enough that can be used in enterprise systems by BI developers for complex data mash-up and modelling scenarios.
Power BI consists of 6 main components,
Power Query: Data connectivity and transformation tool.
Power Pivot: Data modelling tool
Power View: Data visualization tool
Power Map: Geo-spatial data visualization tool
Power Q&A: Natural language question and answering engine.
Power BI Desktop: A powerful companion development tool for Power BI
All these components can be used Individually in the Microsoft Excel 2013 by downloading as Addins. In Microsoft excel 2016 all the above components are embedded except Power BI Desktop, Power BI Desktop is a development tool for Power BI.
Overview
Power Query is a strong data mash up, connectivity and transformation tool. It allows the user to connect to various Data sources like Excel, Access DB, Text files, SQL Server, Oracle server etc. once connected to the data it will help in converting the raw data to meaningful data with the help of #PowerQuery Editor here all the data transformation takes place.
Power Query also uses a powerful formula language as code behind called M. M is much more powerful than the GUI built for it. There are many functionalities in M that cannot be accessed through Graphical User Interface.
#PowerQuery provides a Graphical Interface to transform data like cleaning, appending the tables, merging the tables etc.
Power Pivot is data modelling tool which helps to create complex and large data models, relationship and create calculated columns in the Power BI and can be used as an individual component in the Microsoft Excel. #PowerPivot uses Data Analysis eXpression (DAX) for developing measures and columns in the datasets. #DAX is functional language and consists of numerous functions!
Power View is a data visualization component of Power BI. This connects to data sources and takes the metadata and uses in the data analysis and Data Visualization. Power View has long list visuals and choose the visuals from market. #PowerView visuals are interactive and can communicate with other visuals as well.
Power Map is a three-dimensional (3-D) data visualization tool With Power Map, you can plot geographic and temporal data on a 3-D globe or custom map. #PowerMap works with Bing maps to get best visualizations based on geographical i.e. either latitude and longitude or country, state, city, and street address information.
Power Q&A is a natural language engine for question and answers to your data model. Once you’ve built your data model and deployed it into Power BI, then you or your users can ask questions and get answers easily with the help of #PowerQnA.
Power BI Desktop is the combination of all 5 above components. Power BI Desktop is a development tool for #PowerQuery, #PowerPivot and #PowerView.
This is it! All these components put together makes Power BI powerful
Please do follow and share!
Used some information from this link
Comments