14 Vertical l analysis | FestMan™ Learning Hub

Autoplay
Autocomplete

Previous Lesson Mark as completed

Financial Reporting and analysis with Power BI

Introduction

Walkthrough (5:34)
Exercise Files

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 (12:59)

Qualified Assessment

Final Capstone
Sample Financial Report
Submission
📑Share your feedback
🥇Digital Certificate of Completion

Teach online with

14 Vertical l analysis

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock