The Basics of Big Data in Excel: PowerQuery and PowerPivot
- 01.04.2021
- 156
Duration: 39m | Video: .MP4, 1280x720, 30 fps | Audio: AAC, 48 kHz, 2ch | Size: 219 MB
Genre: eLearning | Language: English
PowerQuery and PowerPivot are, for many people, unknown and hidden functions in Excel.
Demystifying these features is going to give you endless possibilities if you work with big loads of data. Therefore, this class is not specific for certain fields or positions within a company, but rather for people using large datasets.
The class is useful because it will save you an enormous amount of loading , formulas crunching, and importixporting files. This class will help you automate importing, cleaning, and processing data.
For this class we recommend Excel 2016. The two features discussed: PowerPivot and PowerQuery can be ed separately for people using older Excel (2010 and 2013):
DOWNLOAD
uploadgig
rapidgator
nitroflare