Spring, SQL Intersections, and Posts

I have been in academic mode since January hence the lack of posts, on the bright side come June i will have a bout 40 posts minimum i will need to start pumping out, so look forward to that.

Much to read below, but fill out this survey if you please!

Starting this summer i am going to start developing a stat learning and machine learning content, and knowing what medium to focus my efforts on for the coming year would be helpful.

I will be speaking at SQL Intersection mid May, i pretty much have the entire data science track to myself, which means four back to back sessions on Tuesday May 23.

The session calendar can be found here.

The Keynote “Data Science: What Is It and Do I Need It?” my best explanation is it will be a dummies guide to data science. What is it and can a SQL-Expert fit in that skill set somewhere, the answers is yes, yes you can. But please attend anyway.

“Data Science: Visualization and Story Telling” is actually a fun one for me to deliver, i mean who does not love picking on other peoples ridiculous visualizations? No technology will be demonstrated here, this is just a best practices session. I am going to give you the introductory principles so you can call out a bad viz, and know why its bad. I will use the history of visualizations, good ones, bad ones, and demonstrate that you miss have the content on a visaul and can’t remember the rest. Also, what to do next if you are seriously interested in the field of Visualization. Visualization and storytelling are a pillar of Data Science, so every aspiring data scientist needs it in some capacity, not to mention R can spit out a viz with very little syntax.

“Data Science: Azure ML – A Rapid Introduction for DBAs” or you – Any Microsoft salesman can spit out a linear regression in Azure ML, but it does not mean they know how to interpret the results in a meaningful way, and no, its not just the R-square. Have a Azure ML workspace setup before you arrive i am going to try to do this in a one hour workshop style event. And i promise we will not be talking about Cow Menstruation!

Finally “Data Science: SQL Server R – A Rapid Introduction for DBAs!” or for you. For this one i am going to be using the same dataset as the prior Azure ML demo/walk through, but in R Studio. I will show you how to interpret the results of a simple linear regression and multiple linear regression. R-square, adjusted r-square, significance, degrees of freedom, intercept slope, p-value, much goodness! PPT deck and R Script will be available at the start of the session.