Welcome to SQL Saturday in Columbus, OH, July 28, 2018
SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server and related technologies. Our event this year returns to Otterbein University's Roush Hall, 27 South Grove Street, Columbus, Ohio, 43081. The event is free, there is a fee for those who will enjoy a delicious lunch with us on campus. Registration is filling up fast, so register soon and let your friends and colleagues know to do the same.
Need a place to stay? We have a limited set of rooms blocked for Friday and Saturday night, at a group rate of $104/night (single queen bed) and $114/night (two queen beds) at the Candlewood Suites Polaris. To secure your room, please call the hotel directly, (614) 436-6600, and ask for the "Columbus PASS User Group" group rate. There are many other hotels in the surrounding Polaris area, all with easy access to Otterbein.
Event Day Parking
Campus parking at Otterbein is free during the summer, but the university requests that you please do not park in the admissions lot on the corner of South Grove Street and College Avenue or any spots marked "Admissions Visitors", as those are for potential students and their families.
Registration, sessions and closing raffle will be held in Roush Hall, 27 South Grove St, Westerville, OH 43081. Just a short walk away, lunch will be in the Campus Center building, 100 W Home St, Westerville, OH 43081.
SQL Saturday Columbus Precons are Now Available!
Advanced Power BI with Ginger Grant
Looking to learn more advanced Power BI Topics? This session takes a deep dive into Power BI features of Power BI to help improve project development and implementation. Gain a deep understanding of the security and administration capabilities of Power BI and what you need to do for a successful implementation. Learn how and more importantly when to use Content Packs, Templates and App Workpaces and what the impact of those decisions are to deployment strategies. This session will also review measure creation including DAX tips and also when to use quick measures. We will cover the best practice use of M and some advanced M techniques. Of course we will also look at visualization design, including when and where to use which visualizations, color palates designed with optimal contrast ratios, and other design techniques recommended by visualization experts to improve report layout. We will take a look at Drilldown, Drillthrough filters, and other design features like Tooltip pages. You won’t want to miss this comprehensive class which will take your Power BI deployments to the next level. Ginger Grant provides consulting services in advanced analytic solutions, including machine learning, data warehousing, data visualization and cube development using the entire Microsoft Data Stack, including SQL Server, T-SQL, SSIS, SSAS, Power BI and Azure. Ginger started working with data to solutions across a wide range of industries including insurance, education, healthcare, finance and transportation. She is a prolific blogger at http://www.desertislesql.com and frequent speaker and as a MCT provides training for training courses, at conferences and events worldwide to introduce more people to current developments and future trends in data. Microsoft has awarded her an MVP in Data Platform since 2016.
Register here: https://www.eventbrite.com/e/advanced-power-bi-with-ginger-grant-tickets-45669944032
Enter the Tidyverse: R for the Data Professional with Kevin Feasel
In this day-long training, you will learn about R, the premier language for data analysis. We will approach the language from the standpoint of data professionals: database developers, database administrators, and data scientists. We will see how data professionals can translate existing skills with SQL to get started with R. We will also dive into the tidyverse, an opinionated set of libraries which has modernized R development. We will see how to use libraries such as dplyr, tidyr, and purrr to write powerful, set-based code. In addition, we will use ggplot2 to create production-quality data visualizations. Over the course of the day, we will look at several problem domains. For database administrators, areas of note will include visualizing SQL Server data, predicting error occurrences, and estimating backup times for new databases. We will also look at areas of general interest, including analysis of open source data sets. Kevin Feasel is a Data Platform MVP and Engineering Manager of the Predictive Analytics team at ChannelAdvisor, where he specializes in T-SQL and R development, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), a contributing author to Tribal SQL (http://www.tribalsql.com), and one of the contributors behind We Speak Linux (https://wespeaklinux.com). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.
Register here: https://www.eventbrite.com/e/enter-the-tidyverse-r-for-the-data-professional-with-kevin-feasel-tickets-45670396385