After doing these courses, I feel confident creating professional visualizations and dashboards
Shoebur RahmanProcurement Specialist, Giz Bangladesh
Course Description
Analyzing financial statements is an important part of understanding the firm's financial health.
Examine financial statements
In this course, we will examine the financial statements of a fictitious automotive company, Larry's Automotive.Analyze Income Statements and Balance Sheets
We will focus our analysis on the income statement and balance sheet. You will use data visualization to create custom dashboards for the firm's financial information, which will help you identify trends, KPIs, and errors.Calculate KPIs
In addition to calculating key performance measures, such as COGs and EBITDA, we will spend time determining key profitability ratios, like profit margin. These skills will put you on a good path to becoming a financial analyst.Prerequisites
Curriculum
Course outline
1
The Evolution of the Financial Statement
In this chapter, you'll learn the components the balance sheet and income statement and see how they are derived from the accounting equation. With this information, you will examine these financial statements using DAX and creating key measures.
- The balance sheet50 XP
- Accounting equation classification100 XP
- Getting to know the balance sheet50 XP
- Balance Sheet model overview100 XP
- Getting ready for financial statements100 XP
- Detecting balance sheet trends100 XP
- The income statement50 XP
- Income Statement vs Balance Sheet100 XP
- Getting to know the income statement50 XP
- Income Statement model overview100 XP
- Examining EBITDA100 XP
- Profit analysis100 XP
2
Budgetary Planning
Budgetary and Forecast planning plays a key role in the financial well-being of a company. By calculating and visualizing the budget, forecast and variance, you will learn how to detect valuable business trends.
3
Company Performance and Financial Analysis
Performance ratios are financial ratios and other information, that allows a company to determine how well they are doing. You will learn liquidity ratios and how they indicate a firms debt obligation and firm risk.
Introduction to Financial Statements in Power BI
Course
Complete
