UPDATED 2024 VERSION AVAILABLE HERE    • ULTIMATE Power BI Tutorial  Beginner...  

Want more OnDemand Learning? Start With The FREE Learn With The Nerds Stream Plan: https://prag.works/lwtntrial

Class files
✔ https://prag.works/202302LWTNfiles
Install Power BI Desktop
✔ https://tinyurl.com/33rcb3rn

Download the certificate of completion after you finish this course:
https://prag.works/202302LWTNcert

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 rightclick to copy this link
Put that link in the web connector in Power BI https://www.fdic.gov/system/files/202...
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 endtoend 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, onestop 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 OnDemand Learning classes from https://pragmaticworks.com/pricing/'>https://pragmaticworks.com/pricing/

Other Resources:
Data Source for session
✔ https://www.fdic.gov/bank/individual/...
Data Modeling for Power BI by Mitchell Pearson
✔    • Data Modeling for Power BI [Full Cour...  
Data Modeling (Star Schema) in Power BI by Manuel Quintana
✔    • Data Modeling (Star Schema ) in Powe...  
Power BI Administration by Manuel Quintana
✔ https://www.youtube.com/live/QCdAI0XSaZ8
DAX by Mitchell Pearson
✔    • Beginner Power BI DAX Functions Tutor...   
Additional Resources on FORMAT Function
✔https://learn.microsoft.com/enus/dax...
Date Dimension
✔ https://devinknightsql.com/2015/06/16...
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/datastorytelling...


Next step on your journey:
OnDemand Learning Start With The FREE Community Plan: https://tinyurl.com/2ujujsb5

Pragmatic Works OnDemand Learning Packages: https://pragmaticworks.com/pricing/'>https://pragmaticworks.com/pricing/
Pragmatic Works Boot Camps: https://pragmaticworks.com/bootcamps/
Pragmatic Works Hackathons: https://pragmaticworks.com/privatetr...
Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtualme...
Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/privatetr...
Pragmatic Works Blog: http://blog.pragmaticworks.com/

Let's connect:
✔Discord: https://prag.works/ytdiscord
✔Facebook:   / pragmaticworks  
✔Instagram:   / pragmatic.works  
✔LinkedIn:   / pragmaticworks  
✔YouTube:    / pragmaticworks  

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 6385743
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.