UPDATED 2024 VERSION AVAILABLE HERE 👉 youtu.be/Dk25lwdTKow

Want more On-Demand Learning? - Start With The FREE Learn With The Nerds Stream Plan: prag.works/lwtn-trial

Class files
✔️ prag.works/202302-LWTN-files
Install Power BI Desktop
✔️ tinyurl.com/33rcb3rn

Download the certificate of completion after you finish this course:
📄 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 - 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 pragmaticworks.com/pricing/

Other Resources:
Data Source for session
✔️ fdic.gov/bank/individual/failed/banklist.csv 
Data Modeling for Power BI by Mitchell Pearson
✔️ youtube.com/watch?v=MrLnibFTtbA
Data Modeling (Star Schema) in Power BI by Manuel Quintana
✔️ youtube.com/watch?v=7ciFtfi-kQs
Power BI Administration by Manuel Quintana
✔️ youtube.com/live/QCdAI0XSaZ8
DAX by Mitchell Pearson
✔️ youtube.com/watch?v=QJw4HkagVWc 
Additional Resources on FORMAT Function
✔️ learn.microsoft.com/en-us/dax/format-function-dax
Date Dimension
✔️ devinknightsql.com/2015/06/16/creating-a-date-dimension-with-power-query/
DAX Guide
✔️ 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
✔️ prag.works/data-storytelling-with-power-bi
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -

Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5

🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-training/hackathons/
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-mentoring/
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-training/customized-enterprise-training/
🔗Pragmatic Works Blog: blog.pragmaticworks.com/

Let's connect:
✔️Discord: prag.works/yt-discord
✔️Facebook: facebook.com/pragmaticworks/
✔️Instagram: instagram.com/pragmatic.works
✔️LinkedIn: linkedin.com/company/pragmaticworks
✔️YouTube: youtube.com/pragmaticworks

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.

• Hands-On Power BI Tutorial 📊 Beginner to Pro [Full Course] 2023 Edition⚡ ( Download)
• ULTIMATE Power BI Tutorial 📊 Beginner to Pro Course (2024) ( Download)