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":1067,"date":"2019-03-25T22:08:39","date_gmt":"2019-03-26T05:08:39","guid":{"rendered":"https:\/\/bonbonsguide.com\/wp\/?p=1067"},"modified":"2019-03-25T22:08:39","modified_gmt":"2019-03-26T05:08:39","slug":"e-dab-09-power-bi-desktop-data-modeling-interactive-visualizations-data-analysis-bi-basics","status":"publish","type":"post","link":"https:\/\/bonbonsguide.com\/wp\/blog\/2019\/03\/e-dab-09-power-bi-desktop-data-modeling-interactive-visualizations-data-analysis-bi-basics\/","title":{"rendered":"E-DAB 09: Power BI Desktop: Data Modeling & Interactive Visualizations (Data Analysis & BI Basics)"},"content":{"rendered":"Download all files to follow along with video and do homework is zipped folder here: https:\/\/ift.tt\/2HFE8s4
\nTo download individual files, visit class web site here: https:\/\/ift.tt\/2tW1Ibd
\nPdf notes: https:\/\/ift.tt\/2HGLBr0<\/p>\n
How to get Free Power BI Desktop:
\ni. Microsoft Download Page: https:\/\/ift.tt\/1IP49OT
\n1. When you want to update each month, you have to re-download and re-install.
\nii. Microsoft Windows Store: https:\/\/ift.tt\/1T1D80M
\n1. This download will automatically update each month.<\/p>\n
This video is an introduction to Data Modeling and Visualization in Power BI Desktop. Learn how to use Power Query to import Excel Files from a Folder. Learn how to build DAX Formulas. Lean how to create an entire Data Model and then build Data Model Visualizations.
\nThis class : Data Analysis & Business Intelligence Made Easy with Excel Power Tools – Excel Data Analysis Basics = E-DAB Class \u2013 Sponsored by YouTube and taught by Mike Girvin, Highline College Instructor, Microsoft Excel MVP and founder of the excelisfun channel at YouTube. This is a free educational resource for people how want to learn about the Basics of Data Analysis and Business Intelligence using Microsoft Power Tools such as, PivotTables, Power Query, Power Pivot, Power BI Desktop and more.
\nTopics:
\n1. (00:15) Introduction to Power BI and Interactive Visuals
\n2. (01:14) Download Files
\n3. (01:56) Overview of Power BI project
\n4. (02:38) Excel PowerPivot or Power BI Desktop?
\n5. (04:20) Power BI History
\n6. (04:51) Different Versions of Power BI
\n7. (06:33) Download Free Power BI
\n8. (07:07) Open Blank File and name \u201c.pbix\u201d file.
\n9. (07:39) First Look at Power BI Desktop User Interface.
\n10. (08:45) Import Data into Power BI Desktop. Import many Excel files from a folder. Use Excel.Workbook Function.
\n11. (15:21) Import Dimension tables from single Excel Workbook.
\n12. (15:57) Create Relationships between Dimension & Fact Tables
\n13. (16:11) Create Date Table with DAX Formulas. See the DAX Functions: CALENDAR, MIN, YEAR, DATE, MAX,
\n14. (21:30) Create DAX Measures for Total Revenue, Total COGS, Total Gross Profit, and Total Units. See the DAX Functions, SUMX, ROUND, RELATED and SUM.
\n15. (27:20) Hide Tables and Fields that are not used in Reports and Visualizations
\n16. (28:10) Add new Tabs, Sheets, Pages (all synonyms)
\n17. (28:26) Create Gross Profit Interactive Visualization
\n18. (33:29) Create Units Analysis Interactive Visualizations.
\n19. (33:39) Create Hierarchy
\n20. (36:17) Summary<\/p>\n