SQLSaturday 919

Atlanta - BI Edition, 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 Oct 19 2019 at Microsoft, 8000 Avalon Boulevard, Suite 900, Alpharetta, Georgia, 30009, United States

Register Now

Session Glimpse

Event schedule is not published yet.

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: 

 

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.

Module 2:

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.

 Module 3:

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
• Debugging
• Triggers
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.

Event Location

Event news

We've Added Reza Rad to the Precon Lineup! Read More

Contact

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
cage-aids
cage-aids
cage-aids