This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Mark as completed
Financial Reporting and analysis with Power BI
Connecting and cleaning the Financial Reports
Connecting and transforming the Income statement (19:31)
Connecting and transforming the Balance sheet (11:14)
Shaping and transforming the Cashflows statement (14:37)
Working on the Reporting Template (5:49)
Data Modeling and DAX
Creating Calendar Table with CALENDARAUTO Functions (5:06)
07 Income calcualations (39:34)
08 Income statement appendix (6:16)
09 Balance sheet (21:21)
10 Cashflows statement (22:33)
Time Intelligence Calculations
11 Time intlligence(YoY) (26:12)
13 Time intelligence QOQ (15:39)
14 Vertical l analysis (5:41)
15 Master Measure (11:44)
Dashboard and Financial Reporting
16 Income statement report 1 (30:52)
17 Income statement report 2 (40:08)
18 Balance sheet (11:54)
19 Balance sheet ratios (14:09)
20 DuPont Analysis Framework (13:44)
21 Doughnut charts (6:40)
22 Cashflows setup (9:54)
22 Cashflows setup2 (9:54)
23 Cashflows Statement Charts (15:51)
24 Cashflows Statement Final (8:53)
Improving user experience
Using Buttons for Page Navigation (12:15)
Using Bookmarks for Financial Reports (29:14)
Managing visual interactions (6:43)
Report Page tooltips for Income statements (7:29)
Report Page tooltips for Balance sheet (10:08)
Introduction to Smart Narrative (5:27)
Create Smart Insight Pane (20:30)
Using Bookmark to create expandable insights pane (7:43)
Using smart narrative with Tooltips (12:59)
Using smart narrative with Report Tooltip page
Qualified Assessment
Final Capstone
Sample Financial Report
Submission
📑Share your feedback
🥇Digital Certificate of Completion
Connecting and transforming the Balance sheet
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock