{"{\"option\":\"Module 1: Case Study Introduction 1. Case Study Introduction 2. Your Role as a Business Intelligence Developer 3. Video Call with CFO 4. Challenges to Consider in the Project 5. Project Requirements Email 6. Exercise 1 \"}","{\"option\":\" Our Email Response 7. Final Project Requirements and Approach 8. Financial Statements Review 9. Case Study Files Overview 10. Case Study Student Files DownloadModule 2: Extract Data from the Database 1. Chapter Introduction - Extract Data from the Database 2. Download Azure Data Studio 3. Student Task - Connect and Explore the Database 4. Student Task Review - Connect and Explore the Database 5. Entity Relationship Diagram 6. Exercise 2 7. Plan the SQL Query 8. Student Task - Write the SQL Query 9. Student Task Review - SQL Query Part 1 10. Student Task Review - SQL Query Part 2 11. Create the SQL View 12. Chapter ReviewModule 3: Create the Data Model in Power Query 1. Chapter Introduction - Create the Data Model 2. Create the Staging Query 3. Create the Fact and Dimension Tables 4. Create the Remaining Dimension Tables 5. Student Task - Create the Data Model 6. Student Task Review - Create the Data Model 7. Create SumAmount Measure 8. Chapter Review and Summary of ChallengesModule 4: Income Statement in Power BI 1. Chapter Introduction - Income Statement 2. Financial Statements with Existing Data Model 3. Create Headers Table in Excel 4. Import Headers Table into Power BI 5. Create I/S Amount Measure 6. Create I/S Subtotal Measure 7. DAX Functions 8. Exercise 3 9. Create % of Revenue Measure 10. Create Income Statement Measure with SWITCH() 11. Format % of Revenue Measure 12. Finalize the Income Statement Measure 13. Create Subcategory Display Filter 14. Finalize the Income Statement 15. Add Data Refresh Date 16. Format the Power BI Report 17. Chapter Exercise - Income Statement 18. Create the Waterfall Chart Visual 19. Chapter Exercise Hints - Income Statement 20. Chapter Exercise Review - Income StatementModule 5: Balance Sheet in Power BI 1. Chapter Introduction - Balance Sheet 2. Update the Headers Table 3. Create B/S Amount Measure 4. Create Cumulative Amount Measure 5. Create B/S Subtotal Measure 6. Create Balance Sheet Measure with SWITCH() 7. Create Opening Retained Earnings Measure 8. Create Retained Earnings Measure 9. Create Total Equity Measure 10. Create Total Liabilities & Equity Measure 11. Finalize the Balance Sheet 12. Chapter Exercise - Balance Sheet 13. Chapter Exercise Hints - Balance Sheet 14. Chapter Exercise Review - Balance Sheet 15. Add Detail and Create Additional Statements 16. Check-In and Review with CFO 17. Publish Power BI Report & Analyze in Excel 18. Migrate the Data Model to ExcelModule 6: Analyze in Excel with Cube Formulas 1. Chapter Introduction - Cube Formulas 2. What are Cube Formulas? 3. A Closer Look at Cube Formulas 4. Exercise 4 5. Use Slicers with Cube Formulas 6. Define Reporting Year Context for the Income Statement 7. Student Task - Complete the Income Statement 8. Populate Basic Values of the Income Statement 9. Student Task Review - Complete the Income Statement 10. Student Task - Build the Balance Sheet 11. Student Task Review - Build the Balance Sheet 12. Cash Flow Statement Introduction 13. Update the Published Data Model 14. Populate the Cash Flow Statement 15. Cash Flow Statement Review 16. Cube Formulas ReviewModule 7: Case Study Summary 1. Project Wrap-Up with CFO 2. Case Study Wrap-UpModule 8: Qualified Assessment 1. Case Study - Financial Statement in Power BI Qualified Assessment 2. Share Your Feedback 3. Course Completion\"}"}

Get flat 10% off  on CFI's all-access subscription plans

English

United States dollar

Power BI is a powerful way to interact with financial data at high levels.


 This course provides a scenario-based case study that will reinforce your knowledge of PowerBI. It also includes interactive exercises and extended student challenges.


 Three significant challenges are involved in creating financial statements in Power BI. We will help you overcome them using a combination BI tools.


 This is the ultimate Power BI walkthrough on Financial Statements. This case study will teach you how to use BI skills as a Business Intelligence developer. Your role is to automate and visualize financial statements for a retail business.

Learn "Case Study - Financial Statements in Power BI" "Certification" by "Corporate Finance Institute (CFI)" and upskill your career by acquiring skills like Cash Flow Analysis etc with Careervira.

Case Study - Financial Statements in Power BI

Case Study - Financial Statements in Power BI

Description

Features

Duration

Skills

Learning Goals

Course Content

Prerequisites/Requirements

Target Audience

FAQs

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?

Are there any additional fees or costs?

What currency are your courses priced in?

How do I earn my certificates?

Will these courses help me advance my career?

Can I email the instructor if I have questions?

What is the price of the subscription?

What is included in the subscription?

More Questions?

₹3,018