Financial Analytics With Power Bi

Design interactive financial analysis Dashboard with Microsoft Power BI.

What you'll learn

Learn how to design interactive dashboard with Power BI.

Learn how to perform time intelligence calculations using DAX.

Learn how to share and consume Power BI reports.

Learn how to apply conditional formatting in Power BI

Requirements

Basic knowledge of Power BI

Description

Are you considering a career in the Data space?One of the ways to build your skills and your portfolio is to work on projects.In this course, you will have the opportunity to expand your knowledge and skills in Power BI by learning how to design practical and interactive financial dashboards. This course covers the report development process in Power BI. We will start by connecting to data, cleaning, and transforming the Data. Then we will move on to Data modeling and DAX. Here you will learn how to analyze data using Data Analysis expressions. You will also learn how to perform time-based calculations such as Year Over Year change etc. using Time intelligence functions in Power BI. Finally, you will learn to visualize your data to design interactive reports in Power BI.By the end of this guided project, you’ll be extremely comfortable building reports and dashboards in Power BI.Key learning outcomes:· Data cleaning and modelling· Data analysis with DAX· Time intelligence· Conditional formatting· Data visualization· Reporting developmentWhat our Students are sayingAll concepts are carefully explained and illustrated. I enjoy every bit of the training. Thank you to all the Festman team. Brilliant Course.~Folorunso Adebare LalaThe course is easy to understand and the instructor explains the content quite well. The content is plentiful and great in a well put project.~Octavio

Overview

Section 1: Introduction

Lecture 1 Business Case

Lecture 2 Background of required task

Lecture 3 Dataset

Lecture 4 Connecting and importing the Dataset

Lecture 5 Transform and Load Data

Section 2: Data Modeling and Analysis

Lecture 6 Background of Task

Lecture 7 Data Modeling

Lecture 8 Data Analysis with DAX

Lecture 9 Time intelligence calculations

Lecture 10 Time intelligence part 2

Section 3: Report Development

Lecture 11 Task Background

Lecture 12 Report development - Report Theme

Lecture 13 Report_Development - Background Design

Lecture 14 Data visualization - Key Perfomance Indicators

Lecture 15 Data visualization - Breakdown of KPIs

Lecture 16 Data visualization - Breakdown of KPIs 2

Lecture 17 Data visualization - Profit Margin by Segment

Section 4: Sharing and consuming the report

Lecture 18 Task Background

Lecture 19 Export report to PDF

Lecture 20 Export report as Powerpoint Presentation

Lecture 21 Sharing report via Email

Lecture 22 Sharing report on Microsoft Teams

Power BI Beginers,Finance professionals who want to learn how to design reports and dashboards with Power BI,Data analyst who want to develop practical skills in Power BI