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 1831
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 1831
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 1831
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 1831
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 1831
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 1831
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 1831
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 1831
{"id":1101,"date":"2019-05-04T10:27:12","date_gmt":"2019-05-04T17:27:12","guid":{"rendered":"https:\/\/bonbonsguide.com\/wp\/?p=1101"},"modified":"2019-05-04T10:27:12","modified_gmt":"2019-05-04T17:27:12","slug":"msptda-21-power-query-reduce-data-model-size-transformations-to-columnar-database-size","status":"publish","type":"post","link":"https:\/\/bonbonsguide.com\/wp\/blog\/2019\/05\/msptda-21-power-query-reduce-data-model-size-transformations-to-columnar-database-size\/","title":{"rendered":"MSPTDA 21: Power Query: Reduce Data Model Size, Transformations to Columnar Database Size"},"content":{"rendered":"All 4 files used in video and homework are available in this zipped folder: http:\/\/bit.ly\/2JnYkyT
\nDownload file individually at class web site: http:\/\/bit.ly\/2GF25Ni
\npfd notes for Video #21: http:\/\/bit.ly\/2JfGAW1<\/p>\n
In this video learn key strategies and Power Query Transformation Methods for reducing the size of your Data Model, or Columnar Database or File size. This is an important part of Data Analysis and Business Intelligence when you have Big Data because it can help your solution to run more efficiently by creating smaller Data Model behind the scenes Columnar Databases that must be loaded into RAM. Apply concepts of how the Columnar Database stores data when deciding what tables, columns and transformations should be part of the final Data Model.
\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
\n2. (01:11) Download HUGE CSV File.
\n3. (01:34) Talk about How Columnar Database works and how we can reduce size.
\n4. (03:11) Rules for Efficient Data Modeling
\n5. (06:07) Get Data From Government Web Site: http:\/\/bit.ly\/2IYfRht
\n6. (07:18) Import CSV Text File
\n7. (07:46) Load Entire CSV File and look at Model Size.
\n8. (09:20) Filter Rows and look at Model Size.
\n9. (10:56) Remove Columns and look at Model Size.
\n10. (11:40) Reduce Cardinality of Columns with 1) Add Column for Time
\n11. (13:59) Reduce Cardinality of Columns with 2) Transform Columns and get Date Only
\n12. (15:21) Edit Time Column to Create only Hour and reduce size further.
\n13. (16:39) Edit Query can lead to trouble in subsequent steps. See how to fix the problem.
\n14. (17:28) Add Date Table
\n15. (18:28) Create Relationship
\n16. (18:44) Create Measure to Count Rows for Call Type. Use COUNTROWS DAX Function.
\n17. (19:16) Create Dashboard
\n18. (19:16) Create Pivot Table
\n19. (20:17) Filter to show Top 20, 911 Call Types
\n20. (20:45) Show Values As in Data Model PivotTable
\n21. (22:07) Sort Measure Biggest to Smallest
\n22. (22:15) Add Slicers
\n23. (23:05) Scrape Data form Web Site
\n24. (24:18) Summary<\/p>\n