Power BI Part 7- Use Advanced Calculations DAX Formulas
OL933 | On Demand Course | Update | Self-Study
Description
This course is the seventh in the Microsoft Power BI series of courses.
This course focuses on using DAX (Data Analysis eXpressions) to create advanced calculations in Power Pivot data models. We will review what you learned in "Power BI - Go Beyond PivotTables with Power Pivot" and take your calculations to the next level using advanced DAX formulas.
You will learn over 20 DAX functions that will allow you to perform calculations that were not possible with standard Excel. We will also review the use of a date or calendar table that allows us to perform date analysis that was never possible before. This will allow us to use the new time-intelligent functions to perform complex calculations on our data like: month-to-date, quarter-to-date, year-to-date, last year same period, last year-to-date, etc. You will also learn the DAX calculation process in order to proof and validate your calculations.
Credits
| Number of Credits | Type of Credits |
|---|---|
| 4.00 | Computer Software & Applications |
Prices
- Member (Early Bird)
- $149.00
- Non-Member (Early Bird)
- $199.00
- Member
- $149.00
- Non-Member
- $199.00
Instructors
Bryan L. Smith, CPA, CITP, CISA
Bryan serves as a trusted adviser to CPAs in public accounting, as well as business and industry, on all aspects of information technology. Bryan's expertise includes in-depth knowledge of paperless work flow solutions, the impact of technology on internal controls, strategic IT infrastructure design and information security best practices. As a nationally recognized author and presenter on information technology issues impacting CPAs, Bryan is passionate about the opportunities for CPAs to benefit from safe and secure computing.
Back to Instructors