Two weeks after the session, I am blogging my view on the event, view on our session and mostly I will try to answer all the questions and/or comments that have been gathered.
This has been my second 24HOP webinar (although the topic was similar to this one – R and SQL Server – 24HOP 2015 – Growing our community), but my first 24HOP webinar that I did as co-presenter. My co-presenter was Julie Koesmarno (twitter|blog) and it was pure fun and 100% enjoyment. Thank you Julie for doing this and in four weeks preparing on this session we have also learned many things from each other. Oh, and by the way, this was actually the second 24HOP webinar with Julie. With the first one, she was moderating my session 🙂
Doing webinar as co-presenter was somehow interesting from webinar tools point of view, also lovely and helpful Angie Horel from PASS organization was helping us to manage this part. So with Julie we ended up, she was navigating through the slide deck and through the VM machine where we had all our demos prepared. And prior to webinar, we practiced the slides so we knew when to do the transition. Also moderator Markus Ehremüller did great job keeping us together and managing and answering the board full of questions. Thank you Angie and thank you Markus.
We were scheduled on 25 May, 16:00 Hours GMT with around 373 attendees listening, participating and enjoying our sessions, who managed to be with us all the way until the end of the session. We had 10 minutes discussion board and I must say interesting questions were posted so Julie and myself had quite a discussion. Questions going from: “Is R (as R language) for Relational” to “Can R handle unstructured (big data) together with Polybase”. Here are all the comments from evaluation board:
Overall was good, nice to see some good examples. Needed a little technical know-how on what you would actually do to make the visuals in R and use in PowerBI. Want to understand more about how to use R in SQL 2016. Thank you very much!! Great overview. Would have been nice to see more details of what went into the demos Sound quality was a bit spotty, but otherwise it was excellent. Need more material to read Thanks for the BIG PICTURE -- very elegant data representations! Hope to receive the slides! Sometimes technical content can be difficult to present but really liked the links to datavizcatalogue Great demonstration of how the new "R" feature relates to business use Great session! Very useful information as we are looking to provide better visualizations for Could address a little bit on the integration of R into SSRS display canvas. than just the demos. thought this was an excellent session! our company. Thank you!
Based on the comments, our goal of the session was the usage of R closer to broader community and to enhance the data visualization in SSRS, Power BI and any blob/html file export that R library supports.
So to webinar questions (I will answer it with from my point of view and Julie will post hers):
Question: Do you have to use SSRS to display output from R script call in SQL Server?
Question: So prior to SQL2016, how did the R IDE communicate with a SQLServer?
Answer: Yes. You could establish connection in both ways using xp_cmdshell! I have wrote an extended article in 2014 on SQLServerCentral blog and forum on how to create a connection and push data back and forth and run any statistics and create beautiful visualizations. Framework is also available with this article.
Question: Is it possible to create an interactive graph with R in SSRS? Not only image.?
Question: Can we call R script through a web service?
Question: Needed a little technical know-how on what you would actually do to make the visuals in R and use in PowerBI. Want to understand more about how to use R in SQL 2016.
Answer: Please post some questions on this blog and we will gladly help you. If you need more on R and SQL Server 2016, MSDN is a good place to start.
Question:How to show kurtosis and outliers in this platform? What code invokes the regression plots?
Answer: Both were prepared with R ggplot library, using boxplot and lines.
To sum up: this was one of the most fun co-presenting session, especially working with Julie it was very nice. In this webinar we showed the benefits of R visualization, the importance of knowing data insights and all the steps that lead to successful story telling. Most of all bringing the usage of R in SQL Server or SQL Server with R for better data insights and faster data analysis. And most importantly, it was fun! 🙂