October 18, 2022 PASSMN Meeting (Virtual Meeting Only)

Details
Important Note: This meeting is online only and will not be held at the Microsoft Technology Center

Agenda:
3:30-4:00 Kickoff / Announcements
4:00-5:00 A case study - Data Movements using Azure Data Factory
(Alpa Buddhabhatti)
5:00-5:10 Break
5:10-6:10 Best Practices of DAX functions (Rajendra Ongole)
6:10-6:15 Closing
Presentation topics, abstracts, speaker bio for this meeting:

Speaker #1: Alpa Buddhabhatti
Topic: A case study - Data Movements using Azure Data Factory
Abstract:
In this session, I will provide a basic introduction of Azure Data Factory, a scalable cloud-based data integration service. I will show a case study to move data from Azure Blob Storage to Azure SQL Server.I will show you how you can use SINK as XML in Azure Data Factory using Azure SQL Server and XML which is not a supportive type in ADF as Sink. Also will show How to send an email using ADF and Logic Apps. This demo will also use the following technologies:

• Azure Key Vault
• Azure Data SQL Server
• Azure Blob Storage
• Azure Data Factory and its Data Flows.
• Azure Logic Apps
• Azure SQL Server

The main goal of this session is to provide basic knowledge of ADF using case study so attendee will leave with ADF knowledge and how to apply this in different scenarios.
Speaker Bio:
Alpa is an Azure Consultant with a passion for data and technology at Cluster Reply UK. She is Microsoft Certified Trainer and certified in Azure Data engineer and Azure Data Science. She is working on Azure services such as Logic Apps, Azure Functions, Azure Key Vault , Azure , Azure Data Factory, Azure Storage and Azure Data Lake.
Speaker #2: Rajendra Ongole
Topic: Best Practices of DAX functions
Abstract:
In this session:

• Introduction
• Import data & create data model
• Define relationships
• Create new measure using sum function
• Format measures
• Edit & delete measures
• Create new measure using count function
• Create new measure using distinct function
• Add comments to measures
• Create new measure with operators
• Quick Measure tool
• Create calculated column
• Measure vs. calculated column
• Measure that references another measure
• Iterator functions
• Time & date functions
• Find function
• If function
• Calculate function

Speaker Bio:
Rajendra is BI Specialist and Power BI Trainer. Currently working with BOSCH Group. Knowledgeable on different Microsoft technologies like Power Platform – Power BI, Power Apps, Power Automate and Power Virtual Agents. With 11+ Years of Experience in Software Development in different domains (Telecom, Manufacturing, Industrial Automation, Project Management office).