Classroom Instructor Led Microsoft Excel Training 817-841-9560 excel@dfwexcel.com

Power Pivot and DAX

Overview

You will be learning in-detail about all the techniques of Power Pivot of excel and what are its usages & benefits. This course will help you to know how Power Pivot  will help to analyze the comprehensive data to make timely business decisions. This class is ideal for Excel users that want to pull data into Excel using Power Query and summarize and analyze the data in Power Pivot. 

Price

$395 per Student

CPE Credits

8 CPE Credits

Prerequisites

For the best results, participants should be familiar with the topics covered in the Excel Introduction, Excel Intermediate Part 1, and Excel Intermediate Part 2 classes.

Duration

1 Day

Class Outline
Power Suite Overview
  • What is Power Pivot, Power Query, Power View and Power Map
  • The Power Suite Workflow
  • Power Query Examples
  • Power Pivot Examples
  • Power View Examples
Data Modeling
  • Introduction
  • Understanding Excel’s Data Model
  • Data View versus Diagram View
  • Database Normalization
  • Data Tables versus Lookup Tables
  • Relationships versus Merged Tables
  • Creating Table Relationships
  • Updating Table Relationships
  • Active versus Inactive Relationships
  • Relationship Cardinality
  • Connecting Multiple Data Tables
  • Data Filter Direction
  • Hiding Fields from Client Tools
  • Defining Hierarchies
Power Pivot and DAX
  • Introduction
  • Creating a Power Pivot Table
  • Power Pivots versus Normal Pivots
  • Data Analysis Expression (DAX) Overview
  • Calculated Columns
  • DAX Measures
  • Creating Implicit Measures
  • Creating Explicit Measures (AutoSum)
  • Creating Explicit Measures (Power Pivot)
  • Filter Context
  • Measure Calculation Steps
  • Dimensions vs Measures
  • Best Practices
Popular DAX Functions
  • Introduction
  • DAX Formula Syntax and Operators
  • Common DAX Function Categories
  • Basic Math and Statistical Functions
  • COUNT, COUNTA, DISTINCTCOUNT, and COUNTROWS Functions
  • Logical Functions: IF, AND, OR
  • SWITCH Function
  • Text Functions: LEN, CONCATENATE, UPPER, LOWER, PROPER, LEFT, MID, RIGHT, SEARCH, SUBSTITUTE
  • CALCULATE Function
  • Adding Filter Context with FILTER
  • Removing Filter Context with ALL
  • Joining Data with RELATED Function
  • Iterator (“X”) Functions: SUMX
  • Iterator (“X”) Functions: RANKX
  • Date and Time Functions
  • Time Intelligence Formulas
  • Speed and Performance Factors
  • DAX Best Practices

    Excel Power Pivot and DAX Schedule

    In-Person Classes Schedule
    Date/Time Event Registration
    October 21, 2021
    9:00 am - 5:00 pm
    Excel Power Pivot and DAX
    Bedford Training Facility S8, Bedford TX
    Class is Full. Add Your Name to the Waiting List
    November 18, 2021
    9:00 am - 5:00 pm
    Excel Power Pivot and DAX
    Bedford Training Facility S8, Bedford TX
    Class is Full. Add Your Name to the Waiting List
    December 16, 2021
    9:00 am - 5:00 pm
    Excel Power Pivot and DAX
    Bedford Training Facility S8, Bedford TX
    Class is Full. Add Your Name to the Waiting List

    Date Location Price Registration
    #_EVENTDATES#_12HSTARTTIME to #_12HENDTIME {has_location}#_LOCATIONTOWN, #_LOCATIONSTATE{/has_location}{no_location}Live Online{/no_location} #_EVENTPRICEMAXALL {bookings_open}Register{/bookings_open}{bookings_closed}Class is Full. Waiting List{/bookings_closed}
    Live Online Classes Schedule

    Date Location Price Registration
    #_EVENTDATES
    #_12HSTARTTIME to #_12HENDTIME
    {has_location}#_LOCATIONTOWN, #_LOCATIONSTATE{/has_location}{no_location}Live Online{/no_location} #_EVENTPRICEMAXALL {bookings_open}Register{/bookings_open}{bookings_closed}Class is Full. Waiting List{/bookings_closed}

    Don't see a Class Date that works for you?

    Let us know when you would like to take the class and we will see if we can add a new class date to our schedule.

    Public Classes

    Need to Pay via an Invoice?

    No problem. If you need to pay with an invoice, please use our contact form and let us know what class you would like to attend and we will email you an invoice you can pay via your Accounts Payable department.

    Contact Us

    Phone

    817-841-9560

    Email

    excel@dfwexcel.com

    Office Address

    5608 Malvey Ave,
    Suite 14620,
    Fort Worth, TX 76107

    Mailing Address

    PO Box 712
    Aledo, TX 76008

    Communication Preference