In this chapter, you will learn basic financial concepts and apply them to creating dashboards. You will also learn how to use artificial intelligence in Power BI.

Financial Dashboards

OKR you ready?

KPIs in Power BI

Net income and profit margin

Gauging KPIs

Painless analytics

Artificial Intelligence

The truth about artificial intelligence

AI visualizations in Power BI

Looking into a crystal ball

Splitting decompositions trees

Setting up Q&A

Follow the key influencers

Here, you’ll learn how to use "What If" parameters to create a scenario and use sensitivity analysis and forecasts.

What if...?

That doesn't seem right...

Scenario forecasting in Power BI

Calculating revenue growth rates

Creating a straight line forecast for revenue

Using what-if parameters in forecasting

Sensitivity analysis

Dependent versus independent variables

Sensitivity analysis in Power BI

Analyzing change in gross sales

Analyzing change in discount/premium

Creating a sensitivity table for revenue

What If

In this chapter, you will learn how to analyze investments over time with future and present value.

Future value

Classify future value terms

Future value in Power BI

Practicing future value calculations

Creating forecasts with FV

Finding the future value of annuities

Present value

Deal or Deal?

Present value in Power BI

Practicing present value calculations

Creating a savings plan with PV annuities

Value an acquisition using PV

Time Value of Money

In the final chapter, you’ll learn why capital budgeting is an important job for financial analysts. You will learn how to apply time value of money concepts to make business decisions, all while working to create a beautiful dashboard.

Capital Budgeting

Pick a project, any project...

Net present value and profitability index

The feeling is mutually exclusive

The best index is a profitable one

Creating a profile for NPV

Internal rate of return and payback period

Options

Internal rate of return (IRR)

Payback period

Discounted payback period

Pay yourself back

IRR and payback period in Power BI

Evaluating IRResistible investments

Jumping hurdles

Finding the payback period on payback

Congratulations!

DataCamp vs. Local Experience

Exercises and Datasets

This course will teach you basic and intermediate finance skills and how to apply them in Power BI dashboards.
You’ll start by reviewing some basic financial terms and calculations, as well as exploring dashboarding. As you progress, you’ll learn how to use artificial intelligence to create insightful visualizations and financial forecasts.
You’ll also learn how to use what-if parameters in scenarios and sensitivity analysis with financial data. You will explore the concept of the time value of money and its importance in financial analysis, as well as capital budgeting tools to make investment decisions that you can take with you both in your personal and professional life.
By the end of this course, you will be confident in your financial skills and especially in your ability to create meaningful financial analyses and visualizations within Power BI. You’ll have the skills to use Power BI to analyze your own data sets.

This course will teach you basic and intermediate finance skills and how to apply them in Power BI dashboards. 
<br><br>
<h2>Learn the Fundamentals of Financial Analysis in Power BI</h2>
You’ll start by reviewing some basic financial terms and calculations, as well as exploring dashboarding. As you progress, you’ll learn how to use artificial intelligence to create insightful visualizations and financial forecasts. 
<br><br>
You’ll also learn how to use what-if parameters in scenarios and sensitivity analysis with financial data. You will explore the concept of the time value of money and its importance in financial analysis, as well as capital budgeting tools to make investment decisions that you can take with you both in your personal and professional life.
<br><br>
<h2>Gain the Skills to Perform Your Own Financial Analyses</h2>
By the end of this course, you will be confident in your financial skills and especially in your ability to create meaningful financial analyses and visualizations within Power BI. You’ll have the skills to use Power BI to analyze your own data sets. 

Intermediate DAX in Power BI

Data Modeling in Power BI

Learn how to perform financial analysis in Power BI or apply any existing financial skills using Power BI data visualizations.

Financial Analysis in Power BI

Financial Reporting in Power BI

Gives the return of the project by finding which discount rate makes NPV zero

Is an iterative function that is not easily calculated by hand.

Is the time it takes to break-even on an investment without discounting cash flows.

An analyst wants to use the simpliest calculation to find how long it will take to break-even.

Uses discounted cash flows to find the time it takes to break-even.

An analyst wants to use the time-value of money in finding how long it will take to break-even.

Pay yourself back

Financial Analysis in Power BI

Latihan interaktif praktis