Power BI Memory and Performance Considerations

Excerpt From Book: 

Extreme DAX: Take your Power BI and Microsoft data analytics skills to the next level, Publication date: 20 Jan 2022, Author: Michiel Rozema, Henk Vlootman


1. Having fewer columns is better.
2. Use the Right data type.
3. Having many rows is no issues, but watch out for many values.
4. Avoid outliers - leave these values blank or choose special value that is close to actual values.
5. Do really need all that history?
6. Split columns for some cases: columns after split should end up with fewer distinct values. 


 

Comments

Post a Comment

Popular posts from this blog

Power BI DAX and Visualizations: Active employees across time (as x-axis) by Tenure group or age group

Image
Business Case raised by my youtube channel viewer on the 21st July 2023. In my employee tenure data, it has employee birthday, hire date and leaving date, and race, gender, etc. Do you have any idea how to create a dynamic measure of tenure and/or age, as well as a "tenure group" and "age group" that can change with the calendar date? I would like to show in a line chart the changing number of active employees across time (as x-axis). Furthermore, I would like to breakdown the number of employees by their age group or tenure group (using age group as a legend). The age or tenure group will be dynamically change according to the dates in the X-axis. Any suggestions are appreciated. My suggestions: Assumptions on what we have for the case:                         - an employee table with coloumns: table update(or registered) date,              ...
Read more

Power BI Power Query & R: Calculate MACD Indicators With Assumed Initial Values

Image
  The video shares a method by running R script in power query to calculate MACD (Moving Average Convergence Divergence) Indicator with Assumed Initial Value which come from the first closing price data point. In video the advantages and disadvantages of the two MACD calculations, one with initials and one without initials, are compared in a table list. The calculation R scripts are well explained in details with each line in the video as well. You may find and copy the R code lines in my blog site which URL is attached in following. The R code lines as: # Step 1: Load dataset and format data  Dataset <- dataset # format date type as expected date format day/month/year Dataset$Date <- as.Date(Dataset$Date, format = "%d/%m/%Y") # Ensure close_price is numeric Dataset$Close <- as.numeric(Dataset$Close)   # Step 2: Creat Function to calculate EMA calculate_EMA <- function(x, n = 9) {   multiplier <- 2 / (n + 1)   ema <- numeric(length(x)) ...
Read more

Excel VBA Tips: A Macro to Generate Yearly Loan Schedule Report with Aggregated Monthly Re-Payments

Image
In this video, to provide users with a summarized yearly loan schedule report, I guide viewers in creating a new VBA macro based on modifying my previous Video demonstrated VBA macro for monthly loan schedule report which reveals interest and principal payments over the long term. The process involves two vertical VBA project windows and adjusting variables, calculations, and formatting. The updated procedure is offering an aggregated yearly report for different loan terms. Ths VBA codes is provided as following: Sub GenerateLoanReport_AggregatedYearlyPeriodReport() ' Created by MIKE GuangYuan YU on 8th of July , 2023 for M.Y BI & Analytics youtube channel     ' the procedure is to create loan report at yearly repayment period     ' Version 1.0          'I. Define required variables         Dim wsLoan, wsLoanReport As Worksheet         Dim LoanAmount As Double         Dim Interes...
Read more