---
title: Understanding Investment Tables in Pereview Analytics
description: Understanding Investment Tables in Power BI
---
[Skip to content](https://academy.pereviewsoftware.com/knowledge-base/understanding-investment-tables-in-power-bi#main-content)
[](https://academy.pereviewsoftware.com/knowledge-base?hsLang=en)
Open main navigation
Close main navigation
How can we help you?
- There are no suggestions because the search field is empty.
1. [Pereview Knowledge Base](https://academy.pereviewsoftware.com/knowledge-base?hsLang=en)
2. [Reports](https://academy.pereviewsoftware.com/knowledge-base/reports?hsLang=en)
3. [Pereview Analytics](https://academy.pereviewsoftware.com/knowledge-base/reports?hsLang=en#pereview-analytics)
October 2, 2026
# Understanding Investment Tables in Pereview Analytics
In this video, we explore how Pereview organizes and uses Investment Dimension Tables in Pereview Analytics – and why the model is structured the way it is.
The investment dimension brings together details like property type, geography, critical dates, ownership, roles, and custom fields – all mapped back to accounting codes. While certain data points (like city or property type) appear to be property-level, they’re surfaced at the investment level to support common reporting needs and follow Pereview’s 80/20 design principle.
You’ll learn how Pereview Analytics handles client-specific customizations – such as renaming fields or adding new ones – and why elements like critical dates or roles live in separate dimensions instead of folders within the investment table. The video also includes a walkthrough of creating a report using standard and custom investment fields, with tips on understanding data repetition, logical vs. physical accounting codes, and how to interpret semicolon-separated ownership lists.
Whether you’re building reports around asset attributes, ownership, or timelines, this session will help you understand how Pereview makes it easy to manage and visualize investment data at scale.
- [Pereview 101](https://academy.pereviewsoftware.com/knowledge-base/pereview-101?hsLang=en#main-content)
- [Navigation](https://academy.pereviewsoftware.com/knowledge-base/pereview-101?hsLang=en#navigation)
- [Add Records](https://academy.pereviewsoftware.com/knowledge-base/pereview-101?hsLang=en#add-records)
- [Support](https://academy.pereviewsoftware.com/knowledge-base/pereview-101?hsLang=en#support)
- [Product Features](https://academy.pereviewsoftware.com/knowledge-base/product-features?hsLang=en#main-content)
- [Workflow](https://academy.pereviewsoftware.com/knowledge-base/product-features?hsLang=en#workflow)
- [Custom Forms](https://academy.pereviewsoftware.com/knowledge-base/product-features?hsLang=en#custom-forms)
- [Updates and User Experience](https://academy.pereviewsoftware.com/knowledge-base/product-features?hsLang=en#updates-and-user-experience)
- [Reports](https://academy.pereviewsoftware.com/knowledge-base/reports?hsLang=en#main-content)
- [Formatted Reports](https://academy.pereviewsoftware.com/knowledge-base/reports?hsLang=en#formatted-reports)
- [Pereview Analytics](https://academy.pereviewsoftware.com/knowledge-base/reports?hsLang=en#pereview-analytics)
- [Custom Forms Reports](https://academy.pereviewsoftware.com/knowledge-base/reports?hsLang=en#custom-forms-reports)
- [Data Validation](https://academy.pereviewsoftware.com/knowledge-base/data-validation?hsLang=en#main-content)
- [Overview](https://academy.pereviewsoftware.com/knowledge-base/data-validation?hsLang=en#overview)
- [Data Validation Process](https://academy.pereviewsoftware.com/knowledge-base/data-validation?hsLang=en#data-validation-process)
- [Data Ingestion & Management](https://academy.pereviewsoftware.com/knowledge-base/data-ingestion-management?hsLang=en#main-content)
- [Data Management](https://academy.pereviewsoftware.com/knowledge-base/data-ingestion-management?hsLang=en#data-management)
- [AI Data Mapping](https://academy.pereviewsoftware.com/knowledge-base/data-ingestion-management?hsLang=en#ai-data-mapping)
- [System Admin & Technical Documentation](https://academy.pereviewsoftware.com/knowledge-base/system-admin-technical-documentation?hsLang=en#main-content)
- [User Management](https://academy.pereviewsoftware.com/knowledge-base/system-admin-technical-documentation?hsLang=en#user-management)
- [Configuration Options](https://academy.pereviewsoftware.com/knowledge-base/system-admin-technical-documentation?hsLang=en#configuration-options)
- [Pereview Outbound API](https://academy.pereviewsoftware.com/knowledge-base/system-admin-technical-documentation?hsLang=en#pereview-outbound-api)
- [SSO](https://academy.pereviewsoftware.com/knowledge-base/system-admin-technical-documentation?hsLang=en#sso)
- [Pereview Newsletters](https://academy.pereviewsoftware.com/knowledge-base/pereview-newsletters?hsLang=en#main-content)
- [2026 Newsletters](https://academy.pereviewsoftware.com/knowledge-base/pereview-newsletters?hsLang=en#2026-newsletters)
- [2025 Newsletters](https://academy.pereviewsoftware.com/knowledge-base/pereview-newsletters?hsLang=en#2025-newsletters)
- [2024 Newsletters](https://academy.pereviewsoftware.com/knowledge-base/pereview-newsletters?hsLang=en#2024-newsletters)
[](http://pereviewsoftware.com)
12400 Coit Rd, Suite 570, Dallas, TX 75251
[mailto:support@pereviewsoftware.com](mailto:support@pereviewsoftware.com)
Copyright © 2026, Pereview Software
```json
{
"@context" : "https://schema.org",
"@type" : "VideoObject",
"caption" : {
"@type" : "MediaObject",
"contentUrl" : "https://academy.pereviewsoftware.com/media-transcripts/191603479828/en.vtt",
"inLanguage" : "en",
"name" : "en Captions"
},
"contentUrl" : "https://stream.mux.com/r8RmxqueYSbyTdq5eQSMmm6UZ4F38szkYqSipeHGzmo/capped-1080p.mp4",
"dateModified" : "2025-08-26T19:20:54.868Z",
"duration" : "PT10M13.136S",
"height" : 1080,
"name" : "Power BI Investment Tables - Video (1)",
"thumbnailUrl" : "https://20496164.fs1.hubspotusercontent-na1.net/hubfs/20496164/Power%20BI%20Investment%20Tables%20-%20Video%20(1).mp4/medium.jpg",
"uploadDate" : "2025-06-20T16:28:24.732Z",
"width" : 1920
}
```