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