Correlation between “Deaths of Despair” in White America & Trump Victory

"Death of Despair" is an underreported phenomenon which has killed nearly 100,000 middle aged white Americans due to depression related causes. (suicides & addiction) since 99. (epidemic comparable to AIDS in its scope). I was curious to find if this has any correlation with the 2016 election victory of Trump. So I collected CDC mortality… Continue reading Correlation between “Deaths of Despair” in White America & Trump Victory

Advertisements

Trajectory of the “Ingestible Sensors” (Digital Medicine) based analytics

Ingestible sensors are tiny sensors that can be ingested by a patient along with a pill (it’s smaller than grain of a sand). The sensors goes inside body and send the data stream about level of a drug content in the body. The data stream sent from inside a person’s body is received typically by… Continue reading Trajectory of the “Ingestible Sensors” (Digital Medicine) based analytics

Ethics of Employees’ Social Media Analytics

While there are many legitimate & absolutely essential analytics that needs to be done by any company on its employees, there are some grey areas when it comes to some specific applications like Sentiment Analysis of Employees. Large corporate entities which are having operations around the world, have built applications so that they can track… Continue reading Ethics of Employees’ Social Media Analytics

Call Routing Engine by predicting Incoming Call Priority & Importance

Depending upon the overall Importance Level of the given customer and/or by predicting upcoming call priority in advance, incoming call can be "Automatically & Intelligently Routed" by “Recommended Call Action System”; which can decide what treatment should be given to this upcoming call. Based on complex factors , it can either leave it in queue… Continue reading Call Routing Engine by predicting Incoming Call Priority & Importance

Neural songwriter – Generating Poems for any given Image using Multi-modal Semi-Supervised Machine Learning

There is a strong correlation between images that we imagine and a song being played. For example for romantic love song, the images would normally happy, shining, beautiful loving people etc. We decided to train a set of random images along with songs and then try to generate a song stanza for any given random… Continue reading Neural songwriter – Generating Poems for any given Image using Multi-modal Semi-Supervised Machine Learning

Social Profiling Analytics of Asian Americans

Social Profiling of Asian Americans community to discover if it is a monolithic group or if there are hidden patterns of distinct social profiles based on socio-economic demographics ,  priorities of life , immigration status & view of USA ; which can explains their social behavior. Asian Americans forms one of the largest immigrant group… Continue reading Social Profiling Analytics of Asian Americans

ETL Tip- How to Handle Null vs the Blank fields in Data Warehouse

While populating the data warehouse ETL team is always confused as to how to handle the "Logically NA" values of data. Here are some suggestions in that regards, -What does "Logical Nulls" means? There are always some cases in the data model when there is no data available for a field in some cases. Such… Continue reading ETL Tip- How to Handle Null vs the Blank fields in Data Warehouse

ETL Tip- How to implement Surrogate Keys & Constraints in Data Warehouse?

his article is to explain how to implement the Surrogate keys from a logical dimensional model to a physical DBMS. There have been some clear cut guidelines on this matter from Ralph Kimball & Group but some people still manage to make a mess out of it , so it seems that it should be… Continue reading ETL Tip- How to implement Surrogate Keys & Constraints in Data Warehouse?

Modelling Tip- Why it makes sense to ALWAYS have a surrogate key for Date Dim?

While there is normally a consensus about using a surrogate key in all the dimensions in a dimensional model , there are some who wonder if we should be using a surrogate key for a date dimension. Date dimension is used in every single data model so this question is quite typical. Here are some… Continue reading Modelling Tip- Why it makes sense to ALWAYS have a surrogate key for Date Dim?

Template for Physical Dimensional Model Document

Dimensional Model as designed with the facts & dimensions using normally Ralph Kimball methods or sometimes using Bill-Inmon books , normally pertains to the so called "Logical Data Model" or "Logical Dimensional Model" . There are many steps which need to be done to execute this logical model into the physical model & in most… Continue reading Template for Physical Dimensional Model Document