Scenario 1: Multiple fact tables thar are not related to each other Solution: Relate every dimension with their respective fact tables. Identify the shared dimensions. Relate them with every [...]
The DMVs are queries that allow you to retrieve valuable metadata information about your data model, server operations, and server health. What are the DMVs The DMVs queries are an interface [...]
ALM Toolkit is a free and open source tool that facilitates the deployment of Microsoft Power BI datasets, detects differences between source and target datasets, checking for changes to be [...]
This last article includes a list of best practices for data visualization. – Use filters in your visualizations to reduce the amount of data that display: The more data a visual must [...]
In this post I’ll show you several tools that can help you analyze the performance of your Power BI solutions at every step of the way, some of them are built-in features and others are [...]
This second article is focused on best practices for designing your data model, optimizing CPU, RAM, and workspace capacity consumption by minimizing memory usage. Benefits. Reduce space and [...]
This third article will cover how to optimize the DAX Formulas of your data model – Convert Multiple Measures to Variables: This will minimize the number of measures on your data model and [...]
