Monday November 20th 2017

Machine Learning

Michael Hochster, PhD in Statistics, Stanford; Director of Research, Pandora – As a data scientist, how do you answer when non-technical people ask you “is your analysis result statistically significant?” Michael Hochster, PhD in »

Answer They are asking whether you have enough data to trust your results. I would try to answer the real [...]

Tetiana Ivanova – How to become a Data Scientist in 6 months a hacker’s approach to career planning Tetiana Ivanova – How »

You don’t need a PhD or even a masters to do machine learning. On taking calculated risks and [...]

How to Become a Data Scientist in 2017? | Data Scientist Career | Data Science Future How to Become a Data »

Jesse Steinweg-Woods is soon-to-be a Senior Data Scientist at tronc, working on recommender systems for [...]

SQL, BI, IT news

Using subqueries to find gaps in sequence

Using subqueries to find gaps in sequence

Using subqueries to find gaps in sequence source Microsoft Database development self-Paced Training Kit Tobias Thernstrom, Ann Weber, Mike Hotek and GrandMasters Create Table #orderdates (customerid int not null, orderdate DateTime not null); Declare @startdate datetime, @enddate datetime, @customerid int set @customerid =1 while [...]

Difference between CTE and Temp Table

Difference between CTE and Temp Table

From Reporting Perspective its import to to know the difference between CTE, derived tables and Temp Tables, following is the some of our attempt to elaborate the differences A common table expression can be thought of as a temporary result that is defined within execution scope of single a single SELEC, INSERT, UPDATE, DELETE or CREATE VIEW [...]


Crystal Reports

Selecting Null when there is empty »

Selecting Null when there is empty string

Many times we have a limited access to the data and views are created by IT departments and we have to select only the null or empty fields in Crystal [Read More]


Understanding Covariance Understanding »

Great video explaining Covariance it discusses the very basics of what covariance is [...]

Forecasting Methods made simple – Exponential Smoothing Forecasting Methods »

A Great video on understanding Alpha There Series of videos by Piyush Shah, under the [...]

Statistics 101: Simple Linear Regression (Part 4), Fit and the Coefficient of Determination Statistics 101: »

In video Brandon explained - how well a regression line fits the data it models. It is [...]