Financial Reporting & Analysis with Power BI
4.0
(5)
39 learners
What you'll learn
This course includes
- 4 hours of video
- Certificate of completion
- Access on mobile and TV
Course content
1 modules • 32 lessons • 4 hours of video
Financial Reporting & Analysis with Power BI
32 lessons
• 4 hours
Financial Reporting & Analysis with Power BI
32 lessons
• 4 hours
- Financial Reporting & Financial Analysis with Power BI - Course Introduction 03:12
- Lecture 1: Understanding data (and download data files) 04:27
- Lecture 2: Importing data to Power BI 12:48
- Lecture 3: Calculating Sales 08:34
- Lecture 4: Formatting Matrix. Course: Power BI for Financial Reporting & Financial Analysis 04:27
- Lecture 5: Drill up and drill down data (Course: Financial Reporting & Analysis with Power BI) 05:01
- Lecture 6: Visualizing Sales (Course: Financial Reporting & Financial Analysis with Power BI) 07:51
- Lecture 7: Adding slicers (Course: Financial Reporting & Analysis with Power BI) 03:31
- Lecture 8: Preparing Profit & Loss Statement in Power BI (Course: Financial & Analysis w/ Power BI) 09:16
- Lecture 9: Calculate Gross Profit & Net Profit (Course: Financial Reporting & Analysis w/ Power BI) 16:51
- Lecture 10: Using Card to present values (Course: Financial Reporting & Analysis with Power BI) 05:16
- Lecture 11: Using KPI (Course: Financial Reporting & Analysis with Power BI) 06:07
- Lecture 12: Date slicers and TTD value (Course: Financial Reporting & Analysis with Power BI) 02:45
- Lecture 13: Adding basic P&L visuals (Course: Financial Reporting & Analysis with Power BI) 11:04
- Lecture 14: Comparing countries (Course: Financial Reporting & Analysis with Power BI) 07:58
- Lecture 15: Moving to DAX (Course: Financial Reporting & Analysis with Power BI) 00:38
- Lecture 16: Introduction to DAX (Course: Financial Reporting & Analysis with Power BI) 03:53
- Lecture 17: Sum for the period (Course: Financial Reporting & Analysis with Power BI) 08:26
- Lecture 18: Calculating Gross Profit with DAX (Course: Financial Reporting & Analysis w/ Power BI) 10:37
- Lecture 19: Calculating Net Profit with DAX (Course: Financial Reporting & Analysis with Power BI) 04:33
- Lecture 20: DAX Calculate with OR - Operating Profit (Course: Financial Reporting & Analysis w/ PBI) 04:52
- Lecture 21: Alternate way to Operating Profit (Course: Financial Reporting & Analysis with Power BI) 04:24
- Lecture 22: Calculating EBITDA (Course: Financial Reporting & Analysis with Power BI) 03:44
- Lecture 23: Calculating PBIT (Course: Financial Reporting & Analysis with Power BI) 04:31
- Lecture 24: Visualizing Sales, Gross & Net Profit (Course: Financial Reporting & Analysis with PBI) 05:06
- Lecture 25: Adding small multiples in chart (Course: Financial Reporting & Analysis with Power BI) 01:48
- Lecture 26: Marketing Cost to Sales (Course: Financial Reporting & Analysis with Power BI) 08:07
- Lecture 27: Calculate Gross & Net Profit Margin (Course: Financial Reporting & Analysis w/ Power BI) 07:46
- Working with Fiscal/Financial Year that is different from Calendar Year - Power BI 35:27
- Converting two column (debit & credit) General Ledger or TB to One column (positive & negative) 13:14
- Converting Single Column (Positive & Negative) values GL to Debit & Credit - Power BI 06:28
- Creating a Foolproof Sorting System for Income Statement and Balance Sheet in Power BI #powerbi 15:04
