~Get Your Files Here !/1. Getting started/2. Understanding data.mp434.66MB
~Get Your Files Here !/1. Getting started/3. Getting data into Power BI.mp457.64MB
~Get Your Files Here !/2. Getting ready for P&L Preparation - Analyzing Sales/1. Calculating Sales.mp459.96MB
~Get Your Files Here !/2. Getting ready for P&L Preparation - Analyzing Sales/2. Formatting Matrix for better visibility.mp421.92MB
~Get Your Files Here !/2. Getting ready for P&L Preparation - Analyzing Sales/3. Analyzing Sales by Quarter and Month - Drilling up and drilling down the data.mp423.88MB
~Get Your Files Here !/2. Getting ready for P&L Preparation - Analyzing Sales/4. Visualizing Sales trends with Charts.mp445.6MB
~Get Your Files Here !/2. Getting ready for P&L Preparation - Analyzing Sales/5. Visualizing data by Country - Adding Slicers.mp420.63MB
~Get Your Files Here !/3. Preparing and Analyzing P&L/1. Preparing P&L.mp480.69MB
~Get Your Files Here !/3. Preparing and Analyzing P&L/2. Calculating Gross Profit, EBITDA, Operating Profit, PBIT, & Net Profit.mp4152.48MB
~Get Your Files Here !/3. Preparing and Analyzing P&L/3. Using Card to visualize numbers.mp441.8MB
~Get Your Files Here !/3. Preparing and Analyzing P&L/4. Using KPI to visualize numbers.mp449.29MB
~Get Your Files Here !/3. Preparing and Analyzing P&L/5. Using date slicer.mp419.45MB
~Get Your Files Here !/3. Preparing and Analyzing P&L/6. Adding basic chart visuals for P&L analysis.mp4104.63MB
~Get Your Files Here !/3. Preparing and Analyzing P&L/7. Country comparison - P&L values.mp466.43MB
~Get Your Files Here !/3. Preparing and Analyzing P&L/9. Moving forward - DAX!.mp44.67MB
~Get Your Files Here !/4. Introduction to DAX and P&L Analysis redo with DAX/1. Introduction to DAX.mp440.7MB
~Get Your Files Here !/4. Introduction to DAX and P&L Analysis redo with DAX/11. Alternative way to calculate Operating Profit with DAX.mp434.36MB
~Get Your Files Here !/4. Introduction to DAX and P&L Analysis redo with DAX/13. EBITDA.mp432.76MB
~Get Your Files Here !/4. Introduction to DAX and P&L Analysis redo with DAX/14. PBIT.mp437.84MB
~Get Your Files Here !/4. Introduction to DAX and P&L Analysis redo with DAX/15. Sales, GP, & NP visulization.mp462.79MB
~Get Your Files Here !/4. Introduction to DAX and P&L Analysis redo with DAX/16. Adding small multiples in chart.mp414.91MB
~Get Your Files Here !/4. Introduction to DAX and P&L Analysis redo with DAX/17. Marketing to Sales relationship visualization.mp476.2MB
~Get Your Files Here !/4. Introduction to DAX and P&L Analysis redo with DAX/18. Calculating Gross Profit Margin and Net Profit Margin.mp475.82MB
~Get Your Files Here !/4. Introduction to DAX and P&L Analysis redo with DAX/2. DAX - Sum for the period.mp474.52MB
~Get Your Files Here !/4. Introduction to DAX and P&L Analysis redo with DAX/4. Calculate function to apply filters - Calculating Gross Profit.mp484.74MB
~Get Your Files Here !/4. Introduction to DAX and P&L Analysis redo with DAX/7. Calculating Net Profit.mp441.32MB
~Get Your Files Here !/4. Introduction to DAX and P&L Analysis redo with DAX/8. Calculate with multiple conditions - Calculating Operating Profit.mp445.88MB
~Get Your Files Here !/5. Preparing DAX for the Next Level/1. Calculating Minimum & Maximum Date.mp433.14MB
~Get Your Files Here !/5. Preparing DAX for the Next Level/2. Calculating Minimum Date Across the Data - Override Column filters.mp424.09MB
~Get Your Files Here !/6. Preparation of Balance Sheet/1. Preparing the Balance Sheet.mp466.42MB
~Get Your Files Here !/6. Preparation of Balance Sheet/2. Removing visual level filter from the Balance Sheet.mp426.34MB
~Get Your Files Here !/6. Preparation of Balance Sheet/3. Visualizing data with Donut Charts.mp467.03MB
~Get Your Files Here !/6. Preparation of Balance Sheet/4. Visualizing data with Treemap.mp422.25MB
~Get Your Files Here !/6. Preparation of Balance Sheet/5. Current Ratio.mp456.49MB
~Get Your Files Here !/6. Preparation of Balance Sheet/6. Quick Ratio or Acid Test Ratio.mp437.78MB
~Get Your Files Here !/6. Preparation of Balance Sheet/7. Gearing Ratio.mp449.18MB
~Get Your Files Here !/7. More Financial Ratios/1. Asset turnover.mp439.43MB
~Get Your Files Here !/7. More Financial Ratios/2. ROCE - Return on Capital Employed.mp467.86MB