Power Pivot is an Excel add-in that was first introduced in Excel 2010 by Microsoft. It allows you to harness the power of Business Intelligence right in Excel.
In a nutshell, Power Pivot allows you to use multiple data sources for analysis. So it is a Pivot Table on steroids, meaning it can handle more data and create more powerful calculations using Measures & DAX Formulas. Power Pivot gives you the power to work with large sets of data that are OVER 1 millions rows!!! You can import, consolidate and create relationships from your data and perform enhanced analysis. The beautiful thing with Power Pivot is it allows you to work on Big Data with NO limitations. Imagine getting data from multiple sources like SQL Server, Oracle, XML, Excel, Microsoft Access and analyzing these all into one awesome Pivot Table! This course will introduce you to the key concepts of getting started with Power Pivot and it's various features for enhanced calculations, so you will be confident & comfortable in using Power Pivot on your data. More info - https://www.skillshare.com/classes/Microsoft-Excel-Excel-with-Excel-Power-Pivot-Measures-DAX-Formulas/1370216209
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.