Power BI is one of the newest additions to Office 365. In this course you will learn Power BI from beginner to advance. Power BI Course enables you to perform Simple Data Analysis as well as Complex Business intelligence scenarios and advanced dashboarding. This power BI course will cover five major components of power BI: Power Pivot and Power Query. The other two are for data visualization: Power View and Power Map.
About Excel Power BI
Excel is most important Tool for Self-Service Business Intelligence (BI) activities.
There are four components to Power BI, and all are delivered via Excel. Microsoft is capitalizing on the fact that a huge percentage of business users are most comfortable in an Excel environment. Meanwhile Excel has emerged as the primary mechanism for creation and delivery of Self-Service BI solutions.
Four Components to Power BI
Two of the Power BI components are for data preparation: Power Pivot and Power Query.
The other two are for data visualization: Power View and Power Map.
Power Pivot: Imports and integrates data from various sources for the purpose of creating an in-memory data model. PowerPivot has significant performance advantages over older pivot tables, however. PowerPivot tables can take advantage of far more memory and handle much greater worksheet sizes than previous versions of Excel. On 64-bit workstations, massive amounts of memory can be utilized and enormous data sets manipulated. The PowerPivot interface also includes some useful new capabilities, such as the “slice” capability that allows real time drilldown into subsets of the data. Furthermore, PowerPivot allows the combination of multiple views of the data on a single dashboard-like page. Data Analysis eXpressions (DAX) includes more powerful functions for BI type data manipulations, including iterative expressions, grouping, linking, and filtering.
Power Query: It allows you to do things like merge data, rename columns, replace values and other data modifications in a step-by-step process. A very big deal here is that the step-by-step data cleansing and shaping process is savable and therefore repeatable. You can also view the state of the data before and after each step. Optionally, you can bring the data into your Power Pivot model to continue working with the data even further
Power View: Power View is an interactive data visualization tool. It does certain things like highlighting and cross-filtering really well with very little learning curve. Working with data in Power View bears similarities to working with Excel Pivot Tables as well as to PowerPoint. In addition to charts, graphs, and table data, Power View also supports maps which pan and zoom via integration with Bing Maps. The naturally interactive behavior of Power View is what makes it a very big deal.
Power Map: Power Map is a 3D mapping tool. What makes it unique is the ability to save scenes and play them over time in a tour. Power View is Purely an Alternative to the Excel Visualization Layer. In other words, ideally view Power View is new type of Excel Chart with several enhanced capabilities.that would make an Analyst life so simple.