Power Pivot gives you the power to work with large sets of data that are over 1 millions rows!!! In a nutshell, Power Pivot allows you to use multiple data sources for analysis. It allows you to harness the power of Business Intelligence right in Excel. Power Pivot is an Excel add-in that was first introduced in Excel 2010 by Microsoft. We were able to link and consolidate two Excel Tables together with no need for VLOOKUP or helper columns…thanks to Power Pivot! STEP 12: We now have the Names and the Total Sales Amount all in one Pivot Table. In the ROWS area put in the Name field from the Names Table, in the VALUES area you need to put in the Sales Amount field from the Sales Table: STEP 11: This will create a new Pivot Table within your Excel worksheet. Select New/Existing Worksheet and press OK Within the PowerPivot Window, go to Home > PivotTable. Now it’s time to create a Pivot Table to do our analysis. STEP 10:With this, our setup is complete. This will set the relationship and your Sales table will be able to see the values in the Names table.įor Excel 2010, you can do the same using the Create Relationship Dialog Box: STEP 9:Ensure for Table 1, you set Names = ID and for Table 2, you set it to Sales = ID. STEP 8:Go to Design > Create Relationship. Your two Tables should already be loaded there. STEP 7:This will open Power Pivot Window. This will import your new Table into the Power Pivot Window.įor Excel 2010, go to PowerPivot > Create Linked Table. This will import your new Table into the Power Pivot Window. STEP 4: Go to Design > Table Name and give your new Table a descriptive name. STEP 2: Go to Design > Table Name and give your new Table a descriptive name. In our example, we will name it Names
0 kommentar(er)
