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":1926,"date":"2019-10-24T18:05:29","date_gmt":"2019-10-25T01:05:29","guid":{"rendered":"https:\/\/bonbonsguide.com\/wp\/?p=1926"},"modified":"2019-10-24T18:05:29","modified_gmt":"2019-10-25T01:05:29","slug":"msptda-34-data-modeling-for-slowly-changing-dimensions-with-power-query-power-pivot","status":"publish","type":"post","link":"https:\/\/bonbonsguide.com\/wp\/blog\/2019\/10\/msptda-34-data-modeling-for-slowly-changing-dimensions-with-power-query-power-pivot\/","title":{"rendered":"MSPTDA 34: Data Modeling for Slowly Changing Dimensions with Power Query & Power Pivot"},"content":{"rendered":"Download Start Excel file: https:\/\/ift.tt\/2NdZexR
\nDownload Finished Excel file: https:\/\/ift.tt\/2MKIXl9
\nPdf files with notes: https:\/\/ift.tt\/2IOoqtJ<\/p>\n
In this video learn about how to deal with a \u201cSlowly Changing Dimensions\u201d, and how to create a sales report with Employees (Dimension) with a slowly changing Attribute (Team). See how to create the correct grain for the Fact Table and Dimension Table using Power Query, and then see how to load it to the Excel Power Pivot Data Model and create Relationships, DAX Formula and a Data Model PivotTable Report that shows Teams and Employee and how their sales changing over time.
\nTopics:
\n1. (00:09) Introduction and Explanation of Problem with Slowly Changing Dimensions when creating Reports.
\n2. (02:00) Transform Two Dimension Tables into a Lookup Table that can be used in a Merge to bring Employee-Team Unique Identifier into Fact Table
\n3. (08:27) Build Employee Team Dimension Table
\n4. (08:45) Load to Data Model
\n5. (09:18) Build Relationships
\n6. (09:29) Build DAX Formula
\n7. (10:03)Build Data Model PivotTable Report
\n8. (11:06) 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