Sebastian Taylor & Joseph Yeates – CFI Education – Power BI Financial Statements

Description

CFI Education – Power BI Financial Statements , Sebastian Taylor & Joseph Yeates – CFI Education – Power BI Financial Statements download

Sebastian Taylor & Joseph Yeates – CFI Education – Power BI Financial Statements

Power BI Financial Statements
Build a set of robust, customizable, and refreshable Financial Statements in Power BI and Excel using DAX and CUBE formulas.

• Connect to an enterprise database to ensure one version of the truth
• Control the display of your financial statements by creating a custom mapping table
• Gain a deeper understanding of your data by building powerful DAX measures

Overview
Power BI Financial Statements Overview
Welcome to the most comprehensive Financial Statements in Power BI walkthrough ever. In this case study, you’ll practice your BI skills by taking on the role of a Business Intelligence Developer. You will be helping a retail company automate and visualize its most important financial statements. Creating Financial Statements in Power BI poses three significant challenges, which we will help you solve using a combination of BI tools.

• Challenge 1: How to replicate financial statement layouts and formatting
• Challenge 2: How to create account subtotals and other DAX summaries
• Challenge 3: How to create the more complex cash flow statement

With plenty of extended student challenges and interactive exercises, this course is the perfect scenario-based case study to reinforce your fundamental knowledge of Power BI.

Interactive Financial Statements in Power BI
Power BI offers a great way to visualize and interact with high-level financial data.

Power BI Financial Statements Learning Objectives
Upon completing this course, you will be able to:

• Understand how to define and propose an achievable project scope.
• Write an SQL query to source General Ledger Data from a database
• Build a data model using a snowflake schema in Power BI
• Build an Income Statement and Balance Sheet in Power BI
• Create financial statements in Excel using Cube Formulas
• Compare the benefits of Power BI vs. Excel for Financial Analysis

Who should take this course?
This course is perfect for anyone who wants to apply their Power BI and DAX skills in a real-world scenario. There is no better way to kick-start a career in data analysis, quantitative analysis, business intelligence, or other areas of finance with applied, practical knowledge of Power BI and related BI tools.

What you’ll learn

Case Study Introduction
Case Study Introduction
Your Role as a Business Intelligence Developer
Video Call with CFO
Challenges to Consider in the Project
Project Requirements Email
Exercise 1 | Email Response to Mia Simpson
Final Project Requirements and Approach
Financial Statements Review
Case Study Files Overview
Case Study Student Files Download

Extract Data from the Database
Chapter Introduction – Extract Data from the Database
Download Azure Data Studio
Student Task – Connect and Explore the Database
Student Task Review – Connect and Explore the Database
Entity Relationship Diagram
Exercise 2 | ERD
Plan the SQL Query
Student Task – Write the SQL Query
Student Task Review – SQL Query Part 1
Student Task Review – SQL Query Part 2
Create the SQL View
Chapter Review

Create the Data Model in Power Query
Chapter Introduction – Create the Data Model
Create the Staging Query
Create the Fact and Dimension Tables
Create the Remaining Dimension Tables
Student Task – Create the Data Model
Student Task Review – Create the Data Model
Create SumAmount Measure
Chapter Review and Summary of Challenges

Income Statement in Power BI
Chapter Introduction – Income Statement
Financial Statements with Existing Data Model
Create Headers Table in Excel
Import Headers Table into Power BI
Create I/S Amount Measure
Create I/S Subtotal Measure
DAX Functions
Exercise 3 | DAX Functions
Create Income Statement Measure with SWITCH()
Create % of Revenue Measure
Format % of Revenue Measure
Finalize the Income Statement Measure
Create Subcategory Display Filter
Finalize the Income Statement
Add Data Refresh Date
Format the Power BI Report
Create the Waterfall Chart Visual
Chapter Exercise – Income Statement
Chapter Exercise Hints – Income Statement
Chapter Exercise Review – Income Statement

Balance Sheet in Power BI
Chapter Introduction – Balance Sheet
Update the Headers Table
Create B/S Amount Measure
Create Cumulative Amount Measure
Create B/S Subtotal Measure
Create Balance Sheet Measure with SWITCH()
Create Opening Retained Earnings Measure
Create Retained Earnings Measure
Create Total Equity Measure
Create Total Liabilities & Equity Measure
Finalize the Balance Sheet
Chapter Exercise – Balance Sheet
Chapter Exercise Hints – Balance Sheet
Chapter Exercise Review – Balance Sheet
Add Detail and Create Additional Statements
Check-In and Review with CFO

Analyze in Excel with Cube Formulas
Chapter Introduction – Cube Formulas
What are Cube Formulas?
A Closer Look at Cube Formulas
Exercise 4 | CUBE Formulas
Use Slicers with Cube Formulas
Define Reporting Year Context for the Income Statement
Populate Basic Values of the Income Statement
Student Task – Complete the Income Statement
Student Task Review – Complete the Income Statement
Student Task – Build the Balance Sheet
Student Task Review – Build the Balance Sheet
Cash Flow Statement Introduction
Populate the Cash Flow Statement
Cash Flow Statement Review
Cube Formulas Review

Case Study Summary
Project Wrap-Up with CFO
Case Study Wrap-Up

Qualified Assessment
Case Study – Financial Statement in Power BI Qualified Assessment

What our students say

Well explained with practical usage in mind
The course has great practical significance. All concepts explained using real world situation in mind.
Farooq Anwer

very interesting course
this course give many informations about building FS in PBI and i appreciated a lot
Pierre MBRA

New experience
I got to increase my skills in learning how to prepare income statement and balance sheet in power bi, that is something new for me, and I advice others to really try to get this course.

Commonly Asked Questions:

1. Business Model Innovation: Acknowledge the reality of a legitimate enterprise! Our approach involves the coordination of a collective purchase, in which the costs are shared among the participants. We utilize this cash to acquire renowned courses from sale pages and make them accessible to individuals with restricted financial resources. Our clients appreciate the affordability and accessibility we provide, despite the authors’ concerns.
2. CFI Education – Power BI Financial Statements Course

• There are no scheduled coaching calls or sessions with the author.
• Access to the author’s private Facebook group or web portal is not permitted.
• No access to the author’s private membership forum.
• There is no direct email support available from the author or their team.