Overview:This course focuses on using the Power Pivot features to enhance data analysis. One of the strengths of Power Pivot is the formula language DAX (Data Analysis eXpressions). We will spend considerable time using the power of DAX to create meaningful calculations that add new dimensions to our data.
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. We will also demonstrate the hottest tips and tricks that will take your data analysis to the next level.
This event may be a rebroadcast of a live event and the instructor will be available to answer your questions either during or after the event.
The major topics that will be covered in this class include:
- Using Power Pivot for data analysis
- Advanced DAX formulas
- Using a Date / Calendar table for data analysis
After attending this presentation, you will be able to…
- Use Power Pivot for data analysis
- Create advanced DAX formulas
- Utilize a Date / Calendar table to perform complex date analysis
Designed For:All CPAs and Accounting Professionals that want to learn how to analyze data
Prerequisites:Attended Microsoft PowerBI - Improve Data Analysis with DAX Measures
Vendor:CPA Crossings, LLC
Member/Nonmember Fees:129 / 129
CPE:Computer Science 4 hour(s)
Yellow Book Credit:N
Bryan L. Smith
CPA Crossings, LLC
Cancellation or transfer requests made six(6) business days or more prior to the program, no fee assessed.
Cancellation or transfer requests made two(2) to five(5) business days prior to the program, $25 fee assessed.
Cancellation or transfer requests made one business day prior to the program, $50 fee assessed.
Day of program or no notice of cancellation, 100 percent course fee assessed.
If you transfer from an in-class course to a webcast, the above policies apply.
Remember, the COCPA reserves the right to cancel a course seven days prior to the program date. Please keep this cancellation policy in mind when making your travel plans and airline reservations. The COCPA will not be liable for flight cancellation penalties due to our cancellation.
To cancel or transfer a course, please contact the Member Services department at 303-773-2877 or 800-523-9082.