10 Million Rows of Data Loaded into Excel ( **see updated version of this - link in description**)

Описание: NOTE! Newer Version of this video is now here    • 10 Million Rows of data Analyzed using Exc...  


If a member of your team or organisation says that Excel can't handle the amount of data you need to analyse then maybe they don't know about Modern Excel's power.

This video also highlights the importance of only bringing in the columns you need and the impact that "Cardinality" or uniqueness of data has on the resulting size (and performance) of the Power Pivot report