September 2022
Standing with Ukraine
Data Community - United for Ukraine
The Speakers
Dejan Sarka
MCT and SQL Server MVP is an independent trainer and consultant who focuses on development of database and business intelligence applications. Besides projects, he spends about half of the time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of nineteen books about databases and SQL Server. He has also developed many courses and seminars for Radacad, Microsoft, SolidQ, and Pluralsight.
André Melancia
Developer / DBA / Microsoft Certified Trainer (MCT) focuses on Microsoft's Data Platform, Azure, IoT and Security. Owner / Principal Consultant at LunarCat.PT. 23+ years' fun developing information and multimedia systems, DBA, project and IT management. Data Community, IT Pro Portugal and PowerShell Portugal technical communities organiser, as well as moderator in multiple other online communities. Actively volunteering, organising, speaking or just participating at community meetings and events (200+ international speaking sessions in the last 7 years). Proud uncle and food devouring expert, with dangerous pussy cat as companion.
Leila Etaati
The first Microsoft AI MVP in New Zealand and Australia. She has Ph.D. in Information System from the University Of Auckland. She is the co-director and data scientist in RADACAD Company, the co-organizer of Microsoft Business Intelligence and Power BI Use group (meetup) in Auckland, the co-organizer of three main conferences in Auckland, a Data Scientist, BI Consultant, Trainer, and Speaker. She is a well-known International Speakers to many conferences. She has over ten years’ experience working with databases and software systems. She was involved in many large-scale projects for big-sized companies. She is also AI and Data Platform Microsoft MVP and an active Technical Microsoft AI blogger for RADACAD.
Melissa Coates
The owner of Coates Data Strategies. Data architect, technical trainer, and consultant with 15+ years of experience on dozens of projects. Current professional focus is enterprise-level Power BI governance, deployment, security, and administration. Melissa's experience with designing and building data architectures to support data warehousing, data lakes, and business intelligence solutions means that she approaches Power BI as one component of the bigger picture. Melissa is the creator of the comprehensive "Power BI Deployment and Governance" online course. Melissa is the principal author of Microsoft's "Power BI Adoption Roadmap" and co-author of the "Planning a Power BI Enterprise Deployment" whitepaper.
Chris Webb
Principal Program Manager on the Power BI Customer Advisory Team. Has over 20 years of experience as a consultant and trainer specializing in the Microsoft BI stack, with expertise in Power BI, SQL Server Analysis Services, MDX, DAX, M, Power Pivot and Power Query.
Marcin Szeliga
Microsoft MVP, Machine Learning practitioner is independent consultant solving customers data-related problems. Since 2006 invariably awarded Microsoft Most Valuable Professional title, one of two Polish AI MVPs. Speaker at many European conferences, such as Machine Learning Prague, Data Science Summit, SQLDay, 4 Developers, SQL Nexus, SQL Saturday, Sphere.it and Microsoft Technology Summit. University teacher and author of books and articles about Microsoft data platform, including the bestsellers “Data Science and Machine Learning" (Polish IT Book of the year 2018) and “Practical Machine Learning”.
speaker
Catalin Gheorghiu
Solution architect from Timisoara Romania. Founder, CTO and Lead Solution Architect at I Computer Solutions. The current interests are in the area of (I)IoT, industrial mobile and cloud solutions. Catalin is a trainer (MCT) and consultant, all these revolving around Microsoft technologies. In his spare time is member of the technical community, contributing with articles and blogs (signed MrSmersh), presentations to several user groups/meetups (also is RONUA Timisoara user group leader), and lecturing all over Romania and abroad. Since 2011, every year he was awarded the Microsoft MVP Award. Is also a current holder of the Intel Software Innovator Award.
Ricardo Cabral
Microsoft Certified Trainer (MCT) currently residing in Portugal having worked in both administration and development roles with 20+ years of experience in IT management, development, and projects. He has extensive experience on Microsoft 365, Microsoft Azure, Power Platform and Windows Server/Client and holds several Microsoft certifications. Now works as Azure Solutions Architect, consultant, and IT trainer. In his free time, he is actively participating, volunteering, speaking and organizing in technical community meetings.
Murilo Miranda
Blogger, speaker and SQL Server MVP from Portugal. He is a Database Consultant at Pythian, a global data infrastructure services company. Murilo’s passion for working with people coupled with his honesty has helped him establish effective, meaningful relationships with his clients. When he isn’t working, he can be found enjoying life with his family, watching football and playing Playstation.
Conference Agenda
Week 1 (2022-09-12 2022-09-16)
Event Date: 2022-09-13
Time:
7 PM Kyiv
5 PM London
12 PM New York
9 AM San Francisco
Dejan Sarka "Association Rules Step by Step using T-SQL, R, Python, Azure ML, and SSAS"
Market basket analysis with T-SQL, R, Python, Azure ML and SSAS. You will learn how to recognize good products, products which raise the sales of other products, and toxic products, products which are usually sold alone or are the last product in the basket, thus finishing the shopping. Measures like support, confidence and lift, are explained in details. Sequential basket analysis is covered as well. Demos are developed step by step in T-SQL, in order to show how the calculations are made. Then you will see demos also in other languages and on other platforms.
Event Date: 2022-09-14
Time:
7 PM Kyiv
5 PM London
12 PM New York
9 AM San Francisco
Catalin Gheorghiu "Introduction to Azure Stream Analytics"
You have SQL skills, where is the place in Azure where these skills can shine? All explained trough samples, more or less IoT oriented, not because Stream Analytics is just for IoT (far from it) jus because is easier to explain and to demo. Everything shown in this session you can try by yourself afterwards, without meddling with electronics, promise 😊. After this session you will know what it is, where to use it and how to use Stream Analytics.
Event Date: 2022-09-15
Time:
9 PM Kyiv
7 PM London
2 PM New York
11 AM San Francisco
Ricardo Cabral "Power Apps + on-premises data gateway"
PowerApps is a way to quickly create low code applications and use OneDrive, SharePoint, Dataverse as a data source through connectors that are Application Programming Interface (API). The advantage of these connectors is that they allow the use of other data sources such as Microsoft SQL Server on-premises. I will demonstrate how PowerApps can communicate with Microsoft SQL Server on-premises.
Week 2 (2022-09-19 2022-09-23)
Event Date: 2022-09-20
Time:
7 PM Kyiv
5 PM London
12 PM New York
9 AM San Francisco
Marcin Szeliga "Auto ML in Computer Vision"
Auto ML in Computer Vision In this session, you will learn how automated machine learning can be combined with transfer learning to boost data scientist productivity when building computer vision models trained on image data. We will see new capabilities in Azure Machine Learning’s AutoML related to image classification, object detection and segmentation.
Event Date: 2022-09-21
Time:
6 PM Kyiv
4 PM London
11 PM New York
8 AM San Francisco
André Melancia "Machines Are Learning, You Should Learn ML Too: An Azure Story"
Afraid bots will take over your job and you'll need to fight Skynet? Join us and learn how machine learning works, and have a look at how you can win the cyber wars with Azure Machine Learning (and a much more). Disclaimer: "This is the world now... Code with me if you want to live."
Event Date: 2022-09-22
Time:
7 PM Kyiv
5 PM London
12 PM New York
9 AM San Francisco
Murilo Miranda "Scaling Multiple DBs Sharing Resources with Elastic Pools"
Elasticity and Scale has been a challenge for data processing in relational databases. Some of the problems are: - Increase and decrease processing capacity based on workload - Manage some "hotspots", which may affect a part of the data, for example, a particular client. Traditionally, scenarios like these were resolved by investing in large-scale database servers to support the application, which is not in keeping with the cloud paradigm. Spreading data and processing across identically structured databases (a scaling pattern known as "sharding") offers an alternative to traditional scaling approaches, both in terms of cost and elasticity. In this session we will talk about how Azure can help overcome these challenges, based on Elastic Pools.
Week 3 (2022-09-26 2022-09-30)
Event Date: 2022-09-27
Time:
7 PM Kyiv
5 PM London
12 PM New York
9 AM San Francisco
Melissa Coates "Options for Securely Sharing Power BI Content"
Power BI is an extremely flexible ecosystem which includes several ways you can collaborate and share content with your colleagues. In this session we will review the different ways that content can be shared in the Power BI Service. By the end of this session, you'll have familiarity with: - approaches for collaboration vs. content distribution - when to use an app vs. a workspace vs. individual item sharing - the difference between sharing links & direct access - when to use read vs. build permissions - suggestions and strategies to reduce risk and future maintenance
Event Date: 2022-09-28
Time:
8 PM Kyiv
6 PM London
1 PM New York
10 AM San Francisco
Chris Webb "Performance tuning Power Query and dataflows"
Whether you are transforming data in the Power Query Editor in Power BI Desktop or using Power BI Dataflows it's important that your Power Query queries run as quickly as possible. In this session you'll learn how to diagnose Power Query performance problems using features like SQL Profiler, Query Diagnostics and Query Plans, and then fix them by optimizing your code, ensuring query folding takes place, increasing the resources available to the Power Query engine and using the Enhanced Compute Engine in Dataflows.
Event Date: 2022-09-29
Time:
8 PM Kyiv
6 PM London
1 PM New York
10 AM San Francisco
Leila Etaati "Empower Analytics in Power BI using AI"
Using Power BI helps us creating descriptive analysis to analyse what happened in past, however, using AI and ML bring more insight over data to do more descriptive and predictive analysis. In this session, how we able to use AI and ML features such as Charts, Power Query, and writting R or Python code will be presented to get more insight from data.