M.Y. BI and Analytics

  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)) ...

  In this Video I shall share a method on using R in Power BI desktop to unzip the compressed excel files based on the identified file name extensions of extracted files, such as csv, xlsx, xls and xlsb etc, then combine them if they have same column headers and table structure, Finally load the combined data frame into power BI for further data modelling. The introduced R script in this video only focus on loading zipped files from local machine but it is possible to have slight modifications on the R script to be able to fulfil such automatic features online at cloud sites with the required respective http URL paths and access logins.   Let’s get start:   First, we need to prepare the received compressed sample files, we have four excel files with extensions, csv, xls, xlsx and  xlsb. All of them have the same data table structure, same column numbers with same column headers. After compressing them we get a zipped folder for the zipped four files as “Downl...

  In the video I have shared the detail steps and R script codes on creating 3D quadratic surface plot in power BI desktop. With changing the 8 parameter slicers in power BI visual we are able to simulate the different types of 3D quadratic surface with the View Angels at the levels of Horizontal and Vertical. The R package Lattice and function Wireframe are applied to plot the 3D quadratic Surface. The link of the R script codes for the video I have attached in the video descriptions in below. Hope this video brings some help for your project developments. R Scripts for the demo: # Load the lattice package: library(lattice) # Create Parameter Variable for rotating view angles HAngles=dataset$H_Angle VAngles=dataset$V_Angle # Create coefficient Prameter Variables: a = dataset$a b = dataset$b c = dataset$c d = dataset$d e = dataset$e f = dataset$f # Create data for a quadratic surface x <- seq(-5, 5, length.out = 100) y <- seq(-5, 5, length.out = 100) # z <- outer(x, y, fun...

  In the video. I have shared the method on using R script visual with package scatterplot3d to generate a 3D scatter plot, and also introduce a way on adding dynamic viewing angles to  rotate the 3D plot with slicer visual based on power BI new parameter feature generated angle value table . In the demo we applied power query editor to prepare source data table for the 3D plot, used the R studio to cerate and edit R script for 3d scatter plot and finally adopt the slicer visual generate by Power BI new parameter for interactive rotating 3D graphic view angels dynamically. Hope the video give some helps for your power BI project developments.  R Scripts: # Load the scatterplot3d library: library ( scatterplot3d ) # Define variables from the source data for plotting: x <- dataset $ "Technical Skills" y <- dataset $ "Leadership & Management" z <- dataset $ "Personal Development" l <- dataset $ "Employee ID" # apply scattedplot3d...

  In the video I have shared a method to draw the circular barplot in power BI desktop file. As shown in the screen, the Circular BarPlot, which wraps a barplot that has larger numbers of categorical entities in circular shape, thus with it users can obtain all entities with their measure in a more eye catching organization space chart. To get this Circular Barplot chart in power BI we need to employ the power BI R script visual.  To Enable R scripts Visual feature in Power BI Desktop , we need go to File > Options and settings > Options > R Scripting. In the R scripts options you have two fields to fill. First one is to choose home directory for R, which means you need first to install a R engine and select the installed R engine location for the field. To install R engine we may click the  link ”how to install R”. it brings us to the Microsoft learning site regarding where to download R engine and how to install it.  The second field is to choose which R I...