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)