We are excited to announce in partnership with the Atlanta Marriott Alpharetta that we will be offering a discounted hotel room rate for 83 USD per night! Book your group rate for SQL Room Block Oct2019
Hotel Rate Start Date: Thursday, October 17, 2019 through Sunday, October 20, 2019. The last day to book your room is September 26, 2019! Don't forget, book today!
Our Precon Trainings are now live! Sign up today!
Precon: AI in Power Platform: The Realm of the Impossible by Dr. Leila Etaati (Register at https://ai-in-power-platform.eventbrite.com)
Description: Using AI is a norm this day in developing applications and analyzing the data. Easy AI is not a dream anymore, that means everyone regardless of how they are familiar with AI and ML concepts can use AI in their applications and analysis.
Besides, Power Platform technologies (Power BI, Power Apps and Flow) have been used by analysts, BI developers, office 365 specialists and users and so forth for a while. In a one day workshop, audiences will learn how to leverage AI in Power Platform.
Module 1: Introduction to AI and ML
The audience will get familiar with AI and ML concepts and what architecture and opportunity they have. Some introduction to ML approaches from predictive, descriptive and prescriptive analytics will be provided. The audience also gets familiar with prebuild and Custom AI tools in Microsoft stacks such as cognitive service and Azure Ml Service.
Next an introduction to Power BI desktop and service especially Data flow will be provided. The audience will see different approaches to use AI and ML inside Power desktop and Power BI service. In Data flow how we able to use AutoML, and AI insight will be shown. Also, the audience will see how to consume their models that have been created in Azure ML Services using Python, AutoML interface, or Azure ML Studio inside Power bI desktop or Data flow. Also, they will get familiar with some of the interesting visuals like Key Influencer to analyze their data better.
In this module, the audience will learn about how to do AI in Power Apps and Microsoft Flow using AI builder for the aim of classification, regression, and forecasting. Also, they will learn how they can create an application for the aim of object detection and form processing using AI builder. Next audience will see how to consume the other cognitive service model in Microsoft Flow such as an image tag or face recognition.
About the Presenter: Leila is First Microsoft AI MVP in New Zealand and Australia; She has a Ph.D. in Information System from the University Of Auckland. She is the Co-director and data scientist in RADACAD Company with more than 100 clients around the world. She is the co-organizer of Microsoft Business Intelligence and Power BI Use group (meetup) in Auckland with more than 1200 members; She is the co-organizer of three main conferences in Auckland: SQL Saturday Auckland (2015 till now), Difinity (2017 till now) and Global AI Bootcamp 2-18. She is a Data Scientist, BI Consultant, Trainer, and Speaker. She is a well-known International Speakers to many conferences such as Microsoft Ignite, SQL pass, Data Platform Summit, SQL Saturday, Power BI world Tour and so forth in Europe, USA, Asia, Australia, and New Zealand. She has over ten years’ experience working with databases and software systems. She was involved in many large-scale projects for big-sized companies. Leila is an active Technical Microsoft AI blogger for RADACAD.
Precon: From Zero to ADF by Andy Leonard (Register at https://zero-to-adf.eventbrite.com)
Description: From Zero to ADF is designed to jumpstart data engineering and data integration developers, introducing them to Azure Data Factory (ADF). ADF is a cloud data engineering and data integration platform designed to orchestrate data-related activities and move data between sources and sinks in the cloud, on-premises, and combinations thereof.
Lesson 0: Introduction
Lesson 1: Provision a Data Factory
• Examine Azure Portal
• Survey ADF artifacts
• Create Your First ADF Pipeline
Lesson 2: Basic Data Movement
• Copy Data Activity
• Delete Activity
• Stored Procedure Activity
Lesson 3: Pipeline Orchestration
• Conditional, Lookup, ForEach Activities
Lesson 4: Monitoring
• ADF Portal
• Azure Monitor
Lesson 5: Azure-SSIS
• Provision Azure-SSIS instance
• Lifting and shifting on-premises SSIS to Azure-SSIS
Lesson 6: Enterprise ADF Execution Patterns
• Leveraging the Parent-Child design pattern.
Lesson 7: Introduction to Mapping Data Flows
About the Presenter: Andy Leonard is founder and Chief Data Engineer at Enterprise Data & Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of The Biml Book and SQL Server Integration Services Design Patterns and author of Managing Geeks - A Journey of Leading by Doing, Data Integration Lifecycle Management with SSIS, Building Custom Tasks for SSIS, and the Stairway to Integration Services. Andy blogs at andyleonard.blog where you can learn more on the About Andy page.
Precon: Power BI from Rookie to Rock Star - All About DATA by Reza Rad (Register at https://powerbifromrookietostar.eventbrite.com)
Description: You will learn how to use Power BI for simple data analysis situations as well as complex business intelligence scenarios. You will learn about using Power Query and the formula language (M) for data preparation and transformation. You will also learn about relationships, and modeling in Power BI, and DAX which is the calculation engine for Power BI.
This course is full of live demos of real-world challenges of data modeling and how to solve it using Power BI. Modules include, but not limited to:
Module 1: Data preparation using Power Query
Module 2: Advanced Data transformations
Module 3: M: Power Query formula language
Module 4: Data Modelling in Power BI, Everything you need to know about Relationships
Module 5: DAX and Calculations in Power BI
This is a data modeling module of the world-famous Power BI training from Rookie to Rock Star by the book author; Reza Rad.
About the Presenter: Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. He is a Microsoft Data Platform MVP for eight continuous years (from 2011 till now) for his dedication in Microsoft BI. Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of Difinity conference in New Zealand.
His articles on different aspects of technologies, especially on MS BI, can be found on his blog: https://radacad.com/blog. He wrote some books on MS SQL BI and also is writing some others, He was also an active member on online technical forums such as MSDN and Experts-Exchange, and was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the leader of the New Zealand Business Intelligence users group. He is also the author of very popular book Power BI from Rookie to Rock Star, which is free with more than 1700 pages of content and the Power BI Pro Architecture published by Apress.
He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday and SQL user groups. And He is a Microsoft Certified Trainer. Reza’s passion is to help you find the best data solution, he is Data enthusiast.