Course Description
Overview
Power BI brings data to life in rich visuals you can collect, organize and display to make better, more insightful and more informed business decisions. This LIVE, virtual course is for anyone who needs to get up to speed on the fundamentals of Power BI and its business intelligence capabilities. It demystifies Power BI as you learn how to navigate its interface, pull data from multiple sources and begin to build your own dashboards.
DAX (Data Analysis Expressions) is a formula expression language that works in tools like Power BI. The DAX language helps you discover new ways to calculate data values and come up with the fresh, innovative insights your company needs for future growth and to meet its full potential for success.
For an optimal experience with this course, we recommend that you have PowerBi Desktop installed on your computer. Windows platform required.
WORKSHOP AGENDA
Session 1: Developing Reports and Dashboards Using Power BI
Power BI is the intersection of Power Query and Power Pivot. Everything you know about Power Query and Power Pivot is the same in Power BI. However, Power BI adds a visual dimension to your data enabling you to display tables, charts nd graphs connected to your data source.
Explain the value of Power BI
Navigate the Power BI interface
Recognize how to pull data into Power BI
Discuss how to begin to build your Power BI dashboard
Session 2: Power Pivot DAX Measures
To fully leverage the power of Power Pivot, you must understand and apply a special collection of functions that only work with Power Pivot—known collectively as DAX functions. These functions overcome the limits of standard pivots.
Describe what calculated columns are
Use DAX measures
Recognize how to use the CALCULATE expression
Discuss time/date intelligence DAX functions