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":1912,"date":"2019-10-21T09:16:33","date_gmt":"2019-10-21T16:16:33","guid":{"rendered":"https:\/\/bonbonsguide.com\/wp\/?p=1912"},"modified":"2019-10-21T09:16:33","modified_gmt":"2019-10-21T16:16:33","slug":"msptda-33-part-2-power-query-standard-pivottable-to-show-all-employees-sales-or-not","status":"publish","type":"post","link":"https:\/\/bonbonsguide.com\/wp\/blog\/2019\/10\/msptda-33-part-2-power-query-standard-pivottable-to-show-all-employees-sales-or-not\/","title":{"rendered":"MSPTDA 33 Part 2: Power Query & Standard PivotTable To Show All Employees Sales Or Not"},"content":{"rendered":"Download Start Excel file: https:\/\/ift.tt\/2MwVY1F
\nDownload Finished Excel file: https:\/\/ift.tt\/2MCjWZv
\nPdf files with notes: https:\/\/ift.tt\/2IOoqtJ<\/p>\n
This is an alternative method for what we did last video, where we need a report to show all Teams and All Employees regardless of whether or not they had sales. This shows how to deal with a Slowly Changing Dimension where the employees on Teams change over time. See Power Query M Code from Bill Szysz.
\nTopics:
\n1. (00:09) Introduction to Data Setup and Goal of Power Query Data Modeling
\n2. (01:46) Power Query Transformation for Dimension Table into a Fact Table. Including List Syntax to create a list of dates that we can use to expand and repeat the record for each date in the period.
\n3. (06:06) Build Standard PivotTable Report, including Loading Power Query Output directly to a Standard PivotTable.
\n4. (06:35) Summary<\/p>\n
Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.<\/p>\n
Excelisfun, Highline College, Data Analysis, Business Intelligence, BI 348, Mike Girvin, Microsoft Power Tools for Data Analysis 32, MSPTDA 32, MSPTDA 33, MSPTDA 34, MSPTDA 35, Slowly Changing Dimensions, Data modeling Slowly Changing Dimension, Power Query Data Modeling, Power Query M Code, Standard PivotTable, List Syntax, Dates as Whole Numbers, List Syntax Trick for List of Dates, Bill Szysz, Power Query Transformation<\/p>\n