Autoplay
Autocomplete
Previous Lesson
Complete and Continue
POWER BI FOR FINANCE
LECTURES
001 - POWER BI IN FINANCE (3:18)
002 - GETTING TO KNOW THE DATA (2:33)
003 - CONNECTING TO DATA (2:10)
004 - CREATING A SIMPLE DATE TABLE (9:08)
005 - COLUMN CHART, HIERARCHY, SLICER, TOOLTIPS (10:54)
006 - LINE CHART (4:08)
006 - STEPPED AREA CHART (7:33)
007 - COMBO CHART (3:44)
008 - RIBBON CHART (5:12)
009 - WATERFALL CHART (2:45)
010 - DOT PLOT (5:25)
011 - SCATTER CHART (4:39)
012 - SCATTER WITH CLUSTERS (3:06)
014 - TABLE AND MATRIX (14:31)
013 - SMALL MULTIPLES (5:35)
015 - PIE CHART AND TREEMAP (4:04)
016 - CUSTOM TOOLTIP (5:19)
017 - EDIT INTERACTIONS AND BOOKMARKS (8:26)
018 - AI - Q&A (5:09)
019 - POWER QUERY (2:13)
020 - INTRODUCTION TO DATA + COMBINE FROM FOLDER (4:46)
021 - COMBINE FROM FOLDER - EXPLAIN STEPS (9:04)
022 - EXTRACT PARTS OF DATE (1:58)
023 - CONDITIONAL COLUMN (3:33)
024 - CALCULATED COLUMN (1:54)
025 - COLUMN FROM EXAMPLES (7:30)
026 - INTRODUCTION TO DAX (4:02)
027 - DATE TABLE IN DETAIL (14:24)
028 - CALCULATED COLUMN VS MEASURE - AVERAGE VOLATILITY (6:09)
029 - DIFFERENCE BETWEEN INVESTMENT TYPE - CALCULATE, FILTER (7:48)
030 - AMOUNT SUM - ALL, ALLSELECTED (5:05)
031 - EXCLUDE TWO SECTORS - FILTER, NOT, IN (6:12)
032 - AVERAGE OF MAX PE RATIO FOR COMPANIES IN SECTOR - AVERAGEX, VALUES, MAX (6:15)
033 - COMPARE TWO SECTORS - VARIABLE, CONCATENATEX, COUNTROWS, LEFT, RIGHT, FIND, LEN, IF (15:11)
034 - AMOUNT YTD - DATESYTD, TOTALYTD (4:39)
035 - AMOUNT QOQ CHANGE - DATEADD, DIVIDE, SWITCH, UNICHAR, BLANK (9:05)
036 - AMOUNT RUNNING TOTAL - FILTER, ISONORAFTER, ALLSELECTED, MAX (6:09)
037 - AVERAGE YTD MONTH WISE - TOTALYTD, BLANK, DISTINCTCOUNT (11:41)
038 - RANK PE RATIO - HASONEFILTER, RANKX, ALL, ALLSELECTED (5:35)
039 - TOPN COMPANIES - HASONEVALUE, MAXX (6:30)
040 - PARETO % AMOUNT FOR COMPANY - TOPN, HASONEFILTER, RANKX, ALL, DIVIDE (3:56)
RESOURCES
Resources
032 - AVERAGE OF MAX PE RATIO FOR COMPANIES IN SECTOR - AVERAGEX, VALUES, MAX
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock