Deprecated: Creation of dynamic property CF\WordPress\DataStore::$logger is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php on line 23
Deprecated: Creation of dynamic property CF\WordPress\Proxy::$pluginAPI is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/Proxy.php on line 31
Deprecated: file_get_contents(): Passing null to parameter #2 ($use_include_path) of type bool is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/codelights-shortcodes-and-widgets/codelights.php on line 20
Warning: session_start(): Session cannot be started after headers have already been sent in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/wordpress/src/class/wordpress.php on line 53
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758
Warning: Cannot modify header information - headers already sent by (output started at /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php:23) in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/rest-api/class-wp-rest-server.php on line 1758
{"id":773,"date":"2018-10-12T14:20:07","date_gmt":"2018-10-12T21:20:07","guid":{"rendered":"https:\/\/bonbonsguide.com\/wp\/?p=773"},"modified":"2018-12-02T13:38:26","modified_gmt":"2018-12-02T20:38:26","slug":"msptda-14-power-pivot-into-2-amazing-columnar-database-importing-millions-of-rows-data-into-excel-3","status":"publish","type":"post","link":"https:\/\/bonbonsguide.com\/wp\/blog\/2018\/10\/msptda-14-power-pivot-into-2-amazing-columnar-database-importing-millions-of-rows-data-into-excel-3\/","title":{"rendered":"Power Pivot Intro #2: Amazing Columnar Database Importing Millions of Rows Data into Excel MSPTDA 14"},"content":{"rendered":"Download Excel START File: https:\/\/ift.tt\/2OjjG41
\nDownload Zipped Folder with Text Files: https:\/\/ift.tt\/2yAuGiN
\nDownload Excel FINISHED File: https:\/\/ift.tt\/2Omigpl and https:\/\/ift.tt\/2yDQGsS
\nDownload pdf Notes about Power Query: https:\/\/ift.tt\/2Okxdsa
\nAssigned Homework:
\nDownload Excel file and complete the homework:
\nhttps:\/\/ift.tt\/2yIVa1J
\nExamples of Finished Homework:
\nhttps:\/\/ift.tt\/2OoIUxZ
\nThis 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 \u201cBig Data\u201d.
\nComprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.
\nTopics:
\n1. (00:15) Introduction: Discussion of how to import \u201cBig Data\u201d 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).
\n2. (03:25) Power Query to Import Text Files (Big Data) From Folder and Append them into a single table.
\n3. (07:50 Columnar Database Explained. How does Columnar Database work? Where is Columnar Database in Excel?
\n4. (12:55) Make Data Model PivotTable with Implicit Measures.
\n5. (14:23) Example of dramatic file size reduction when we use the Columnar Database for a single Text File.
\n6. (16:21) Define Columnar Database. Lookup at pdf notes.
\n7. (17:37) Why Microsoft names the Big Data tool in Excel \u201cPower Pivot\u201d.
\n8. (18:21) Summary<\/p>\n