👉 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 ✔ 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 ✔️ null 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: ✔️Twitter: https://twitter.com/PragmaticWorks ✔️Facebook: https://www.facebook.com/pragmaticworks/ ✔️Instagram: https://www.instagram.com/pragmatic.works ✔️LinkedIn: https://www.linkedin.com/company/pragmaticworks ✔️YouTube: null Pragmatic Works 7175 Hwy 17, Suite 2 Fleming Island, FL 32003 Phone: (904) 638-5743 Email: training@pragmaticworks.com #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.