July 27, 2015 at 8:22 pm
Comments posted to this topic are about the item Visualizing in Space
July 28, 2015 at 1:46 am
If SQL professionals are needing a tool to help them visualize spatial datasets I would recommend QGIS - an open source digital mapping package that can easily be configured to link to SQL Server.
It has better tools than many paid alternatives and is very actively developed. There has been 6 or 7 releases this year.
cloudydatablog.net
July 28, 2015 at 6:07 am
It's also well worth the effort of learning at least the basics of R. It's not difficult getting data from SQL Server (or just about any database engine) into R, but knowing how R handles data definitely helps writing queries for data sets used for analysis. R is becoming more popular all the time and it's completely free, so there's really no reason not to.
____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
July 28, 2015 at 6:34 am
There's a ton of tools both commercial and OSS that help visualize data. Two of my favorites are Excel and IPython Notebook.
July 28, 2015 at 7:10 am
I love working with data. I like to relate it to human activity. Working in the medical industry provides lots of opportunity to do just that.
July 28, 2015 at 8:11 am
Maybe everyone knows by now, but data.gov is a gold mine for public datasets. Most of them are US specific, but there are also thousands of sets related to global topics as well. One good way to showcase your skills would be to pick an interesting topic and then create an Azure or ASP.NET website with some interactive visualizations.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 28, 2015 at 8:39 am
lshanahan (7/28/2015)
It's also well worth the effort of learning at least the basics of R. It's not difficult getting data from SQL Server (or just about any database engine) into R, but knowing how R handles data definitely helps writing queries for data sets used for analysis. R is becoming more popular all the time and it's completely free, so there's really no reason not to.
And I've heard that SQL 2016 will have R in it. Is that correct?
Kindest Regards, Rod Connect with me on LinkedIn.
July 28, 2015 at 10:46 am
Rod at work (7/28/2015)
lshanahan (7/28/2015)
It's also well worth the effort of learning at least the basics of R. It's not difficult getting data from SQL Server (or just about any database engine) into R, but knowing how R handles data definitely helps writing queries for data sets used for analysis. R is becoming more popular all the time and it's completely free, so there's really no reason not to.And I've heard that SQL 2016 will have R in it. Is that correct?
Yes, we have some info here: http://www.computerworld.com/article/2923214/big-data/sql-server-2016-to-include-r.html
July 29, 2015 at 8:30 am
Should we wait for R# ?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
March 22, 2016 at 2:07 am
Rod at work (7/29/2015)
Thank you, Steve. I've just downloaded R for Advanced Beginners PDF.
Any good?
Gaz
-- Stop your grinnin' and drop your linen...they're everywhere!!!
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply