This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
Being able to monitor, detect and act on events based of your data plays a crucial role in making data driven decisions. Activator allows you to monitor events, detect certain conditions on your data and act on them by sending alerts.
Contoso Bank, a fictitious bank, is dedicated to enhancing its security measures by leveraging real-time data to monitor fraudulent activities on bank transactions. As part of their requirements, they aim to implement a system that sends teams or email alerts when a transaction, specifically of the type 'transfer', exceeds a certain threshold, such as $2500, within an hour, thereby flagging it as potentially fraudulent. Additionally, the bank seeks to ensure that clients do not withdraw more than the permitted amount. If a withdrawal that meets or exceeds this limit occurs, an alert will be sent. These requirements are part of Contoso Bank's commitment to safeguarding their clients' assets and maintaining the integrity of their financial operations.
To achieve this, you can use Activator to create new rules/alerts on specific events related to transactions. By tying these events to an object, such as Transactions, and monitoring the properties of transaction data, it becomes possible to identify and act on potential fraud. Alerts can be configured to trigger when a transfer exceeds $2500 within an hour, or when withdrawals surpass the allowed limit, enabling prompt responses to safeguard financial integrity.
Before using Activator to create new rules/alerts you need to stream your data into Microsoft Fabric. You can get your data from different data sources like Azure Cosmos DB, Azure SQL DB, Azure DB for PostgreSQL and more. To set up an event stream follow these steps and this documentation for creating an activator artifact.
Creating rules on events allows you to get an activation for every event that comes in on the event stream. These kinds of rules will help you get an alert every time a new event comes in and the value for a column in that event meets the defined condition, for example when the Transaction Location is New York.
Enhance_fraud_detection_with_Activator_in_Microsoft_Fabric
Creating rules on events that are added to an object work similar to rules created on events. However, you can track events for specific object IDs or Transaction IDs. The added benefit is that you can use properties from the same or other event streams that added to the same object.
Enhance_fraud_detection_with_Activator_in_Microsoft_Fabric
Enhance_fraud_detection_with_Activator_in_Microsoft_Fabric
To meet the requirement for kicking off alerts when a transfer exceeds $2500 within an hour you would need to create an alert on a property which allows you to monitor a property on an object over time.
Enhance_fraud_detection_with_Activator_in_Microsoft_Fabric
Note: Activator is not limited to the above, it also allows you to detect for a variety conditions like numeric changes, numeric states, text change, text states and more.
Enhance_fraud_detection_with_Activator_in_Microsoft_Fabric
There’s more you can do for a Fraud Detection scenario with Data Activator, we provided a baseline of how you would approach it and for other scenarios.
Resources
Get started with Data Activator
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.