Course Description

Embark on a transformative learning journey with this comprehensive course on Microsoft Power BI for Financial Reporting. You’ll be guided through the process of turning GL data into high-quality, automated income statement, balance sheet and cash flow statement reporting.

In this course, you will learn to:

• Use Power Query to import data and transform it into a usable format
• Explore DAX and the data model
• Build dynamic visualizations to enhance your financial reporting skills and create compelling reports

Who Should Attend

• Financial analysts seeking to leverage Power BI for creating dynamic and detailed financial reports
• Data professionals looking to enhance their skill set with advanced Power BI features and techniques
• Business intelligence enthusiasts interested in optimizing and modeling financial data within Power BI
• Professionals in finance and accounting roles seeking to automate their reporting processes
• Anyone interested in exploring and visualizing financial data in a meaningful and impactful way using Power BI

Prerequisites

• Basic understanding of Power Query and Power BI: As this course delves into advanced features and techniques of Power Query and Power BI, participants should have a basic understanding of how Power Query and Power BI work and their main features.
• Experience with financial data: Familiarity with financial statements and key financial metrics will help participants better understand the course content and apply the techniques to real-world data.
• Access to the Power Query feature in Microsoft Excel. This course will include practical exercises that require participants to use Power Query.
• Access to Power BI software: participants will need to have Power BI installed on their computers. The course will include practical exercises that require participants to use Power BI.

Course Outline

Module 1: Introduction

• Financial Reporting
• Focus on GL Data
• Understanding Data
• Importance of COA

Module 2: Getting Data into Power BI

• Bringing Data into Power BI
• Query to Clean Up and Transform
• Data Model: Relationships
• Data Model: Calculations (Calculated Columns & Measures)

Module 3: Profit & Loss

• Preparing P&L
• Calculating Gross Profit, EBITDA, Operating Profit, PBIT & Net Profit
• Time Comparison Calculations
• Create the P&L Report
• Vertical Analysis on P&L

Module 4: Balance Sheet

• Preparing Balance Sheet
• Managing Data at a Different Granularity
• Calculating Subtotal Amounts
• Create the Balance Sheet
• Vertical Analysis on Balance Sheet
• Create a summary table of key financial ratios such as Current Ratio, Quick Ratio, Gearing Ratio, etc.

Module 5: Cash Flow

• Cash Flow Using the Indirect Method
• Defining Cash Flow Structure
• Calculations on Summary Totals
• Create the Cash Flow