{"id":3289,"date":"2020-10-04T20:56:05","date_gmt":"2020-10-04T18:56:05","guid":{"rendered":"http:\/\/www.extradrm.com\/?p=3289"},"modified":"2020-10-04T20:56:54","modified_gmt":"2020-10-04T18:56:54","slug":"power-bi-tutorial-from-beginner-to-pro-%e2%9a%a1-desktop-to-dashboard-in-60-minutes-%e2%8f%b0","status":"publish","type":"post","link":"https:\/\/www.extradrm.com\/?p=3289","title":{"rendered":"Power BI Tutorial From Beginner to Pro \u26a1 Desktop to Dashboard in 60 Minutes \u23f0"},"content":{"rendered":"<p>This Complete Power BI Tutorial takes you Step-by-Step as you use Power BI Desktop to create a beautiful Power BI Dashboard. \ud83d\udc49 Download Power BI Files in Video at https:\/\/web.learnpowerbi.com\/download?content=20190501<\/p>\n<p>\u2705 Subscribe to always get my latest videos: https:\/\/www.youtube.com\/powerbipro?sub_confirmation=1<br \/>\n\ud83d\udd34 Ask Questions LIVE on TalkPowerBI Fridays https:\/\/www.youtube.com\/PowerBIPro\/live<br \/>\n\ud83d\udc49 Join the Learn Power BI Family https:\/\/web.learnpowerbi.com\/waitlist-invite\/ (Paid Power BI Training Program)<\/p>\n<p>\u25b6\ufe0fTopics Covered\u25c0\ufe0f (click to jump to topic)<br \/>\n02:27 1. Get Data (Query Editor)<br \/>\n21:42 2. Relationships<br \/>\n33:41 3. DAX<br \/>\n48:15 4. Visuals<br \/>\n56:13 5. PowerBI.com<\/p>\n<p>\u25b6\ufe0fDetailed Topics Covered\u25c0\ufe0f (click to jump to topic)<br \/>\n00:00 How to Use this Tutorial<br \/>\n02:27 1A Meet the Power BI Duo!<br \/>\n03:06 1B Get Data &#8211; Connectors and Get Simple Data<br \/>\n08:45 1C Get Data &#8211; Query Editor Overview<br \/>\n12:40 1D Get Data &#8211; Clean up Messy Data<br \/>\n15:52 1E Get Data &#8211; Query Editor vs Macros<br \/>\n17:29 1F Get Data &#8211; Clean up Continued<br \/>\n21:42 2A Relationships &#8211; Key Concepts \ud83d\udddd\ufe0f<br \/>\n24:10 2B Relationships &#8211; Creating Relationships<br \/>\n26:59 2C Relationships &#8211; Explore Data Using Visuals<br \/>\n32:42 2D Relationships &#8211; Analyzing Multiple Data Tables Together \ud83d\udddd\ufe0f<br \/>\n33:41 3A DAX &#8211; Writing DAX Measure (Implicit vs. Explicit Measures) \ud83d\udddd\ufe0f<br \/>\n37:00 3B DAX &#8211; Calculated Column<br \/>\n39:03 3C DAX &#8211; Measure vs. Calculated Column (Key Concept \ud83d\udddd\ufe0f)<br \/>\n44:26 3D DAX &#8211; More Measures and Magic!<br \/>\n46:20 3E DAX &#8211; Before and After Power BI \ud83d\udddd\ufe0f<br \/>\n48:15 4A Visuals &#8211; 80\/20 Rule \ud83d\udddd\ufe0f<br \/>\n49:19 4B Visuals &#8211; Text, Image, Cards, Shape<br \/>\n51:28 4C Visuals &#8211; Bar\/Column Chart, Drill Down<br \/>\n52:51 4D Visuals &#8211; Conditional Formatting \ud83d\udddd\ufe0f<br \/>\n53:38 4E Visuals &#8211; Line Chart, Bar Chart<br \/>\n54:11 4F Visuals &#8211; Top 10 Products\/Customers<br \/>\n56:13 5A Power BI.com &#8211; Publish<br \/>\n57:28 5B PowerBI.com &#8211; Features In-Depth \ud83d\udddd\ufe0f<br \/>\n59:27 5C PowerBI.com &#8211; Everything About Dashboards \ud83d\udddd\ufe0f<br \/>\n01:02:19 5D PowerBI.com &#8211; Sharing Dashboards with Others \ud83d\udddd\ufe0f<br \/>\n01:02:46 Your 3 Crucial Next Steps to Power On!<\/p>\n<p>\u25b6\ufe0fNext Step In Your Journey\u25c0\ufe0f<br \/>\n\ud83d\udc49 Join the Learn Power BI Family https:\/\/web.learnpowerbi.com\/waitlist-invite\/ (Paid Power BI Training Program)<\/p>\n<p>\u25b6\ufe0fSlower Power BI Tutorial\u25c0\ufe0f<br \/>\nhttps:\/\/www.youtube.com\/watch?v=1bysgMsPwC4&#038;list=PL7GQQXV5Z8ef2SjkDpLnvsz7TAQjlzlpO<\/p>\n<p>\u25b6\ufe0fLinks to Other YouTube Videos\u25c0\ufe0f<br \/>\nYou can watch ALL the videos mentioned in this Tutorial as part of this playlist<br \/>\n\ud83d\udc49 https:\/\/www.youtube.com\/playlist?list=PL7GQQXV5Z8eeQCLqTIoxjw0POIzHUXPae<\/p>\n<p>This playlist includes:<br \/>\n\u2022 How to Download &#038; Install Power BI<br \/>\n\u2022 \ud83d\udddd\ufe0fPower BI Licensing (Paid Power BI Options)<br \/>\n\u2022 \ud83d\udddd\ufe0fUltimate Calendar Table<br \/>\n\u2022 \ud83d\udddd\ufe0fPower BI Data Modeling<br \/>\n\u2022 \ud83d\udddd\ufe0fDAX: Row Context and Filter Context In-Depth<br \/>\n\u2022 Data vs. Lookup Tables In-Depth<br \/>\n\u2022 Power BI Relationships In-Depth<br \/>\n\u2022 Using a Fiscal Calendar (See Ultimate Calendar)<br \/>\n\u2022 DAX: Implicit vs Explicit Measures<br \/>\n\u2022 DAX: Create Row Context in Measures Using X Functions (Coming Soon. Will be added to Playlist)<br \/>\n\u2022 DAX: Measures vs Calculated Columns In-Depth<br \/>\n\u2022 DAX: When Is It Right to Create a Calculated Column? (Coming Soon. Will be added to Playlist)<br \/>\n\u2022 PowerBI.com: Creating Excel Reports Connected to Power BI (Analyze In Excel In-Depth)<br \/>\n  (Coming Soon. Will be added to Playlist)<br \/>\n\u2022 PowerBI.com: Setting up Automated Refresh (Coming Soon. Will be added to Playlist)<br \/>\n\u2022 Power BI Custom Visuals (Coming Soon. Will be added to Playlist)<br \/>\n\u2022 PowerBI.com: Different Ways of Sharing Your Reports (Coming Soon. Will be added to Playlist)<br \/>\n\u2022 PowerBI.com: How to Create a PowerBI.com Account (Coming Soon. Will be added to Playlist)<br \/>\n========================================<\/p>\n<p>This Tutorial would take you step-by-step through a LIVE Demo as we<br \/>\n\u2714\ufe0fBuild a Power BI Model<br \/>\n\u2714\ufe0fCreate a Beautiful Power BI Report<br \/>\n\u2714\ufe0fPublish it and Use it on PowerBI.com<\/p>\n<p>You can follow along using the Download Files (link above).<\/p>\n<p>The Tutorial would introduce you to\u3010 Power BI Desktop \u3011\u2013 the \u201cAuthoring Tool\u201d of Power BI. And teach you how to use:<br \/>\n\u2714\ufe0fQuery Editor<br \/>\n\u2714\ufe0fRelationships<br \/>\n\u2714\ufe0fDAX Measures<br \/>\n\u2714\ufe0fCreating Beautiful &#038; Interactive Reports<br \/>\n\u2714\ufe0fand more\u2026<\/p>\n<p>Then we would continue our journey to the \u3010 PowerBI.com Platform \u3011- where you would learn:<br \/>\n\u2714\ufe0fPublish a Report<br \/>\n\u2714\ufe0fCreate New Reports<br \/>\n\u2714\ufe0fCreate a Single Source of Truth for All Your Reporting<br \/>\n\u2714\ufe0fCreating a Dashboard<br \/>\n\u2714\ufe0fSharing a Dashboard<br \/>\n\u2714\ufe0fand more\u2026<\/p>\n<p>You would also understand the Power BI Process<br \/>\n\u2714\ufe0fAuthor<br \/>\n\u2714\ufe0fPublish<br \/>\n\u2714\ufe0fConsume<\/p>\n<p>You would learn fundamental Power BI Concepts<br \/>\n\u2714\ufe0fDifference Between Creating Models vs. Reports<br \/>\n\u2714\ufe0fImplicit vs. Explicit Measures<br \/>\n\u2714\ufe0fMeasures vs. Calculated Columns<br \/>\n\u2714\ufe0f80-20 Rule of Power BI Model Authoring<br \/>\n\u2714\ufe0fand more\u2026<\/p>\n<p>\u26a1Power On!\u26a1<br \/>\n-Avi Singh<br \/>\nhttp:\/\/www.LearnPowerBI.com<\/p>\n<p>#PowerBI   #PowerBITutorial        #PowerBIPro<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This Complete Power BI Tutorial takes you Step-by-Step as you use Power BI Desktop to create a beautiful Power BI Dashboard. \ud83d\udc49 Download Power BI Files in Video at https:\/\/web.learnpowerbi.com\/download?content=20190501 \u2705 Subscribe to always&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":3290,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"video","meta":[],"categories":[547,583],"tags":[602,603,609,610,616],"youtube_video":{"channel_id":"UCRNmSv7mAPYiC0Y40TJijAw","channel_title":"Avi Singh - PowerBIPro","title":"Power BI Tutorial From Beginner to Pro \u26a1 Desktop to Dashboard in 60 Minutes \u23f0","description":"This Complete Power BI Tutorial takes you Step-by-Step as you use Power BI Desktop to create a beautiful Power BI Dashboard. \ud83d\udc49 Download Power BI Files in Video at https:\/\/web.learnpowerbi.com\/download?content=20190501\r\n\r\n\u2705 Subscribe to always get my latest videos: https:\/\/www.youtube.com\/powerbipro?sub_confirmation=1\r\n\ud83d\udd34 Ask Questions LIVE on TalkPowerBI Fridays https:\/\/www.youtube.com\/PowerBIPro\/live\r\n\ud83d\udc49 Join the Learn Power BI Family https:\/\/web.learnpowerbi.com\/waitlist-invite\/ (Paid Power BI Training Program)\r\n\r\n\u25b6\ufe0fTopics Covered\u25c0\ufe0f (click to jump to topic)\r\n02:27 1. Get Data (Query Editor)\r\n21:42 2. Relationships\r\n33:41 3. DAX\r\n48:15 4. Visuals\r\n56:13 5. PowerBI.com\r\n\r\n\u25b6\ufe0fDetailed Topics Covered\u25c0\ufe0f (click to jump to topic)\r\n00:00 How to Use this Tutorial\r\n02:27 1A Meet the Power BI Duo!\r\n03:06 1B Get Data - Connectors and Get Simple Data\r\n08:45 1C Get Data - Query Editor Overview\r\n12:40 1D Get Data - Clean up Messy Data\r\n15:52 1E Get Data - Query Editor vs Macros\r\n17:29 1F Get Data - Clean up Continued\r\n21:42 2A Relationships - Key Concepts \ud83d\udddd\ufe0f\r\n24:10 2B Relationships - Creating Relationships\r\n26:59 2C Relationships - Explore Data Using Visuals\r\n32:42 2D Relationships - Analyzing Multiple Data Tables Together \ud83d\udddd\ufe0f\r\n33:41 3A DAX - Writing DAX Measure (Implicit vs. Explicit Measures) \ud83d\udddd\ufe0f\r\n37:00 3B DAX - Calculated Column\r\n39:03 3C DAX - Measure vs. Calculated Column (Key Concept \ud83d\udddd\ufe0f)\r\n44:26 3D DAX - More Measures and Magic!\r\n46:20 3E DAX - Before and After Power BI \ud83d\udddd\ufe0f\r\n48:15 4A Visuals - 80\/20 Rule \ud83d\udddd\ufe0f\r\n49:19 4B Visuals - Text, Image, Cards, Shape\r\n51:28 4C Visuals - Bar\/Column Chart, Drill Down\r\n52:51 4D Visuals - Conditional Formatting \ud83d\udddd\ufe0f\r\n53:38 4E Visuals - Line Chart, Bar Chart\r\n54:11 4F Visuals - Top 10 Products\/Customers\r\n56:13 5A Power BI.com - Publish\r\n57:28 5B PowerBI.com - Features In-Depth \ud83d\udddd\ufe0f\r\n59:27 5C PowerBI.com - Everything About Dashboards \ud83d\udddd\ufe0f\r\n01:02:19 5D PowerBI.com - Sharing Dashboards with Others \ud83d\udddd\ufe0f\r\n01:02:46 Your 3 Crucial Next Steps to Power On!\r\n\r\n\u25b6\ufe0fNext Step In Your Journey\u25c0\ufe0f\r\n\ud83d\udc49 Join the Learn Power BI Family https:\/\/web.learnpowerbi.com\/waitlist-invite\/ (Paid Power BI Training Program)\r\n\r\n\u25b6\ufe0fSlower Power BI Tutorial\u25c0\ufe0f\r\nhttps:\/\/www.youtube.com\/watch?v=1bysgMsPwC4&list=PL7GQQXV5Z8ef2SjkDpLnvsz7TAQjlzlpO\r\n\r\n\u25b6\ufe0fLinks to Other YouTube Videos\u25c0\ufe0f\r\nYou can watch ALL the videos mentioned in this Tutorial as part of this playlist\r\n\ud83d\udc49 https:\/\/www.youtube.com\/playlist?list=PL7GQQXV5Z8eeQCLqTIoxjw0POIzHUXPae\r\n\r\nThis playlist includes:\r\n\u2022 How to Download & Install Power BI\r\n\u2022 \ud83d\udddd\ufe0fPower BI Licensing (Paid Power BI Options)\r\n\u2022 \ud83d\udddd\ufe0fUltimate Calendar Table\r\n\u2022 \ud83d\udddd\ufe0fPower BI Data Modeling\r\n\u2022 \ud83d\udddd\ufe0fDAX: Row Context and Filter Context In-Depth\r\n\u2022 Data vs. Lookup Tables In-Depth \r\n\u2022 Power BI Relationships In-Depth \r\n\u2022 Using a Fiscal Calendar (See Ultimate Calendar) \r\n\u2022 DAX: Implicit vs Explicit Measures\r\n\u2022 DAX: Create Row Context in Measures Using X Functions (Coming Soon. Will be added to Playlist)\r\n\u2022 DAX: Measures vs Calculated Columns In-Depth\r\n\u2022 DAX: When Is It Right to Create a Calculated Column? (Coming Soon. Will be added to Playlist)\r\n\u2022 PowerBI.com: Creating Excel Reports Connected to Power BI (Analyze In Excel In-Depth)\r\n  (Coming Soon. Will be added to Playlist)\r\n\u2022 PowerBI.com: Setting up Automated Refresh (Coming Soon. Will be added to Playlist)\r\n\u2022 Power BI Custom Visuals (Coming Soon. Will be added to Playlist)\r\n\u2022 PowerBI.com: Different Ways of Sharing Your Reports (Coming Soon. Will be added to Playlist)\r\n\u2022 PowerBI.com: How to Create a PowerBI.com Account (Coming Soon. Will be added to Playlist)\r\n========================================\r\n\r\nThis Tutorial would take you step-by-step through a LIVE Demo as we \r\n\u2714\ufe0fBuild a Power BI Model\r\n\u2714\ufe0fCreate a Beautiful Power BI Report\r\n\u2714\ufe0fPublish it and Use it on PowerBI.com\r\n\r\nYou can follow along using the Download Files (link above).\r\n\r\nThe Tutorial would introduce you to\u3010 Power BI Desktop \u3011\u2013 the \u201cAuthoring Tool\u201d of Power BI. And teach you how to use:\r\n\u2714\ufe0fQuery Editor \r\n\u2714\ufe0fRelationships \r\n\u2714\ufe0fDAX Measures\r\n\u2714\ufe0fCreating Beautiful & Interactive Reports\r\n\u2714\ufe0fand more\u2026\r\n\r\nThen we would continue our journey to the \u3010 PowerBI.com Platform \u3011- where you would learn:\r\n\u2714\ufe0fPublish a Report\r\n\u2714\ufe0fCreate New Reports\r\n\u2714\ufe0fCreate a Single Source of Truth for All Your Reporting\r\n\u2714\ufe0fCreating a Dashboard \r\n\u2714\ufe0fSharing a Dashboard\r\n\u2714\ufe0fand more\u2026\r\n\r\nYou would also understand the Power BI Process\r\n\u2714\ufe0fAuthor\r\n\u2714\ufe0fPublish\r\n\u2714\ufe0fConsume\r\n\r\nYou would learn fundamental Power BI Concepts\r\n\u2714\ufe0fDifference Between Creating Models vs. Reports\r\n\u2714\ufe0fImplicit vs. Explicit Measures\r\n\u2714\ufe0fMeasures vs. Calculated Columns\r\n\u2714\ufe0f80-20 Rule of Power BI Model Authoring\r\n\u2714\ufe0fand more\u2026\r\n\r\n\u26a1Power On!\u26a1\r\n-Avi Singh\r\nhttp:\/\/www.LearnPowerBI.com\r\n\r\n#PowerBI   #PowerBITutorial        #PowerBIPro","category_id":"27","category":"Education","tags":["power bi tutorial","power bi desktop tutorial","power bi tutorial for beginners","power bi desktop","power bi dashboard","power bi training","power bi demo","power bi for beginners","power bi dashboard tutorial","power bi tutorial for beginners excel","power bi","tutorial","desktop","dashboard","excel","microsoft excel","power bi vs tableau","tableau vs power bi","tableau","mspowerbi","Power BI Pro","PowerBIPro","Avi Singh","powerbi"],"duration":3811,"iso_duration":"PT1H3M31S","human_duration":"1:03:31","definition":"hd","thumbnails":{"default":{"url":"https:\/\/i.ytimg.com\/vi\/AGrl-H87pRU\/default.jpg","width":120,"height":90},"medium":{"url":"https:\/\/i.ytimg.com\/vi\/AGrl-H87pRU\/mqdefault.jpg","width":320,"height":180},"high":{"url":"https:\/\/i.ytimg.com\/vi\/AGrl-H87pRU\/hqdefault.jpg","width":480,"height":360},"standard":{"url":"https:\/\/i.ytimg.com\/vi\/AGrl-H87pRU\/sddefault.jpg","width":640,"height":480},"maxres":{"url":"https:\/\/i.ytimg.com\/vi\/AGrl-H87pRU\/maxresdefault.jpg","width":1280,"height":720}},"video_id":"AGrl-H87pRU","published":"2019-05-01T16:00:04Z","stats":{"comments":"1155","views":"1353155","likes":"18398","dislikes":"292","favourite":"0"},"privacy":{"status":"public","embeddable":true,"license":"youtube"}},"_links":{"self":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/3289"}],"collection":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3289"}],"version-history":[{"count":0,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/posts\/3289\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=\/wp\/v2\/media\/3290"}],"wp:attachment":[{"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3289"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3289"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.extradrm.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}