Course
|
Tableau

Preparing Financial Statements

Develop an Income Statement, Balance Sheet and Statement of Cash Flows in Tableau. Learn how to analyze your accounts and create compelling visualizations of your financial reports.
3 HOURS
Advanced
10 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Explain the ideal layout of financial data for analysis in Tableau
Transform financial data using Tableau Prep
Develop an Income Statement, Balance Sheet, and Cash Flow Statement in Tableau
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
helping to build
data, Tech & ai skills in
g2-badgebritish-airwaysjotunamazon-logopwc-logoford-logo
Course
|
Tableau

Preparing Financial Statements

Develop an Income Statement, Balance Sheet and Statement of Cash Flows in Tableau. Learn how to analyze your accounts and create compelling visualizations of your financial reports.
3 HOURS
Advanced
10 Lessons
CPE/CPD & NASBA ACREDITED
Learning Outcomes
Explain the ideal layout of financial data for analysis in Tableau
Transform financial data using Tableau Prep
Develop an Income Statement, Balance Sheet, and Cash Flow Statement in Tableau
Leave your number for the fastest response

Get More Info

Looking to understand how Kubicle can better help your organization meet its learning objectives? Book some time with one of our consultants today.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

What’s Included

10 Lessons
Course Introduction
4 MINS
LESSON
Course Introduction
Exercise

Tableau has plenty of potential for finance and accounting professionals. In this lesson, you'll learn why this is the case, and we'll introduce the case study for this course.

Exploring the Dataset
5 MINS
LESSON
Exploring the Dataset
Exercise

One of the key considerations when developing accounts in Tableau is ensuring that your underlying data is in the right format. In this lesson, we'll discuss these considerations, and see how they apply to the dataset for our case study.

Transforming the Data
6 MINS
LESSON
Transforming the Data
Exercise

When developing a complex data model in Tableau, the first step is always to transform the data in Tableau. In this lesson, we'll see what transformations need to be applied to our data before we analyze it.

Building the Income Statement
#.## MINS
LESSON
Building the Income Statement
Exercise

In this lesson, we build the Income Statement, the first of the three financial statements we cover in this course. We'll learn how to build the various measures needed to create the statement, and then build it using Tableau's visualizations.

Analyzing the Income Statement
6 MINS
LESSON
Analyzing the Income Statement
Exercise

The advantage of using Tableau for financial statement analysis is that we can easily analyze statements in the same place where we create them. In this lesson, we'll analyze the trends in our Income Statement using different visualizations.

Creating the Balance Sheet
6 MINS
LESSON
Creating the Balance Sheet
Exercise

The Balance Sheet is the second financial statement we want to create. We'll learn how to do so in this lesson, and see that there is significant overlap between the methods used to create the Income Statement and Balance Sheet.

Analyzing the Balance Sheet
7 MINS
LESSON
Analyzing the Balance Sheet
Exercise

Ratio analysis is a common way of analyzing Balance Sheet data. In this lesson, we'll calculate various ratios for our data, and see how to handle calculations involving data from both the Income Statement and Balance Sheet.

Creating the Statement of Cash Flows
6 MINS
LESSON
Creating the Statement of Cash Flows
Exercise

The Cash Flow Statement is the final financial statement we'll consider in this course. In this lesson, we'll learn how to create this statement in Power BI.

Analyzing the Statement of Cash Flows
4 MINS
LESSON
Analyzing the Statement of Cash Flows
Exercise

In this lesson, we'll learn how to create a matrix containing a small sample of values from the Cash Flow Statement, and analyze the data in the statement using visualizations.

Considering Ledger Data
3 MINS
LESSON
Considering Ledger Data
Exercise

When you're creating financial statements in Power BI, it's likely that your underlying data source will be your company's General Ledger. This lesson will show you what this data can look like, and explain how it differs from the data we've seen in the rest of the course.

LESSON
Exercise

LESSON
Exercise

See More
See Less
Certifications
Earn a certificate with every exam you complete. All successful course completions are recognized by CPD, CPE, and NASBA. As your team gains confidence, skill, and speed, your firm becomes more competitive.
Earn cPE / CPD Credits
No items found.
Get More Info
Looking to understand how Kubicle can better help your organization meet its learning objectives?  Book some time with one of our consultants today.
Contact Information
Looking to speak to someone directly?
01 700 9000
info@kubicle.com
Dublin, Ireland
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Plus Size YourLearning with Academies+
THE PLATFORM OF CHOICE FOR 1M+ USERS

A Learner Experience Designed to Deliver Transformation

Testimonials

How Leading Teams Use Kubicle to Upskill & Excel

Heineken Case Study
ADL Logo