Discovering the Power of Excel 2010-2013 PowerPivot Data Analytic Expressions (DAX)

Cena

210.00

Lokacija

Beograd,
Online,
In-house

Trajanje kursa

2 dana / 14 sati

Datum

Po dogovoru

Prijava

Plan obuke:

Module 1: Course Overview

  • Introduction
  • Course Materials
  • Facilities
  • Prerequisites
  • What We’ll Be Discussing

Module 2: Exploring Data Modeling

  • Differences Between Excel 2010 & 2013
  • PowerPivot for Excel Add-in
  • PowerPivot Data Model
  • VLOOKUP vs Relationships
  • Relationships

Mobile 3: Introduction to DAX

  • Introduction to DAX
  • Explaining Syntax
  • Exploring Data Types
  • Utilizing Operators
  • Understanding Values
  • Handling Errors

Module 4: Using DAX Functions

  • Mathematical Functions
  • Statistical Functions
  • Logical Functions
  • Information Functions
  • Text Functions
  • Conversion Functions
  • Aggregation Functions
  • Relational Functions

Mobile 5: Understanding Evaluation Contexts

  • The CALCULATE Function
  • Filter Functions
  • Single Table Evaluation Context
  • Multiple Table Evaluation Context

Module 6: Working with Dates

  • Date Functions
  • Working with Calendars
  • Using Multiple Calendars

Module 7: Utilizing Advanced DAX Functionality

  • Many-to-Many Relationships
  • Banding
  • EVALUATE
  • Simplifying Your Life with DAX Studio

Module 8: Examining Patterns

  • Walkthrough a Basic Pattern

Benefiti:

  • Video snimak predavanja u periodu od 365 dana posle kraja obuke
  • Pristup laboratorijama u toku trajanja kursa
  • Materijal u elektronskom obliku
  • Zvaničan Microsoft sertifikat o pohađanju kursa

Poželjno predznanje:

Experience with Excel and Microsoft SQL query writing is helpful.

Dalje usavršavanje:

Analyzing Data with Excel (MS20779)

PowerPivot, Power View and SharePoint 2013 Business Intelligence Center for Analysts (MS55049)