Posts

Showing posts from 2017

Essentials of Machine Learning Algorithms using R

https://www.analyticsvidhya.com/blog/2015/08/common-machine-learning-algorithms/ https://www.datascience.com/blog/introduction-to-forecasting-with-arima-in-r-learn-data-science-tutorials https://techietweak.wordpress.com/2016/05/18/r-data-frame-the-one-data-type-for-predictive-analytics/ Linear Regression Model: TestDataset <- read.csv("D:\\Dinesh\\AI\\TestDataset.csv") TrainingDataset <- read.csv("D:\\Dinesh\\AI\\TrainingDataset.csv") TrainingDataset TestDataset date <- as.Date(TrainingDataset$dteday) TrainingDataset <- cbind(TrainingDataset,date) sapply(TrainingDataset, class) date <- as.Date(TestDataset$dteday) TestDataset <- cbind(TestDataset,date) sapply(TestDataset, class) lmModel <- lm(cnt ~ date + season + yr + mnth + holiday + weekday + workingday + weathersit + temp + atemp + hum + windspeed + casual + registered, data = TrainingDataset) glmModel <- glm(cnt ~ date + season + yr + mnth + holiday + weekday + work...
DAX for filtering data up to given Year in Power BI Report: Create MaxDateKey measure in FactFinancial table using below DAX MaxDateKey = CALCULATE(MAX('Date'[DateKey]), ALLEXCEPT('Date', 'Date'[FYYear])) Revenue = CALCULATE(sum(FactFinancial[Amount] ),DimAccount[AccountType] = "Income", FILTER(DimDate, DimDate[DateKey] <= [MaxDateKey] )) All other measure like QoQ and Total Amount you apply below logic Revenue = CALCULATE(sum(FactFinancial[Amount] ),DimAccount[AccountType] = "Income", FILTER(DimDate, DimDate[FYYear] = max('Date'[FYYear]) )