Big Data is ready for a DEP dive, deep inside your body! Introduction 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 of the and send the data stream about level of a drug content in the… Continue reading Analysis of social & ethical impact of the Ingestible sensors based data analytics applications
Abstract There has been explosive growth in the big data applications in recent past and one such area is Workforce 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… Continue reading Need vs. Ethical Need of Big data Applications in Workforce Analytics
Big Data Application in Effective Customer Marketing & Satisfaction Abstract 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… Continue reading Call Routing Analytics – Response Mechanism by predicting Incoming Call Priority & overall Customer Importance
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 Lyrics for any given Image using Multi-modal Semi-Supervised Machine Learning
Analyze 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. Abstract Asian Americans forms one of the largest immigrant group in… Continue reading Social Profiling Analytics- Behavior Analysis of Asian Americans
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
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?
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?
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
We have seen the concept of Junk Dimension in the preceding article and how it is developed and how it is helpful in the life-cycle of dimensional modelling. Some people however have the concern about the performance of Junk Dimension namely that since we are putting together multiple entities , that will affect the performance… Continue reading Modelling Tip- How Junk Dimensions helps in DW Performance?