New

Microsoft PowerBI: Power Pivot for Advanced Data Analysis (Webinar)

Code: WX9156

Space is available, but online registration has closed. Please call 952-831-2707 to register.

Date Wednesday, February 21, 2018
Time 8:00 AM - 12:00PM
Central Time
Location Online
CPE credits CPE 4.0
Instructor Bryan Smith, CPA, CITP, CISA
CPA Crossings, LLC
Fees
Standard member fee $129.00
checkmarkStandard nonmember fee $129.00

Members: Please log in to receive member fee.

Description

  • This course is #6 in the Microsoft PowerBI series of webinars. Click button in Program Content section below to see suggested viewing order.



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.

Who should take this program?

All CPAs and Accounting Professionals that want to learn how to analyze data

Major subjects

  • 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 This course is #6 in the Microsoft PowerBI series of webinars. Click button below to see suggested viewing order. View Series Sequence

Learning objective(s)

  • After attending this presentation, you will be able to.Use Power Pivot for data analysisCreate advanced DAX formulasUtilize a Date / Calendar table to perform complex date analysis

Notes:

Course code Code WX9156
Sponsor CPA Crossings, LLC
NASBA ID#: 108744
Level Advanced
Field(s)
of study
Computer Software & Applications - Non-Technical (4.0)
Format Group Internet Based
Prerequisites Prereq. Attended Microsoft PowerBI - Improve Data Analysis with DAX Measures
Advance
prep
Install Power Pivot