Power Bi Financial Reporting & Financial Analysis: A To Z

The Ultimate Hands-On Microsoft Power BI & DAX Financial Statements, Reporting, Analysis, Visualization, & BI Course.

What you'll learn

Power BI fundamentals like Data Import, Data Modelling, Analysis, and Visualization

Prepare Financial Statements: Profit & Loss Statement (Income Statement), Balance Sheet, Cash Flow Statement, & The Statement of Changes in Equity

Calculate Ratios & Analyze Financial Data to assess Business Performance in terms of Profitability, Liquidity, Risk Management, & Operational Efficiency

Visualize and Cross-Visualize Financial Data with a variety of Power BI Charts and Graphs

Prepare Beautiful & Dynamic Financial Reporting & Analytics Dashboards

Filter and Cross-Filter Power BI Reports Charts and Dashboards

Requirements

Basic knowledge of Financial Statements

No previous Power BI knowledge is required

Windows computer as Power BI is not available on Mac

Description

To prepare Financial Statements and Analyze Financial Data, a powerful Business Intelligence Software like Power BI is the number 1 choice of professionals and organizations. But with the extra ordinary capability that Power BI offers, there comes some complexity and one needs expert training to be able to prepare Financial Reports and Analytics.This is exactly what is course is all about! Starting with no Power BI background, you will master using this amazing program to  prepare all the Financial Reports and Analytics that you need. You will learn: Fundamentals, like importing data, modelling data, analyzing and visualizing data in Power BIPreparing Financial Statements: Profit and Loss Statement (Income Statement), Balance Sheet, Cash Flow Statement Calculating key Financial Ratios to analyze Profitability, Liquidity, Financial Risk, and Operational Business Efficiency Preparing Beautiful and Dynamic Financial DashboardsPower BI is the tool used by the top organizations for reporting and analysis. Having this on your resume, and to that too with a very specific financial application, would clearly take you an extra mile."This is a very well thought out course. I learned a great deal: this is even after earning my DA-100 certification last year. The instructor is very responsive to student questions. I highly recommend this course."If you have basic knowledge of Financial Statements, you are ready to jump in! No previous knowledge of Power BI or any other technical knowledge is required. However, you will need to have a windows computer as Power BI desktop is not available for Mac. Learn from a UK qualified Chartered Accountant with 12 years of experience in Accounting, Reporting and Business Intelligence systems. And finally, there is Nothing to lose! If you will not be satisfied with the course, you will have the option to avail full refund within 30 days of the purchase.

Overview

Section 1: Getting started

Lecture 1 Downloading Power BI desktop

Lecture 2 Course data files

Lecture 3 Understanding data

Lecture 4 Why use GL | Why use positive and negative values

Lecture 5 Getting data into Power BI

Section 2: Getting ready for P&L Preparation - Analyzing Sales

Lecture 6 Calculating Sales

Lecture 7 Formatting Matrix for better visibility

Lecture 8 Analyzing Sales by Quarter and Month - Drilling up and drilling down the data

Lecture 9 Visualizing Sales trends with Charts

Lecture 10 Visualizing data by Country - Adding Slicers

Section 3: Preparing and Analyzing P&L

Lecture 11 Preparing P&L

Lecture 12 Calculating Gross Profit, EBITDA, Operating Profit, PBIT, & Net Profit

Lecture 13 Using Card to visualize numbers

Lecture 14 Using KPI to visualize numbers

Lecture 15 Using date slicer

Lecture 16 Adding basic chart visuals for P&L analysis

Lecture 17 Country comparison - P&L values

Lecture 18 Section Power BI file

Lecture 19 Moving forward - DAX!

Section 4: Introduction to DAX and P&L Analysis redo with DAX

Lecture 20 Introduction to DAX

Lecture 21 DAX - Sum for the period

Lecture 22 DAX Notes 1 - Sum function

Lecture 23 Calculate function to apply filters - Calculating Gross Profit

Lecture 24 DAX Notes 2 - Calculate function

Lecture 25 Optional Homework - Calculate Net Profit

Lecture 26 Calculating Net Profit

Lecture 27 Calculate with multiple conditions - Calculating Operating Profit

Lecture 28 DAX Notes 3 - Calculate function with OR conditions

Lecture 29 DAX Notes 4 - Calculate function with AND conditions

Lecture 30 Alternative way to calculate Operating Profit with DAX

Lecture 31 Homework - calculate EBITDA and PBIT

Lecture 32 EBITDA

Lecture 33 PBIT

Lecture 34 Sales, GP, & NP visulization

Lecture 35 Adding small multiples in chart

Lecture 36 Marketing to Sales relationship visualization

Lecture 37 Calculating Gross Profit Margin and Net Profit Margin

Section 5: Preparing DAX for the Next Level

Lecture 38 Calculating Minimum & Maximum Date

Lecture 39 Calculating Minimum Date Across the Data - Override Column filters

Section 6: Preparation of Balance Sheet

Lecture 40 Preparing the Balance Sheet

Lecture 41 Removing visual level filter from the Balance Sheet

Lecture 42 Visualizing data with Donut Charts

Lecture 43 Visualizing data with Treemap

Lecture 44 Current Ratio

Lecture 45 Quick Ratio or Acid Test Ratio

Lecture 46 Gearing Ratio

Lecture 47 Coming next!

Section 7: Miscellaneous Break - Defining a fool proof sorting on P&L & Balance Sheet

Lecture 48 About this section

Lecture 49 Sorting of P&L and Balance Sheet

Section 8: More Financial Ratios

Lecture 50 Asset turnover

Lecture 51 ROCE - Return on Capital Employed

Lecture 52 ROE - Return on Equity

Lecture 53 Interest Cover

Lecture 54 Let's clean our file

Lecture 55 Receivables Collection Period

Lecture 56 Payables Payment Period

Lecture 57 Inventory turnover period

Section 9: Making Ledgers and Enabling Drill-through

Lecture 58 Making Ledgers

Lecture 59 Enabling Drill-through from Reports to Ledgers

Section 10: Trial Balance

Lecture 60 Making Trial Balance Structure

Lecture 61 Measure to calculate Trial Balance Value

Lecture 62 Fixing the problem and calculating the correct balance

Lecture 63 Getting Trial Balance Ready for Reporting & Analysis

Section 11: More Ways to Analyze Financial Data - Rolling Values | Moving Average

Lecture 64 Introduction and problem statement

Lecture 65 90 Day Rolling Value & 30 Day Moving Average

Lecture 66 3 Month Rolling Value and Monthly Moving Average

Lecture 67 Calculating Average Values for Balance Sheet Accounts

Lecture 68 Calculating Average Values considering each single day value

Section 12: Calculating Dynamic Period on Period Growth (Month on Month | Year on Year)

Lecture 69 Calculating Dynamic Previous Period Value - TTD

Lecture 70 Calculating Period on Period Growth - TTD

Lecture 71 Calculating Period on Period Growth - FTP

Lecture 72 Calculating Period on Period Growth - FTP

Section 13: Horizontal Analysis of Financial Statements

Lecture 73 Horizontal Analysis of Income Statement

Lecture 74 Horizontal Analysis of Balance Sheet

Section 14: Vertical Analysis of Financial Statements

Lecture 75 Vertical Analysis of Income Statement

Lecture 76 Vertical Analysis of Balance Sheet

Section 15: Calculating Previous Corresponding Period Value and PCP Growth

Lecture 77 What is Previous Corresponding Period - PCP

Lecture 78 Calculating Previous Corresponding Period Value - FTP

Lecture 79 Calculating Growth from the PCP

Lecture 80 Visualizing PCP Growth

Lecture 81 Calculating PCP Values for Total to Date Values

Section 16: Cash flow Statement

Lecture 82 Revising the Cash flow Statement in indirect method

Lecture 83 Defining Cash flow structure in data

Lecture 84 Understanding the ValueType field in report structure

Lecture 85 Importing report structure into Power BI & Modelling it with the data

Lecture 86 Making Cash flow Statement Structure

Lecture 87 Calculation of the Cash flow statement values

Section 17: Statement of Changes in Equity

Lecture 88 Revising the Statement of Changes in Equity and Defining the Structure in Data

Lecture 89 Calculation of Values for the Statement of Changes in Equity

Section 18: Streamlining Financial Reporting: Foreign Currency Transactions to Home Currency

Lecture 90 Introduction the section

Lecture 91 Getting the Forex Rates data ready

Lecture 92 Importing Exchange Rate table and Modelling it

Lecture 93 Calculating Max Date's Exchange Rate and converting values to USD based on it

Lecture 94 Writing a measure which can SWITCH values based on slicer selection

Lecture 95 Preparing Reports with currency conversion

Lecture 96 Converting Each Transaction at Daily Exchange Rate

Section 19: Reporting & Analysis from Trial Balance

Lecture 97 Getting things ready

Lecture 98 Understanding and Calculating FTP Values using TB

Lecture 99 Understanding and Calculating TTD Values using TB

Section 20: Budget vs Actual Comparison & Analysis

Lecture 100 Introduction and uploading the budget to our Power BI file

Lecture 101 Budget vs Actual for the FTP Values - P&L and related values

Lecture 102 Budget vs Actual for the TTD Values - Balance Sheet and related values

Section 21: Working with GL that has NO Closing Entry

Lecture 103 Understanding the problem

Lecture 104 Our data without closing entry

Lecture 105 Up and Running with Power BI

Lecture 106 Preparing Value for the Retained Earnings Line of the Balance Sheet

Lecture 107 Fixing the subtotals

Section 22: Other Miscellaneous & Final Stretch

Lecture 108 How do we convert Debit & Credit GL values to Positive and Negative values

Lecture 109 Converting Debit & Credit values to positive and negative

Lecture 110 Converting Positive & Negative Values to Debit & Credit

Lecture 111 Working with Financial Year that is different from the Calendar Year

Lecture 112 Demo - connecting Database with Power BI

Lecture 113 Bonus lecture

Finance Managers,Financial Controllers,Finance Directors,Accountants, Bookkeepers, & Financial Analysts,Accounting, Bookkeeping, and Finance students,Investors and stock market analysts