6:00PM – 6:30PM social | 6:30PM – 8:30PM meeting
Boost your Analytics with Machine Learning for SQL Nerds
Are you trying to understand what’s the fuss around Machine Learning? Are you working with a lot of data analysis and wondered how SQL Server 2016 R Services might be able to help? This session will provide a gentle and fun introduction to SQL Server R Services for SQL Nerds. We will walk through pragmatic examples of using R through demos, to illustrate Machine Learning in boosting your Data Analysis capabilities. The goal of this session is to provide quick tips and tricks for attendees to get started on SQL Server R Services, either for fun or for work.
Julie is a Principal Program Manager at Microsoft, with a Bachelor’s degree in IT. She has over 10 years of experience working with SQL Server for large-scale and multi-million-dollar OLTP and ETL projects as a SQL Server developer and system analyst/designer. Her past projects include delivering a SQL Server data warehouse and BI solutions in the US and Australia. She now works with big data projects to drive business analytics for Azure Data. She has recently co-authored SQL Server 2017 Machine Learning Services with R.
Seeing Stars – Dimensional Modeling Essentials
You’ve extracted a set of flat data or you have a transactional database in third normal form. How can you transform it to create a data model optimized for analysis and reporting? We’ll step through the basic process of transforming different data structures into dimensional models; review some best practices and common worst mistakes. Building on basic dimensional design, you will see how even the most mundane or disorderly data can be transformed to tell stories and give unexpected insights.
Paul ( Blog | LinkedIn | Twitter ) is Principal Consultant for Intelligent Business LLC, a Mentor and Microsoft Data Platform MVP. He will present a session at the 2018 PASS Summit titled “Visualize World Peace Through the Art and Science of Presenting Beautiful Data”. He consults, writes, speaks, teaches & blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon SQL PASS chapter & user group, author of Professional SQL Server 2016 Reporting Services and co-author of 14 other titles from Wrox & Microsoft Press. He holds several certifications including MCSE for the Data Platform, Analytics and BI.
Refreshments graciously provided by ServerLogic.
We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously providing the meeting venue.