Power BI Beginner to Pro 2023 Edition

To give a better understanding of how end-to-end solutions can 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

Class files

• Download Your Student Files Now
• Download Microsoft Power BI Desktop from Official Microsoft Download Center

Other Resources:

• Data Modeling for Power BI by Mitchell Pearson

https://www.youtube.com/watch?v=MrLni…

• Data Modeling (Star Schema) in Power BI by Manuel Quintana

https://www.youtube.com/watch?v=7ciFt…

• Power BI Administration by Manuel Quintana

https://www.youtube.com/live/QCdAI0XSaZ8

• DAX by Mitchell Pearson

https://www.youtube.com/watch?v=QJw4H…

• Additional Resources on FORMAT Function

https://learn.microsoft.com/en-us/dax…

• Date Dimension

Creating a Date Dimension with Power Query – Devin Knight

• 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’)