Hands-On Power BI Tutorial 📊 Beginner to Pro [Full Course] 2023 Edition⚡

UPDATED 2024 VERSION AVAILABLE HERE 👉 https://youtu.be/Dk25lwdTKow Want more On-Demand Learning? - Start With The FREE Learn With The Nerds Stream Plan: https://prag.works/lwtn-trial Class files ✔️ https://prag.works/202302-LWTN-files Install Power BI Desktop ✔️ https://tinyurl.com/33rcb3rn Download the certificate of completion after you finish this course: 📄 https://prag.works/202302-LWTN-cert The website used in this demonstration recently updated the way the data is stored. Here are the steps that you will follow to get the data now. -Left/regular click on the download button to go to the new page -Scroll to the very bottom of that page and right-click to copy this link -Put that link in the web connector in Power BI - https://www.fdic.gov/system/files/2024-07/banklist.csv -Notice the error question marks. To remove those, change the File Origin from Unicode to Western European (Windows) Follow the rest of the video as normal :) ✔ Event Overview: This free live event is designed for those who have little experience with Power BI to give a better understanding of how end-to-end solutions can be designed. This course covers how to load data with Power BI Desktop, how to use some basic DAX, and create amazing visualizations on your data. Power BI is an impressive, one-stop reporting and analytical tool. You can connect and shape your data, as well as build reporting solutions that help drive decision making. What you’ll learn: ✔️ Connect and organize your data ✔️ Create data cleansing processes in Power BI ✔️ Organize your data model ✔️ DAX Basics ✔️ Build Interactive Reports ✔️ Deploy and share your solution If you enjoy this Learn With the Nerds and are interested in formal training on DAX, Power BI, Power Apps, Azure, or other Microsoft products, you can use the code "Devin30" to get an extra 30% off at check out when purchasing our On-Demand Learning classes from https://pragmaticworks.com/pricing/ Other Resources: Data Source for session ✔️ https://www.fdic.gov/bank/individual/failed/banklist.csv  Data Modeling for Power BI by Mitchell Pearson ✔️ https://www.youtube.com/watch?v=MrLnibFTtbA Data Modeling (Star Schema) in Power BI by Manuel Quintana ✔️ https://www.youtube.com/watch?v=7ciFtfi-kQs Power BI Administration by Manuel Quintana ✔️ https://www.youtube.com/live/QCdAI0XSaZ8 DAX by Mitchell Pearson ✔️ https://www.youtube.com/watch?v=QJw4HkagVWc  Additional Resources on FORMAT Function ✔️https://learn.microsoft.com/en-us/dax/format-function-dax Date Dimension ✔️ https://devinknightsql.com/2015/06/16/creating-a-date-dimension-with-power-query/ DAX Guide ✔️ https://dax.guide/ DAX code used in this session: Calendar = CALENDARAUTO() Year = YEAR([Date]) Month Number = MONTH([Date]) Month = FORMAT([Date], "mmmm") Total Banks = COUNTROWS('Failed Banks')  00:00:00 Introduction 00:08:52 Phases of a Power BI Project 00:20:30 Transforming the Data - Power Query 01:05:30 Building a Data Model 01:16:29 DAX Basics 01:51:47 Creating Relationships 02:15:13 Data Visualizations 02:56:53 Publishing the Report Next event: Data Storytelling with Power BI - Lunch with Nerds with Allison Gonzalez ✔️ https://prag.works/data-storytelling-with-power-bi -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - Next step on your journey: 👉 On-Demand Learning - Start With The FREE Community Plan: https://tinyurl.com/2ujujsb5 🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/ 🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/ 🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-training/hackathons/ 🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-mentoring/ 🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-training/customized-enterprise-training/ 🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/ Let's connect: ✔️Discord: https://prag.works/yt-discord ✔️Facebook: https://www.facebook.com/pragmaticworks/ ✔️Instagram: https://www.instagram.com/pragmatic.works ✔️LinkedIn: https://www.linkedin.com/company/pragmaticworks ✔️YouTube: https://www.youtube.com/pragmaticworks Pragmatic Works 7175 Hwy 17, Suite 2 Fleming Island, FL 32003 Phone: (904) 638-5743 Email: [email protected] #PowerBI #DAX #PragmaticWorks #DevinKnight #Training #Microsoft#Tech #FreeConference #LearnWithTheNerds **Any sales mentioned in the video may no longer be valid. Offers are subject to change with/without notice and are for a limited time only.