{"id":338,"date":"2017-03-29T21:23:00","date_gmt":"2017-03-29T21:23:00","guid":{"rendered":"https:\/\/sqlshep.com\/?p=338"},"modified":"2017-12-18T18:28:48","modified_gmt":"2017-12-18T18:28:48","slug":"spring-sql-intersections-posts","status":"publish","type":"post","link":"https:\/\/sqlshep.com\/?p=338","title":{"rendered":"Spring, SQL Intersections, and Posts"},"content":{"rendered":"<p>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.<\/p>\n<p>Much to read below, <a href=\"https:\/\/goo.gl\/forms\/68KFuzOIJi4bf6Tk1\" target=\"_blank\">but fill out this survey if you please<\/a>!<br \/>\n<!--more--><\/p>\n<p>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. <\/p>\n<p>I will be speaking at <a href=\"https:\/\/devintersection.com\/#!\/SQL-Conference\" target=\"_blank\">SQL Intersection<\/a> mid May, i pretty much have the entire data science track to myself, which means four back to back sessions on Tuesday May 23.  <\/p>\n<p>The session <a href=\"https:\/\/devintxcontent.blob.core.windows.net\/showcontent\/Schedule\/SQLint_Spring17_Schedules.pdf\" target=\"_blank\">calendar can be found here.<\/a><\/p>\n<p>The Keynote &#8220;Data Science: What Is It and Do I Need It?&#8221; 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. <\/p>\n<p>&#8220;Data Science: Visualization and Story Telling&#8221; 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&#8217;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.<\/p>\n<p>&#8220;Data Science: Azure ML &#8211; A Rapid Introduction for DBAs&#8221; or you  &#8211; 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 <a href=\"https:\/\/www.youtube.com\/watch?v=oY0mxwySaSo\">Cow Menstruation<\/a>! <insert eye rolling emoticon here><\/p>\n<p>Finally &#8220;Data Science: SQL Server R \u2013 A Rapid Introduction for DBAs!&#8221; 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. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>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!<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6,9,25,11],"tags":[26,8],"class_list":["post-338","post","type-post","status-publish","format-standard","hentry","category-data-science","category-r","category-sql-intersections","category-visualization","tag-sql-intersections","tag-sqlshep"],"_links":{"self":[{"href":"https:\/\/sqlshep.com\/index.php?rest_route=\/wp\/v2\/posts\/338","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlshep.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlshep.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlshep.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlshep.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=338"}],"version-history":[{"count":8,"href":"https:\/\/sqlshep.com\/index.php?rest_route=\/wp\/v2\/posts\/338\/revisions"}],"predecessor-version":[{"id":547,"href":"https:\/\/sqlshep.com\/index.php?rest_route=\/wp\/v2\/posts\/338\/revisions\/547"}],"wp:attachment":[{"href":"https:\/\/sqlshep.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=338"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlshep.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=338"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlshep.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=338"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}