Overview What You'll Learn What Students Say FAQ

Case Study - Financial Statements in Power BI

Subscribe

Approx 7h to complete

100% online and self-paced

Subscribe to get access to BIDA™ and other programs

From $497/year

Learn More

Overview

Financial Statements in Power BI Case Study 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.

Financial Statements in Power BI 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 BIDA™ Course?

This Case Study is perfect for anyone who would like 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.

Financial Statements in Power BI is a Required Case Study of CFI’s BIDA™ Program

CFI’s Business Intelligence & Data Analyst (BIDA)™ program covers all the basic, intermediate, and advanced topics about business intelligence and data analysis. This program teaches the quantitative methods used in the finance and capital markets industry. It is ideal for students who want to learn how to analyze complex data. The program is completely online so you can take it at your own pace, from anywhere in the world.

Common career paths for students who take the BIDA™ program are Business Intelligence, Asset Management, Data Analyst, Quantitative Analyst, and other finance careers.

What You'll Learn

Lesson
Multimedia
Exams
Files
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 | Our Email Response
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
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
Create % of Revenue Measure
Create Income Statement Measure with SWITCH()
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
Chapter Exercise - Income Statement
Create the Waterfall Chart Visual
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
Publish Power BI Report & Analyze in Excel
Migrate the Data Model to Excel
Analyze in Excel with Cube Formulas
Chapter Introduction - Cube Formulas
What are Cube Formulas?
A Closer Look at Cube Formulas
Exercise 4
Use Slicers with Cube Formulas
Define Reporting Year Context for the Income Statement
Student Task - Complete the Income Statement
Populate Basic Values of 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
Update the Published Data Model
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
Share Your Feedback
Course Completion

Become a certified Business Intelligence & Data Analyst (BIDA)™

Case Study - Financial Statements in Power BI is part of the Business Intelligence & Data Analyst (BIDA)™ certification, which includes 17 BIDA courses + all future courses in the program.

Business Intelligence & Data Analyst (BIDA)™ Certification
  • Skills Learned Data Visualization, Data Warehousing and Transformation, Data Modeling and Analysis
  • Career Prep Business Intelligence Analyst, Data Scientist, Data Visualization Specialist
Learn More

What Our Students Say

Real-world challenges and application of BI skills
Wow, I was truly challenged by this module. As an accounting professional I found a lot value in being able to combine and practice SQL, Power Query and Power BI. Learning about Cube Formulas was an excellent cherry on top.

Lwazi Mace

Case Study - Financial Statements in Power BI Review Title
Insightful

Azeez Raimi

Excellent work
excellent work, furthermore if we can add pop ap to the dashboard.

Salem Qasem Ahmed Al-Tashi

PBI case study
Hand on and straightforward to learn course

Rodrigo González Morales

Frequently Asked Questions

How do I enroll in this course?
Are there any additional fees or costs?
What currency are your courses priced in?
Can I download the Excel files and financial modeling templates for the course?
How long do I have to complete the courses?
Are CFI courses officially accredited?
How do I earn my certificates?
Can I email the instructor if I have questions?
Will these courses help me advance my career?
What is included in the subscription?
More Questions?

Get Certified for
Data Analysis (BIDA™)

Access With Subscription Learn More
30 Day Money Back Guarantee