Advanced Power BI: DAX Language, Formulas, and Calculations
Focused View
Helen Wall
3:03:51
673 View
01 - Explore advanced features of Power BI.mp4
00:37
02 - What you should know.mp4
00:32
03 - Exercise files.mp4
03:56
01 - Introducing the course project.mp4
03:29
02 - Power Query and M language.mp4
05:19
03 - DAX language.mp4
02:17
04 - Efficient data strategies.mp4
04:23
01 - DAX tables and GENERATESERIES.mp4
02:58
02 - DAX columns.mp4
02:43
03 - DAX measures.mp4
03:41
04 - DATE, YEAR, MONTH, and DAY date DAX functions.mp4
03:14
05 - CALENDAR and CALENDARAUTO DAX functions.mp4
03:00
06 - DAX measure evaluation context.mp4
10:33
07 - CALCULATE DAX function.mp4
06:17
08 - DAX ruler using FIRSTDATE, LASTDATE, and PARALLELPERIOD DAX functions.mp4
05:58
09 - Challenge Crop modeling.mp4
01:10
10 - Solution Crop modeling.mp4
04:32
01 - ALL DAX function.mp4
05:02
02 - POWER DAX function.mp4
05:37
03 - DIVIDE DAX function.mp4
06:22
04 - Variables in DAX formulas.mp4
07:04
05 - Iterator DAX functions and SUMX.mp4
07:09
06 - FILTER DAX function.mp4
07:15
07 - Challenge Rate of change by commodity.mp4
00:55
08 - Solution Rate of change by commodity.mp4
02:37
01 - SELECTEDVALUE DAX function.mp4
06:22
02 - IF DAX function for conditional formulas.mp4
06:46
03 - EOMONTH DAX function.mp4
04:49
04 - DATEDIFF DAX function.mp4
04:34
05 - BLANK and ISBLANK DAX functions.mp4
06:33
06 - Filtering between tables.mp4
05:10
07 - DAX acrobatics.mp4
06:18
08 - GENERATE and ROW DAX functions with calculated dates tables.mp4
07:43
09 - DATESBETWEEN DAX function.mp4
04:01
10 - DATEADD DAX function.mp4
04:00
11 - MTD, QTD, and YTD date DAX functions.mp4
04:01
12 - DAX quick measures.mp4
06:22
13 - Power BI summarized view.mp4
05:43
14 - Challenge DAX time intelligence modeling.mp4
00:27
15 - Solution DAX time intelligence modeling.mp4
03:32
01 - Next steps and additional resources.mp4
00:50
Description
Data visualization allows you to represent information digitally and graphically, to convey the results of data analysis. Microsoft Power BI is a suite of business analytics tools that help you gain insights from your data. The suite brings together familiar operations from well-known products—including Excel, Access, Power Query, and Power Pivot—to help you quickly move past the basics and on to comprehensive analysis. In this course, Helen Wall guides you through the advanced capabilities of the service. She shows how to work with calculations, effectively leverage the DAX language, create advanced queries, and use the M language to improve the querying process. Helen also demonstrates how to get data into Power BI using the Power Query editor and then model the loaded data using DAX columns, tables, and measures. To lend these concepts a real-world context, she shares how to create a financial model for loans.
More details
User Reviews
Rating
average 0
Focused display
Category
Helen Wall
Instructor's CoursesFollow me to see my latest published content on data science, analytics, and visualization! Aficionado of Power BI, AWS, Tableau, and Excel (including Power Query), and currently diving deep into the world of Python, R, and AI (including machine learning). Designer and developer of business intelligence dashboards and visualizations supporting many business functions and industries.
Linkedin Learning
View courses Linkedin LearningLinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications.
It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.
- language english
- Training sessions 41
- duration 3:03:51
- English subtitles has
- Release Date 2024/06/19
