Excel 2013 PowerPivot Basics #02: Import Large Non-Normalized Data Set To Reduce File Size

See how importing large data sets into PowerPivot can dramatically reduce file size.
1. (00:03 min mark) 500,000 row non-Normalized Data Set in Excel
2. (01:31 min mark) Example of Normalized Data
3. (02:02 min mark) Import data from External Excel workbook into PowerPivot Columnar Database
4. (04:10 min mark) File size is much smaller for Non-Normal data Set example and for Normalized Data Set example.

[excelisfun]

Excel 2013 PowerPivot Basics #02: Import Large Non-Normalized Data Set To Reduce File Size

See how importing large data sets into PowerPivot can dramatically reduce file size.
1. (00:03 min mark) 500, 000 row non-Normalized Data Set in Excel
2. (01:31 min mark) Example of Normalized Data
3. (02:02 min mark) Import data from External Excel workbook into PowerPivot Columnar Database
4. (04:10 min mark) File size is much smaller for Non-Normal data Set example and for Normalized Data Set example.

[trungbui]

These videos are so helpful. Extremely thank you! Excelisfun is always number one in me, a person from Vietnam.

[JimmyChibsTv]

I never knew an excel vid could be soo funny. Love how excited u get.

[akming]

Love you mike! you are way better than my school teachers!

[pauldobbertin]

Thanks so much for these videos. Your enthusiasm for the subject matter and clear/concise instructions make this so easy to follow and stay interested. Great stuff.

[TickyMN]

What a great series this is.  Thank you Mike.  I sure hope your health is back to normal for you.

[krismaly]

I enjoyed this video and recommend to others

Thanks for educating the community and appreciate all your efforts

Thanks a bunch

[bogdanudovicic]

Thank you (also the display-shortcuts-on-the-run is a very nice touch) :).

[mahit]

Excellent explanation, Mike, your passion for Excel is amazing. Thanks, please keep releasing new videos for lesser mortals like me:-)

[DougHExcel]

Good example of the "power" of Power Pivot!

[jitkaflasarova]

Excellent, looking forward to the next videos!

[pmsocho]

Thanks!
It's awesome surprise for the weekend :)

[ExcelxlNl]

Thanks Mike. Great intro to PowerPivot. 

[hoangbachdao]

Thanks a lot for your series of excellence training vid on excel, I just want to ask is there a way to develop a multiple language dashboard so that we have "language" as a slicer, once you filtered one language, all of the indicators in the dashboard changed accordingly. thanks and all the best

[dakotafog]

This is awesome, thank you for the passionate explanations.

If I create and send out a report based on the data that I imported into PowerPivot, would the recipient need to have access to the original data file that I imported from?

Thanks!

[boqunyin]

ExcellsFun, thanks for the great tutorial. One quick question, how to update the PowerPivot file after having the original Non-Normalized data updated? Do it use Ctrl+Alt+F5 to refresh? Thanks.

[doareuGDZ]

I want to thank you for the videos and I have just a short question for you. If you change/add data in the original file, it will be changed automatically in the imported one? or I have to do the import thing again?

[yashvirriar]

Hey! Love your work, really helpful stuff :)

Also, it seems your website is down, can't download file to follow along. It was working fine yesterday though!

[abhaygadiya]

I noted Power Query on your ribbon during the videos....any plan to start series for it as well with PP (PowerPivot) series. It can be helpful for importing the data like in this video.

[TheLincCage]

Thanks for the power pivot series - really loving it! Non excel related question, I see you use camtasia to produce your files... Ive just started using it and am struggling to find a good production setting that has a suitable trade-off between size and quality. Your videos always come out with very good quality - what settings do you use? Thanks!