SQL Saturday Columbus Precons are Now Available!
Azure for the SQL Server DBA with Tim Radney
Microsoft Azure is an open, flexible, scalable, enterprise-grade cloud computing platform. This full day class will teach you why migrating to SQL Server running in Azure is secure, reliable, easy, as well as how to do it. The Azure platform is vast with many services to choose from. You will get a high level overview of the various services with a focus on SQL Server running in Azure Infrastructure as a Service (Iaas) and Azure SQL Database and Managed Instance as a Platform as a Service (PaaS).
Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passionate in the SQL Community. He runs the Columbus GA SQL Users Group, has been a PASS Regional Mentor for a number of years, was named a PASS Outstanding Volunteer in 2012, and is a frequent speaker at user groups, SQL Saturdays and PASS Summits. Tim is one of the top ranked in karma on ask.sqlservercentral.com, answers questions as @tradney on Twitter, and blogs at http://timradney.com and SQLskills blog at http://www.SQLskills.com/blogs/tim.
Register here: https://www.eventbrite.com/e/azure-for-the-sql-server-dba-with-tim-radney-tickets-45670609021
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
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