SQL Script to populate Date Dimension table in the Data warehouse.

This is a simple script l wrote in SQL server 2012 which can be used to populate the Date table for use in a data warehouse. It provides components of the date which can be used in any situation. IF OBJECT_ID(‘tempdb..##Dates’) IS NOT NULL DROP TABLE ##Dates CREATE TABLE ##Dates(DateValue Date, YearValue INT, MonthValue INT, […]

Read More

Machine Learning predicting quality of exercise performed using smart wearable device data.

Background Using devices such as Jawbone Up, Nike FuelBand, and Fitbit it is now possible to collect a large amount of data about personal activity relatively inexpensively. These type of devices are part of the quantified self movement – a group of enthusiasts who take measurements about themselves regularly to improve their health, to find […]

Read More

Comparing accuracy of prediction of Alzheimer’s diagnosis by Machine Learning Algorithms Random Forest, Boosted Trees and Linear Discriminant Analysis to a stack prediction of all the three Algorithms.

In this post, what I want to show is how the Machine Learning algorithms Random Forest, Boosted Trees and Linear Discriminant Analysis will compare to a stack or an ensemble of all of them together. Load the Alzheimer’s data using the following commands library(caret) library(gbm) set.seed(3433) library(AppliedPredictiveModeling) data(AlzheimerDisease) adData = data.frame(diagnosis,predictors) inTrain = createDataPartition(adData$diagnosis, p […]

Read More