This exercise consists of of three parts. There are hints and solution files for each part.

You’ll learn tool such as Pivot, Transpose, Text Column, Stack, Create Rows, Compare and IF Column.

​
Context

You’ll be pretending to be a Finance Analyst. You have set up connections to your accounting system - that could be Xero, Quickbooks, e-conomic, 24seven, etc.

In that accounting system you have a bunch of different tables: general ledger, territory mapping table, accounts, etc. This exercise is contains three parts. You can obviously complete as many parts as you’d like.

Part One. In the first part, you will create an complete Income Statement for 2018, 2019 and 2020. You also want to add a year-on-year percentage change column comparing 19/20.

Part Two. In the second part you’ll use the Income Statement to create a Gross Profit Margin and Operating Margin for each year.

Part Three. In the last part, you will adjust your Income Statement by using an accrual-based approach instead of a cash-based account from Part 1.

​
Data

Create a new connection. Search for “exercise” and select the Automated Financial Analysis. Configure the connector and you should have access to the tables from the Canvas.