SQLSaturday 492

Phoenix, United States

PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. This event will be held on Apr 16 2016 at Grand Canyon University, 3300 West Camelback Road, Phoenix, Arizona, 85017, United States

Register Now

Welcome to Phoenix SQL Saturday 2016! #492


SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held April 16th 2016 at Grand Canyon University . Admittance to this event is FREE, but we do charge a lunch fee of 5.00 so that we can provide a lunch - not pizza! Please register soon as seating is limited, and let friends and colleagues know about the event


We are pleased to announce 5 ALL DAY sessions on Friday April 15 from 8:30AM - 4:30pm.  Four will be held at the Microsoft Office in Tempe, Arizona. One more will be held at Tyler Technologies off the 10 and Warner. Between now and March 25th, you can get this training for only $99 + Eventbrite Fees. After March 25th, you can get the training at the regular price of $125+ EventBrite Fees.
Session 1: Introducing Organizational BI with SSAS 2014 Tabular – Bill Pearson
SQL Server MVP and Business Intelligence Architect Bill Pearson leads this hands-on introduction to using SQL Server Analysis Services 2014 Tabular (“SSAS Tabular”) to deliver corporate-level business intelligence solutions. The focus of the course is to help those new to SSAS Tabular to assemble data from diverse sources, and to then build and query a basic Tabular model. Participants will gain introductory hands-on exposure to accessing and relating data, and to employing the Data Analysis eXpressions (DAX) language, to construct SSAS Tabular models that support rapid analysis and reporting throughout the enterprise.
Session 2: Power BI Hands-on Workshop – Paul Turley
This engaging workshop will teach attendees how to use Power BI Desktop to create a complete solution delivering dashboards, self-service and mobile BI. Attendees will learn to analyze information using impactful and interactive visualizations. We will create a solution using a variety of data sources that can be used on the desktop by Data Analysts or for group collaboration in the Power BI secure cloud service.
Session 3: Real World SQL Server High Availability Masterclass – Mark Broadbent
In this pre-conference session we shall explain how to design, plan, implement and maintain SQL Server Availability solutions laying not only the conceptual foundations for your learning, but the practical technical hands on know-how for Database (and Windows) administrators and Technical Architects.
Session 4: T-SQL for Performance and Accuracy – Vern Rabe
This preconference will teach you how to write T-SQL with two goals in mind: Getting the results you expect (accuracy), and quickly (performance). In this preconference we will start with some SQL Server internals, where you will learn how the optimizer determines the execution plan, which join algorithms should be used in which situations, and some of the right and wrong choices that the optimizer can make. We’ll discuss how statistics are key to the optimizer’s choices, how the plan cache is used (for good or bad), how to minimize blocking, and how the ubiquitous transaction log is a performance factor is just about everything.
Session 5: Building an end to end modern data architecture with Cortana Analytics – Josh Sivey and Microsoft Data Team
Cortana Analytics suite is a fully managed big data and advanced analytics suite that enables you to transform data into intelligent action. Join the local Microsoft data team as they build out an end to end solution leveraging an IoT device streaming data into Microsoft Azure through hubs into real time analytic repositories as well as a data lake to illustrate the benefits of a lambda architecture in the cloud. We will also create machine learning experiments to make predictions on the data and create rich, interactive visualizations to surface the data to end users.
You can follow us on Twitter at @azssugsqlpass and via Hashtag #azssugsqlpass.  Please also visit our AZSSUG Website http://arizona.sqlpass.org.

Event Location

Event news

SQLSaturday Phoenix 2016  is excited to have Adam Jorgensen as our Keynote speaker.Adam Jorgensen has over 15 years of experience leading companies and designing data strategies. He is the President Read More


Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us

What is a PASS SQLSaturday?

PASS SQLSaturdays are local events organized by PASS community members around the world. PASS is a not-for-profit association for data professionals who leverage the Microsoft Data Platform, offering interactive learning built by community and guided by trusted data experts.

Back to Top cage-aids