3 - Understanding data (56.98 MB) 5 - Getting data into Power BI (83.49 MB) 60 - Making Trial Balance Structure (64.9 MB) 61 - Measure to calculate Trial Balance Value (51.94 MB) 62 - Fixing the problem and calculating the correct balance (42 MB) 63 - Getting Trial Balance Ready for Reporting Analysis (59.54 MB) 64 - Introduction and problem statement (52.19 MB) 65 - 90 Day Rolling Value 30 Day Moving Average (154.54 MB) 66 - 3 Month Rolling Value and Monthly Moving Average (44.74 MB) 67 - Calculating Average Values for Balance Sheet Accounts (55.24 MB) 68 - Calculating Average Values considering each single day value (89.73 MB) 69 - Calculating Dynamic Previous Period Value TTD (38.06 MB) 70 - Calculating Period on Period Growth TTD (45.89 MB) 71 - Calculating Period on Period Growth FTP (54.63 MB) 72 - Calculating Period on Period Growth FTP (34.5 MB) 73 - Horizontal Analysis of Income Statement (57.34 MB) 74 - Horizontal Analysis of Balance Sheet (53.05 MB) 75 - Vertical Analysis of Income Statement (58.83 MB) 76 - Vertical Analysis of Balance Sheet (141.22 MB) 77 - What is Previous Corresponding Period PCP (15.51 MB) 78 - Calculating Previous Corresponding Period Value FTP (37.24 MB) 79 - Calculating Growth from the PCP (16.59 MB) 80 - Visualizing PCP Growth (26.18 MB) 81 - Calculating PCP Values for Total to Date Values (41.03 MB) 82 - Revising the Cash flow Statement in indirect method (24.53 MB) 83 - Defining Cash flow structure in data (238.84 MB) 84 - Understanding the ValueType field in report structure (198.64 MB) 85 - Importing report structure into Power BI Modelling it with the data (43.63 MB) 86 - Making Cash flow Statement Structure (104.5 MB) 87 - Calculation of the Cash flow statement values (424.98 MB) 88 - Revising the Statement of Changes in Equity and Defining the Structure in Data (48.59 MB) 89 - Calculation of Values for the Statement of Changes in Equity (114.48 MB) 90 - Introduction the section (14.82 MB) 91 - Getting the Forex Rates data ready (115.72 MB) 92 - Importing Exchange Rate table and Modelling it (32.46 MB) 93 - Calculating Max Dates Exchange Rate and converting values to USD based on it (92.3 MB) 94 - Writing a measure which can SWITCH values based on slicer selection (34.97 MB) 95 - Preparing Reports with currency conversion (19.85 MB) 96 - Converting Each Transaction at Daily Exchange Rate (168.99 MB) 97 - Getting things ready (62.79 MB) 98 - Understanding and Calculating FTP Values using TB (42.04 MB) 99 - Understanding and Calculating TTD Values using TB (76.17 MB) 10 - Visualizing data by Country Adding Slicers (15.67 MB) 6 - Calculating Sales (73.8 MB) 7 - Formatting Matrix for better visibility (15.78 MB) 8 - Analyzing Sales by Quarter and Month Drilling up and drilling down the data (18.3 MB) 9 - Visualizing Sales trends with Charts (35.48 MB) 100 - Introduction and uploading the budget to our Power BI file (95.44 MB) 101 - Budget vs Actual for the FTP Values PL and related values (391.01 MB) 102 - Budget vs Actual for the TTD Values Balance Sheet and related values (117.67 MB) 103 - Understanding the problem (23.4 MB) 104 - Our data without closing entry (86.02 MB) 105 - Up and Running with Power BI (184.25 MB) 106 - Preparing Value for the Retained Earnings Line of the Balance Sheet (209.3 MB) 107 - Fixing the subtotals (83.92 MB) 109 - Converting Debit Credit values to positive and negative (213.22 MB) 110 - Converting Positive Negative Values to Debit Credit (117.56 MB) 111 - Working with Financial Year that is different from the Calendar Year (152.79 MB) 112 - Demo connecting Database with Power BI (36.93 MB) 11 - Preparing PL (118.02 MB) 12 - Calculating Gross Profit EBITDA Operating Profit PBIT Net Profit (234.02 MB) 13 - Using Card to visualize numbers (68.47 MB) 14 - Using KPI to visualize numbers (41.38 MB) 15 - Using date slicer (17.12 MB) 16 - Adding basic chart visuals for PL analysis (172.93 MB) 17 - Country comparison PL values (42.85 MB) 19 - Moving forward DAX (3.29 MB) 20 - Introduction to DAX (50.07 MB) 21 - DAX Sum for the period (109.34 MB) 23 - Calculate function to apply filters Calculating Gross Profit (123.93 MB) 26 - Calculating Net Profit (61.77 MB) 27 - Calculate with multiple conditions Calculating Operating Profit (57.1 MB) 30 - Alternative way to calculate Operating Profit with DAX (27.25 MB) 32 - EBITDA (41.24 MB) 33 - PBIT (48.54 MB) 34 - Sales GP NP visulization (71.14 MB) 35 - Adding small multiples in chart (9.24 MB) 36 - Marketing to Sales relationship visualization (129.69 MB) 37 - Calculating Gross Profit Margin and Net Profit Margin (94.15 MB) 38 - Calculating Minimum Maximum Date (25.29 MB) 39 - Calculating Minimum Date Across the Data Override Column filters (20.25 MB) 40 - Preparing the Balance Sheet (54.62 MB) 41 - Removing visual level filter from the Balance Sheet (24.45 MB) 42 - Visualizing data with Donut Charts (58.65 MB) 43 - Visualizing data with Treemap (15.98 MB) 44 - Current Ratio (52.62 MB) 45 - Quick Ratio or Acid Test Ratio (32.2 MB) 46 - Gearing Ratio (43.65 MB) 49 - Sorting of PL and Balance Sheet (237.64 MB) 50 - Asset turnover (34.63 MB) 51 - ROCE Return on Capital Employed (88.34 MB) 52 - ROE Return on Equity (14.76 MB) 53 - Interest Cover (59.86 MB) 54 - Lets clean our file (25.84 MB) 55 - Receivables Collection Period (78.24 MB) 56 - Payables Payment Period (47.58 MB) 57 - Inventory turnover period (25.49 MB) 58 - Making Ledgers (107.62 MB) 59 - Enabling Drillthrough from Reports to Ledgers (42.75 MB)