Improve planning with next-gen data model builder

Business value

Designing and maintaining data models for planning can be complex and time-consuming. The next-gen data model builder simplifies this process with an improved, Microsoft-consistent interface that enhances visibility, flexibility, and control. With a modern, intuitive design, users can easily define dimensions and facts, preview their model structure, and manage properties within a single view. This streamlined experience reduces setup time, improves collaboration between finance and IT teams, and helps organizations build reliable planning models faster, ensuring greater transparency and agility across their planning processes.

Feature details

The next-gen data model builder introduces a redesigned user experience for creating and managing cubes and dimensions in Business performance planning. - Unified view: Build and edit all model elements—cubes, dimensions, relationships, and measures—in one workspace. - Improved navigation: Instantly preview model structures and dependencies for better visibility and validation. - Flexible setup: Create models from scratch or upload Excel files to automatically detect dimensions and fact tables. - Draft and publish control: Experiment with draft cubes before publishing finalized models to Dataverse. - Microsoft-consistent interface: Aligned with Power BI design principles for a more familiar and efficient workflow. This enhancement provides faster model creation, greater accuracy, and a smoother end-to-end planning experience. It lays the foundation for future AI-assisted modeling and data preparation within Business Performance Planning.