Microsoft Fabric: Getting Started with DAX Queries
Microsoft Fabric
| Intermediate
- 14 videos | 1h 35m 19s
- Includes Assessment
- Earns a Badge
DAX empowers organizations to perform advanced analytics by creating dynamic, meaningful calculations that drive better decision-making. In this course, learn the fundamentals of DAX, how DAX integrates with semantic models to enable dynamic data analysis, and how to write, test, and optimize DAX queries effectively in DAX Studio. Next, discover how to create measures, run queries, and write results to various sources, and construct DAX expressions and queries for meaningful insights. Finally, explore how to create and evaluate complex measures and the CALCULATE function's integration with the FILTER and ALL functions. This course is part of a series that prepares learners for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in this course
Describe the features of dax for computations
Identify how dax is used in semantic models
Recognize how dax studio works with the dax language
Install dax and connect it to a fabric semantic model using an xmla endpoint
Outline the behavior and use of calculated columns and measures in dax
Identify how to use dax expressions and queries -
Run basic dax queries in dax studio using the editor and visual query builder
Write dax query results to a file, the clipboard, and linked excel sheets
Define and evaluate measures in dax studio and fabric
Compute measures, aggregations, and filters in dax studio
Use the calculate function to create measures
Integrate the calculate function with the filter and all functions
Summarize the key concepts covered in this course
IN THIS COURSE
-
1m 19sIn this video, we will discover the key concepts covered in this course. FREE ACCESS
-
9m 9sAfter completing this video, you will be able to describe the features of DAX for computations. FREE ACCESS
-
3. DAX in Microsoft Fabric4m 21sUpon completion of this video, you will be able to identify how DAX is used in semantic models. FREE ACCESS
-
4. DAX Studio4m 30sThrough this video, you will be able to recognize how DAX Studio works with the DAX language. FREE ACCESS
-
5. Installing and Setting Up DAX Studio12m 25sLearn how to install DAX and connect it to a Fabric semantic model using an XMLA endpoint. FREE ACCESS
-
6. DAX Calculated Columns and Measures11m 24sIn this video, we will outline the behavior and use of calculated columns and measures in DAX. FREE ACCESS
-
7. DAX Expressions and Queries4m 37sAfter completing this video, you will be able to identify how to use DAX expressions and queries. FREE ACCESS
-
8. Running Basic DAX Queries9m 36sIn this video, find out how to run basic DAX queries in DAX Studio using the editor and visual query builder. FREE ACCESS
-
9. Writing Results to Files, the Clipboard, and a Linked Excel File5m 26sDiscover how to write DAX query results to a file, the clipboard, and linked Excel sheets. FREE ACCESS
-
10. Creating and Evaluating Measures8m 19sIn this video, you will learn how to define and evaluate measures in DAX Studio and Fabric. FREE ACCESS
-
11. Computing Measures, Aggregations, and Filters in DAX Studio7m 51sDuring this video, discover how to compute measures, aggregations, and filters in DAX Studio. FREE ACCESS
-
12. Using the CALCULATE Function to Create Measures7m 26sFind out how to use the CALCULATE function to create measures. FREE ACCESS
-
13. Integrating CALCULATE with the FILTER and ALL Functions7m 10sIn this video, learn how to integrate the CALCULATE function with the FILTER and ALL functions. FREE ACCESS
-
14. Course Summary1m 45sIn this video, we will summarize the key concepts covered in this course. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
