1. Getting to know the income statement
In this screencast we are going to explore the data in our income statement and create a measure to help us analyze this financial statement. First let’s look at our data. We see in our data pane we have five tables loaded.
We have one fact table called “Actuals” and four dimension tables: "Date","Income Statement Layout", "Mapping" and "Organization Mapping”.
We also have a table called “Model Measures” where we will store all our created measures.
Here you can see in our model pane how all of these different tables are connected.
You will notice that the income statement has many line items that consist of revenues at the top, then expenses with Profit or loss at the bottom.
Here at the top we have Gross Revenue which is all the money a company earns without subtracting any expenses.
Next we have Net Revenue which is the money a company earns minus all expenses.
Then we have “Cost of Sales” or Cost of goods sold or (COGS) which refers to the costs of producing items sold by a company.
COGS is subtracted from revenues to determine its gross profit; which we have here.
Gross Profit is the profit a company makes after subtracting the costs associated with making and selling its products.
Here we have Earnings before interest, taxes, depreciation, and amortization, or EBITDA, this is an alternate measure of profitability.
Lastly we have our bottom line, “Profit After Tax”, also known as Net Profit or Net Loss.
We have a slicer that provides us monthly data for each year.
Now we can add a card visualization to take a look at our first line item under gross revenues, and we have selected “2021” in our slicer and then we have selected the “Total Operating Revenue” in our measures.
We are able to see the Total Operating Revenue in 2021 is $84.2 Million.
Now we are going to create a measure to find Total Net Revenues, which includes Total Operating Revenues.
To calculate Total Net Revenue, we find the sum of Total Operating Revenue, Total Intercompany Revenue, Total Discount and Total Returns and Total Adjustments.
After we press enter that is going to give us our Total Net Revenue.
Now that you have become familiar with the income statement, it is your turn to try some new analysis.
2. Let's practice!