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)