Explore digital courses

Data Analysis Expressions (DAX) is a formula language for Power BI that enables you to create calculations, add logic, and enhance data analysis within your reports and semantic models.

Units in this learning path:

• 1 Introduction
• Calculation Types
• 2 Formulas
• 3 Data Types
• 4 Functions
• 5 Operators
• 6 Variables
• 7 Check
• 8 Summary

Products: Power Bi, Fabric

Roles: Data Analyst

Level: Beginner

Subjects: Data Analytics

Duration: 30 minutes

Learn how to write advanced T-SQL code including CTEs, window functions, JSON functions, regular expressions, fuzzy string matching, graph queries, correlated queries, and error handling.

Units in this learning path:

• Introduction
• Common Table Expressions
• Window Functions
• Json Functions
• Regular Expressions
• Fuzzy String Matching
• Graph Queries
• Correlated Queries
• Error Handling
• Exercise Write Advanced SQL Code
• Knowledge Check
• Summary

Products: SQL Server, Azure SQL Database, Azure SQL Managed Instance, Fabric

Roles: Data Engineer, Database Administrator, Developer, Solution Architect

Level: Intermediate

Subjects: Databases, Data Management, Data Engineering, Cloud Computing, App Development

Duration: 146 minutes

Learn how to write data in a Power Apps canvas app.

Units in this learning path:

• 1 Introduction to Forms
• 2 Form Modes
• 3 Adding Customizing Edit Form
• 4 Submit Your Form
• 5 Special Properties
• Exercise
• 6 Knowledge Check
• 7 Summary

Products: Power Platform, Power Apps

Roles: Business User, Maker, Functional Consultant

Level: Intermediate

Subjects: Data Management, Custom App Development

Duration: 53 minutes

Learn how to manage Azure Cosmos DB for NoSQL accounts, databases, and containers using the Azure CLI.

Units in this learning path:

• Introduction
• Create Resources
• Manage Index Policies
• Configure Database Container Provisioned Throughput
• Migrate Standard Autoscale Throughput
• Change Region Failover Priority
• Initiate Failovers
• Exercise Adjust Provisioned Throughput Using Azure Cli Script
• Knowledge Check
• Summary

Products: Azure Cosmos Db

Roles: Developer

Level: Intermediate

Subjects: Databases

Duration: 41 minutes