Office 2013 PowerPivot, PowerQuery & PowerView

Discussion in 'Databases' started by OhioTom76, Apr 3, 2014.

  1. OhioTom76

    OhioTom76 Member

    Messages:
    185
    Likes Received:
    3
    Trophy Points:
    18
    Have any of you been playing around with these? I just recently upgraded to Office 2013 and was really surprised and pleased to see all the new features they added to Excel. This is probably one of the biggest updates they have ever done to Excel in over a decade.

    PowerPivot essentially allows you to join multiple tables of data very much like a relational database, instead of having to rely on VLOOKUPs to pull everything into a single table to build a Pivot Table off of. So you can essentially just import several different tables of data into PowerPivot, establish relationships between them, then build a PivotTable that pulls in all the dimensions and measures from each into one PivotTable.

    The other very important aspect of this is that PowerPivot can handle an unlimited number of rows with ease, like 100MM+ - whereas Excel could traditionally only handle up to 1MM rows on a single sheet.
     

Share This Page