MSPTDA 14: Power Pivot Intro #2: Amazing Columnar Database Importing Millions of Rows Data to Excel
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
Видео MSPTDA 14: Power Pivot Intro #2: Amazing Columnar Database Importing Millions of Rows Data to Excel канала ExcelIsFun
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
Видео MSPTDA 14: Power Pivot Intro #2: Amazing Columnar Database Importing Millions of Rows Data to Excel канала ExcelIsFun
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
MSPTDA 15: Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions5 QUICK Ways to Improve Your PowerPoint DesignEasiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)MSPTDA 13: Power Pivot Introduction #1: Relationships rather than VLOOKUP for PivotTable ReportPivotTable or FREQUENCY function? How They Are Different For Counting Numbers Excel Magic Trick 1720Get Multiple Files Containing Multiple Sheets with Power QuerySlicers in Excel Pivot TableINDEX & MATCH Excel Lookup Functions - All You Need To Know in 10 Minutes (EMT 1618)Getting Started with Power Pivot & Power Query in Excel - 1-Hour ClassMSPTDA 19: CALCULATE DAX Function & Filter Context & ALLSELECTED & KEEPFILTERS (50 Examples)Manage Many to Many Relationships in Power PivotMSPTDA 21: Power Query: Reduce Data Model Size, Transformations to Columnar Database SizeMSPTDA #02: Data Analysis Business Intelligence Terms: Microsoft Power Tools for Data Analysis ClassPower Query Overview - Automate Data Tasks in Excel & Power BIMSPTDA 03: Power Query Introduction: Importing & Transformation Data in Excel & Power BI DesktopMSPTDA 06: Power Query: Merge, Append, & UnPivot – 3 Important TransformationsMSPTDA 09 Power Query Complete M Code Introduction: Values, let, Lookup, Functions, Parameters, MoreMSPTDA 11: Power Query to Import from SQL Server Database in Excel or Power BI Desktop