Published On Streamed live on Feb 9, 2023
đ 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/...
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 Tuto...  Â
Additional Resources on FORMAT Function
âď¸https://learn.microsoft.com/en-us/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/data-storytelling-...
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
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-tr...
đPragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-me...
đPragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-tr...
đPragmatic Works Blog: http://blog.pragmaticworks.com/
Let's connect:
âď¸Twitter:   / pragmaticworks Â
âď¸Facebook:   / pragmaticworks Â
âď¸Instagram:   / pragmatic.works Â
âď¸LinkedIn:   / pragmaticworks Â
âď¸YouTube:    / 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.