Emily Taylor will show you how to create pivot tables for dynamic data insights in Excel. The session will include writing essential functions to streamline data processing and cleaning data using Power Query Editor, while also covering quick data modeling and how to utilize Power Pivot.
Overview
COURSE DIFFICULTY
COURSE DURATION
1h 28m
Skills Learned
After completing this online training course, students will be able to:
Create DAX measures for business calculations
Build calculated columns for data enrichment
BI Developers, Data Analysts
None
01. Introduction
02. Why Use DAX?
03. CALENDAR
04. CALENDARAUTO
05. DATE
06. DATEDIFF
07. DATEVALUE
08. DAY
09. EDATE
10. EOMONTH
11. MONTH, QUARTER, YEAR
12. HOUR, MINUTE, SECOND
13. NOW, TODAY
14. WEEKDAY, WEEKNUM
15. TIME
16. TIMEVALUE
17. UTCNOW, UTCTODAY
18. NETWORK DAYS
19. YEARFRAC
20. Class Wrap Up
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Create DAX measures for business calculations
Build calculated columns for data enrichment
WHO SHOULD ATTEND
BI Developers, Data Analysts
PREREQUISITES
None
COURSE OUTLINE
01. Introduction
02. Why Use DAX?
03. CALENDAR
04. CALENDARAUTO
05. DATE
06. DATEDIFF
07. DATEVALUE
08. DAY
09. EDATE
10. EOMONTH
11. MONTH, QUARTER, YEAR
12. HOUR, MINUTE, SECOND
13. NOW, TODAY
14. WEEKDAY, WEEKNUM
15. TIME
16. TIMEVALUE
17. UTCNOW, UTCTODAY
18. NETWORK DAYS
19. YEARFRAC
20. Class Wrap Up
