Download Excel START File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/014-MSPTDA-PowerPivotToImportMillionsStart.xlsx
Download Zipped Folder with Text Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/014MSPTDATextData.zip
Download Excel FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/014-MSPTDA-PowerPivotToImportMillionsFinished.xlsx and https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/014-ImportOneText.xlsx
Download pdf Notes: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/014-MSPTDA-ColumnarDatabaseNotes-PowerPivotToImportMillions.pdf
Assigned Homework:
Download Excel file and complete the homework:
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/014-HomeworkStart.xlsx
Zipped Folder with Text Files: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/014-MSPTDA-HomeworkTextFiles.zip
Examples of Finished Homework:
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerPivot/014-HomeworkFinished.xlsx
This video teaches about the Columnar Database in Excel Power Pivot Data Model, which allows us to import and hold millions of rows of data in an Excel Workbook and have a small file size. We can also make Data Model PivotTable Reports from this imported “Big Data”.
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
Topics:
1. (00:15) Introduction: Discussion of how to import “Big Data” Into Excel. Discussion about how Excel, Power Query, Power Pivot and the Data Model Columnar Database work together to make importing big data possible in Excel (and in Power BI Desktop).
2. (03:25) Power Query to Import Text Files (Big Data) From Folder and Append them into a single table.
3. (07:50 Columnar Database Explained. How does Columnar Database work? Where is Columnar Database in Excel?
4. (12:55) Make Data Model PivotTable with Implicit Measures.
5. (14:23) Example of dramatic file size reduction when we use the Columnar Database for a single Text File.
6. (16:21) Define Columnar Database. Lookup at pdf notes.
7. (17:37) Why Microsoft names the Big Data tool in Excel “Power Pivot”.
8. (18:21) Summary