Income Statement Semantic Models

This comprehensive guide will teach you how to build an income statement semantic model, also known as the profit and loss (P&L) statement.

Author Chris Barber— a business intelligence (BI) consultant, Microsoft MVP, and chartered accountant (ACMA, CGMA)—helps you master everything from designing conceptual models to building semantic models based on these designs. You will learn how to build a re-usable solution based on the trial balance and how to expand upon this to build enterprise-grade solutions. If you want to leverage the Microsoft BI platform to understand profit within your organization, this is the resource you need.

What You Will Learn


Modeling and the income statement: Learn what modelling the income statement entails, why it is important, and how income statements are constructed
Calculating account balances: Learn how to optimally calculate account balances using a Star Schema
Producing external income statement semantic models: Learn how to produce external income statement semantic models as they enable income statements to be analyzed from a range of perspectives and can be explored to reveal the underlying accounts and journal entries
Producing internal income statement semantic models: Learn how to create multiple income statement layouts and further contextualize financial information by including percentages and non-financial information, and learn about the various security and self-service considerations