Saturday December 3rd 2016

Machine Learning

Can Machine Learning Decode Depression? Can Machine Learning Decode »

An interesting article published in Huffington post by Arshya Vahabzadeh, M.D. Harvard Trained [...]

Machine Learning Algorithm Dev Opportunity in Toronto Canada Machine Learning Algorithm »

Our client is a well-established leader in online sports gaming with a Technical Centre of Excellence at [...]

Data Munging with Pandas – John Fries, CTO, OpenMail Data Munging with Pandas »

An excellent video on Data munging. The good thing about this video is that it attempted to compare SQL [...]

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

Running Aggregate »

Running Aggregate

An excelent use of sql to produce running aggregate like we do in reporting tools like Crystal Reports. Yhis example is take from Microsoft SQL Server [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 [...]