Free Download Power Bi Financial Reporting & Financial Analysis A To Z
Last updated 5/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 7.55 GB | Duration: 13h 42m
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
Homepage
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
Code:
Bitte
Anmelden
oder
Registrieren
um Code Inhalt zu sehen!
